Microsoft Office Tutorials and References
In Depth Information
Figure 8-18: This worksheet uses a formula that uses the LOOKUP function and the TREND function.
The formula in cell B2 follows. This formula uses an IF function to make a decision. If an exact match is found
in the x range, the formula returns the corresponding y value (using the LOOKUP function). If an exact match is
not found, the formula uses the TREND function to return the calculated “best-fit” y value. (It does not perform
a linear interpolation.)
Search JabSto ::

Custom Search