Excel ROUNDDOWN function

Summary

The Excel ROUNDDOWN function rounds a number down, toward zero, to a specified number of digits. It’s especially useful in scenarios where you need to decrease a number to the nearest specified decimal or integer without rounding up, such as in financial calculations or when working with specific measurement standards.
Syntax
				
					=ROUNDDOWN(number, num_digits)
				
			
  • number: The number to round down
  • num_digits: The number of digits to which you want to round down the number
Return value
The number rounded down to the specified number of digits.

How to use

Use ROUNDDOWN by inputting the number to be rounded and specifying the number of digits for rounding. If num_digits is greater than 0, the function rounds down to the specified number of decimal places. If num_digits is 0, it rounds down to the nearest integer. If num_digits is less than 0, it rounds down to the left of the decimal point.

Examples

Simple ROUNDDOWN

Rounding Down to a Specific Decimal Place: To round a number down to two decimal places:

				
					=ROUNDDOWN(3.14159, 2)
				
			
This formula rounds 3.14159 down to 3.14.
ROUNDDOWN to Tens and Hundreds

Rounding down with negative num_digits: Rounding a number down to the nearest ten:

				
					=ROUNDDOWN(157, -1)
				
			
Rounds 157 down to 150.
ROUNDDOWN for Clean Display
Rounding Down Inventory Counts: Applying ROUNDDOWN in inventory calculations:
				
					=ROUNDDOWN(Quantity, 0)
				
			
Rounds down the Quantity to the nearest whole number, useful for inventory counts where partial items are not counted.

Additional Notes

  • ROUNDDOWN always rounds numbers down (towards zero), making it distinct from the general ROUND function.
  • It’s valuable in situations where you need to conservatively estimate or adjust numbers.

Related Functions

Excel ROUNDUP function

The Excel ROUNDUP function rounds a number up, away from zero, to a specified number of digits, ideal for precautionary measures in calculations.

Excel FLOOR function

The Excel FLOOR function rounds numbers down to the nearest multiple of significance, useful for inventory and budget control.

Excel ROUND function

The Excel ROUND function rounds a number to a specified number of digits, crucial for accurate financial and scientific calculations.

Excel CEILING function

The Excel CEILING function rounds numbers up to the nearest multiple of significance, ideal for pricing and budgeting calculations.

Excel TRUNC function

The Excel TRUNC function truncates a number to an integer by removing the fractional part, useful for precise mathematical operations.

Content Navigation