| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Interpolation
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? |
|
#2
|
|||
|
|||
|
Interpolation
In A2 enter:
=(A11-A1)/10 In A3 enter: =A2+$A$2 and copy down thru A10 -- Gary's Student "Bent Hansen" wrote: 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? |
|
#3
|
|||
|
|||
|
Interpolation
Hi "Gary"s Student,
Thanks for the answer - how simple!!! "Gary''s Student" skrev: In A2 enter: =(A11-A1)/10 In A3 enter: =A2+$A$2 and copy down thru A10 -- Gary's Student "Bent Hansen" wrote: 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? |
|
#4
|
|||
|
|||
|
Interpolation
You are welcome. I consider simplicity a virtue. I even try to shave with
Occam's Razor. -- Gary's Student "Bent Hansen" wrote: Hi "Gary"s Student, Thanks for the answer - how simple!!! "Gary''s Student" skrev: In A2 enter: =(A11-A1)/10 In A3 enter: =A2+$A$2 and copy down thru A10 -- Gary's Student "Bent Hansen" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linear interpolation function in excel | Excel Worksheet Functions | |||
| I am looking for a function for linear interpolation | Excel Discussion (Misc queries) | |||
| interpolation in a particular interval (HELP) | Excel Discussion (Misc queries) | |||
| help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
| interpolation in excel | Excel Worksheet Functions | |||
Hybrid Mode
