View Single Post
 
Old 05-05-2015, 03:17 AM
Richard121 Richard121 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2015
Posts: 10
Richard121 is on a distinguished road
Default

Thanks, Pecoflyer. I have looked at the link.
Although the explanation is clear the fixes are either inaccurate or inelegant. But here is a curiosity: if you take an empty cell and enter =17.73-25.00 you get -7.27, which is correct.
So the link explanation does not really solve the problem of why in my spreadsheet G18-F19 gives the wrong result in G19. In neither G18 or F19 are there any floating point errors, and Excel has shown it is perfectly capable of doing the calculation correctly!
Richard
Reply With Quote