ROUNDDOWN( ) Rounds a number down to a specified number of digits. Syntax ROUNDDOWN(num) ROUNDDOWN(num, dec) Arguments num The number to round down. dec The number of digits to which to round num down. If you omit dec, ROUND( ) assumes 0. Returns A number rounded down to a specified number of digits. Example The following example rounds down the numbers in the PriceEstimate data field to return an integer. For example, if the PriceEstimate value is 1545.25, ROUNDDOWN( ) returns 1545. If the PriceEstimate value is 1545.90, ROUNDDOWN( ) returns 1545. ROUNDDOWN([PriceEstimate]) The following example rounds down the numbers in the PriceEstimate data field to one decimal place. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1545.5. If the PriceEstimate value is 1545.23, ROUNDDOWN( ) returns 1545.2. ROUNDDOWN([PriceEstimate], 1) The following example rounds the numbers in the PriceEstimate data field down to one digit to the left of the decimal point. For example, if the PriceEstimate value is 1545.56, ROUNDDOWN( ) returns 1540. If the PriceEstimate value is 1338.50, ROUNDDOWN( ) returns 1330. ROUNDDOWN([PriceEstimate], -1)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy