Even or Odd Number

  • Thread starter Thread starter silky_green
  • Start date Start date
S

silky_green

This may be very basic but I can't seem to think of an easy way t
determine if a number is even or odd.

Can someone help? Thank you
 
Hi
one way:
use the functions ISEVEN or ISODD
another way
=IF(Mod(A1,2)=1,"Odd", "Even")

HTH
Frank
 
Thanks so much. I knew there was an easy way. I don't seem to have th
ISEVEN or ISODD function but the MOD formula worked great. I did it
convoluted way:

=IF(A1/2=ROUND(A1/2,0),"EVEN","ODD")

Switching to MOD...

Thanks
 
Hi

for ISEVEN and ISODD you have to install the Analysis Toolpak Add-In
(Goto 'Tools - Add-Ins...' and check the Analysis toolpak Add-In)

Frank
 
silky

ISODD and ISEVEN are Functions from the Analysis ToolPak.

Tools>Add-ins. Checkmark Analysis ToolPak.

Gord Dibben Excel MVP
 
Back
Top