Multiple If Conditions

		Microsoft Office Forums > Microsoft Excel > Excel
Multiple If Conditions

FAQ

Thread Tools

Display Modes

08-07-2015, 10:08 PM

z941714

Windows 8

Office 2007

Novice

Join Date: Aug 2015

Posts: 6

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"

Attached Files

Delivery Schedule Report ver 2.xlsx (495.7 KB, 13 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 AM.