Multiple If Conditions

macropod · #1 08-07-2015, 10:37 PM

It seems to me your formula could be reduced to something like:

Code:

=IF(B2+C2=0,"Delivery date needed",IF(C2>0,"Services",IF(AND(D2="NO",B2>$H$1),"Schedule not due yet",IF(D2="NO",IF(AND(B2<H$1,E2=0),"Missing",IF(D2="YES",IF(AND(B2>=$H$1,E2>=B2),"Proactive",""),"")),""))))

Note where I have inserted "". Those indicate missing arguments from your calculations. By comparison, the missing arguments in your existing formula are as indicated by "" in:

Code:

=IF(F2="No","Delivery date needed",IF(F2="Yes",IF(C2<>"","Services",IF(D2="NO",IF(B2>$H$1,"Schedule not due yet",IF(F2="Yes",IF(C2="",IF(D2="NO",IF(B2<H$1,IF(E2="","Missing",IF(F2="Yes",IF(C2="",IF(D2="Yes",IF(B2>=$H$1,IF(E2>=B2,"Proactive",""),""),""),""),"")),""),""),""),"")),"")),""))

z941714 · #2 08-08-2015, 05:17 AM

Thanks for cleaning up the formula, but I still is having an issue with it. It returns a blank cell, instead of "Proactive".

Z941714

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
6 conditions formula	paconovellino	Excel	2	03-05-2012 06:45 AM
3 Conditions	Laurie B.	Excel	4	08-15-2011 10:27 PM
Count with multiple conditions	bundy5150	Excel	4	02-22-2011 10:00 AM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM