ROUNDDOWN
Formulas / ROUNDDOWNRound 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.
