match formula question

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?
 
R

RagDyeR

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using IF and VLOOKUP for range of cells 5
Need a function to fill column from other columns 5
Lookup Question 3
How to join two functions in a formula? 1
combining multiple columns using ", " seperations.. 4
Need help with concatenate formula 4
help on INDEX 2
Using Three Conditions in CF 3

Top