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?

Improve this question

1 Answer 1

Reset to default
2

Please use this

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

Improve this answer
0

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.