ROUNDDOWN Function
Advertisements
Description
The ROUNDOWN function rounds a number down, toward zero. ROUNDDOWN is one of the Excel Rounding Functions.
Syntax
ROUNDDOWN (number, num_digits)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | Any real number that you want rounded down. | Required |
Num_digits | The number of digits to which you want to round number. | Required |
Notes
ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
If num_digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.
If num_digits is 0, then number is rounded down to the nearest integer.
If num_digits is less than 0, then number is rounded down to the left of the decimal point.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements