Some of the numbers added results in rounding errors. For example three numbers with two decimal points added should result in 25,000.00 but the result is 24,999,9999999990000
There can be rounding errors, due to the conversions Base10<->Base2. Most of the computer programs use the IEEE 754 standard where this is decribed in detail. Anyway, if you remember base conversions from school, you remember that a number that has a finite number of decimals in one base may have an infinite number of decimals (although periodic) in another.
Thanks for your asnwer, It helped explaining Excel shorfall. Precision as displayed did not help either. I will have to use formula to make the statement true with > 0.001 and < 0.001 to fix my problem. Any other suggestion?
One of the usual solutions is to round the number. For example if you use 2 decimals use
=Round(A1,2)
Another would be to format the number with 2 decimals and use "Set precision as displayed". This would impact, however, all other values in the workbook.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.