Excel ROUNDDOWN Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel ROUNDDOWN function rounds a number down (toward zero) to a specified number of digits.

Syntax and arguments

Formula syntax

Arguments

Return Value

The ROUNDDOWN function returns to a numeric value.

Version

Excel 2003

Remark

If argument number is > 0, the ROUNDDOWN number returns result <= number.

If argument number is < 0, the ROUNDDOWN number returns result >= number.

Usage and Examples

Example: basic usage

In range C3:G3 contains the different number of digits you want to use to round the number down in cell B4:B5, please use below formula to get the corresponding rounding results.

=ROUNDDOWN($B4,C$3)

Press Enter key, and drag autofill handle right to get all rounding results of the number in cell B4.

Then drag autofill handle down to next row, the rounding results of the number in cell B5 are displayed.

Note: If you only use the ROUNDDOWN function once, you can directly type the number and number digits into the function as this:

=ROUNDDOWN(1235.3673,2)

Relative Functions:

• Excel RAND Function
  The RAND function returns a random number between 0 and 1.

• Excel RANDBETWEEN Function
  The RANDBETWEEN function returns a random number between two given numbers.

• Excel ROMAN Function
  The ROMAN function converts a number to a roman number in text.

• Excel ROUND Function
  The Excel ROUND function rounds a number to a specified number of digits.