Policies & Guidelines

SEQUENCE

Array of sequential numbers

Description

Generates an array of sequential numbers, separated by the given step value.

Function signature

SEQUENCE(startnumber: Number, countnumber: Number, stepnumber: Number) => Array

Parameter

Description

Start number

The number to start the sequence at

Count number

The number of values to return

Step number

The amount to increase/decrease each number in the sequence.

Examples

Formula

Return value

SEQUENCE(1, 10, 1)

[1,2,3,4,5,6,7,8,9,10]

SEQUENCE(100, 5, 100)

[100,200,300,400,500]