ROUNDUP( )

Rounds a number up to a specified number of digits.

Syntax

ROUNDUP(number)

ROUNDUP(number, dec)

Arguments

number

The number to round up.

dec

The number of digits to round number up to. 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 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 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 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)

Copyright Actuate Corporation 2012