If / Or Statement.

[Ian Betteridge]

Good Morning,
I'm after a statement that when cell A1 isn't=Red or A1 isn't=Yellow then enter "" otherwise enter "SALE"

Thanks Ian

 

[Airfix9]

=IF(AND(A1<>"Red",A1<>"Yellow"),"","SALE")

 

[Ian Betteridge]

Works perfect.
Thank you