Calculator Soup^{®}

This calculator rounds a number or decimal to the nearest multiple similar to Excel MROUND() function. Both values entered must be positive or both must be negative.

Suppose we wanted to round off money value of $76.225. Depending on which multiple we're rounding to, the final result can vary.

**Round**to the nearest**ten dollars or multiple of 10**(80.000) is**80.00****Round**to the nearest**five dollars or multiple of 5**(75.000) is**75.00****Round**to the nearest**dollar or multiple of 1**(76.000) is**76.00****Round**to the nearest**25 cents or multiple of 0.25**(76.250) is**76.25****Round**to the nearest**10 cents or multiple of 0.10**(76.200) is**76.20****Round**to the nearest**5 cents or multiple of 0.05**(76.250) is**76.25****Round**to the nearest**cent or multiple of 0.01**(76.230) is**76.23**

Several people have discovered rounding errors with Excel MROUND() function, for example

http://www.office-archive.com/14-excel/63cda9916e27c869.htm

Excel is inconsistent with rounding results when applying MROUND(). You can overcome this error by first applying ROUND(). For example

Number (X) | Excel MROUND(X,0.01) |
Excel MROUND(ROUND(X,0.01),2) |
---|---|---|

76.2240 | 76.22 | 76.22 |

76.2250 |
76.22 |
76.23 |

76.2260 | 76.23 | 76.23 |

You can also use an equation to calculate MROUND() in PHP which can be programmed as an equation in Excel.

**Cite this content, page or calculator as:**

Furey, Edward "Round to Nearest Multiple Calculator" From *http://www.CalculatorSoup.com* - Online Calculator Resource.