The feature can be used to identify an optimal value for a formula in the cell known as the objective cell. It is an add-in program in Microsoft Excel and is helpful on many levels. Several different sets of values can be used in one or multiple of these Advanced excel formulas to explore the different results.Ī solver is ideal for what-if analysis. What-If Analysis is the method of changing the values to try out different scenarios for formulas in Advanced excel. Go to Home > Number and change the value to Percentage. You will see the goal seek function automatically gives the interest rate that is required to pay the loan amount. Set rate of interest as the changing cell. The deduction in amount signifies the negative value.
0 Comments
Leave a Reply. |