RANGE
Syntax
Description
Returns in the form of a list, integers ranging in numerical order from the first value (From) and ending with last value (To) .
If the first value (From) is higher than the second value (To) the result is an empty list.
Examples
Column1 | Column2 | RANGE returns |
|---|---|---|
1 | 3 | [1, 2, 3] |
3 | 1 | [] |
27 | 35 | [27, 28, 29, 30, 31, 32, 33, 34, 35] |
75.2 | 54.9 | [] |
5.4 | 20.7 | [5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20] |