MROUND
Syntax
Description
Returns a number rounded to the desired multiple.
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
Example
=MROUND(19.4445; 2) returns 20 because 19.4445 is closer to 20 than it is to 18=MROUND(0.7651; 1) returns 1 because 0.7651 is closer to 1 than it is to 0.
| Value | Rounding multiple | Result |
|---|---|---|
| 0.4 | 1 | 0 |
| 0.5 | 1 | 0 |
| 0.6 | 1 | 1 |
| 8 | 3 | 9 |
| 9 | 3 | 9 |
| 10 | 3 | 9 |
| 11 | 3 | 12 |
| 12 | 3 | 12 |
| 13 | 3 | 12 |
| 1234 | 100 | 1200 |
| 1250 | 100 | 1200 |
| 1251 | 100 | 1300 |
| 1299 | 100 | 1300 |