SEQUENCE Function

The SEQUENCE function is one of the math and trigonometry functions. It is used to generate an array of sequential numbers.

Syntax

SEQUENCE(rows, [columns], [start], [step])

The SEQUENCE function has the following arguments:

Argument	Description
rows	Is used to set the number of rows to return.
columns	Is used to set the number of columns to return.
start	Is used to set the first number in the sequence.
step	Is used to control the increment for each subsequent value in the array.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the SEQUENCE function.

Examples

The figure below displays the result returned by the SEQUENCE function.

Alla pagina precedente