Interpolation

[Bent Hansen]

A1: 0
A11: 10
How do I interpolate in range A2:A10 by using A1 and A11
I'm using Excel 2003 (danish)
Has anyone a Solution?

 

[Gary''s Student]

In A2 enter:
=(A11-A1)/10

In A3 enter:
=A2+$A$2 and copy down thru A10

 

[Bent Hansen]

Hi "Gary"s Student,
Thanks for the answer - how simple!!!

"Gary''s Student" skrev:

 

[Gary''s Student]

You are welcome. I consider simplicity a virtue. I even try to shave with
Occam's Razor.