ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My calculations are not always exact/accurate (https://www.excelbanter.com/excel-discussion-misc-queries/24165-my-calculations-not-always-exact-accurate.html)

kanye

My calculations are not always exact/accurate
 
The formulas in my speadsheet aren't always accurate. Sometimes they are off
by 1 penny, othertimes by as more as $4. How can I fix?

Don Guillett

rounding? within the formula steps
=round(a1,2)*round(a2,4)

--
Don Guillett
SalesAid Software

"kanye" wrote in message
...
The formulas in my speadsheet aren't always accurate. Sometimes they are

off
by 1 penny, othertimes by as more as $4. How can I fix?





All times are GMT +1. The time now is 03:49 AM.

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