Function Description
| Category | Description |
|---|---|
| Syntax | ROUNDDOWN(number,num_digits) |
| Function | Returns a number rounded down to the specified number of digits. The first discarded digit is removed even when it is greater than 5. |
| Parameters | number: the number to round num_digits: the number of digits to which the number is rounded |
| Number of Parameters | 2 |
| Parameter Type | Number |
| Return Value Type | Number |
| Notes | If the value of num_digits is greater than 0, the number is rounded to the specified number of decimal places.If the value is equal to 0, the number is rounded to the nearest integer.If the value is less than 0, the number is rounded to the left of the decimal point. For example, -2 rounds number down at the hundreds place. |
Examples
| Formula | Result |
|---|---|
ROUNDDOWN(2.15,1) | 2.1 |
ROUNDDOWN(2.149,1) | 2.1 |
ROUNDDOWN(-1.475,2) | -1.47 |
ROUNDDOWN(21.5,-1) | 20 |
More Examples
For example, you can use ROUNDDOWN to remove the decimal part of Cleaned Profit and round the value down to an integer.
