EasyMorph Help

Site Tools

syntax:functions:roundxl

Differences

This shows you the differences between two versions of the page.

 syntax:functions:roundxl [2016/07/09 08:48]dmitry created syntax:functions:roundxl [2016/08/23 18:09]dmitry 2021/07/31 21:40 craigt 2016/08/23 18:09 dmitry 2016/08/13 11:25 dmitry 2016/07/09 08:48 dmitry created Next revision Previous revision 2021/07/31 21:40 craigt 2016/08/23 18:09 dmitry 2016/08/13 11:25 dmitry 2016/07/09 08:48 dmitry created Last revision Both sides next revision Line 3: Line 3: Rounds a number to N decimal digits using the Excel rounding logic. 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. + 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  ^ ^  Example  ^  Result  ^ - | round( 5.55, 1 )  |  5.6 | + | roundxl( 5.55, 1 )  |  5.6 | - | round( 5.65, 1 )  |  5.7 | + | roundxl( 5.65, 1 )  |  5.7 |
syntax/functions/roundxl.txt · Last modified: 2021/07/31 21:40 by craigt