How to use the Excel ROUNDDOWN function

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:

Excel ROUNDDOWN function 1 - How to use the Excel ROUNDDOWN function

Syntax:  =ROUNDDOWN(A2,B2)

Result:

ROUNDDOWN function - How to use the Excel ROUNDDOWN function

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.).
READ:  How to use the Excel LOG function

E.G. =ROUNDDOWN(-984.5395,-2) returns the value -900

Add a Comment

Your email address will not be published. Required fields are marked *