Odd or Even

[SAMiD_Dubai]

Hi All

Is there any function that can return a TRUE if a value is even and FALSE if not ?

Thank you

[1minManager]

help.appsheet.com

MOD()

Arithmetic remainder from integer division

use with a divide by two. even numbers will have no remainder

[ArieHoo]

Thank you!

I needed to do this to calculate even and odd week numbers  and used this formula:

IF(MOD(WEEKNUM(TODAY()),2)=0, "value if true", "value if false")