D
D4WNO
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 possibl
results.
=IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within
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 tur
out to be "Open", then do another calculation on it to split it dow
even further so I could have 5 possible results ("Not in Use", "Ope
Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Misse
PDD Over 5 Days")
For anything with a result of Open I'd like it to check if F2 is greate
than -5 (in which case it would be "Open Missed Limit", if it's les
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'
learning a lot (keeping this in my bookmarks for future referenc
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 possibl
results.
=IF(B2="","Not in Use",IF(E2="","Open",IF(I2<=5,"Hit PDD Within
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 tur
out to be "Open", then do another calculation on it to split it dow
even further so I could have 5 possible results ("Not in Use", "Ope
Within Limit", "Open Missed Limit", "Hit PDD Within 5 Days" or "Misse
PDD Over 5 Days")
For anything with a result of Open I'd like it to check if F2 is greate
than -5 (in which case it would be "Open Missed Limit", if it's les
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'
learning a lot (keeping this in my bookmarks for future referenc