Forum Discussion

Azr4el's avatar
Azr4el
Copper Contributor
Dec 30, 2021

Help with nested function needed

Hello All

 

I have this function which is actually working fine, more or less.

This is the function in cell G9: 

 

=IF(OR(C9="Abandoned",C9="Completed"),"",IF(B9="","",IF(F9="",E9-TODAY(),F9-TODAY())))

 

It does what I want except when it comes to "Completed". Cell G9 is empty if "Abandoned" is chosen in cell C9 but if "Completed" is chosen it calculates the number of days left.

C9 is a dropdown menu of 5 items and in addition cell styles is applied. D, E and F are formatted cells (Date).

Is there anybody out there who can help me fix the error? I am using Office 365 on a Mac.

 

Thank you

 

9 Replies

Resources