{"id":4343,"date":"2023-07-11T20:38:10","date_gmt":"2023-07-11T20:38:10","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/"},"modified":"2023-07-11T20:38:10","modified_gmt":"2023-07-11T20:38:10","slug":"vba-dibulatkan-ke-bawah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/","title":{"rendered":"Cara membulatkan nilai di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <strong>RoundDown<\/strong> di VBA untuk membulatkan nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> RoundDownValue()\n    Range(\" <span style=\"color: #ff0000;\">B1<\/span> \") = WorksheetFunction.RoundDown(Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), 0)\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan membulatkan nilai di sel <strong>A1<\/strong> ke bilangan bulat terdekat dan menampilkan hasilnya di sel <strong>B1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa argumen kedua pada metode <strong>RoundDown<\/strong> menentukan jumlah digit yang akan dibulatkan:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>-3<\/strong> dibulatkan ke bawah ke ribuan terdekat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>-2<\/strong> dibulatkan ke bawah ke ratusan terdekat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>-1<\/strong> dibulatkan ke sepuluh terdekat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>0<\/strong> dibulatkan ke bawah ke bilangan bulat terdekat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> dibulatkan ke bawah ke persepuluhan terdekat (satu desimal)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> pembulatan ke bawah ke perseratus terdekat (dua desimal)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> dibulatkan ke bawah ke seperseribu terdekat (tiga angka desimal)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan metode <strong>RoundDown<\/strong> dalam praktiknya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/ikhtisar-vba\/\" target=\"_blank\" rel=\"noopener\">Cara Membulatkan Nilai di VBA<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Pembulatan ke bilangan bulat terdekat di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk membulatkan nilai di sel <strong>A1<\/strong> ke bilangan bulat terdekat dan menampilkan hasilnya di sel <strong>B1<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> RoundDownValue()\n    Range(\" <span style=\"color: #ff0000;\">B1<\/span> \") = WorksheetFunction.RoundDown(Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), 0)\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-34126 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rd1.jpg\" alt=\"\" width=\"499\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai 1432,78 di sel <strong>A1<\/strong> dibulatkan ke bilangan bulat terdekat yaitu 1432 di sel <strong>B1<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Pembulatan ke ratusan terdekat di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk membulatkan nilai di sel <strong>A1<\/strong> ke ratusan terdekat dan menampilkan hasilnya di sel <strong>B1<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> RoundDownValue()\n    Range(\" <span style=\"color: #ff0000;\">B1<\/span> \") = WorksheetFunction.RoundDown(Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), -2)\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-34127 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rd2.jpg\" alt=\"\" width=\"498\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai 1432,78 di sel <strong>A1<\/strong> dibulatkan ke ratusan terdekat dari 1400 di sel <strong>B1<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Pembulatan ke persepuluhan terdekat di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk membulatkan nilai di sel <strong>A1<\/strong> ke persepuluhan terdekat (yaitu satu desimal) dan menampilkan hasilnya di sel <strong>B1<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> RoundDownValue()\n    Range(\" <span style=\"color: #ff0000;\">B1<\/span> \") = WorksheetFunction.RoundDown(Range(\" <span style=\"color: #ff0000;\">A1<\/span> \"), 1)\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-34128 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rd3.jpg\" alt=\"\" width=\"497\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai 1432,78 di sel <strong>A1<\/strong> dibulatkan ke bawah ke sepersepuluh terdekat dari 1432,7 di sel <strong>B1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA <strong>RoundDown<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheetfunction.rounddown\" 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> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode RoundDown di VBA untuk membulatkan nilai. Fungsi ini menggunakan sintaks dasar berikut: Sub RoundDownValue() Range(&#8221; B1 &#8220;) = WorksheetFunction.RoundDown(Range(&#8221; A1 &#8220;), 0) End Sub Contoh khusus ini akan membulatkan nilai di sel A1 ke bilangan bulat terdekat dan menampilkan hasilnya di sel B1 . Perhatikan bahwa argumen kedua pada metode RoundDown [&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 Membulatkan Nilai di VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membulatkan nilai 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\/vba-dibulatkan-ke-bawah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membulatkan Nilai di VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membulatkan nilai di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T20:38:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rd1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/\",\"name\":\"Cara Membulatkan Nilai di VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T20:38:10+00:00\",\"dateModified\":\"2023-07-11T20:38:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membulatkan nilai di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membulatkan nilai 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 Membulatkan Nilai di VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membulatkan nilai 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\/vba-dibulatkan-ke-bawah\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membulatkan Nilai di VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membulatkan nilai di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/","og_site_name":"Statorials","article_published_time":"2023-07-11T20:38:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rd1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/","url":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/","name":"Cara Membulatkan Nilai di VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T20:38:10+00:00","dateModified":"2023-07-11T20:38:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membulatkan nilai di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-dibulatkan-ke-bawah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membulatkan nilai 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\/4343"}],"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=4343"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4343\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}