Maarten wrote:
Hello,

Is it possible to construct a function for the following problem:
Im looking for a method in Excel to automatically fill in a range of cells
(column A), given a value for the step and an end value.
Example: If
InitialValue (A1) = 0.5
Step = 0.1
EndValue = 1
Then column A should go from 0.5 (in cell A1) to 1 (in cell A6) in steps of
0.1. If I adjust the step to 0.05, column A should automatically become 2
times longer.
Can somebody help me with this?
Thanks,
Maarten

Not quite enough info to provide a general "solution". E.g., if EndValue
is not included in the progression of values from InitialValue by steps
(e.g., InitialValue=.5, Step =.2, EndValue=1), what do you want to happen?

By the way, the previously posted code seems erratic. E.g, for your
illustration it produces .5,.6,.7,.8,.9,1,1

And for .5 to 1 with Step=.2 it produces .5,.7,.9,1,0

Alan Beban