®

Online Calculator Resource

Round to Nearest Multiple Calculator

Round to Nearest Multiple
Answer:

76.55

Details:
Your value is near the following
multiples of 0.05:

76.45
76.5
76.55

Rounding, the nearest is 76.55

Share this Calculator & Page

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

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.

Follow CalculatorSoup: