Three Criteria for an If Statement

[Excel_77]

Hi All,

In column A I want to check for "Liverpool Football" and in Column B I want to check for the words "Football" or "Sport", if this criteria is met I want "yes" returned otherwise "no", how can this be done?

Thanks

 

[Nishant94]

Unknown
	A	B	C
1	Liverpool Football	Football	Yes
2	Other	Football	No
3	Liverpool Football	Sport	Yes
4	Other	Sport	No
5	Other	Football	No
6	Liverpool Football	Nothing	No
Sheet8

Cell Formulas
Range	Formula
C1	=IF(AND(A1="Liverpool Football",ISNUMBER(MATCH(B1,{"Football","Sport"},0))),"Yes","No")

 

[mrhstn]

Another option might be

=IF((A1="Liverpool Football")*(OR(B1={"Football","Sport"})), "Yes", "No")

 

[Excel_77]

Great, works perfectly, jut in the same vein why is the below not working for me? Basically if column A has "Yes" in it I want "1" returned, otherwise I want to check B and if it has yes I want "5" returned and if both fail I want "test" returned, I have tried below and just been returned "FALSE".

=IF(IF(A="Yes","1"),IF(B="Yes","5","Test"))

 

[FormR]

Hi, the second IF() should be nested in the FALSE part of the first IF().

=IF(A1="Yes",1,IF(B1="Yes",5,"Test"))

Note, you should also leave the quotes from around the numbers else they get returned as text.