# Excel ROUNDDOWN Function

The Excel ROUNDDOWN function returns a number rounded down to a given number of places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN rounds *all numbers down*.

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

The ROUNDDOWN function works like the ROUND function, except the ROUNDDOWN function will always round numbers *down*. The number of places to round to is controlled by the *num_digits* argument. Positive numbers round to the right of the decimal point, negative numbers round to the left, and zero rounds to the nearest 1. The table below summarizes this behavior:

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

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

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

=0 | Round down to nearest 1 |

### Example #1 - round to right

To round down 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

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

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

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

## Download 200+ Excel Shortcuts

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