You need the Analysis toolpak enabled to use the ISEVEN function.

Mangesh



"Niek Otten" wrote in message
...
=IF(ISEVEN(A1),"E","O")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
"jenn" wrote in message
...
hi there

I need a formula that will produce "E" or "O" for even or odd numbers in
columnA. I have tried messing around with =if(A1=iseven,"E","O") but
not
to
much success. What am i missing here?
Thanks!