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