Round
Returns a number rounded to the specified precision (number of decimal places).
Format
Round ( number ; precision )
Parameters
number
- any numeric expression or field containing a numeric expression
precision
- any numeric expression or field containing a numeric expression for the number of decimal places
Data type returned
number
Originated in version
6.0 or earlier
Description
If you round a negative number of decimal places, all digits to the right of the decimal point are dropped, and the number is rounded to the nearest tens, hundreds, and so on. The Round function always rounds up at 0.5.
Example 1
Round(123.456;2)
returns 123.46.
Round(14.5;0)
returns 15.
Round(14.5;2)
returns 14.5.
Round(29343.98;-3)
returns 29000.
Round(123.456;-1)
returns 120.