Excel Help: Calculating in between numbers

[tonytiger55]

I have 4 numbers. I need excel to calculate the numbers in between over a number of cells.(i.e Mortgage draw down). I know the numbers at particular years.
I cant remember how to do this.
My googlefu is letting me down.

310


262


200


77

[ExtraSlow]

310- ((310-262)/12) That should get you the amount one month after 310. Obviously use cell references or static cell references ($cell) and not values. Repeat . . . .?

[tonytiger55]

This quote is hidden because you are ignoring this member. Show Quote

310- ((310-262)/12) That should get you the amount one month after 310. Obviously use cell references or static cell references ($cell) and not values. Repeat . . . .?

I'l just bring my laptop to dinner....

[ExtraSlow]

I'm not totally clear what you want to do here. We can laptop that shit up over tacos.

[CompletelyNumb]

Sounds like what you're looking for is interpolation. As long as you know the start/end numbers and the number of points needed, it's pretty simple.