{"id":4948,"date":"2023-07-06T01:38:09","date_gmt":"2023-07-06T01:38:09","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-pi\/"},"modified":"2023-07-06T01:38:09","modified_gmt":"2023-07-06T01:38:09","slug":"vba-pi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-pi\/","title":{"rendered":"Vba: cara menggunakan pi dalam perhitungan"},"content":{"rendered":"

<\/p>\n

\n

Dalam matematika, Pi<\/strong> adalah bilangan irasional (bilangan desimal tak berujung) yang kira-kira sama dengan 3,14.<\/span><\/p>\n

Untuk menggunakan Pi dalam perhitungan di VBA, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n

 Function<\/span> MultiplyByPi(inputVal)\n\nDim<\/span> Pi As<\/span> Double\n\nMultiplyByPi = inputVal * Application.WorksheetFunction.Pi()\n\nEnd Function\n<\/span><\/strong><\/span><\/pre>\n
 Fungsi khusus ini memungkinkan Anda mengalikan nilai apa pun di Excel dengan Pi.<\/span><\/p>\n
 Perhatikan bahwa Application.WorksheetFunction.Pi<\/strong> mengembalikan nilai 3.14159265358979<\/strong> , yang merupakan konstanta Pi 15 digit yang tepat.<\/span><\/p>\n
 Jika Anda memerlukan penghitungan yang lebih presisi daripada 15 digit, Anda cukup melakukan hardcode Pi dengan digit sebanyak yang Anda inginkan.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menggunakan Pi di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar nilai berikut di Excel yang ingin kita kalikan dengan Pi:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk melakukan ini, kita dapat membuat fungsi berikut di VBA:<\/span><\/p>\n
 Function<\/span> MultiplyByPi(inputVal)\n\nDim<\/span> Pi As<\/span> Double\n\nMultiplyByPi = inputVal * Application.WorksheetFunction.Pi()\n\nEnd Function<\/span><\/strong><\/span><\/pre>\n
 Setelah kita membuat fungsi ini, kita bisa mengetikkan rumus berikut di sel B2<\/strong> untuk mengalikan nilai di sel A2<\/strong> dengan Pi:<\/span><\/p>\n
 =MultiplyByPi( A2<\/span> )<\/strong><\/pre>\n
 Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B sekarang menampilkan setiap nilai di kolom A dikalikan Pi.<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menambahkan nilai dalam suatu rentang<\/a>
 VBA: Cara menghitung nilai rata-rata rentang<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Dalam matematika, Pi adalah bilangan irasional (bilangan desimal tak berujung) yang kira-kira sama dengan 3,14. Untuk menggunakan Pi dalam perhitungan di VBA, Anda dapat menggunakan sintaks berikut: Function MultiplyByPi(inputVal) Dim Pi As Double MultiplyByPi = inputVal * Application.WorksheetFunction.Pi() End Function Fungsi khusus ini memungkinkan Anda mengalikan nilai apa pun di Excel dengan Pi. Perhatikan bahwa […]<\/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":"\nVBA: Cara menggunakan Pi dalam perhitungan - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa 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\/vba-pi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan Pi dalam perhitungan - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-pi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T01:38:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivba1.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\/vba-pi\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-pi\/\",\"name\":\"VBA: Cara menggunakan Pi dalam perhitungan - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T01:38:09+00:00\",\"dateModified\":\"2023-07-06T01:38:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-pi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-pi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-pi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan pi dalam perhitungan\"}]},{\"@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":"VBA: Cara menggunakan Pi dalam perhitungan - Statologi","description":"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa 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\/vba-pi\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan Pi dalam perhitungan - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-pi\/","og_site_name":"Statorials","article_published_time":"2023-07-06T01:38:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivba1.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\/vba-pi\/","url":"https:\/\/statorials.org\/id\/vba-pi\/","name":"VBA: Cara menggunakan Pi dalam perhitungan - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T01:38:09+00:00","dateModified":"2023-07-06T01:38:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan Pi saat melakukan perhitungan dengan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-pi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-pi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-pi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan pi dalam perhitungan"}]},{"@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\/4948"}],"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=4948"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4948\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}