Try this =A1+ISEVEN(A1)*2-ISODD(A1)*2
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andrew" wrote in message
...
Hi

I need a formula that will Add 2 to the numbers in Column A if they are
even
and Minus Two if they are Odd.

Thanks in advance