Even or Odd Number

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
 
F

Frank Kabel

Hi
one way:
use the functions ISEVEN or ISODD
another way
=IF(Mod(A1,2)=1,"Odd", "Even")

HTH
Frank
 
S

silky_green

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
 
F

Frank Kabel

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
 
G

Gord Dibben

silky

ISODD and ISEVEN are Functions from the Analysis ToolPak.

Tools>Add-ins. Checkmark Analysis ToolPak.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for odd even numbers 4
Odd and even numbers 6
odd and even addresses 3
Countif function for Even and Odd numbers 34
COUNT function 1
Why Excel Does not increment by 2 or 3, odd/even numbers? 6
how to correct the decimal number to the nearest even number 1
how do you do reduce ratios in a spreadsheet 2

Top