syntax:functions:roundxl
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
syntax:functions:roundxl [2016/08/23 18:09] – dmitry | syntax:functions:roundxl [2021/07/31 21:40] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== RoundXl(number, | + | ====== RoundXL(number, |
+ | Category: | ||
- | Rounds a number to N decimal digits using the Excel rounding logic. | + | \\ |
+ | =====Description===== | ||
+ | This function rounds //number// to // | ||
- | Note: there exist two types of rounding | + | Excel rounding |
- | ^ | + | \\ |
- | | roundxl( 5.55, 1 ) | 5.6 | | + | =====Arguments===== |
- | | roundxl( 5.65, 1 ) | 5.7 | | + | ^Argument^Type^Description^ |
+ | |number|Number|The value, usually fractional, to be rounded.| | ||
+ | |dec_places|Number | ||
+ | \\ | ||
+ | **Return value type: | ||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | There exists two types of rounding, in general - " | ||
- | === See also === | + | Using a // |
- | * [[syntax: | + | |
- | * [[syntax: | + | \\ |
- | * [[syntax: | + | =====Examples===== |
+ | |||
+ | roundxl(5.55, | ||
+ | roundxl(5.65, | ||
+ | roundxl(10.434, | ||
+ | roundxl(20.5456, | ||
+ | |||
+ | |||
+ | \\ | ||
+ | ===== See also ===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: |
syntax/functions/roundxl.txt · Last modified: 2023/02/28 20:14 by craigt