syntax:functions:roundxl
This is an old revision of the document!
RoundXl(number, N)
Rounds a number to N decimal digits using the Excel rounding logic.
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 uses the former, which is also the type of rounding used in Excel. For the standard rounding (the banker's rounding) use [syntax:functions:round] function.
Example | Result |
---|---|
roundxl( 5.55, 1 ) | 5.6 |
roundxl( 5.65, 1 ) | 5.7 |
See also
syntax/functions/roundxl.1471101934.txt.gz · Last modified: 2016/08/13 11:25 by dmitry