# Round to Nearest Multiple Calculator

## Calculator Use

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 the 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**

## Incorrect Rounding with Excel MROUND()

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

Wrong calculation with MROUND function at www.office-archive.com.

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

MROUND(X,0.01)

MROUND(ROUND(X,0.01),2)

**76.2250**

**76.22**

**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.