Microsoft Office Tutorials and References

In Depth Information

**USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA**

Part

I

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

Figure 64:

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

●

●

●

●

●

●

●

●