Microsoft Office Tutorials and References
In Depth Information
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA
Figure 64. h
e formulas in J3:J17 i nds the result.
You can solve the problem using a series of formulas as shown in J3:J17 of
The MATCH in J3 ﬁ nds the row number in Figure 63 that is less than or
equal to the height in cell J1.
The MATCH in J5 ﬁ nds the column number in Figure 63 that is less than or
equal to the span in J2.
Formulas in J4 and J6 add one to the previous cell.
Formulas in J7:J10 use INDEX functions based on rows J3 & J4 and
columns J5 & J6 to get the lower & higher height & spans.
The HtDiff in J11 is the amount at which the sought height is in excess of
the previous height.
The SpanDiff in J12 is the amount at which the sought span is in excess of
the previous span.
The intervals in J13:J14 calculate the delta between the previous and next
height or span.
Cells J15:J17 then complete the interpolation