Using if statment to confirm if a number is eith odd or even please

[smerrick]

Hello,
is there a simple formula that I can use that would distinguish if a number was either odd or even? Basically, if the numbber is odd then I want an if statement to return 'odd' and even 'even'.
This shold take seconds but never come across an easy way before - any takers??
Many Thanks

 

[Weaver]

=if(ISODD(A1),"Odd","Even")

 

[JackDanIce]

Try:

=IF(MOD(A1,2)=0,"Even","Odd")

 

[GlennUK]

=IF(ISEVEN(number),"Even","Odd")

 

[Trebor76]

Hi there,

Have a look at these solutions.

HTH

Robert

 

[smerrick]

Many thanks - great tip that one will keep a note. Cheers.