What's the difference between ROUNDDOWN and INT?

Both truncate decimals toward zero for positive numbers, but for negative numbers they diverge: INT always rounds toward negative infinity, while ROUNDDOWN rounds toward zero. For -4.9, INT returns -5, but ROUNDDOWN returns -4.

Can I use ROUNDDOWN with negative num_digits?

Yes. Negative num_digits round to the left of the decimal point: ROUNDDOWN(1234.56, -2) rounds to the nearest hundred, returning 1200. This is useful for simplifying large numbers.

Does ROUNDDOWN work in Google Sheets the same way as Excel?

Yes, ROUNDDOWN behaves identically in both platforms. Both support positive and negative num_digits, and both round toward zero for positive numbers.

When should I use ROUNDDOWN instead of ROUND?

Use ROUNDDOWN when you must never overstate a value—inventory counts, billing amounts, or available stock. ROUND may round up, risking overbooking or overcharging. ROUNDDOWN is the conservative choice for lower-bound calculations.

ROUNDDOWN function

ROUNDDOWN returns a number rounded down toward zero to the specified number of decimal places, useful for inventory and billing calculations.

=ROUNDDOWN(number, num_digits)

Generate a ROUNDDOWN formula

Describe what you need. The generator will reach for ROUNDDOWN where ROUNDDOWN is the right tool, and tell you when it is not.

Arguments

How ROUNDDOWN reads its arguments

Argument	Required	Description
number	Required	The numeric value to round down; can be a cell reference, formula result, or literal number. Negative numbers round toward zero (away from negative infinity).
num_digits	Required	The number of decimal places to keep (positive) or digits left of decimal to zero (negative); must be a numeric value.

Returns

A numeric value rounded down (toward zero) to the specified precision.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Round ingredient quantities to whole units for inventory count

Ingredient	Supplier	Unit	Qty	Expiry Date
Flour	Baker's Co	kg	25.847	2024-12-15
Olive Oil	Mediterranean	L	12.386	2025-02-20
Salt	Salt Works	kg	5.925	2025-01-10

=ROUNDDOWN(D2,0)

Result: 25

The restaurant has 25.847 kg of flour in stock. Since physical inventory counts must use whole units, ROUNDDOWN with 0 decimal places returns 25 kg—the minimum amount guaranteed available, with 0.847 kg held as safety buffer.

2. Calculate billable volume at 2 decimal precision

Ingredient	Supplier	Unit	Qty	Expiry Date
Flour	Baker's Co	kg	25.847	2024-12-15
Olive Oil	Mediterranean	L	12.386	2025-02-20
Salt	Salt Works	kg	5.925	2025-01-10

=ROUNDDOWN(D3,2)

Result: 12.38

Olive oil quantity is 12.386 L. When charging by precise volume, rounding down to 2 decimal places ensures billing never exceeds actual measured stock, protecting the restaurant from overages and compliance issues.

3. Round quantities to nearest 10 units for bulk ordering

Ingredient	Supplier	Unit	Qty	Expiry Date
Flour	Baker's Co	kg	25.847	2024-12-15
Olive Oil	Mediterranean	L	12.386	2025-02-20
Salt	Salt Works	kg	5.925	2025-01-10

=ROUNDDOWN(D2,-1)

Result: 20

With 25.847 kg of flour, using num_digits of -1 rounds down to the nearest 10 kg, yielding 20 kg. This determines how many complete 10-unit cases can be fulfilled before reordering, preventing partial orders.

Common errors

Which ROUNDDOWN error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	The number argument is text (a cell formatted as text, or a quoted string like "25.847") instead of a numeric value.	Ensure the first argument is numeric: use VALUE() to convert text-stored numbers, or change cell formatting from Text to Number.
#N/A	A referenced cell contains #N/A (from VLOOKUP, MATCH, or a broken link), which ROUNDDOWN cannot process and propagates the error.	Use IFERROR or IFNA to replace missing values before rounding: =ROUNDDOWN(IFNA(D2,0),0) treats missing values as zero.
#REF!	A cell reference in the formula points to a deleted column or row, breaking the link and invalidating the formula.	Restore the deleted row/column, or manually update the formula to reference valid cells; use Find & Replace to fix stale references across the sheet.

Tips and when to use something else

ROUNDDOWN always rounds toward zero: 4.9 becomes 4, and -4.9 becomes -4. Use ROUND if you need symmetric rounding or banker's rounding (round-to-even).
Negative num_digits round to tens, hundreds, or thousands: ROUNDDOWN(1234,-2) = 1200. This is powerful for rounding large numbers.
For financial and inventory calculations, ROUNDDOWN is safer than ROUND because it never overstates available stock, capacity, or billable amounts.
If you need to round UP instead, use ROUNDUP or CEILING.MATH; ROUNDDOWN always removes digits and never adds them.

Related functions

ROUNDUPRounds a number up to a specified number of decimal places, always rounding away from zero, useful for conservative financial estimates.ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.FLOOR.MATHRounds a number down to the nearest multiple of a specified significance value, commonly used for budget categories and interval-based rounding.TRUNCTRUNC removes decimal places from a number without rounding, returning a truncated integer—use it when you need precise decimal removal without rounding.

Frequently asked questions

What's the difference between ROUNDDOWN and INT?: Both truncate decimals toward zero for positive numbers, but for negative numbers they diverge: INT always rounds toward negative infinity, while ROUNDDOWN rounds toward zero. For -4.9, INT returns -5, but ROUNDDOWN returns -4.
Can I use ROUNDDOWN with negative num_digits?: Yes. Negative num_digits round to the left of the decimal point: ROUNDDOWN(1234.56, -2) rounds to the nearest hundred, returning 1200. This is useful for simplifying large numbers.
Does ROUNDDOWN work in Google Sheets the same way as Excel?: Yes, ROUNDDOWN behaves identically in both platforms. Both support positive and negative num_digits, and both round toward zero for positive numbers.
When should I use ROUNDDOWN instead of ROUND?: Use ROUNDDOWN when you must never overstate a value—inventory counts, billing amounts, or available stock. ROUND may round up, risking overbooking or overcharging. ROUNDDOWN is the conservative choice for lower-bound calculations.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17