Forum Discussion
Solved
Help with Excel Function to return the correct status
Hi, I have an excel sheet where i need the "Status" column to either return a blank, "open", "overdue" or closed" status depending on the following scenarios: If "Target" and "Completion" co...
=IF(AND(J8="",K8=""),"",IF(AND(J8<>"",K8<>""),"Closed",IF(AND(J8>O1,K8=""),"Overdue",IF(AND(J8<>"",K8=""),"Open"))))Is this what you are looking for?
=IF(AND(J8="",K8=""),"",IF(AND(J8<>"",K8<>""),"Closed",IF(AND(J8>O1,K8=""),"Overdue",IF(AND(J8<>"",K8=""),"Open"))))Is this what you are looking for?
Thank you so much! Yes that's exactly what i was looking for 🙂