Multiplying in Excel

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.
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top