- 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 - ROUND Function
Description
The ROUND function rounds a number to a specified number of digits. ROUND is one of the Excel Rounding Functions.
Syntax
ROUND (number, num_digits)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| number | The number that you want to round. | Required |
| num_digits | The number of digits to which you want to round the number argument. | Required |
Notes
If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, the number is rounded to the nearest integer.
If num_digits is less than 0, the number is rounded to the left of the decimal point.
To always round up (away from zero) use the ROUNDUP function.
To always round down (toward zero) use the ROUNDDOWN function.
To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND Function.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements