- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - MROUND Function
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