Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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??

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make individual x values? gpktm Charts and Charting in Excel 3 August 3rd 06 02:54 AM
How to match values in one column to values in another? trib Excel Worksheet Functions 3 July 25th 06 08:30 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
How to interpolate in an array forX and Y values to get Z? Geeps Excel Worksheet Functions 2 December 12th 05 07:37 PM
#N/A Values : Returned by Formulas vs Entered Manually monir Charts and Charting in Excel 8 July 7th 05 01:16 AM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"