TREND function to fill in the gaps between two points

[RoundaboutCJP]

Hi,
Perhaps TREND is not the correct function for this?

In A1 I have a starting point number = 10
In A8 I have a goal number - the one I want to get to = 50

What I want is a formula that will autocomplete cells A2 - A7 with the numbers that make a trend between A1 and A8

I tried using the 'cell fill series' functionality BUT the number in cell A1 may change dynamically via a function and I want cells A2-A7 to auto update when that happens.

Thanks so much excellers

[shg]

	a	b
1	10
2	15.71429	a2: =a$1 + (rows(a$1:a2) - 1) * (a$8 - a$1) / (rows(a$1:a$8) - 1)
3	21.42857
4	27.14286
5	32.85714
6	38.57143
7	44.28571
8	50

[RoundaboutCJP]

Seems obvious now. I was looking for a formula when a simple work around will do the job!
Cheers

[joeu2004]

I was looking for a formula when a simple work around will do the job!

What shg provided is a formula, not a work-around. For a simpler formula, close to what you might have had in mind:

	a	b
1	10
2	15.71429	a2: =FORECAST(ROW(A2), CHOOSE({1,2},$A$1,$A$8), {1,8})
3	21.42857
4	27.14286
5	32.85714
6	38.57143
7	44.28571
8	50

Copy A2 into A3:A7.