MROUND
Returns a number rounded to the desired multiple.
Math & TrigonometryMath Basics
What it does
Rounds a number to a specific multiple.
Syntax
MROUND(number, multiple)
Arguments
number(number) — Value to round.multiple(number) — Multiple to round to.
Examples
Round to Multiple
Round 13 to nearest 5.
FORMULA
=MROUND(13, 5)
RESULT
15
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val | Mult |
| 2 | 13 | 5 |