ROUNDUP( )
Rounds a number up to a specified number of digits.
Syntax
ROUNDUP(num)
ROUNDUP(num, dec)
Arguments
num
The number to round up.
dec
The number of digits to which to round num up. If you omit dec, ROUND( ) assumes 0.
Returns
A number rounded up to a specified number of digits.
Example
The following example rounds up the numbers in the PriceEstimate data field to return an integer. For example, if the PriceEstimate value is 1545.25, ROUNDUP( ) returns 1546. If the PriceEstimate value is 1545.90, ROUNDUP( ) returns 1546.
ROUNDUP([PriceEstimate])
The following example rounds up the numbers in the PriceEstimate data field to one decimal place. For example, if the PriceEstimate value is 1545.56, ROUNDUP( ) returns 1545.6. If the PriceEstimate value is 1545.23, ROUNDUP( ) returns 1545.3.
ROUNDUP([PriceEstimate], 1)
The following example rounds up 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, ROUNDUP( ) returns 1550. If the PriceEstimate value is 1338.50, ROUNDUP( ) returns 1340.
ROUNDUP([PriceEstimate], ‑1)