Obviously it is for an HR form that only lets users enter increments of 4 or 8 for the value entered. So I figured one way may be is to take the inputted number, divide it by 4 and see if I get a whole number by using conditions. If it is not divisible by 4 then a decimal would appear making it known it is not divisible by 4 with a return of a whole number. I looked at all the functions and I can't find one that one would sort this out.

  • try validation in infopath, there you can use formulas mod. Commented Apr 4, 2018 at 3:30
  • I have mentioned that but I do not know how to code it to do as I'd like. Commented Apr 4, 2018 at 4:33

1 Answer 1


Follow the steps below:

  1. Add an additional field named “modValue” and set the default value to number mod 4.

    enter image description here

  2. Remove the field from the form to make it as a hidden field.

  3. Select the number field and add a Validation rule.

    enter image description here


enter image description here

  • JoannaW_MSFT you are amazing!! You totally rock. Thank you! Wishing you good karma!! :) Commented Apr 4, 2018 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.