even or odd

[timothysmith_NYFRB]

How do I make a formula that tells me if a number is even or odd

[CarliE · Accepted solution]

Hi @timothysmith_NYFRB 

You can use a formula tool to create a new field with the following expression:

iif(Mod([Numbers], 2)=0, "Even", "Odd")

This statement says if the remainder of the value in the number field divided by 2 is zero, then the number is even. Otherwise it is odd. 

Please mark as a solution if this helped solve your problem!

Thanks,

[BobR · Accepted solution]

You can use the mod() function to check.

iif( mod([field_w_number], 2) = 0, 'even',  'odd' )

Bob

[timothysmith_NYFRB]

thank you that worked perfectly

[MarqueeCrew]

Btw 

iif(mod([number]),"odd","even") should work too.  

it requires less effort in cpu. 

cheers,

 mark