/
RANGE

RANGE

Jan 30, 2018

Syntax

RANGE(<number>;<number>)

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

Column1Column2RANGE returns
13[1, 2, 3]
31[]
2735[27, 28, 29, 30, 31, 32, 33, 34, 35]
75.254.9[]
5.420.7[5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20]