ROUNDDOWN( )
Rounds a number down to a specified number of digits.
Syntax
ROUNDDOWN(num)
ROUNDDOWN(num, dec)
Arguments
num
The number to round down.
dec
The number of digits to which to round num down. If you omit dec, ROUND( ) assumes 0.
Returns
A number rounded down to a specified number of digits.
Example
The following example rounds down the numbers in the PriceEstimate data field to return an integer. For example, if the PriceEstimate value is 1545.25, ROUNDDOWN( ) returns 1545. If the PriceEstimate value is 1545.90, ROUNDDOWN( ) returns 1545.
ROUNDDOWN([PriceEstimate])
The following example rounds down the numbers in the PriceEstimate data field to one decimal place. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1545.5. If the PriceEstimate value is 1545.23, ROUNDDOWN( ) returns 1545.2.
ROUNDDOWN([PriceEstimate], 1)
The following example rounds the numbers in the PriceEstimate data field down to one digit to the left of the decimal point. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1540. If the PriceEstimate value is 1338.50, ROUNDDOWN( ) returns 1330.
ROUNDDOWN([PriceEstimate], ‑1)