mutiple criterias formula

[JaneSmith]

i need a formula that has multiple criterias.
ei, in the below list i need column b to "Yes" if column a is "blvd, st,
crt" but not "cir ave or crk", otherwise give null value. also, how many
criteria's can one formula have?

A B
blvd yes
st yes
crt yes
cir
ave
st yes
crk
st yes

 

[T. Valko]

Try this:

=IF(OR(A1={"blvd","st","crt"}),"Yes","")

Copy down as needed.

how many criteria's can one formula have?

Depends on the particular function and what version of Excel you're using.

The OR function can have up to 30 arguments in versions of Excel prior to
Excel 2007. In Excel 2007 it can have up to 255 arguments.

The above OR function has just a single argument although you might think it
has 3.

If you're asking about "how many" you probably should use some type of
lookup formula but you'd have to give us *all the details*.

 

[JaneSmith]

Thank you for the quick response.

Try this:

=IF(OR(A1={"blvd","st","crt"}),"Yes","")

Copy down as needed.


Depends on the particular function and what version of Excel you're using.

The OR function can have up to 30 arguments in versions of Excel prior to
Excel 2007. In Excel 2007 it can have up to 255 arguments.

The above OR function has just a single argument although you might think it
has 3.

If you're asking about "how many" you probably should use some type of
lookup formula but you'd have to give us *all the details*.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you for the quick response.