Excel > Functions

ROUNDDOWN Function

The Excel ROUNDDOWN function is used to round a number down to a specified number of digits.For example, round a number down to one decimal place.

The syntax for the ROUNDDOWN function is:

=ROUNDDOWN(number,num_digits)

Argument

Purpose

Number

The number you want to round down

num_digits

The number of digits you want to round the number down to.

  • If the num_digits is greater than 0, the number is rounded down to the specified number of decimal points
  • If the num_digits is 0, the number is rounded down to the nearest integer
  • If num_digits is less than 0, the number is rounded down to the left of the decimal point

Below are examples of the ROUNDDOWN function being used to round numbers down to a various number of digits.

Data to use for ROUNDDOWN function

Function

Result

=ROUNDDOWN(A1,2)

5.32

=ROUNDDOWN(A2,0)

2

=ROUNDDOWN(A3,1)

4.5

=ROUNDDOWN(A4,-1)

20

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions

Excel 2010 Superhero Course