If, Or and an And

[Darin Kramer]

Me again....

Should be simple, but for some reason I can get it to work...

Formulae in cell a5, needs to say...
If cell a1 = "Bird", then display cell b1
If cell a1 = "Cat", then display cell b2
If cell a1 - "Seed" or "Dish" then display "N/A"

I thought it was a nested if with an and and a or, but mine does not
seem to work...

Thanks guys....

 

[Guest]

=if(a1="bird",b1,if(a1="cat",b2,if(or(a1="Seed",a1="Dish"),"N/A","none of
them")))
....should work
Rob

 

[Guest]

Darin,

=IF(A1="Bird",B1,IF(A1="Cat",B2,IF(OR(A1="Seed",A1="Dish"),"N/A")))

Does this work?

Pete

 

[NickHK]

Darin,
How about:

=IF(A1="Bird",B1,IF(A1="Cat",B2,IF(OR(A1="Seed",A1="Dish"),"N/A","All
Wrong")))

NickHK

 

[Darin Kramer]

Thanks, Works perfectly

 

[Bob Phillips]

You might want to use the NA() function rather than text "N/A" as well, as
you can error check that using IF(ISNA...

--

HTH

RP
(remove nothere from the email address if mailing direct)