Forum Discussion

Copper Contributor

Jun 29, 2019

Solved

Excel roundup decimal 0.15 problem

hi team, Kindly look out the excel which i have added. can u pls checked the calculation.when i subtracted cell C with cell D i have result in cell cell E(here no issues).but when i round of the resul...

A3D9C905-2AEF-49E2-A4CD-1FE0F2224E43.MP4466 KB

Formulas and Functions

SergeiBaklan
Jun 29, 2019
Neelakandan2408

That's since 20.15-20 actually is equal to

0.14999999999999900

https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/

The workaround is

=ROUND(B1,1)-ROUND(A1,1)

SergeiBaklan

Diamond Contributor

Jun 29, 2019

Neelakandan2408

That's since 20.15-20 actually is equal to

0.14999999999999900

https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/

The workaround is

=ROUND(B1,1)-ROUND(A1,1)