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