Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 30th 04, 11:00 PM
Terry
 
Posts: n/a
Default Help with Interpolating for a value.

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.

  #2   Report Post  
Old October 31st 04, 05:43 AM
BenjieLop
 
Posts: n/a
Default


Terry Wrote:
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.


I don't think Excel has an interpolation function so let us just derive
your interpolation formula using the basic concept presented in an
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% of
36) in Col B?


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=273909

  #3   Report Post  
Old October 31st 04, 12:14 PM
Jerry W. Lewis
 
Posts: n/a
Default

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

BenjieLop wrote:

Terry Wrote:

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.


I don't think Excel has an interpolation function so let us just derive
your interpolation formula using the basic concept presented in an
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% of
36) in Col B?




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



All times are GMT +1. The time now is 12:44 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017