{"id":4952,"date":"2023-07-06T00:20:37","date_gmt":"2023-07-06T00:20:37","guid":{"rendered":"https:\/\/statorials.org\/id\/lantai-vba\/"},"modified":"2023-07-06T00:20:37","modified_gmt":"2023-07-06T00:20:37","slug":"lantai-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lantai-vba\/","title":{"rendered":"Cara menggunakan fungsi lantai di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>Lantai<\/b> di VBA untuk membulatkan angka dalam sel ke kelipatan signifikan terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara umum untuk menggunakan fungsi ini dalam praktik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubToFloor<\/span> ()\n\n<span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n<span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 10\n    Range(\"C\" &amp; i) = WorksheetFunction.Floor(Range(\"A\" &amp; i), Range(\"B\" &amp; i))\n<span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan membulatkan setiap nilai dalam rentang <strong>A2:A10<\/strong> ke kelipatan signifikan terdekat yang ditentukan dalam rentang <strong>B2:B10<\/strong> dan menampilkan hasilnya dalam rentang <strong>C2:C10<\/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: Cara menggunakan fungsi Lantai di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nilai di kolom A dan daftar kelipatan penting lainnya di kolom B yang ingin kita bulatkan setiap nilainya menjadi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38661 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etagev1.png\" alt=\"\" width=\"447\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut dengan metode <strong>Lantai<\/strong> di VBA untuk membulatkan setiap nilai di kolom A ke kelipatan signifikan di kolom B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubToFloor<\/span> ()\n\n<span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n<span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 10\n    Range(\"C\" &amp; i) = WorksheetFunction.Floor(Range(\"A\" &amp; i), Range(\"B\" &amp; i))\n<span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38662 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etagev2.png\" alt=\"\" width=\"462\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C menunjukkan hasil penggunaan metode <strong>Floor<\/strong> pada setiap nilai di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">12.2452 dibulatkan ke bawah ke kelipatan 0.001 terdekat adalah <strong>12.245<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">14.927 dibulatkan ke bawah ke kelipatan 0.01 terdekat adalah <strong>14.92<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">-5.23 dibulatkan ke bawah ke kelipatan 0.1 terdekat adalah <strong>-5.3<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <b>Lantai<\/b> VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheetfunction.floor\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/ikhtisar-vba\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan nilai di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan nilai di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-membulatkan-2-tempat-desimal\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan nilai ke 2 desimal di VBA<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode Lantai di VBA untuk membulatkan angka dalam sel ke kelipatan signifikan terdekat. Berikut cara umum untuk menggunakan fungsi ini dalam praktik: SubToFloor () Dim i As Integer For i = 2 To 10 Range(&#8220;C&#8221; &amp; i) = WorksheetFunction.Floor(Range(&#8220;A&#8221; &amp; i), Range(&#8220;B&#8221; &amp; i)) Next i End Sub Makro khusus ini akan [&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 Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.\" \/>\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\/lantai-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lantai-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T00:20:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etagev1.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\/lantai-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/lantai-vba\/\",\"name\":\"Cara Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T00:20:37+00:00\",\"dateModified\":\"2023-07-06T00:20:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lantai-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lantai-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lantai-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi lantai 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 Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.","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\/lantai-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/lantai-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-06T00:20:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etagev1.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\/lantai-vba\/","url":"https:\/\/statorials.org\/id\/lantai-vba\/","name":"Cara Menggunakan Fungsi Lantai di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T00:20:37+00:00","dateModified":"2023-07-06T00:20:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi lantai di VBA untuk membulatkan nilai ke kelipatan signifikan terdekat, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lantai-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lantai-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lantai-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi lantai 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\/4952"}],"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=4952"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4952\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}