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

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.

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.

One mo
=mod(a1+1,2)



sutchpain wrote:

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.

--

Dave Peterson