Forum Discussion
Nested IF
Hopefully someone can understand what I'm trying to achieve and lend a helping hand!
The formula I'm trying to use is as follows:
=IF(K2="",D,IF( (L2="Expired"),IF(O5="" AND L2=""),"In Progress","Closed"),"Closed"))
What im trying to achieve is for Column P to display either "Closed" or "In Progress". If Column L is blank or "Expired" then Column P should display "In Progress". If Column L or Column O is NOT blank, Column P is to display "Closed".
There is a sample file attached and thank you in advance!!!
=IF(O2<>"", "Closed", IF(OR(L2="Expired",ISBLANK(L2)),"In Progress","Closed"))
21 Replies
Aaron,
=IF(OR(L2="",L2="Expired"),"In Progesss","Closed")
Hi there,
You have missed the fact that if Column O has a date entered, Column P should display "Closed"
Well... you stated that the result would either "Closed" or "In Progress".
And the rules for "In Progress" are: column L is blank or "Expired". So everything else must "Closed".
Hi Aaron,
What do you mean under the D in
=IF(K2="",D...
?
- Nothing as such, it will just blank the cell when conditionally formatted.
