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.