In this article, we will learn how to use ROUNDOWN function in Excel.
ROUNDDOWN function Round downs the numbers from 1-9. Unlike Round function, round down the numbers less than 5. It takes 2 arguments
Let’s use them in some examples to see how it works.
In one Column there are Numbers and in other, there are num_digits up to which the number to be rounded down.
Use the formula in C2 cell.
Here in C2 cell, the number will be round off to 1 decimal place.
As you can see 2.4 is rounded DOWN to 1 decimal place.
Copy the formula using Ctrl + D taking the first cell till the last cell needed formula.
As you can see
Hope you understood how to use ROUNDDOWN function in Excel. Explore more articles on ROUND and ROUNDUP function here. State your queries in the comment box below.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.