How to use PMT Function and Goal Seek Functions in Microsoft Excel
How to use PMT and Goal Seek Functions in Microsoft Excel
Learn how to use Goal Seek to change a formula input to cause a formula to evaluate to set amount. Goal Seek is like a "reverse" formula because we tell the formula what we want it to evaluate to and Goal Seek changes the formula input. Learn how to use the PMT function to calculate a loan payment.