ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Having this tablet X;Y values how can I make interpolate between e (https://www.excelbanter.com/excel-worksheet-functions/108152-having-tablet-x%3By-values-how-can-i-make-interpolate-between-e.html)

cradino

Having this tablet X;Y values how can I make interpolate between e
 
Having this tablet X;Y values how can I make interpolate between each pair of
Xn;Xn+1 values for eatch straight line!

A B C
1 Values X Values Y
2 1.200,00 10,03
3 3.000,00 8,8
4 6.000,00 7,93
5 12.000,00 7,1
6 24.000,00 6,3
7 60.000,00 5,29
8 120.000,00 4,57
9 300.000,00 3,72
10 600.000,00 3,24
11 1.200.000,00 3,03
12 New value X New Value Y1 New Value Y2
13 1.500,00 9,83 7,03
14 4.000,00 8,51 7,02
15 7.500,00 7,72 7,00
16 15.000,00 6,90 6,97
17 30.000,00 6,13 6,90
18 100.000,00 4,81 6,59
19 200.000,00 4,19 6,15
20 500.000,00 3,40 4,81
21 1.000.000,00 3,10 2,59
B13= TREND(F12:F13;E12:E13;E23) C13=TREND(F12:F21;E12:E21;E23:E31)
B14= TREND(F13:F14;E13:E14;E24) C14=TREND(F12:F21;E12:E21;E23:E31)

At column B
In this case (Column B) the formulas are diferent because I want to
interpolate between each pair of Knowed Values_Y and Knowed Values_X for each
Knowed Value X to get each desired Value_Y
At Column C
In this case (Column C) Formuras are equal because I use un array for Known
Values_Y, un unique array for Known Values_X, un unique array for New
Values_X and too un unique array to desired Ney Values_Y and I ajusted to the
same trend line

Question:
How can I create one only formula to get the same result at column B but
with one only formula??



All times are GMT +1. The time now is 11:23 PM.

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