Forum Discussion

heatherKaras's avatar
heatherKaras
Qrew Trainee
2 months ago

Even/Odd Formula

Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number? Thanks!
  • MarkShnier__You's avatar
    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"))