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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.


Drop CSV