{"id":4854,"date":"2023-07-07T05:18:38","date_gmt":"2023-07-07T05:18:38","guid":{"rendered":"https:\/\/statorials.org\/id\/faktorial-vba\/"},"modified":"2023-07-07T05:18:38","modified_gmt":"2023-07-07T05:18:38","slug":"faktorial-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/faktorial-vba\/","title":{"rendered":"Cara membuat fungsi faktorial di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Faktorial<\/strong> adalah hasil kali semua bilangan bulat positif yang kurang dari atau sama dengan bilangan bulat positif tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, faktorial 5 (ditulis 5!) dihitung sebagai:<\/span><\/p>\n<ul>\n<li> <strong><span style=\"color: #000000;\">5! = 5*4*3*2*1 = 120<\/span><\/strong><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk membuat fungsi faktorial di VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> FindFactorial(N <span style=\"color: #0000ff;\">As<\/span> Integer) <span style=\"color: #0000ff;\">As<\/span> Double\n\n Dim i <span style=\"color: #0000ff;\">As<\/span> Integer, result <span style=\"color: #0000ff;\">As<\/span> Long\n \n result = 1\n\n <span style=\"color: #0000ff;\">For<\/span> i = 1 <span style=\"color: #0000ff;\">To<\/span> N\n     result = result * i\n <span style=\"color: #0000ff;\">Next<\/span>\n\n FindFactorial = result\n\n<span style=\"color: #0000ff;\">End Function\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Setelah Anda membuat fungsi ini, Anda kemudian dapat mengetikkan sesuatu seperti <strong>=FindFactorial(A2)<\/strong> ke dalam sel di Excel untuk menemukan faktorial bilangan bulat di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Membuat Fungsi Faktorial di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar angka berikut di Excel dan kita ingin menghitung faktorial setiap angka:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37928 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/facto1.png\" alt=\"\" width=\"493\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mendefinisikan fungsi berikut di VBA untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> FindFactorial(N <span style=\"color: #0000ff;\">As<\/span> Integer) <span style=\"color: #0000ff;\">As<\/span> Double\n\n Dim i <span style=\"color: #0000ff;\">As<\/span> Integer, result <span style=\"color: #0000ff;\">As<\/span> Long\n \n result = 1\n\n <span style=\"color: #0000ff;\">For<\/span> i = 1 <span style=\"color: #0000ff;\">To<\/span> N\n     result = result * i\n <span style=\"color: #0000ff;\">Next<\/span>\n\n FindFactorial = result\n\n<span style=\"color: #0000ff;\">End Function<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita membuat fungsi ini, kita kemudian dapat mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung faktorial dari nilai di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><b>=FindFactorial( <span style=\"color: #3366ff;\">A2<\/span> )<\/b><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37929\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/facto2.png\" alt=\"fungsi faktorial di VBA\" width=\"504\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom B sekarang menampilkan faktorial setiap bilangan bulat di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">1! = <strong>1<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">2! = 2 * 1 = <strong>2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">3! = 3*2*1 = <strong>6<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">4! = 4*3*2*1 = <strong>24<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Untuk menghitung faktorial di Excel tanpa menggunakan VBA, Anda bisa menggunakan fungsi <strong>FACT<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rentang-jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menambahkan nilai dalam suatu rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai rata-rata rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Faktorial adalah hasil kali semua bilangan bulat positif yang kurang dari atau sama dengan bilangan bulat positif tertentu. Misalnya, faktorial 5 (ditulis 5!) dihitung sebagai: 5! = 5*4*3*2*1 = 120 Anda dapat menggunakan sintaks berikut untuk membuat fungsi faktorial di VBA: Function FindFactorial(N As Integer) As Double Dim i As Integer, result As Long result [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah 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:\/\/statorials.org\/id\/faktorial-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/faktorial-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T05:18:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/facto1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/faktorial-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/faktorial-vba\/\",\"name\":\"Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T05:18:38+00:00\",\"dateModified\":\"2023-07-07T05:18:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/faktorial-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/faktorial-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/faktorial-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat fungsi faktorial di vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah 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:\/\/statorials.org\/id\/faktorial-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/faktorial-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-07T05:18:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/facto1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/faktorial-vba\/","url":"https:\/\/statorials.org\/id\/faktorial-vba\/","name":"Cara Membuat Fungsi Faktorial di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T05:18:38+00:00","dateModified":"2023-07-07T05:18:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat fungsi untuk menghitung faktorial di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/faktorial-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/faktorial-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/faktorial-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat fungsi faktorial di vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4854"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4854"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4854\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}