Forum Discussion
Solved
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"...
=IF(O2<>"", "Closed", IF(OR(L2="Expired",ISBLANK(L2)),"In Progress","Closed"))
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".
If I focus on the other statement for "Closed": column L or column O are not blank. This would be:
=IF(COUNTA(L2,O2),"Closed","In Progress")
Row 5, 6 and 7 show different results. So, your rules are not unambiguously.
Like this
=IF(ISBLANK(K2),"",IF( OR(L2="Expired",ISBLANK(L2)),"In Progress",IF(OR(O2<>"",L2<>""),"Closed","Not defined")))
Hi Sergei,
This doesn't take into account if Column L is "Expired" and a date is given in Column O. Column P should display "Closed"
