Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
Has anyone experienced this problem where NaN results appear and disappear for no obvious or repeatable reason ?
This is not a one-off event and appears to happen when working with large worksheets. It happened a lot with Prime8 and it appears Prime9 is prone to the same issue.
On recalculating the worksheet and changing nothing, I get:
If no one else has seen this issue then it might be a problem with my machine - although, I have checked the memory without finding any issues.
Thanks
GeoffD