Calculation is wrong, Rounding wrong

The problem is that the numbers are being calculated to a higher precision. Try,

=ABS(ROUND(K2, 2)*(ROUND(K11, 2)-ROUND(K10, 2))/ROUND(K13, 2))

Look into the ‘Precision as displayed’ option but be sure to understand all of the caveats before deciding to do it.

enter image description here

Browse More Popular Posts

Leave a Comment