Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Change Data In Pivot Table | New Users to Excel | |||
IS THERE A WAY TO INTERPOLATE AUTOMATICALLY WITHIN A DATA TABLE? | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions |