Skip to main content
Solved

Even/Odd Formula

  • Sep 26, 2024 3:20 PM UTC
  • 0 replies
  • 138 views
Forum|alt.badge.img+2

Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number?

Thanks!

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

 

View original
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
  • MarkShnierYou
  • Qrew Champion
  • Answer
  • Sep 26, 2024 4:09 PM UTC

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

 

Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+2
    • heatherKaras
    • Author
    • Qrew Cadet
    • Sep 26, 2024 5:20 PM UTC

    Thank you Mark! I have not used that function before; very helpful!

    Terms & ConditionsAccessibility statement