Forum Discussion
Azr4el
Dec 30, 2021Copper Contributor
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...
Azr4el
Jan 05, 2022Copper Contributor
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"?
Maybe I am wrong and you meant another command then "error checking"?
Detlef_Lewin
Jan 05, 2022Silver Contributor
It's seems that formula evaluation is not available on a Mac.
- Azr4elJan 05, 2022Copper ContributorSo 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.