Excel Round Down Formula
In this excel tutorial, we’ll learn how to round down in excel. Round function in excel just rounds a given numeric value to specific number of digits. But Round down in excel is used to round down the numeric value to given decimal places.
The Round down function in excel works just like other excel functions. It can used as a formula in a cell.
Example: we have a numeric value let’s say 76, normally if you use round the numeric value will be rounded to nearest 10 which will return 80 as the value. But if we use Excel round down function, it’ll return 70.
How to Round Down in Excel
Just follow the basic syntax for Excel Round Down formula:
Number: refers to the number you want to roundup.
Num_digits: refers to the number of decimal places to which this number would be rounded down.
The value of Num_digits could be negative as well as positive. Positive number works to the right of the decimal, it tells excel to round to the right of decimal point. The negative value works to the left of the decimal. And if the num_digit is 0 then it rounds to nearest 1.
Let’s see how to use the round down formula:
- Select the numeric value you want to round up and use the rounddown formula.
It will round down Value in A2 cell up-to 3 decimal places to the right.
- Let’s round down to two decimal places to the left.
It will round down value in A3 up to 2 decimal places to the left.
Let’s see some more variations of round down in excel:
Round Down to nearest 5
Use =ROUNDDOWN(A2,-0.5) This will rounddown the value to the nearest 5
Round Down to nearest 100
Use =ROUNDDOWN(A2,-2) This will rounddown the value to the nearest 100
Round Down to nearest 1000
Use =ROUNDDOWN(A2,-3) This will rounddown the value to the nearest 1000
Round Down to nearest whole number
Use =ROUNDDOWN(A2,0) This will round down the value to the nearest whole number
Excel round down comes in very handy when dealing with a large set of numeric values having decimal places. Do check Excel Round & Excel Round Up functions to better understand the different variations of round.
I hope this article was helpful to you and explained you in depth the use of excel rounddown formula and much more.
If you have any questions or tips, I’d love to hear them in the comment section below.
Free Excel Resources
Get top 10 free excel templates, excel shortcuts and other free excel resources to help you learn excel.
Excel Training Courses
Learn Pivot Tables, Vlookup, Power BI and much more.
Our training courses are coming soon.