Microsoft Office Tutorials and References

In Depth Information

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

velocity (a design parameter to be read from the table). In the table above, if

you need to ﬁ nd the velocity corresponding to a height of 47 meters, it is a fairly

simple matter to devise a formula that computes 130 + (180 – 130) * 7 / 10 =

165 meters/sec.

How would you do this for a two-way table in which there are two control

parameters? Is it possible to do so using a single formula? The table in Figure

63 illustrates values of wind pressure for the control parameters Height of

structure and Span, and you need to compute the wind pressure for a height of

25 meters and a span of 300 meters.

Figure 63.
Interpolate values from column B and row 2.

Solution: The procedure you use to solve this problem is essentially an

extension of the method used for the single control parameter table. Follow

these steps:

Start with the worksheet shown in Figure 63. Add input cells for height and

span in J1 and J2 respectively.

For ease of formula readability, deﬁ ne the following names:

ColHd =Sheet1!$B$1:$F$1

RoHd

1.

2.

=Sheet1!$A$2:$A$9

Dat

=Sheet1!$B$2:$F$9

Ht

=Sheet1!$J$1

Sp

=Sheet1!$J$2