Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number?
Thanks!
Solved
Even/Odd Formula
+2Best answer by MarkShnierYou
The formula for a Formula Checkbox field for true would simply be
REM([my numeric field],2)=0
If you want the same result but with more needless typing you can also do:
IF(REM([my numeric field],2)=0, true, false)
If you want the words, the it would be a formula text field.
IF(
REM([my numeric field],2)=0, "Even",
REM([my numeric field],2)=1, "Odd"))
This topic has been closed for replies.
+24The formula for a Formula Checkbox field for true would simply be
REM([my numeric field],2)=0
If you want the same result but with more needless typing you can also do:
IF(REM([my numeric field],2)=0, true, false)
If you want the words, the it would be a formula text field.
IF(
REM([my numeric field],2)=0, "Even",
REM([my numeric field],2)=1, "Odd"))
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.