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)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy
