syntax:functions:roundxl

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

Next revision | Previous revision Last revision Both sides next revision | ||

syntax:functions:roundxl [2016/07/09 08:48] dmitry created |
syntax:functions:roundxl [2016/08/23 18:09] dmitry |
||
---|---|---|---|

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 -- " | + | Note: there exist two types of rounding in general -- "[[syntax:]] function. |

^ Example | ^ Example | ||

- | | 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