ExcelBanter - Interpolation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Interpolation (https://www.excelbanter.com/excel-worksheet-functions/53355-interpolation.html)

Bent Hansen

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?

Gary''s Student

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?

Bent Hansen

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?

Gary''s Student

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?

All times are GMT +1. The time now is 08:19 AM.