Forum Discussion

reemav's avatar
reemav
Copper Contributor
Mar 10, 2022
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...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 10, 2022

reemav 

=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? 

  • reemav's avatar
    reemav
    Copper Contributor
    Mar 23, 2022
    Thank you so much! Yes that's exactly what i was looking for 🙂

Resources