Compound Logic Tests

[polarisking]

I'm testing a cell to see whether it's not equal to several values, e.g.


=if(and(A1<>"Bear",A1<>"Goat",A1<>"Moose",A1<>"Lion") . . .


Is there a way to contruct the test where I only have to cite the cell once, e.g.


=if(A1 <> and("Bear","Goat","Moose","Lion") [I know this isn't real syntax, but you get the idea, I hope]

 

[Hui]

I think this should do it

=IF(Not(OR(A1={"Dog","Cat","Goat","Bear"})),TRUE, FALSE)

 

[polarisking]

Exactly the syntax I was looking for! Thank you very much, Hui.