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"))
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.