{"id":2022,"date":"2023-10-24T01:59:08","date_gmt":"2023-10-24T01:59:08","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/dirindukan\/"},"modified":"2023-12-06T06:17:50","modified_gmt":"2023-12-06T06:17:50","slug":"dirindukan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/dirindukan\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba rate?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-200315250\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Fungsi VBA RATE tercantum dalam kategori keuangan fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <strong>ia mengembalikan tingkat bunga per periode (dengan arus kas yang sama) untuk pinjaman atau investasi.<\/strong><\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>RATE(Nper, Pmt, Pv, [Fv], [Batas Waktu], [Tebak])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Nper<\/strong> : Jumlah jangka waktu pelunasan pinjaman atau investasi.<\/li><li> <strong>Pmt<\/strong> : Jumlah pembayaran tetap per periode.<\/li><li> <strong>PV<\/strong> : Nilai investasi atau pinjaman saat ini.<\/li><li> <strong>[FV]<\/strong> : Nilai pinjaman\/investasi di masa depan (Ini adalah argumen opsional dan jika dihilangkan, VBA mengambil 0 secara default).<\/li><li> <strong>[Due]<\/strong> : Mendefinisikan apakah pembayaran jatuh tempo pada awal atau akhir periode, gunakan 0 untuk akhir periode dan 1 untuk awal periode [Ini adalah argumen opsional dan jika dihilangkan, VBA mengambil akhir periode secara default] .<\/li><li> <strong>[Guess]<\/strong> : Estimasi awal (tebakan) berapa IRR yang akan dihasilkan [Ini adalah argumen opsional dan jika dihilangkan, VBA mengambil 10% (=0,1) secara default].<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA RATE, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode vba menggunakannya: <\/p><figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-fungsi-tingkat-vba\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-rate-function\" width=\"838\" height=\"438\"><\/figure><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_RATE() Range(\"A8\") = Rate(60, -1200, 0, 98000, 1) * 12 End Sub<\/code><\/pre><p> Dalam kode di atas, kami telah menggunakan RATE untuk menghitung tingkat bunga investasi di mana kami memiliki 60 bulan, 1200 pembayaran bulanan dan 98000 nilai investasi di masa depan, dan pada akhirnya kami mengalikannya dengan 12 untuk mendapatkan suku bunga tahunan.<\/p><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Saat menggunakan RATE, setiap uang yang dibayarkan diwakili oleh angka negatif dan setiap uang yang diterima diwakili oleh angka positif.<\/li><li> Ini menghitung tingkat iterasi. Ia tidak dapat menemukan hasilnya dalam 20 percobaan, ia mengembalikan runtime 5. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-124\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/sore-2\/\">VBA PMT<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ppmt\/\">PPMT VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hp-2\/\">PVVBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sln\/\">VBA SLN<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/syd\/\">VBA SYD<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2022","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/dirindukan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/dirindukan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\",\"datePublished\":\"2023-10-24T01:59:08+00:00\",\"dateModified\":\"2023-12-06T06:17:50+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/dirindukan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dirindukan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba rate?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)","description":"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/dirindukan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)","og_description":"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/dirindukan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/","url":"https:\/\/exceladvisor.org\/id\/dirindukan\/","name":"Bagaimana cara menggunakan fungsi VBA RATE? (Sintaks + Contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","datePublished":"2023-10-24T01:59:08+00:00","dateModified":"2023-12-06T06:17:50+00:00","description":"Pelajari cara menggunakan fungsi VBA RATE dengan sintaks, argumen, dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/dirindukan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-taux-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/dirindukan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba rate?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2022"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2022\/revisions"}],"predecessor-version":[{"id":2649,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2022\/revisions\/2649"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}