Ask Your Question

Revision history [back]

If you put 5 into A1, and 12 into A5, you may put this to A2:

=A1+($A$5-$A$1)/(ROW($A$5)-ROW($A$1))

... and drag-copy to A4.

If you put 5 into A1, and 12 into A5, you may put this to A2:

=A1+($A$5-$A$1)/(ROW($A$5)-ROW($A$1))

... and drag-copy to A4.

Then you even can turn the formulas to the values, e.g. using DataCalculateFormula to Value.