The «Goal Seek» function is perfect for solving equations with one unknown. The solution of the equation by the method Goal Seek in Excel The command gives only one solution of the problem. The function «Goal Seek» changes the value in the cell B3 until it receives the result of user-defined formulas, which was written in the cell B4.
In the field «By changing cell» – we set the absolute reference to the cell with the desired parameter ($B$3).Īfter you click OK on the screen will appear the result. For example -5000 (that the formula to work properly, put the sign up «minus», because these money will be given to). In this example, this is amount of monthly payments. The field «To value» is intended to introduce the desired result of the formula. In the field «Set cell» we set the reference to the cell with the calculation formula (B4). «Data Tools»-«What-If Analysis»-«Goal Seek». When the conditions of the problem is recorded, proceed to the «DATA» tab. To calculate the monthly payments using the =PLT() function. The percentage rate is unknown, so the cell B3 is empty.
Complete to the table by the input information. It is necessary to choose the interest rate on the loan, if we know the amount of money and timefrime. We contemplate to the function «Selection parameters» in Excel in the example now. For example, you know the result of some kind of formula.
0 kommentar(er)
