C
cradino
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??
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??