Itu function untuk menentukan cicilan per bulan dari kredit dengan tingkat bunga tetap dalam waktu tertentu (jangka waktu cicilan, mis. 12 bulan).
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rizky Prihanto Sent: Monday, June 16, 2008 9:15 AM To: [email protected] Subject: Re: [indoprog-vb] pmt function A=Round(Abs(Pmt(12/100)/12,12,1000000)),0) mbak, ekspresi matematikanya salah tuh. kurang kurung buka stlh pemanggilan function PMT. mestinya gini : A=round(abs(Pmt((12/100)/12,12,1000000)),0) nah.. klo mba' pengen liat hasilnya, coba aja buka immediate window (Ctrl-G) trus ketikin di situ : ?round(abs(Pmt((12/100)/12,12,1000000)),0) (kasih tanda tanya sebelum round). ntar bakal muncul hasilnya. klo di t4 saya, hasilnya *88849* untuk fungsi dari function Pmt() itu sendiri menurut Object Browser (arahkan cursor text ke pmt, trus tekan Shift-F2) : Function Pmt(Rate As Double, NPer As Double, PV As Double, [FV], [Due]) As Double Member of VBA.Financial *Returns the payment for an annuity* *dia termasuk function VBA financial. hmm.. jujur, gw baru tau jg neh.. ternyata ada macam2 function utk handling operasi2 akuntansi. hihihihi. mantaph.. bisa nih, refactoring code akuntansi gw... *semakin banyak kita tau, semakin sadar kita bahwa sesungguhnya kita belum tau apa-apa* makasih udah bertanya mbak... n makasih atas ilmunya. -- wassalam, *Rizky Prihanto* http://www.software-arsitek.web.id <http://www.software-arsitek.web.id> 2008/6/16 Evi Damayanti <[EMAIL PROTECTED] <mailto:evidamai%40yahoo.com> >: > Hai...All > > Mau tanya donk seputar pmt fucntion itu apa sih dan untuk apa ? > klo ada syntak kayak gini ada gak yang tau hasilnya brp > A=Round(Abs(Pmt(12/100)/12,12,1000000)),0) > > Hasil A-nya jadi brp yah ? > > Trims... > -Evi- > > [Non-text portions of this message have been removed] NOTICE - This message and any attached files may contain information that is confidential and intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message. [Non-text portions of this message have been removed]
