identify even numbers with a "1" and odd numbers with a "0"

S

sutchpain

I need a formula that will return a value of '1' if the number in another
column is 'even' (divisible by 2) and a '0' if it is not. I used the
'countif' function in a single cell once before, but can't remember how. Have
a work-around that uses countif 'true value in one column and a 3rd column
with 'if' function to return a '1' if true and '0' if odd...but can't seem to
make it work in one cell. It was 'easier' before, and used 'counif'. Any good
ideas out there? Thanks.
 
B

Biff

Hi!

Assume your numbers are in column D.

If you have the Analysis ToolPak add-in installed:

=--ISEVEN(D1)

If you try the above formula and get #NAME? as a result, it means that you
probably don't have the ATP installed.

If you don't have the ATP installed:

=--(MOD(D1,2)=0)

Copy down as needed.

Biff
 
D

Dave Peterson

One more:
=mod(a1+1,2)


I need a formula that will return a value of '1' if the number in another
column is 'even' (divisible by 2) and a '0' if it is not. I used the
'countif' function in a single cell once before, but can't remember how. Have
a work-around that uses countif 'true value in one column and a 3rd column
with 'if' function to return a '1' if true and '0' if odd...but can't seem to
make it work in one cell. It was 'easier' before, and used 'counif'. Any good
ideas out there? Thanks.
Click to expand...
 
Top