IF with "or"

[Katie]

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.

[Marcelo]

hi Katie,

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

hth
regards from Brazil
Marcelo

"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.

[Marcelo]

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.

[Katie]

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?
"Marcelo" wrote:

> 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.

[Ragdyer]

Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Katie" <[email protected]> wrote in message
news:[email protected]...
> 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?
> "Marcelo" wrote:
>
>> 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.

[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")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Katie" <[email protected]> wrote in message
news:[email protected]...
>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.

[Katie]

Fantastic. Thank you both of you!

"Ragdyer" wrote:

> 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")
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Katie" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>

[Sasa Stankovic]

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

"Katie" <[email protected]> wrote in message
news:[email protected]...
>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.