cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

NaN Nonsense in Prime8 and Prime9

GeoffD
13-Aquamarine

NaN Nonsense in Prime8 and Prime9

Has anyone experienced this problem where NaN results appear and disappear for no obvious or repeatable reason ? 

 

GeoffD_0-1678803765668.png

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:

GeoffD_1-1678804483268.png

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

 

0 REPLIES 0
Announcements

Top Tags