terima kasih rumusnya2... jujur..angsuran ini aku sadur dari cetakan sistem anuitas/loan...kalo dihitung pake excel selisihnya terlihat jelas karena pembulatan angka di belakang koma. bisa ngga disetting atau apa yang harus di contreng supaya hasil perhitungan excel sama persis perhitungan di sistem anuitas/loan. masalahnya aku sering buat laporan pake excel dan harus sesuai cetakan angsuran loan jadi pasti ada selisih lebih atau kurang karena pembulatan itu...
di sheet rekapan juga belum diutak atik tuh... makasih semuanya.. ----- Original Message ----- From: dwint ruswanto To: [email protected] Sent: Wednesday, July 06, 2011 6:38 PM Subject: Bls: [belajar-excel] angsuran pinjaman sambil menunggu para suhu dan master BeExcel menjawab dengan jurus-jurus yang canggih, saya coba bantu dengan formula yang sederhana, saya menggunakan tambahan 2 kolom bantu yaitu "Saldo Awal" dan "Sisa Pokok Pinjaman". terdapat sedikit perbedaan angka karena pembulatan angka di belakang koma. untuk jelasnya bisa agan lihat di attachment sheet "ABDUL" cekidot :D Dari: Rey <[email protected]> Kepada: [email protected] Dikirim: Rabu, 6 Juli 2011 15:32 Judul: [belajar-excel] angsuran pinjaman Mohon bantuannya.. Semoga bisa di pahami...lihat lampiran.. terima kasih. Rey PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
