Returns the rounded value of a numeric value according to the specified number of decimal places.

Example

// Retrieve the rounded value of -16.238167 ResRound = Round(-16.238167, 2) // Returns -16.24

Syntax

<Result> = Round(<Numeric value> [, <Number of decimals>])

<Result>: Integer or real

Rounded value of the specified numeric value.

<Numeric value>: Real or currency

Numeric value to round. We recommend that you use the currency type in order to get reliable results.

<Number of decimals>: Optional integer

Number of decimals to return. No decimal is returned if this parameter is not specified.

Remarks

Numeric value

If <Numeric value> is included between:

0 and 0.49: the number is rounded to 0. For example, 3.2 is rounded to 3 (no decimal).

0.5 and 0.99: the number is rounded to 1. For example, 3.7 is rounded to 4 (no decimal).

Caution: The rounding performed with the "Real" type is not precise. Indeed, the operations performed with the "real" types are not precise because of the computing representation of reals. To get an exact rounding, we recommend that you use the Currency or Numeric type that is using an exact memory representation. For more details, see the real type.

Decimal separator

The decimal separator for the real numbers is "." (dot).