Need to know how to use this forum. Had to look around to find this,
and I think my question I post it in private message it wasnot suppose
to be there or was it. Please let me know. Now If its here i need to
ask: I have a formula which i do not understand?
PMT(D412,E4,-C4) I know is payment but what does it mean,
what will do this formula what is it looking for????


--
skybird23
------------------------------------------------------------------------
skybird23's Profile: http://www.excelforum.com/member.php...o&userid=28898
View this thread: http://www.excelforum.com/showthread...hreadid=486467

"skybird23" wrote:
I have a formula which i do not understand?
PMT(D412,E4,-C4) I know is payment but what
does it mean, what will do this formula what is
it looking for????

The first thing you should do is use Help to learn
about the PMT function. You will find that its
parameters a PMT(rate,nper,pv,fv,type).

In the example you give, PMT() computes the
periodic payment necessary to reduce an initial
principle amount given in C4 (a loan, for example)
to zero over a number of periods given in E4 at a
periodic interest rate given in D412(!).

Thanks For Your Anwser, :)


--
skybird23
------------------------------------------------------------------------
skybird23's Profile: http://www.excelforum.com/member.php...o&userid=28898
View this thread: http://www.excelforum.com/showthread...hreadid=486467