We have a problem in the office that we can not figure out.
One worksheet, when opened on one computer works fine. When opened on another computer, an if statement with an EDATE function gives a NAME? error.
When I evaluate the error (Show Calculation Steps...) here is what is returned:
IF(40402, EDATE(D69, 1), "")
IF (TRUE, #NAME?,"")
There is definitely a date in D69 (as it serializes in the calculation steps). Just tested on a third, and it works fin on that one also.
I have no idea why this is happening. Any ideas?
Bookmarks