Having this tablet X;Y values how can I make interpolate between e

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top