4 scenario if statement

[ExcelHelpNeeded99]

Hi there,

I want to get a formula for 4 different scenarios.


- Dog
- Cat
- Siamese Cat
- Everything else



- Ideally Id like to say if contains Dog or if contains cat do this, otherwise do that
- Id still be happy with, if dog then do this, if cat then so this, if siamese cat then do this otherwise do this.

Thanks

 

[Trebor76]

Ideally Id like to say if contains Dog or if contains cat do this, otherwise do that

Try this where 1 will be allocated for Dog or Cat (not case sensitive) and 2 for everything else:

=IF(OR(A2="Dog",A2="Cat"),1,2)

HTH

Robert

 

[jtakw]

Hi,

Something like this:

Book1
	A	B
1	5 legged	Martian
Sheet115

Cell Formulas
Range	Formula
B1	=IF(OR(A1={"Dog","Cat","Siamese Cat"}),"Pet","Martian")

Add as many Criterion as you need within the curly brackets.