Dec 30 2021 05:05 AM
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
Dec 30 2021 05:21 AM
Dec 30 2021 05:25 AM
Perhaps there is a space after (or before) Completed?
Dec 30 2021 05:29 AM
Hide error values and error indicators in cells
With your permission, I also recommend the VLOOKUP function for such cases.
Hope this information could help you.
Wish you a nice day.
I know I don't know anything (Socrates)
Jan 04 2022 10:19 PM
@Hans Vogelaar Thanks for bringing this up; I checked and confirm that it is , unfortunately, not that easy.
Jan 04 2022 10:30 PM
Jan 04 2022 10:43 PM
Jan 04 2022 10:47 PM
It's seems that formula evaluation is not available on a Mac.
Jan 04 2022 10:51 PM
Jan 05 2022 05:23 AM