I want to use the function in a model to automate the setting of the time
frame. So normally, an example like you gave, should not occur. But in case
it would, the function should return teh nearest integer.
If I get it right, the function would consist of a Do..loop sub, and
something like 'fill up next cell' as a statement, but I don't know much
about it ...
I hoped to be able to give in the funtion in the first cell (A1) and Excel
fills up automatically the rest of the cells as defined by the EndValue and
the StepValue.

Thanks in advance
Maarten


"Alan Beban" wrote:

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