|
|
|
|
- Numeric value
- Decimal separator
Round (Function) In french: Arrondi Returns the rounded value of a numeric value according to the specified number of decimal places. // 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 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: Rounding with the "Real" type is not accurate. 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 uses an exact memory representation. For more details, see the real type. The decimal separator for real numbers is "." (point).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|