Category: Number function

This function rounds a number to the desired multiple (grain).

Return value type: Number

MRound uses "bankers rounding" which rounds to the nearest even value.

mround(5.3, 0.5) //Returns 5.5

mround(10.05, 0.1) //Returns 10.0 (.05 rounds down)

mround(10.06, 0.1) //Returns 10.1 (greater than .05 rounds up)

mround(20.78, 1) //Returns 21

mround(57, 15) //Returns 60

• Ceiling(number)
• Floor(number)
• Round(number, dec_places)
• RoundXL(number, dec_places)
• Truncate(number)