# Excel ROUND Function

The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.

**number**- The number to round.**num_digits**- The number of digits to which number should be rounded.

The ROUNDDOWN function rounds a number to a given number of places. The number of places to round to is controlled by the number of digits provided to ROUND, as seen in the table below:

Digits | Behavior |
---|---|

>0 | Round to nearest .1, .01, .001, etc. |

<0 | Round to nearest 10, 100, 1000, etc. |

=0 | Round to nearest 1 |

### Example #1 - round to right

To round values to the *right* of the decimal point, use a *positive* number for digits:

### Example #2 - round to left

To round down values to the *left* of the decimal point, use *zero* or a *negative* number for digits:

### Example #3 - nesting inside ROUND

Other operations and functions can be nested inside the ROUND function. For example, to round down the result of A1 divided by B1, you can ROUND in a formula like this:

=ROUND(A1/B1,0) // round result to nearest integer

Any formula that returns a numeric result can be nested inside the ROUND function.

### Rounding functions in Excel

- To round normally, use the ROUND function.
- To round to the nearest
*multiple*, use the MROUND function. - To round
*down*to the nearest specified*place*, use the ROUNDDOWN function. - To round
*down*to the nearest specified*multiple*, use the FLOOR function. - To round
*up*to the nearest specified*place*, use the ROUNDUP function. - To round
*up*to the nearest specified*multiple*, use the CEILING function. - To round
*down*and return an integer only, use the INT function. - To truncate decimal places, use the TRUNC function.

### Notes

- Round works by rounding numbers 1-4 down, and rounding numbers 5-9 up.
- The ROUND function rounds numbers to a specified level of precision, determied by
**num_digits**. - If a number is already rounded to the given number of places, no rounding occurs.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.