calculate the average selling price over time

[MartinL]

If I have a price at Year1 (10.00) and a price at Year10 (50)
How do I calculate the average price during all the interceding years
i.e.
Yr1 = 10
Yr2 = ?
Yr3 = ?
Yr4 = ?
Yr5 = ?
Yr6 = ?
Yr7 = ?
Yr8 = ?
Yr9 = ?
Yr10 = 50

I'm having a brain dead moment

 

[palaeontology]

if years are in range C1:C10, and 10 is in D1, and 50 is in d10, then place this into d2 and drag down to d9 ....

=D1+(D$10-D$1)/(ROWS($D$1:$D$10)-1)

Chris

 

[FDibbins]

I got pretty much the same thing, but used COUNTA instead of ROWS...
=D1+($D$10-$D$1)/(COUNTA($C$1:$C$10)-1)

 

[MartinL]

if years are in range C1:C10, and 10 is in D1, and 50 is in d10, then place this into d2 and drag down to d9 ....

=D1+(D$10-D$1)/(ROWS($D$1:$D$10)-1)

Chris

Thanks for this, It worked just as I expected and showed me the flaw in my initial thinking..