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

[Guest]

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.

 

[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

 

[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.