ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/11239-excel-formulas.html)

albebach

Excel Formulas
 
When multiplying numbers in excel using formulas the answer seems to be
incorrect by a few hundreths of a point. When you compare the excel answer
with that of a calculator they are different. Why is this and can this be
changed?

Peo Sjoblom

Not Excel per se, more of how computers work

http://www.cpearson.com/excel/rounding.htm



Regards,

Peo Sjoblom

"albebach" wrote in message
...
When multiplying numbers in excel using formulas the answer seems to be
incorrect by a few hundreths of a point. When you compare the excel

answer
with that of a calculator they are different. Why is this and can this be
changed?





All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com