The ROUNDDOWN Function allows us to easily Round down in Excel by a specified value. This can be super handy when working with a lot of data that may have far too many decimals for what we are looking to work with.
Rounding down a number isn’t necessarily the most complicated thing in the world, and can definitely just be done manually by re-typing each number, however if we have hundreds of values that we want to bring down to the 3rd decimal only then this formula can be a massive time saver to clean up our data.
In this simple guide, we will run through how to use the Excel ROUNDDOWN function. We will cover:
- The ROUNDDOWN Formula
- Examples of rounding down using different values
Let’s get started with the formula itself.
The formula itself for ROUNDDOWN is a relatively simple one, with the following syntax:
The first number is the raw initial number itself that we are looking to round down, and the num_digits portion specifies exactly what point we want to round down to.
Let’s say we had the value of 76.54 and we wanted to round this down to a single decimal, the formula would end up looking like this:
This would then output a result of 76.5.
There are a few different ways we can use the num_digits portion of the formula when looking to round down in Excel. Essentially the breakdown is as follows:
Positive Number: The number of decimals we are looking for
Zero: This simply rounds down to the nearest whole number with no decimals
Negative Numbers: This one basically moves a specified number of points to the left of the decimal. -1 for example rounds down to the nearest 10, while -2 to the nearest hundred and so on.
Let’s look at some examples that cover off all of the above scenarios with a different range of decimals.
Examples of rounding down in Excel
As mentioned above, outside of rounding down to the nearest specified decimal, we can also simply round down to a whole number, or to the nearest ten, hundred, thousand and more depending on how large the number we are working with is.
Let’s take the below examples. Here we have a series of numbers, some with decimals, some without, and different variations of the formula that have been applied to them, along with the final outputs:
As we can see, while the formula is super simple, the outputs can vary greatly depending on the goal. We have some numbers with a multiple decimals that are rounded to whole numbers such as 99, while we even have numbers in the hundreds of thousands with 4 decimals that we take all the way down to the nearest hundred for an output of 746,300, resulting in a potentially cleaner dataset depending on what kind if analysis we are looking to conduct later on.
While the ROUNDDOWN function let’s us specify exactly how many decimals we want to round down by, or down to the tens or hundreds, another variation of this that is worth briefly covering is the FLOOR Function which let’s us round down to the nearest multiple of a specified value.
FLOOR can also be extremely useful at rounding down in a different series of use cases – we have a separate guide here covering the FLOOR function, which as you will see is a very different way to round down in Excel.
This sums up our quick and easy guide on how to round down in Excel using the built in ROUNDDOWN function. For more handy guides on working with Excel, be sure to check out our Excel Tips page.