Round function

Contents > Functions reference (alphabetical list) > Number functions > Round function

Round function

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

Data type returned

number

Description

Returns number rounded off to the specified precision (number of decimal places). 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.

Examples

Round(123.456;2) returns 123.46.

Round(14.5;0) returns 15.

Round(29343.98;-3) returns 29000.

Round(123.456;-1) returns 120.

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Number functions > Round function