{"id":1756,"date":"2023-11-06T23:37:18","date_gmt":"2023-11-06T23:37:18","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/"},"modified":"2023-12-06T06:14:13","modified_gmt":"2023-12-06T06:14:13","slug":"dibulatkan-ke-ribuan-terdekat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/","title":{"rendered":"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-818144240\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Jika Anda salah satu orang yang bekerja dengan data statistik atau menganalisis banyak data, rumus ini mungkin berguna bagi Anda dalam banyak hal. Disini kita akan belajar cara membulatkan suatu bilangan ke 1000, 100, dan 10 terdekat.<\/p><h2 class=\"wp-block-heading\"> Bulatkan suatu bilangan ke ribuan terdekat<\/h2><p> Di Excel, ada fungsi bernama ROUND yang bisa Anda gunakan untuk membulatkan suatu angka ke ribuan terdekat. Disini saya mempunyai angka &#8220;123456789&#8221;, dan saya ingin membulatkan angka tersebut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67143\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel-dengan-nilai numerik\" width=\"457\" height=\"175\"><\/figure><\/div><p> Anda dapat menggunakan langkah-langkah berikut.<\/p><ol type=\"1\"><li> Pertama, <a href=\"https:\/\/exceladvisor.org\/id\/mengedit-sel\/\">edit sel<\/a> B1 dan mulailah mengetik fungsi ROUND \u201c=ROUND(\u201c.<\/li><li> Sekarang rujuk ke sel A1 di mana kita memiliki angka yang ingin Anda bulatkan.<\/li><li> Lalu, di argumen kedua, masukkan -3.<\/li><li> Terakhir, masukkan tanda kurung tutup dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67144\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-fonction-darrondi-au-1000-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi pembulatan ke 1000 terdekat\" width=\"522\" height=\"209\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUND(A1,-3)<\/code><\/pre><p> Saat Anda menekan enter, ia mengembalikan 123457000 yang kemudian dibulatkan ke versi 1000 dari 123456789. Karena Anda memiliki empat digit terakhir 6789, maka ia telah dibulatkan menjadi 7000. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Resultat-de-la-fonction-3-tours.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil dari fungsi putaran\" width=\"544\" height=\"178\"><\/figure><\/div><p> Namun jika Anda mengubah angka ini menjadi 123456489 di mana Anda memiliki 6489 di akhir, fungsi yang sama akan membulatkannya menjadi 123456000. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67146\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-types-de-resultats-de-fonction-ronde.png\" sizes=\"auto, \" srcset=\"\" alt=\"tipe hasil-fungsi bulat\" width=\"534\" height=\"192\"><\/figure><\/div><p> Fungsi ROUND cukup pintar untuk mengidentifikasi ke sisi mana angka tersebut harus dibulatkan. Namun ada kalanya Anda perlu MEMULAI ke bawah atau ke atas ke ribuan terdekat.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUNDDOWN(123456789,-3) = 123456000 =ROUNDUP(123456489,-3) = 123457000<\/code><\/pre><h2 class=\"wp-block-heading\"> Cara lain untuk membulatkan suatu bilangan ke ribuan terdekat<\/h2><p> Ada beberapa cara untuk menggunakannya:<\/p><ul><li> <strong>Fungsi LANTAI<\/strong> : LANTAI(123456789,1000) = 123457000<ul><li> Dalam fungsi ini, Anda harus menggunakan angka positif 1000 untuk membulatkan angka positif dan angka negatif -1000 untuk membulatkan angka negatif.<\/li><\/ul><\/li><li> <strong>Fungsi Plafon<\/strong> : Plafon (C1,1000) = 123457000<ul><li> Dalam fungsi ini, Anda harus menggunakan angka positif 1000 untuk membulatkan angka positif dan angka negatif -1000 untuk membulatkan angka negatif.<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> MEMBULATKAN suatu bilangan ke 100 terdekat<\/h2><p> Demikian pula, Anda dapat menggunakan fungsi ROUND untuk membulatkan suatu bilangan ke ratusan terdekat. Untuk melakukan ini, cukup gunakan -2 dalam argumen num_digit. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUND(A1,-2)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67147\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-arrondir-un-nombre-au-100-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"angka-dibulatkan-ke-100-terdekat\" width=\"466\" height=\"201\"><\/figure><\/div><h2 class=\"wp-block-heading\"> MEMBULATKAN suatu bilangan ke 10 terdekat<\/h2><p> Dan jika ingin membulatkan suatu bilangan ke sepuluh terdekat, gunakan fungsi ROUND dengan cara berikut ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67148\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-arrondir-un-nombre-au-10-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"membulatkan suatu bilangan ke 10 terdekat\" width=\"483\" height=\"189\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUND(A1,-1)<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/arrondir-au-millier-le-plus-proche-100-10.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/\">Bulatkan ke 0,5, 5,50 (Down-Up) terdekat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/persentase-bulat-2\/\">Persentase nilai bulat<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1756","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/\",\"name\":\"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png\",\"datePublished\":\"2023-11-06T23:37:18+00:00\",\"dateModified\":\"2023-12-06T06:14:13+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.","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:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/","url":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/","name":"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png","datePublished":"2023-11-06T23:37:18+00:00","dateModified":"2023-12-06T06:14:13+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara membulatkan angka ke 1000, 100, dan 10 terdekat di Excel menggunakan metode yang berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-cellule-avec-valeur-numerique.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/dibulatkan-ke-ribuan-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membulatkan suatu bilangan ke 100 dan 10 terdekat?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1756"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1756\/revisions"}],"predecessor-version":[{"id":2338,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1756\/revisions\/2338"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}