Rounddown function in excel rounds off the decimal number but it also allows us to eliminate the complete digits after the selected number and replaces those numbers after decimal with Zeros. For example, if we have a number with 4 decimal digits and we select 2 in place of num_digit then after 2 digits of decimal we will be having 00 till the last decimal digit that number has.
Syntax: =ROUNDDOWN (number, num_digits)
The ROUNDDOWN function syntax has the following arguments:
- number – The number to round down.
- num_digits – The number of digits to which number should be rounded down.
Example: Let’s look at some Excel ROUNDDOWN function examples and explore how to use the ROUNDDOWN function as a worksheet function in Microsoft Excel:
Syntax: =ROUNDDOWN(A2,B2)
Result:
Based on the Excel spreadsheet above, the following ROUNDDOWN examples would return:
Syntax: =ROUNDDOWN(A3,B3)
Result: 586
Syntax: =ROUNDDOWN(A4,B4)
Result: 800.258
Syntax: =ROUNDDOWN(A5,B5)
Result: -800.2
Syntax: =ROUNDDOWN(A6,B6)
Result: 800.2
Syntax: =ROUNDDOWN(A7,B7)
Result: 800.25
Syntax: =ROUNDDOWN(A8,B8)
Result: 800
Syntax: =ROUNDDOWN(A9,B9)
Result: 800
Syntax: =ROUNDDOWN(A10,B10)
Result: 35000
Syntax: =ROUNDDOWN(A11,B11)
Result: 30000
Note:
A ROUNDDOWN function can round either to the right or left side of the decimal point.
- If the num_digits argument is greater than 0, Then it results in or number is rounded down to the specified number of decimal places to the right of the decimal point.
E.G. =ROUNDDOWN(984.5395,2) returns the value 984.53
- If a num_digits argument is equal to 0, Then it results in or number is rounded down to the nearest integer
E.G. =ROUNDDOWN(984.5395,0) returns the value 984
- If a num_digits argument is lesser than 0, Then it results in or number is rounded down to the left side of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
E.G. =ROUNDDOWN(-984.5395,-2) returns the value -900
