heatherKaras

19 days agoQrew Member

# Even/Odd Formula

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"))