Forum Discussion
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...
That's since 20.15-20 actually is equal to
0.14999999999999900 The workaround is
=ROUND(B1,1)-ROUND(A1,1)
I also can confirm that the actual # is 0.149 which rounds down and needs to have a "round" function added. Please mark the first comment with this answer as correct! Neelakandan2408
-Aron