ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Show me how to use the forum (https://www.excelbanter.com/excel-discussion-misc-queries/56292-show-me-how-use-forum.html)

skybird23

Show me how to use the forum
 

:confused:

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


[email protected]

Show me how to use the forum
 
"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(!).


skybird23

Show me how to use the forum
 

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



All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com