Description
Rounds a number down.
Syntax
ROUNDDOWN ( number, numberOfDigits )
| Parameter | Description |
|---|---|
| number | Any real number you want to round. |
| precision | The number of decimal places to which number is rounded. If precision is negative, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros. If precision is 0, number is rounded to the nearest integer. |
Examples
This function returns 3.141:
ROUNDDOWN(3.14159, 3)
This function returns 31400:
ROUNDDOWN(31415.92654, -2)
See also