MROUND(number, multiple)

Returns the number rounded to the desired multiple.

numberThe number you want to round.
multipleThe multiple to which you want to round.

Remarks

* This function rounds up, if the remainder of dividing "number" by "multiple" is greater than or equal to half the value of "multiple".
* This function rounds down, if the remainder of dividing "number" by "multiple" is less than half the value of "multiple".
* If "number" and "multiple" have different signs, then #NUM! is returned.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=MROUND(10,3) = 9
2=MROUND(-10,-3) = -9
3=MROUND(1.58,0.5) = 1.5
4=MROUND(1.3,0.2) = 1.4
5=MROUND(1234,100) = 1200
6=MROUND(1234,1000) = 1000
7=MROUND(5,-2) = #NUM!
8=MROUND(-5,2) = #NUM!
9=MROUND(10,"some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top