If A1 = Red or Blue, Yes otherwise No

[Fuzzy]

I cannot get this to work. A1 has text "Red" or "Blue" and I want B1 to read =if A1="Red","Red" if A1="Blue","Red", otherwise "Green". This is so simple but tonight I cannot get it.
Thanks in advance.

 

[etaf]

=if(A1="red","red",if(A1="blue","blue","green"))

Book7
	A	B
1		green
2	red	red
3		green
4	blue	blue
5		green
6	yellow	green
7		green
Sheet1

Cell Formulas
Range	Formula
B1:B7	B1	=IF(A1="red","red",IF(A1="blue","blue","green"))

 

[Fuzzy]

I cannot get this to work. A1 has text "Red" or "Blue" and I want B1 to read =if A1="Red","Red" if A1="Blue","Red", otherwise "Green". This is so simple but tonight I cannot get it.
Thanks in advance.

Got it and thanks, I missed the second 'if',

 

[FormR]

Hi, you could also approach it this way:

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