Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |