ExcelBanter - match formula question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - match formula question (https://www.excelbanter.com/excel-worksheet-functions/201084-match-formula-question.html)

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?

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?