View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
israelica
 
Posts: n/a
Default Interpolate from a table?


I'm working with this table:


H/W 0.25 0.5 0.75 1 1.5
Angle
20 0.08 0.08 0.08 0.07 0.07
30 0.18 0.17 0.17 0.16 0.15
45 0.38 0.37 0.36 0.34 0.33
60 0.6 0.59 0.57 0.55 0.52
75 0.89 0.87 0.84 0.81 0.77
90 1.3 1.3 1.2 1.2 1.1

I'm trying to develop a formula which will interpolate a value for when
I'm in between numbers. For example, if my angle is 25 degrees, and my
H/W is 1.25, then I would get 0.1125. There's gotta be a way to do
this. Any suggestions?


--
israelica
------------------------------------------------------------------------
israelica's Profile: http://www.excelforum.com/member.php...o&userid=31657
View this thread: http://www.excelforum.com/showthread...hreadid=513444