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 =
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
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: