ROUNDDOWN Function in Excel

In Excel, the ROUNDDOWN function is a built-in function. We used this function to round off the given number. This function rounds the given number to the nearest lower number with respect to the given number. This function can be accessed by typing the keyword =ROUNDDOWN (in any cell). Unlike standard rounding, which only rounds down numbers less than 5, ROUNDDOWN rounds all numbers down.

Syntax of the ROUNDDOWN Function

The following is the syntax of the ROUNDDOWN function in Excel:

=ROUNDDOWN(number, num_digits)

Arguments or Parameters

The following are the arguments or parameters of the ROUNDOWN function:0

  1. number
  2. number_digits

number: – number is any real number which we need to round down. It is a required and compulsory argument. It can be entered as function, formula, number or cell reference.

num_digits: – number_digits is the number of digits which we need to round.

Returns

The ROUNDDOWN function returns a numeric value.

How to Use Excel ROUNDDOWN Function? (Examples)

The ROUNDDOWN function is really easy to use. Let’s have a look at some examples of how to utilize the ROUNDDOWN function in Excel.

Example 1: Rounds a positive float number to zero decimal places

ROUNDDOWN Function in Excel

In this example, cell A2 is an input number with a value 5.3758. The result cell is B2, in which the ROUNDOWN formula applied is =ROUNDDOWN (A2,0), which means we have to rounds down the value in A2 with zero decimal numbers.

ROUNDDOWN Function in Excel

After applying the formula, the result would be 5, as we can see in the below screenshot.

ROUNDDOWN Function in Excel

Example 2: Rounds a positive float number to one decimal place to the left of the decimal point

ROUNDDOWN Function in Excel

In this example, cell A3 is the input number with a value 533428.698.

B3 is the result cell in which the ROUNDDOWN formula applied is =ROUNDDOWN(A3,-1) which specifies that the number should be rounded down to the left of the decimal point by 1.

ROUNDDOWN Function in Excel

After applying the formula, the result would be 533420, as we can see in the below screenshot.

ROUNDDOWN Function in Excel

Example 3: Round a negative float number to one decimal places

ROUNDDOWN Function in Excel

In this example, A4 is the input number with the value -4.3969. The ROUNNDDOWN formula applied to the result cell B4 is =ROUNDDOWN(A4,1), which rounds down the value in A4 by one decimal place.

ROUNDDOWN Function in Excel

After applying the formula, the result would be -4.3, as we can see in the below screenshot.

ROUNDDOWN Function in Excel

Example 4: Round down a number to two decimal places

In this example, cell A2 comprises a number with a decimal value 8647.5435. Using the ROUNDDOWN function, we have to round down a number to two decimal values in cell B2.

ROUNDDOWN Function in Excel

In order to round down the value, we have to apply the following ROUNDDOWN formula:

=ROUNDDOWN(A2,2)

ROUNDDOWN Function in Excel

After applying the formula, the result would be 8647.54, as we can see in the below screenshot:

ROUNDDOWN Function in Excel

Things to Remember

  • ROUNDDOWN function round off the given number to the nearest number down the given number.
  • In the ROUNDOWN function, both parameters are required ones.
  • In the ROUNDDOWN function, if the second parameter, num_digits, is 0, then the number is rounded down to the nearest integer number.
    For example; =ROUNDDOWN(756.4595,) returns the value 756.
  • In the ROUNDDOWN function, if the second parameter, num_digits, is less than 0, then the number is rounded down to the left of the decimal point.
    For example; =ROUNDDOWN(-756.4595,-2) returns the value -700
  • If the second parameter, num_digits is greater than 0, then the number is rounded down to the number of decimal digits specified in the ROUNDDOWN excel function.
    For example; =ROUNDDOWN(756.4595,2) returns the value 756.45