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