Math and Trignometric - MROUND Function
Advertisements
Description
The MROUND function returns a number rounded to the desired multiple. MROUND function is one of fifteen rounding functions in Excel.
Syntax
MROUND (number, multiple)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The value to round. | Required |
Multiple | The multiple to which you want to round number. | Required |
Notes
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.
If multiple has a different arithmetic sign (positive or negative) to the number, MROUND returns #NUM! error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements