Help with PMT formula

Hi there!

I have an excel sheet which uses the PMT formula but i need to change it because one of the independent variables has now become the dependent one. That is, it is now the required output.

In brief, is there a way to reengineer the following formula so that I get the value of x? All variables other than x are known.

c = PMT(r,t,x,ax) + bx

Thank you!

Cross post http://chandoo.org/forum/threads/reversing-excel-pmt-formula.19652/ and http://www.excelforum.com/excel-formulas-and-functions/1042725-reversing-excel-pmt-formula.html

Please read this message to cross posters

Hi,

I assume the new dependent variable is the Present Value. If yes, you can use the function PV which computed for Present Value. You can take a look at the Formulas Ribbon and go to Financial for more formulas that will suit your needs.

Regards,
Peter