SharePoint Column Formula Validation

Question

I need to check if a column (type Number) is an Integer (no decimal).
I added this formula to the list validation:

=mod([MyField],1)=0

But I get this error:

The formula contains a syntax error or is not supported.

Answer 1

Maybe your separator is not "," but ";". It depends on the regional settings. You can try your formula like this

=mod([MyField];1)<>0

Hope that helps.

Answer 2

You can try the following formula:

=MOD([MyField],1)=0