3

I have number column in my new form. If user write here number, I need to validate if it is multiple of value 0,5. For example 1 or 2,5.

I've tried formula for column validation: = ?*0,5
but it gives me syntax error.

Please, help. Thank you

2 Answers 2

4

I think you need,

=mod([FieldName];0,5)=0

4
  • 4
    Just want to note for anyone who sees this in the future, that this formula depends on the regional settings. For languages that use a comma for a decimal point, this is correct. For languages, such as English (US), that use a period, Gintas K's answer below should work.
    – Erin L
    Commented Apr 19, 2016 at 15:49
  • How can I connect it together with other folmula? Second formula is: =IF(OR(Do<Od);FALSE;IF(OR([Nástup do zamestnania po dovolenke]<=Do);FALSE;TRUE)) Commented Apr 19, 2016 at 16:21
  • Two points here: (1) If the formula you posted above is in list item validation, you don't really have to combine the two formulas, as both of them will be validated if you add '=mod([FieldName];0,5)=0' in the field validation for your field. (2) A rough guess for the combined formula would be '=IF(mod([FieldName];0,5)=0;IF(OR(Do<Od);FALSE;IF(OR([Nástup do zamestnania po dovolenke]<=Do);FALSE;TRUE));FALSE)' beware of typos :) Commented Apr 19, 2016 at 16:27
  • Wow, thank you for your fast response. I use second option, and it works great. Thanks Commented Apr 19, 2016 at 16:35
2

Try using the following:

= MOD([YourColumnName],0.5) = 0

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.