Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number?
Thanks!
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"))
Thank you Mark! I have not used that function before; very helpful!
FYI if you want to account for negative numbers you should use Mod instead, which will output the 0 and1 in this case. Rem would output -1 and 0 in that scenario.
Qrew LegendThe 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"))
