interpolated values

D

Denish D

Column A Column B Column D
4.99 3650 6.500
5.06 3940 6.450
5.12 4230 6.400
5.19 4520 6.400
5.26 4810 6.450
5.33 5100 6.500
5.39 5430 6.500
5.46 5760 6.400
5.53 6090 6.350
5.60 6420 6.300
5.68 6750 6.200
5.73 7100 6.150
5.80 7450 6.150
5.87 7800 6.100
5.93 8150 6.050
6.00 8500 6.000
6.07 8850 6.150
6.14 9200 6.350
6.21 9550 6.450
6.27 9900 6.470
6.34 10250 6.900
6.41 10650 6.950


For the input values of column "A" I am having respective out put values in
column "B".
now for any input number between "4.99" to "6.41", I want output values to
be interpolated from column "B".
I want the output values for the input values mentioned in column "D".
Output values must be interpolated from column "B".
example: for input value of 5.02, I must get the output values in between
"3650" and "3940" by interpolation.
 
B

Bernard Liengme

Your data is very close to a straight line so I would use FORECAST
Suppose the A1 values are in A1:A22 and the B values in B1:B22
In E1 enter
=ROUND(FORECAST(D1,$B$1:$B$22,$A$1:$A$22),0)
and copy down the column by double clicking the fill handle (small solid
square in lower right corner of E1 when it is the active cell)
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
 
Top