LinRange Function

Generates a linear list with a fixed step size


Description

The function LinRange generates a linear list of values of the specified range and step size.

The start value is always the first value in the list. The stop value is only included in the list if the stop value is a multiple of start and step (start * step). Otherwise the last value is smaller than the stop value.

The function LinRange can also be defined on the worksheet as:

[Start..Stop:Step]

Syntax

LinRange (Start, Stop, Step)

Parameters

Start

First value in the list


Stop

Maximum value of the last item in the list


Step

The value by which each following element is incremented


Example

Linrange(4,20,3)=4 7 10 13 16 19