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