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.
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.