Multiple If Conditions

z941714 · #1 08-09-2015, 08:08 AM

B2=$H$1,"Due today"
B2<$H$1,E2<>0, E2<>0 is "Missing" when there a date in E2 if it is greater the $H$1,"Current", if less than "Expired"

B2>=$H$1,E2<$H$1, I need to think on this.
D2="" D will always have a yes or no, system report.(I should stated before)

macropod · #2 08-09-2015, 04:12 PM

Quote:

Originally Posted by z941714

B2>$H$1,E2<$H$1, "Expired"

Since that's the same result as for B2<$H$1,E2<$H$1, you can reduce the 'yes' test to:

Code:

IF(D2="YES",IF(AND(B2>=$H$1,E2>=$H$1),"Proactive",IF(E2>=$H$1,"Current","Expired"))

Quote:

Originally Posted by z941714

B2<$H$1,E2<>0, E2<>0 is "Missing" when there a date in E2 if it is greater the $H$1,"Current", if less than "Expired"

is ambiguous, but it seems to suggest your overall formula could be expressed as:

Code:

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

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