Page 118 - Excel for Scientists and Engineers: Numerical Methods
P. 118
CHAPTER 5 INTERPOLATION 95
The function InterpC2 was used to obtain the viscosity of a 74.5% weight
percent solution of ethylene glycol at 195"F, as illustrated in Figure 5-22. The
formula in cell M7 was
=I nterpC2( K7, L7, $A$4:$A$29, $B$3:$1$3,$8$4:$1$29)
This custom function provides a convenient way to perform interpolation in a
two-way table.
Figure 5-22. Result returned by the cubic interpolation function.
(folder 'Chapter 05 Interpolation', workbook 'Interpolation II', sheet 'Cubic lnterp 2-Way by Custom Fn')
