Simple "OR" statements in excel ?

[styxxuk]

Hi

I know this is a very newbie question - but I cant work out how to do the following would much appreciate it if someone could help please

I have the following to print in a column if a number entered is "odd" or "even"

=IF(OR(A12={1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35}),"odd","even")

I cannot for the life of me work out how to modify this to give three or more results - for instance "odd" "even" "zero" "null" (I am guessing that once I have the formula for three possible results then it would be easy to understand and edit for 4 or more options).

Cant see this question in the forums already - and apologies for what I am sure is a simple question to you guys, but I would be grateful if someone could possibly answer it please.

[ragulduy]

=if(case1=true,1,if(case2=true,2,3))

?

[ragulduy]

=IF(CASE1=TRUE,1,IF(CASE2=TRUE,2,3))

?

So for your example:

=IF(OR(A12={1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35}),"odd",IF(OR(A12={2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36}),"even","null"))

[Ghozi Alkatiri]

=if(iseven(a12),"even","od")

[Ghozi Alkatiri]

=if(iseven(a12),"even","odd")

[Pete_UK]

Try this:

=IF(ISERROR(A12),"Error",IF(A12="","Null",IF(A12=0,"Zero",IF(ISNUMBER(A12+0),IF(MOD(A12,2)=0,"Even","Odd"),"Text"))))

This should cover all possibilities.

Hope this helps.

Pete

[styxxuk]

Thank you very much indeed - yes that did it

=IF(CASE1=TRUE,1,IF(CASE2=TRUE,2,3))

?

So for your example:

=IF(OR(A12={1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35}),"odd",IF(OR(A12={2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36}),"even","null"))

[Pete_UK]

Thanks for the Rep, styxxuk - please mark the thread as Solved if you consider it to be so (click on Thread Tools above your first post).

Pete