Sequence
  • 27 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Sequence

  • Dark
    Light
  • PDF

Article Summary

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

Function signature

SEQUENCE(startnumber: Number, countnumber: Number, stepnumber: Number) => Array
ParameterDescription
Start numberThe number to start the sequence at
Count numberThe number of values to return
Step numberThe amount to increase/decrease each number in the sequence.

Examples

FormulaReturn value
SEQUENCE(1, 10, 1)[1,2,3,4,5,6,7,8,9,10]
SEQUENCE(100, 5, 100)[100,200,300,400,500]

Was this article helpful?

What's Next