Excel Round Down

This article outlines everything you need to know about to round a number down in Excel.

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.

Click here to download the Excel template.

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.