Syntax

[gary]

What is the correct syntax of the Excel formula for this
expression:

If A1="DOG"
or
if B1="CAT"
or
if C1="POSSUM"
or
if D1="FERRET"
then "YES"
else "NO".

 

[Peo Sjoblom]

=IF(OR(A1="Cat",B1="Dog",C1="Possum",D1="Ferret"),"Yes","No")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[GARY]

Peo,

Thanks !

(I was trying to use #OR# instead but I couldn't get the
syntax right).

Gary

 

[Harlan Grove]

(I was trying to use #OR# instead but I couldn't get the
syntax right).

....

That's the 123/Quattro Pro *operator*. Excel uses functions. So AND(..)
rather than #AND# and NOT(..) rather than #NOT#.