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

Versions 16 and later

This function is now available for Windows Phone applications.

New in version 16

This function is now available for Windows Phone applications.

This function is now available for Windows Phone applications.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

This function is now available in Universal Windows 10 App mode.

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. See the real type for more details.

Decimal separator

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