Use Goal Seek to find the result you want by adjusting an input …
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to …
PMT function - Microsoft Support
The PMT function syntax has the following arguments: Rate Required. The interest rate for the loan. Nper Required. The total number of payments for the loan. Pv Required. The present …
Using Excel formulas to figure out payments and savings
Excel formulas and budgeting templates can help you calculate the future value of your debts and investments, making it easier to figure out how long it will take for you to reach your goals. Use …
Calculate multiple results by using a data table
A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function …
NPER function - Microsoft Support
This article describes the formula syntax and usage of the NPER function in Microsoft Excel. Returns the number of periods for an investment based on periodic, constant payments and a …
PMT function - Microsoft Support
The PMT function syntax has the following arguments: Rate Required. The interest rate for the loan. Nper Required. The total number of payments for the loan. Pv Required. The present …
PPMT function - Microsoft Support
Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. Make sure that you are consistent about the …
Quick Reference Card: VLOOKUP refresher - Microsoft Support
VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often. If all you want is the syntax for VLOOKUP, here it is: To …
PV function - Microsoft Support
The PV function syntax has the following arguments: Rate Required. The interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make …
FV function - Microsoft Support
Use the Excel Formula Coach to find the future value of a series of payments. At the same time, you'll learn how to use the FV function in a formula. Or, use the Excel Formula Coach to find …
IPMT function - Microsoft Support
The IPMT function syntax has the following arguments: Rate Required. The interest rate per period. Per Required. The period for which you want to find the interest and must be in the …