# 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.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.