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