Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-05-2015, 03:17 AM
Richard121 Richard121 is offline Errors in financial calculations Windows 7 64bit Errors in financial calculations Office 2013
Novice
Errors in financial calculations
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors in financial calculations Tiered Fee Calculations lynchbro Excel 5 07-17-2014 11:01 AM
Errors in financial calculations Financial Data Organization captain_hawkeye Excel 1 06-14-2010 04:09 AM
Errors in financial calculations Federal financial rounding? markg2 Excel 6 05-26-2010 09:54 AM
Formatting financial ratios jtrobinson Word 0 01-19-2010 06:46 AM
Errors in financial calculations Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft