"E" for even numbers. "O" for odd numbers.
 

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!

=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!

=IF(ISEVEN(A1)=TRUE,"E","O")
--
paul
remove nospam for email addy!



"jenn" wrote:

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!

=IF(ISEVEN(A1),"E","O")

jenn wrote:

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!

=IF(MOD(A1,2)=0,"E","O")

and to take care of blanks.

=IF(A1="","",IF(MOD(A1,2)=0,"E","O"))

Mangesh



"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!

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!

hey ppl,

both the =if(iseven....etc) and =if(mod...etc) worked great! thanks
Mangesh Yadav has warned me about blanks...and it is a problem. Any cells
left blank are considered Even. What should i do?
Thanks

As I said in my earlier post, check for blanks. Use:

=IF(A1="","",IF(ISEVEN(A1),"E","O"))

Mangesh


"jenn" wrote in message
...
hey ppl,

both the =if(iseven....etc) and =if(mod...etc) worked great! thanks
Mangesh Yadav has warned me about blanks...and it is a problem. Any cells
left blank are considered Even. What should i do?
Thanks

And, this checks for TEXT........

=IF(ISNUMBER(A1),IF(A1="","",IF(ISEVEN(A1),"E","O" )),"")

Vaya con Dios,
Chuck, CABGx3




"Mangesh Yadav" wrote in message
...
As I said in my earlier post, check for blanks. Use:

=IF(A1="","",IF(ISEVEN(A1),"E","O"))

Mangesh


"jenn" wrote in message
...
hey ppl,

both the =if(iseven....etc) and =if(mod...etc) worked great! thanks
Mangesh Yadav has warned me about blanks...and it is a problem. Any
cells
left blank are considered Even. What should i do?
Thanks

thanks ppl!
it has been enlightening!