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

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

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Follow us on

Guides

Other Mathematical Functions