List.Numbers
- 2 minutes to read
Syntax
List.Numbers(start as number, count as number, optional increment as nullable number) as list
About
Returns a list of numbers given an initial value, count, and optional increment value. The default increment value is 1.
start: The initial value in the list.count: The number of values to create.increment: [Optional] The value to increment by. If omitted values are incremented by 1.
Example 1
Generate a list of 10 consecutive numbers starting at 1.
List.Numbers(1, 10)
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
Example 2
Generate a list of 10 numbers starting at 1, with an increment of 2 for each subsequent number.
List.Numbers(1, 10, 2)
| 1 |
| 3 |
| 5 |
| 7 |
| 9 |
| 11 |
| 13 |
| 15 |
| 17 |
| 19 |