syntax:functions:round
This is an old revision of the document!
Table of Contents
Round(number, dec_places)
Category: Number function
Description
This function rounds a number to dec_places number of decimal digits.
Arguments
Argument | Type | Description |
---|---|---|
number | Number | The value, usually fractional, to be rounded. |
dec_places | Number (positive, >=0) | The number of decimal places to round number to. |
Return value type: Number
Remarks
There exist two types of rounding in general - "Rounding away from zero" (a.k.a symmetric rounding) and "Rounding to the nearest even number" (a.k.a. banker's rounding). This function is using the latter, as it's the standard way of rounding as described in IEEE Standard 754, section 4. For Excel-type rounding (away from zero) use RoundXL(number, dec_places) function.
Using a dec_places value of "0" rounds to the nearest whole number.
Examples
round(5.55, 1) //Returns 5.6
round(5.65, 1) //Returns 5.6
round(101.567, 2) //Returns 101.57
round(101.5784, 3) //Returns 101.578
round(92.523, 0) //Returns 93
See also
syntax/functions/round.1628710412.txt.gz · Last modified: 2021/08/11 15:33 by craigt