# Excel SEQUENCE function

## Summary

The Excel SEQUENCE function creates an array of sequential numbers, either in a one-dimensional or two-dimensional array. The size of the array is determined by the rows and columns arguments, with options to set the starting value and the step increment between numbers.
##### Syntax
```				```
=SEQUENCE(rows, [columns], [start], [step])
```
```
• rows: Number of rows for the array
• [columns]: [Optional] Number of columns for the array. Defaults to 1 if omitted
• [start]: [Optional] Starting value for the sequence. Defaults to 1
• [step]: [Optional] Increment between each value in the sequence. Defaults to 1
##### Return value
An array of sequential values, arranged as specified by the rows and columns arguments.

## How to use

Use SEQUENCE to generate a list of numbers in an orderly sequence. This function can be used to create simple numeric sequences or more complex arrays, suitable for various applications in data analysis, simulations, and more.

## Examples

##### Simple SEQUENCE
Creating a Sequential Number List: To generate a vertical list of numbers from 1 to 5:
```				```
=SEQUENCE(5)
```
```
This formula produces an array of 5 numbers (1, 2, 3, 4, 5) in a vertical arrangement.
##### SEQUENCE for Two-Dimensional Arrays
Generating a Two-Dimensional Number Grid: Creating a 3×3 grid of sequential numbers:
```				```
=SEQUENCE(3, 3)
```
```
This formula creates a 3×3 array, with numbers from 1 to 9 arranged in three rows and three columns.
##### SEQUENCE with Custom Start and Step
Creating a Custom Sequence: Generating numbers starting from 10, incrementing by 5:
```				```
=SEQUENCE(4, 1, 10, 5)
```
```
Produces a vertical array: 10, 15, 20, 25.
##### SEQUENCE for Negative and Positive Ranges
Counting Up and Down with SEQUENCE: Creating a sequence from -5 to 5:
```				```
=SEQUENCE(11, 1, -5, 1)
```
```
Generates a vertical array from -5 to 5.
##### MOD with Other Excel Functions
Integrating MOD in Complex Formulas: Combining MOD with IF:
```				```
=IF(MOD(A2, 2) = 0, "Even", "Odd")
```
```
This formula checks if a value in A2 is even or odd and returns “Even” or “Odd” accordingly.