Due to the known issue of floating decimal precision in Excel, MROUND formulas are not always 100% accurate in Excel. A simple solution is to add ROUND to the variable going into the formula.


To see an example of how Excel may result differently with MROUND in Excel,  click here.


For example, here's what your original formula may look like:

MROUND(C2*(1+D2),0.25)


Here's what SecureSheet recommends instead:

MROUND(ROUND(C2*(1+D2),6),0.25)


Other rounding considerations:

  • Round to 5 decimal places instead of 2 to avoid inconsistent rounding issues in Excel