{"id":4778,"date":"2023-07-08T01:24:33","date_gmt":"2023-07-08T01:24:33","guid":{"rendered":"https:\/\/statorials.org\/id\/logaritma-vba\/"},"modified":"2023-07-08T01:24:33","modified_gmt":"2023-07-08T01:24:33","slug":"logaritma-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/logaritma-vba\/","title":{"rendered":"Cara menghitung logaritma di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk menghitung log<\/strong> (basis 10) suatu nilai menggunakan VBA:<\/span><\/p>\n

 Function<\/span> FindLog(number)<\/strong><\/span>\nFindLog = Application.WorksheetFunction.Log(number)<\/strong><\/span>\nEnd Function<\/strong><\/span><\/pre>\n
 Dan Anda dapat menggunakan sintaks berikut untuk menghitung logaritma natural<\/strong> suatu nilai menggunakan VBA:<\/span><\/span><\/p>\n
 Function<\/span> FindNaturalLog(number)<\/strong><\/span>\nFindNaturalLog = Log(number)<\/strong><\/span>\nEnd Function<\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan setiap fungsi dalam praktik.<\/span><\/p>\n
 Contoh 1: Hitung Log (Basis 10) Menggunakan VBA<\/strong><\/span><\/h2>\n
 Untuk menghitung log (basis 10) suatu nilai di Excel, kita akan menggunakan fungsi LOG<\/strong> sebagai berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Ini memberitahu kita bahwa log dari 5 adalah 0.69879<\/strong> .<\/span><\/p>\n
 Untuk mereplikasi fungsi ini di VBA, kita dapat mendefinisikan fungsi berikut:<\/span><\/p>\n
 Function<\/span> FindLog(number)<\/strong><\/span>\nFindLog = Application.WorksheetFunction.Log(number)<\/strong><\/span>\nEnd Function<\/strong><\/span><\/pre>\n
 Kita kemudian dapat mengetikkan fungsi ini ke dalam sel B2<\/strong> untuk menghitung log nilai di sel B1<\/strong> :<\/span><\/span> <\/p>\n
\"\"<\/p>\n
 Ini memberitahu kita bahwa log dari 5 adalah 0.69879<\/strong> .<\/span><\/p>\n
 Ini sesuai dengan nilai yang dihitung oleh fungsi LOG<\/strong> di Excel.<\/span><\/p>\n
 Contoh 2: Menghitung Log Natural Menggunakan VBA<\/strong><\/span><\/h2>\n
 Untuk menghitung logaritma natural suatu nilai di Excel, kita akan menggunakan fungsi LN<\/b> sebagai berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Ini memberitahu kita bahwa logaritma natural dari 5 adalah 1,609438<\/strong> .<\/span><\/p>\n
 Untuk mereplikasi fungsi ini di VBA, kita dapat mendefinisikan fungsi berikut:<\/span><\/p>\n
 Function<\/span> FindNaturalLog(number)<\/strong><\/span>\nFindNaturalLog = Log(number)<\/strong><\/span>\nEnd Function<\/strong><\/span><\/pre>\n
 Kita kemudian dapat mengetikkan fungsi ini di sel B2<\/strong> untuk menghitung logaritma natural dari nilai di sel B1<\/strong> :<\/span> <\/p>\n
\"log<\/p>\n
 Ini memberitahu kita bahwa log dari 5 adalah 1.609438<\/strong> .<\/span><\/p>\n
 Ini sesuai dengan nilai yang dihitung oleh fungsi LN<\/b> di Excel.<\/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 menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a>
 VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a>
 VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk menghitung log (basis 10) suatu nilai menggunakan VBA: Function FindLog(number) FindLog = Application.WorksheetFunction.Log(number) End Function Dan Anda dapat menggunakan sintaks berikut untuk menghitung logaritma natural suatu nilai menggunakan VBA: Function FindNaturalLog(number) FindNaturalLog = Log(number) End Function Contoh berikut menunjukkan cara menggunakan setiap fungsi dalam praktik. Contoh 1: Hitung Log […]<\/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":"\nCara menghitung logaritma di VBA (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung logaritma di 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\/logaritma-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung logaritma di VBA (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung logaritma di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/logaritma-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T01:24:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logvba1.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\/logaritma-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/logaritma-vba\/\",\"name\":\"Cara menghitung logaritma di VBA (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T01:24:33+00:00\",\"dateModified\":\"2023-07-08T01:24:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung logaritma di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/logaritma-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/logaritma-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/logaritma-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung logaritma 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 menghitung logaritma di VBA (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung logaritma di 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\/logaritma-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung logaritma di VBA (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung logaritma di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/logaritma-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-08T01:24:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logvba1.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\/logaritma-vba\/","url":"https:\/\/statorials.org\/id\/logaritma-vba\/","name":"Cara menghitung logaritma di VBA (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T01:24:33+00:00","dateModified":"2023-07-08T01:24:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung logaritma di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/logaritma-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/logaritma-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/logaritma-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung logaritma 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\/4778"}],"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=4778"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4778\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}