Multiplying in Excel
Why does excel and my calculator come up with different answer when
multiplying numbers with decimal points? Excel seems to be off by a couple hundreths of a point. |
On Thu, 3 Feb 2005 07:53:03 -0800, "albebach"
wrote: Why does excel and my calculator come up with different answer when multiplying numbers with decimal points? Excel seems to be off by a couple hundreths of a point. Hard to tell why you get the results you do when you post so little information. The most likely answers have to do either with you not realizing that certain values in Excel are being displayed as rounded numbers, but are calculating based on their actual values; or with the inability of programs that conform to certain IEEE specifications to accurately represent certain decimal numbers in binary format. If you post more information, you may receive a more specific answer. --ron |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com