0

I am trying to use a text column, as opposed to a number column, as I don't want any of the number formatting that automatically comes with Sharepoint.

I only want this column to accept multiples of 10. I've tried this validation formula:

=AND(ISNUMBER([Priority]+0), [Priority]%10=0)

And variants on it, but to no avail. Effectively, I need to check the input is a number, then check it is a multiple of 10. Is this possible?

1 Answer 1

2

Please use this

=AND(ISNUMBER(myNum+0),MOD(myNum,10)=0)

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.