From: Nadine on
Cell DQ contains a formula that pulls in the status of the item.

Here is my existing formula so far:
=IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")

What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
but I don't know how to do that in Excel 2003.

Thanks.
From: Ms-Exl-Learner on
Try this...

=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L2>0,"Yes","No"),""),"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Nadine" wrote:

> Cell DQ contains a formula that pulls in the status of the item.
>
> Here is my existing formula so far:
> =IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")
>
> What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
> but I don't know how to do that in Excel 2003.
>
> Thanks.
From: steve on
=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="text2"),IF(L2>0,"Yes","No"),""),"")

Regards
Steve

"Nadine" <Nadine(a)discussions.microsoft.com> wrote in message
news:156D9985-550B-431E-84A3-5B67970A95E1(a)microsoft.com...
> Cell DQ contains a formula that pulls in the status of the item.
>
> Here is my existing formula so far:
> =IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")
>
> What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
> but I don't know how to do that in Excel 2003.
>
> Thanks.


From: "David Biddulph" groups [at] on
=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L2>0,"Yes","No"),""),"")
--
David Biddulph

"Nadine" <Nadine(a)discussions.microsoft.com> wrote in message
news:156D9985-550B-431E-84A3-5B67970A95E1(a)microsoft.com...
> Cell DQ contains a formula that pulls in the status of the item.
>
> Here is my existing formula so far:
> =IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")
>
> What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
> but I don't know how to do that in Excel 2003.
>
> Thanks.


From: Nadine on
WONDERFUL! Thanks so much.

"Ms-Exl-Learner" wrote:

> Try this...
>
> =IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L2>0,"Yes","No"),""),"")
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "Nadine" wrote:
>
> > Cell DQ contains a formula that pulls in the status of the item.
> >
> > Here is my existing formula so far:
> > =IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")
> >
> > What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
> > but I don't know how to do that in Excel 2003.
> >
> > Thanks.