Formula needed, stuck and do not know how to proceed!

[bksparkz]

Good morning All,

Before I start I would like to thank everyone for any help. I love this site and the help I receive is always amazing.

I need help getting a formula to do the following...

Formula is going into cell B4, if true cell b4 should say "Improved" if false "No Improvement"
N4 = Y and M4(date) is >70 days from today and if(BH4 is half of or more than half of AB4) or if (BH4 is 5 or more less than AB4 and BH4 is under 10)

I know this is a lot. I am stuck and do not know how to do this.

Thank you all!

 

[revcanon]

If I understand you correctly:

Try this:

=IF(OR(AND(N4="Y",(M4-TODAY())>=70,BH4>-(AB4/2)),(AND(AB4-BH4<=5,BH4<10))),"Improved","Not Improved")

Walk through each of those logical conditions to make sure that is what you are needing.

It seemed to me that you had 2 sets of data to look at. One where 3 conditions are met, and one where 2 conditions are met.

 

[bksparkz]

Thank You Revcanon for the reply. The formula did not work, and I think I know why. I forget to add another detail. If N4 = N or if N4 is blank, then B4 should be blank.

 

[bksparkz]

Thank You Revcanon for the reply. The formula did not work, and I think I know why. I forget to add another detail. If N4 = N or if N4 is blank, then B4 should be blank.
Also, for M4-Today (I do not know if it makes a difference but M4 is a data that has already passed)