Quick Answer

ROUNDDOWN Function

ROUNDDOWN always rounds numbers down, never up, to the specified decimal places.

Syntax

ROUNDDOWN

(number, num_digits)

Parameters

Parameter	Description	Required
number	The number to round down.	Required
num_digits	The number of decimal places to round to.	Required

Basic Example

Always round down to 2 decimal places

=ROUNDDOWN(3.14999, 2)

Result3.14

Rounds 3.14999 down to 2 decimal places, resulting in 3.14.

Advanced Examples

Example 1: Truncate to whole number

Integer conversion

Remove decimal portion without rounding

=ROUNDDOWN(A1, 0)

Result: 12

12.9 becomes 12, always truncating decimals.

Example 2: Round down to nearest 1000

Budgeting

Round down to the nearest thousand for budget estimation

=ROUNDDOWN(A1, -3)

Result: 5000

5999 becomes 5000 when rounded down to the nearest thousand.

How ROUNDDOWN Works

ROUNDDOWN always rounds numbers toward zero, effectively truncating decimal values. 1.999 rounded to 0 decimal places becomes 1.

1

Select output cell

Choose where the result should appear.

2

Enter formula

Type =ROUNDDOWN(number, decimal_places).

3

Press Enter

The result shows the rounded-down number.

Important Notes & Limitations

ROUNDDOWN always decreases the number (or makes it more negative).
Use ROUNDUP for the opposite behavior.

Common Errors & Fixes

#VALUE!Non-numeric arguments

Fix: Ensure both arguments are numbers.

Download Practice File

Practice ROUNDDOWN with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the ROUNDDOWN function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ABS

ABS converts negative numbers to positive, leaving positive numbers unchanged.

ACOS

Returns the angle (in radians) whose cosine is the supplied number.

ASIN

Returns the angle (in radians) whose sine is the supplied number.

ATAN

Returns the angle (in radians) whose tangent is the supplied number.

ATAN2

Returns the angle in radians to a point given by its x and y coordinates.

CEILING.MATH

Rounds up to a multiple of significance, with a mode for negative numbers.

Frequently Asked Questions

What is the difference between ROUNDDOWN and INT?

INT rounds negative numbers away from zero, while ROUNDDOWN always rounds toward zero. INT(-1.5) = -2, ROUNDDOWN(-1.5, 0) = -1.