Returns a list of sequential numbers as an array in the provided cell range.
Syntax
row: Number of rows to be filled with the sequential array. Eg., 2
column: Number of columns to be filled with the sequential array. Defaults to 1 if omitted. Eg., 3
first_value: The starting or first value in the sequence. Defaults to 1 if omitted. Eg., 1
Examples
Formula |
=SEQUENCE(2;3;1;2) |
=SEQUENCE(3;2;-10;3) |
=SEQUENCE(2;3;12;0.5) |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com
Quick Links |
Workflow Automation |
Data Collection |
|
||
Form Templates |
||
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|