Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# ROUND function

## Description

The **ROUND** function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

=ROUND(A1, 2)

The result of this function is 23.78.

## Syntax

ROUND(number, num_digits)

The ROUND function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

**number**Required. The number that you want to round.**num_digits**Required. The number of digits to which you want to round the number argument.

## Remarks

- If
is greater than 0 (zero), then number is rounded to the specified number of decimal places.*num_digits* - If
is 0, the number is rounded to the nearest integer.*num_digits* - If
is less than 0, the number is rounded to the left of the decimal point.*num_digits* - 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.

## Example

The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.

To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.

Applies to:

Excel 2013, Excel Online