| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match formula question
With this current formula: =IF(O2<21,"",IF(AND(O2<28,M2TODAY(),Q2100000),"X ","")) What would i add to the formula if i wanted to also indicate that if there was no date in M then i want to consider it meeting the condition along with the other to. ie if m2 today or blank, and q2100000 and 02 is between 21-28 days? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match formula question
Does this work for you:
=IF(O2<21,"",IF(AND(O2<28,OR(M2TODAY(),M2=""),Q2 100000),"X","")) ? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Belinda7237" wrote in message ... With this current formula: =IF(O2<21,"",IF(AND(O2<28,M2TODAY(),Q2100000),"X ","")) What would i add to the formula if i wanted to also indicate that if there was no date in M then i want to consider it meeting the condition along with the other to. ie if m2 today or blank, and q2100000 and 02 is between 21-28 days? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match with isna formula question | Excel Worksheet Functions | |||
| match formula question | Excel Worksheet Functions | |||
| Match formula question | Excel Worksheet Functions | |||
| INDEX/MATCH formula question | Excel Discussion (Misc queries) | |||
| Question about the "Match" formula | Excel Discussion (Misc queries) | |||
Linear Mode
