RANGE

Owned by Charles Bishop (Deactivated)

Jan 30, 2018

1 min read

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

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]