Multiplying in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top