Forum Discussion
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-TOD...
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)
NikolinoDE: many thanks as well for your input and providing the links. I was not aware of the "error" functions and will carefully read the articles.
Good point: VLOOKUP. Thanks for reminding me, I was so focused on that "if" that I didn't even consider other solutions. Will try and come back in case I fail.
Good point: VLOOKUP. Thanks for reminding me, I was so focused on that "if" that I didn't even consider other solutions. Will try and come back in case I fail.