List.Numbers

Returns a list of numbers given an initial value, count, and optional increment value.

Syntax

List.Numbers(
    start as number,
    count as number,
    optional increment as number
) as list

Remarks

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.

Examples

Example #1

Generate a list of 10 consecutive numbers starting at 1.

List.Numbers(1, 10)

Result:

{
    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)

Result:

{
    1,
    3,
    5,
    7,
    9,
    11,
    13,
    15,
    17,
    19
}

Category

List.Generators