Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with complex IF statement
Hi everyone, I hope you can help?
I currently have the below, which either gives me "Not in Use", "Open", "Hit PDD Within 5 Days" or "Missed PDD Over 5 Days" as possible results. =IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within 5 Days",IF(I2=6,"Missed PDD Over 5 Days")))) Now what I'd like to be able to do is then say if E2 does in fact turn out to be "Open", then do another calculation on it to split it down even further so I could have 5 possible results ("Not in Use", "Open Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Missed PDD Over 5 Days") For anything with a result of Open I'd like it to check if F2 is greater than -5 (in which case it would be "Open Missed Limit", if it's less then -5 then "Open Within Limit". I hope this all makes sense as I'm confusing myself now Thanks so much in advance, you guys have been so so helpful and I'm learning a lot (keeping this in my bookmarks for future reference |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with complex IF statement
Hi,
Am Wed, 3 Oct 2012 08:45:27 +0000 schrieb D4WNO: =IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within 5 Days",IF(I2=6,"Missed PDD Over 5 Days")))) Now what I'd like to be able to do is then say if E2 does in fact turn out to be "Open", then do another calculation on it to split it down even further so I could have 5 possible results ("Not in Use", "Open Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Missed PDD Over 5 Days") For anything with a result of Open I'd like it to check if F2 is greater than -5 (in which case it would be "Open Missed Limit", if it's less then -5 then "Open Within Limit". try: =IF(B2="","Not in Use",IF(AND(E2="",F2-5),"Open Missed Limit",IF(AND(E2="",F2<-5),"Open Within Limit",IF(I2<=5,"Hit PDD Within 5 Days",IF(I25,"Missed PDD Over 5 Days"))))) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex IF Statement | Excel Discussion (Misc queries) | |||
Complex If/And Statement | Excel Worksheet Functions | |||
Complex IF statement | Excel Programming | |||
complex IF statement | Excel Programming | |||
complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) |