Forum Discussion
Round Function Bug
For instance, if the function =ROUND(E11-E12,2) is rounding incorrectly when E11 and E12 are 49.995 & 49.2 respectively. I noticed its also incorrect for 39 and 59. All other values seem to round cor...
As Riny mentioned, it's floating point error. You could try rounding the inputs instead of rounding the result:
=ROUND(E11,2)-ROUND(E12,2)
=ROUND(E11,2)-ROUND(E12,2)