Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Compute Expert

Excel ROUNDDOWN Formula: Functions, Examples, and How to Use


Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> Excel ROUNDDOWN Formula: Functions, Examples, and How to Use





In this tutorial, you will learn completely how to use the excel ROUNDDOWN formula.

The rounding process is an important thing when we process numbers in excel, especially the decimal ones. Sometimes, we need to round a number specifically down, not normally. Fortunately, excel provides us with the ROUNDDOWN formula to do just that.

Want to understand more about this formula? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







ROUNDDOWN Function in Excel

We can use ROUNDDOWN to round a number (usually a decimal) down to a certain number of decimals.



ROUNDDOWN Result

ROUNDDOWN gives us a rounded number with details based on our inputs to it.



Excel Version from Which We Can Use ROUNDDOWN

We can start using ROUNDDOWN since excel 2003.



The Way to Write It and Its Inputs

Here is the writing form of ROUNDDOWN in excel.

= ROUNDDOWN ( number_to_round , number_of_decimals )


And here is the explanation of each input we should give to ROUNDDOWN.
  • number_to_round = the number that we want to round down
  • number_of_decimals = the number of decimals we want for the rounding process result



Example of Its Usage and Result

Here is the implementation and result example of ROUNDDOWN in excel.

Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of the ROUNDDOWN Implementation Example in Excel

In the screenshot above, we want to round down our numbers to the number of decimals requested in each row. To do that much easier and faster, we use ROUNDDOWN.

You can see the ROUNDDOWN formula writing for each row on the right side of the table. We input the number we want to round down and the number of decimals we want for the result in ROUNDDOWN. Just as explained in the tutorial’s previous part.

The results are as you can see in the screenshot. We get our rounded decimal numbers in no time using the formula!



Writing Steps

After discussing the ROUNDDOWN writing form, inputs, and example, now let’s discuss this formula’s writing steps. We give a screenshot for each step explanation so you can understand the implementation of the step easier!

  1. Type an equal sign ( = ) in the cell where you want to put the ROUNDDOWN result in

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 1

  2. Type ROUNDDOWN (can be with large and small letters) and an open bracket sign after =

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 2

  3. Input the number/cell coordinate where the number which you want to round down is. Then, type a comma sign ( , )

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 3

  4. Input the number of decimals you want for the result/cell coordinate where it is

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 4

  5. Type a close bracket sign

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 5

  6. Press Enter
  7. Done!

    Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of Step 7






Round Down to the Nearest Whole Number in Excel Using ROUNDDOWN

What if instead of rounding down to another decimal, we want to round down to a whole number? Can we do that using ROUNDDOWN?

The answer is yes, you can! Just input 0 for the number of decimals you request as a symbol that you want a whole number result.

With that in mind, here is the writing form of ROUNDDOWN which rounds down your decimal to its nearest whole number.

= ROUNDDOWN ( number_to_round , 0 )


Write the ROUNDDOWN normally and don’t forget to give 0 as its number of decimals input!

To make the explanation clearer, here is an example of the ROUNDDOWN writing implementation in excel.

Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of the ROUNDDOWN Implementation Example to Round Down a Number to its Nearest Whole Number in Excel

In this example, we use 0 for the number of decimals inputs in our ROUNDDOWNs to round down our numbers. As a result, we get all the results in whole numbers!



Round Down to the Nearest 10, 100, etc Multiples in Excel Using ROUNDDOWN

By using ROUNDDOWN, you can also round down a number you have to 10 multiples (10, 100, 1000, etc) fast. You just need to give a negative number to the number of decimals input in your ROUNDDOWN.

Generally, here is the writing form of ROUNDDOWN to do the rounding process.

= ROUNDDOWN ( number_to_round , - power_level_of_10 )


The negative number you input into ROUNDDOWN depends on the power level of 10 you want for the rounding process result. Here are some examples for that.
  • If you input -1, then ROUNDDOWN will round down your number to the nearest 10 multiples (10 = 10 powered by 1)
  • If you input -2, then ROUNDDOWN will round down your number to the nearest 100 multiples (100 = 10 powered by 2)
  • If you input -5, then ROUNDDOWN will round down your number to the nearest 10000 multiples (10000 = 10 powered by 5)

Still confused? Here is the implementation example of this ROUNDDOWN concept.

Excel ROUNDDOWN Formula: Functions, Examples, and How to Use - Screenshot of the ROUNDDOWN Implementation Example to Round Down a Number to the Nearest 10 Multiples in Excel

As you can see in the example, we get 10, 100, 1000, and 10000000 multiples rounding process results for our numbers. That is because we give a negative number for the second input of each of our ROUNDDOWNs!

We adjust the magnitude of the negative number input according to the multiples we want to round down our number to. We use -1 for 10, -2, for 100, -3 for 1000, and -7 for 10000000.

Write your ROUNDDOWN formula correctly to get the rounding down process result you want from the formula!



Exercise

After we have discussed completely excel ROUNDDOWN formula usage, let’s do an exercise related to the discussion!

Download the exercise file from the link below and answer all of the following questions. Download and see the answer key file if you have done the exercise and want to check your results!

Link to the exercise file:
Download here

Questions

  1. What is the answer if we round down to 5 decimals?
  2. What is the answer if we round down to a whole number?
  3. What is the answer if we round down to the nearest hundred?

Link to the answer key file:
Download here



Additional Note

Want to know other rounding formulas that you can use in excel? Visit this Compute Expert tutorial to learn and master them!



Other tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert