SEQUENCE
List of sequential numbers

Description

Generates a list of sequential numbers, separated by the given step value.

Function signature

1
SEQUENCE(startnumber: Number, countnumber: Number, stepnumber: Number) => Array
Copied!
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]
Last modified 11mo ago
Export as PDF
Copy link