heatherKaras
2 months agoQrew Trainee
Even/Odd Formula
Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number? Thanks!
- 2 months ago
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"))