ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wan't to know command for iterpolation (https://www.excelbanter.com/excel-discussion-misc-queries/186114-want-know-command-iterpolation.html)

Kiran Naik

Wan't to know command for iterpolation
 
I want to know how to make iterpolation between Two vaues in two Different Rows
f.g
In one row ly/lx values are there in the range of 1,2,3,4...............10
In second row ax values are there in the range of
0.1,0.2,0.3,0.4.................1
Now I want to Know the values of ax for ly/lx equal to 2.5

Gary''s Student

Wan't to know command for iterpolation
 
Look in Excel help for the FORCAST() function. It also interpolates.
--
Gary''s Student - gsnu200784


"Kiran Naik" wrote:

I want to know how to make iterpolation between Two vaues in two Different Rows
f.g
In one row ly/lx values are there in the range of 1,2,3,4...............10
In second row ax values are there in the range of
0.1,0.2,0.3,0.4.................1
Now I want to Know the values of ax for ly/lx equal to 2.5



All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com