syntax:functions:round
This is an old revision of the document!
Round(number, N)
Rounds a number to N decimal digits.
Note: 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 function.
| Example | Result |
|---|---|
| round( 5.55, 1 ) | 5.6 |
| round( 5.65, 1 ) | 5.6 |
See also
syntax/functions/round.1468068511.txt.gz · Last modified: 2016/07/09 08:48 by dmitry