![]() |
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