ROUNDDOWN

Formulas / ROUNDDOWN
Round down to a specified number of digits.
==ROUNDDOWN(number,num_digits)
  • number - the number to truncate
  • num_digits - [REQUIRED] the place where to round number

Examples

  • =ROUNDDOWN(3.9,0) rounds 3.9 down to the nearest whole number, which is 3.

  • =ROUNDDOWN(A1,1) rounds down to the nearest decimal place. For example, if A1 is 3.75, the result would be 3.7.

  • =ROUNDDOWN(A1,2) rounds down to the nearest two decimal places. For example, if A1 is 3.753, the result would be 3.75.

  • =ROUNDDOWN(A1,0) rounds down to the nearest one. For example, if A1 is 3.4, the result would be 3.

  • =ROUNDDOWN(A1,-1) rounds down to the nearest ten. For example, if A1 is 23.4, the result would be 20.


Summary

The ROUNDDOWN function is a useful tool for rounding a number down to its nearest whole number, percentage, or other number. It takes one argument, the number to be rounded down.

  • The ROUNDDOWN function takes two arguments: number and num_digits. The number argument is the number to truncate and the num_digits argument is the place to round down to the nearest integer.
  • ROUNDDOWN rounds all numbers down to the nearest whole number.

Frequently Asked Questions

What is the ROUNDDOWN Function?
The ROUNDDOWN function is a mathematical function that rounds a number down towards zero. The ROUNDDOWN function always rounds a number down to the nearest integer, regardless of the number of decimal places.
How Does the ROUNDDOWN Function Work?
The ROUNDDOWN function works by rounding a number down to the specified number of decimal places if the num_digits parameter is greater than 0. If the num_digits parameter is less than or equal to 0, the ROUNDDOWN function will round a number down to the nearest integer.
What Happens if the Num_Digits Parameter is Less than 0?
If the num_digits parameter is less than 0, the ROUNDDOWN function will round a number down to the nearest integer.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV