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...
Then C9 is not equal to Completed. Did you use formula evaluation?
- Hi Detlef. I was able to run the formula evaluation. First it looked a bit strange but then I realised that HansVogelaar was not completely wrong. I had a space AFTER "completed" in my drop-down-list.
NikolinoDE: I will still see whether I can integrate the VLOOKUP function just to know myself.
A huge and sincere Thank you to everybody's input, very much appreciated. - Hello Detlef. Thanks for your idea. Indeed, I only did now an error check with the following outcome: "the error check is complete for the entire sheet". I also tried to trace the error: "the trace error command requires that the active cell contain an error value".
Maybe I am wrong and you meant another command then "error checking"?It's seems that formula evaluation is not available on a Mac.
- So kind, thanks for checking on that! Will find a way to change the system and follow up on this as well and keep you all posted.
