Writing IF statement for ODD numbers

[Chrissya03]

Hello! I am trying to figure out how to write an IF statement such as this

IF (value in column A is ODD, then do this)
IF (value in column A is EVEN, then do this)

All in the same string.

Suggestions?

 

[JamesW]

Hi there try:

=IF(EVEN(A1)=A1,"EVEN - do something","ODD - do something else")

 

[Joe4]

Have a look at the MOD function.

=IF(MOD(A1,2)=0,what to do if even,what to do if odd)

 

[MrKowz]

Try:

=IF(MOD(A1,2)=0,*What to do if it is even*,*What to do if it is odd*)