Using Goal Seek to Find Values
After you've constructed a worksheet and built several intricate formulas, you might discover that you can't easily get the answer you're looking for. A formula that uses the PMT function, for example, is designed to produce the total monthly payment when you enter the price and loan details. But what if you want to start with a specific monthly payment and interest rate, and then calculate the maximum loan amount you can afford based on those values? Rather than construct a new formula or use trial-and-error methods to find the right result, use Excel's Goal Seek tool to perform the calculations in one operation:
Start by opening the worksheet that contains the formula you want to work with, and then choose Tools, ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
