![]() |
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 |
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(!). |
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