| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF's with an OR
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(L20,"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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's with an OR
Try this...
=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L20, "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(L20,"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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's with an OR
=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="text2"),IF(L20, "Yes","No"),""),"")
Regards Steve "Nadine" wrote in message ... 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(L20,"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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's with an OR
=IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L20, "Yes","No"),""),"")
-- David Biddulph "Nadine" wrote in message ... 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(L20,"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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's with an OR
WONDERFUL! Thanks so much.
"Ms-Exl-Learner" wrote: Try this... =IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L20, "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(L20,"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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF's with an OR
You are welcome and thanks for feeding back.
-------------------- (Ms-Exl-Learner) -------------------- "Nadine" wrote: WONDERFUL! Thanks so much. "Ms-Exl-Learner" wrote: Try this... =IF(O2<=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L20, "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(L20,"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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How 2 avoid multiple IF's by LOOKUP's??? | Excel Discussion (Misc queries) | |||
| Multiple IF's to Select a Value | Excel Worksheet Functions | |||
| Multiple If's and OR's | Excel Worksheet Functions | |||
| multiple IF's ? | Excel Worksheet Functions | |||
| Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
Linear Mode
