upchurchsophia
New Member
- Joined
- Jun 24, 2013
- Messages
- 3
Hi i'm an engineering student and I've got problems in interpolation in excel using 2-way lookup.
Let me show you an example:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Let me show you an example:
<tbody> </tbody> The red colored numbers (header) are roof angles. the blue colored numbers (rows) are factors. The black colored numbers are the coefficients. i understand that 2-way lookup searches for the the number intersecting both angle and the factor. if my factor is 0.5 and my roof angle is 15, the resulting coefficient is -0.5. now my concern is, what if my factor is 0.6 and my roof angle is 18, (which by inspection requires two interpolations to happen)? please help me. .thank you | |||||||||||||||||||
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>