Help with Interpolating for a value.

[Terry]

I am trying to calculate a value such as 60 % that occurs in a column of
cells, and then have it return a value proportionately from another column.

 

[BenjieLop]

I am trying to calculate a value such as 60 % that occurs in a colum
of
cells, and then have it return a value proportionately from anothe
column.

I don't think Excel has an interpolation function so let us just deriv
your interpolation formula using the basic concept presented in a
Algebra course.

If your (assumed) data are arranged as follows

ColumnA ColumnB
12 36
x y
20 60

what/where is your 60%? Is it (12+ 60% of 12) in Col A or (36 + 60% o
36) in Col B

 

[Jerry W. Lewis]

While there is no interpolation function in Excel, you can often fake it
through judicious use of FORECAST, TREND, or GROWTH, depending on the
form of interpolation you wish to use.

Jerry