Multiple IF's with an OR
in [Functions]
|
From: Nadine on 4 Jun 2010 12:18 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 4 Jun 2010 12:27 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 4 Jun 2010 12:27 =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 4 Jun 2010 12:31 =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 4 Jun 2010 12:33
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. |