Thread: IF with "or"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default IF with "or"

sorry i forgot the quotes on "keep"

=if(or(A2="BLUE",A2="RED"),"KEEP","")

regards

"Katie" escreveu:

I know this is a crazy question but I was wondering if I want to say,

If A2 = "blue" or "red" then display "keep". How do I input the "or". I know
And is displayed as "*".

Thank you.