match formula question

  • Thread starter Thread starter Belinda7237
  • Start date Start date
B

Belinda7237

With this current formula:
=IF(O2<21,"",IF(AND(O2<28,M2>TODAY(),Q2>100000),"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 q2>100000 and 02 is between
21-28 days?
 
Does this work for you:

=IF(O2<21,"",IF(AND(O2<28,OR(M2>TODAY(),M2=""),Q2>100000),"X",""))

?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



With this current formula:
=IF(O2<21,"",IF(AND(O2<28,M2>TODAY(),Q2>100000),"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 q2>100000 and 02 is between
21-28 days?
 
Back
Top