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

"sutchpain" wrote in message
...
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.