Multiple IF/OR Statements in Excel

[Sundance_Kid]

Hey Folks

Just need a small bit of help with an IF & OR formula.

I am trying to say IF cell A1 is equal to Blue or Green then the answer is Home, if cell A1 is equal to Red then the answer is Away, otherwise I want to insert the word Check into the cell if A1 does not say Blue, Green or Red.

I could do it by doing multiple IF statements, like if A1 = Blue then Home, if A1 = Green then Home, if A1 = Red then Away but I am trying to see can I incorporate the OR function as Blue or Green can both return the same answer. Or just see is there a more efficient way to write a formula.

Thanks

 

[Sundance_Kid]

Just an update, I managed to figure it out.

Thanks

 

[Toadstool]

...as usual I'm too slow
=IF(OR(A1="Blue",A1="Green"),"Home",IF(A1="Red","Away","Check"))

 

[Dave87]

=IF(OR(UPPER(A1)="BLUE",UPPER(A1)="GREEN",UPPER(A1)="RED"),IF(OR(UPPER(A1)="BLUE",UPPER(A1)="GREEN"),"Home",IF(UPPER(A1)="RED","Away",)),"Check")

 

[Scott Huish]

=IF(OR(UPPER(A1)="BLUE",UPPER(A1)="GREEN",UPPER(A1)="RED"),IF(OR(UPPER(A1)="BLUE",UPPER(A1)="GREEN"),"Home",IF(UPPER(A1)="RED","Away",)),"Check")

If isn't case sensitive. The UPPER is unnecessary.

 

[Scott Huish]

=IF(OR(A1={"Blue","Green"}),"Home",IF(A1="Red","Away","Check"))