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)
