# Excel Round Down

## How to round down in Excel

When performing financial analysis in Excel it’s often useful to round down a number to either a decimal place or a whole number.

In this tutorial we will show you how to round a number down in Excel using the =ROUNDDOWN() formula.

This function will save you time when building a financial model and improve your accuracy in Excel.

### How the formula works

The round down formula in Excel requires you to reference a number and then specify how many units (decimal places) you want to round it to.

=ROUNDDOWN()

In the example below we have shown you how to create a table that uses the formula to link to one number and then return a certain number of decimal places.

Step 1: type “=ROUNDDOWN(“

Step 2: link to the cell you want to round down and add a comma

Step 3: type the number of units, or link to a cell that contains the number of units you want to display

Step 4: close bracket and press enter.

In the screenshot below you will see an example of the “rounddown” function in action.

### More relevant Excel resources

To become an Excel power user please check out our Excel Resources to learn all the most important functions, formulas, shortcuts, tips and tricks.