IF with "or"

[Guest]

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.

 

[Guest]

hi Katie,

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

hth
regards from Brazil
Marcelo

"Katie" escreveu:

 

[Guest]

sorry i forgot the quotes on "keep"

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

regards

"Katie" escreveu:

 

[Guest]

Okay. Let me make this a little more confusing. What I have in there now is-

=IF((F2="WTD")*(J2="Approved"),"Keep","!")

But what I need to say is, If J2="Approved" or "Reversed".. How would I put
that in?

 

[Ragdyer]

Are either of these what you're looking for:

=IF(OR(A2="Blue",A2="Red"),"Keep","Neither")

=IF(OR(A2={"Blue","Red"}),"Keep","Neither")

=IF((A2="Blue")+(A2="Red"),"Keep","Neither")

 

[Sasa Stankovic]

this formula should do just fine (I tested and it worked):
=IF(OR(A2="blue",A2="red"),"KEEP","")

 

[Ragdyer]

Try this:

=IF(OR(J2={"Approved","Reversed"}),"Keep","!")

 

[Guest]

Fantastic. Thank you both of you!

Are either of these what you're looking for:

=IF(OR(A2="Blue",A2="Red"),"Keep","Neither")

=IF(OR(A2={"Blue","Red"}),"Keep","Neither")

=IF((A2="Blue")+(A2="Red"),"Keep","Neither")