|
|
#1
08-07-2015, 10:08 PM
|
|||
|
|||
Multiple If Conditions
I am having a problem with this formula. =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",I F(B2>=$H$1,IF(E2>=B2,"Proactive")))))))))))))))
Everything working except the last condition. "Proactive" 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2007
Threaded Mode