syntax:functions:roundxl
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
syntax:functions:roundxl [2016/07/09 08:48] – created dmitry | syntax:functions:roundxl [2023/02/28 20:14] (current) – [See also] fix MRound page reference -CT 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 |
- | ^ Example | + | \\ |
- | | round( 5.55, 1 ) | 5.6 | | + | |
- | | round( 5.65, 1 ) | 5.7 | | + | |
+ | =====Alternative syntax===== | ||
+ | The 2nd argument in this function is optional. If omitted, it's assumed to be 0. | ||
+ | RoundXL(number) | ||
- | === See also === | + | \\ |
- | * [[syntax: | + | =====Arguments===== |
- | * [[syntax: | + | ^Argument^Type^Description^ |
- | * [[syntax: | + | |number|Number|The value, usually fractional, to be rounded.| |
+ | |dec_places|Number (from -9 to 28)|The number of decimal places to round //number// to.| | ||
+ | \\ | ||
+ | **Return value type: | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | There exist two types of rounding, in general - " | ||
+ | |||
+ | Using a // | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | roundxl(5.55, | ||
+ | |||
+ | roundxl(5.65, | ||
+ | |||
+ | roundxl(10.434, | ||
+ | |||
+ | roundxl(20.5456, | ||
+ | |||
+ | roundxl(12345, | ||
+ | |||
+ | \\ | ||
+ | ===== See also ===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: |
syntax/functions/roundxl.1468068529.txt.gz · Last modified: 2016/07/09 08:48 by dmitry