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"))
Incorrect Formula..
Iv Column L Displays "Expire" and Column O is blank this formula still returns "Closed" and I would want it to display "In Progress"
=IF(O2<>"", "Closed", IF(OR(L2="Expired",ISBLANK(L2)),"In Progress","Closed"))
You may wrap it with another IF
=IF(K2="","",IF(O2<>"", "Closed", IF(OR(L2="Expired",ISBLANK(L2)),"In Progress","Closed")))
The only thing the formula doesn't do is Blank the cell if Column K is blank..
Not to worry, I can live with that.
Huh, so far so good.
Ignore me!!
You have cracked!
This formula returns "Closed" even if Column L and Column O are blank. It should return "In Progress"