{"id":1606,"date":"2023-11-15T12:57:17","date_gmt":"2023-11-15T12:57:17","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/"},"modified":"2023-12-06T06:14:11","modified_gmt":"2023-12-06T06:14:11","slug":"bulatkan-ke-5-terdekat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/","title":{"rendered":"Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1636239774\"><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>Pada tutorial rumus kali ini, kita akan mempelajari cara membulatkan suatu bilangan ke terdekat 5, 50, dan 0,5. Anda bisa menggunakan rumus ini di Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, dan Excel untuk Mac.<\/p><h2 class=\"wp-block-heading\"> Bulatkan ke 0,5, 5, dan 50 terdekat<\/h2><p> Untuk membulatkan ke 5 terdekat, Anda bisa menggunakan fungsi MROUND, di mana Anda bisa menentukan argumen untuk mendapatkan kelipatannya. Perhatikan rumus berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63656\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\" sizes=\"auto, \" srcset=\"\" alt=\"fungsi bulat\" width=\"420\" height=\"195\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MROUND(A2,5)<\/code><\/pre><p> Dalam rumus di atas, Anda menggunakan 5 sebagai kelipatan untuk membulatkan nilainya. Sekarang, jika Anda melihat nilai pertama di sel A2 yaitu 4 dan kelipatan 5 terdekat adalah 5. Dan, untuk nilai kedua, Anda memiliki 15 yang merupakan kelipatan terdekat dari 5.<\/p><p> Demikian pula dengan fungsi MROUND Anda dapat menggunakan 50. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63657\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-mround-fonction-avec-argument.png\" sizes=\"auto, \" srcset=\"\" alt=\"mround-fungsi-dengan-argumen\" width=\"415\" height=\"217\"><\/figure><\/div><p> Dan fungsi yang sama berlaku untuk 0,5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63658\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-mrond-fonction-rond-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"mround-fungsi-bulat-terdekat\" width=\"425\" height=\"207\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bulatkan ke 5 terdekat<\/h2><p> Untuk membulatkan angka menjadi 5, Anda harus menggunakan fungsi FLOOR. Fungsi ini memiliki argumen yang sama dengan yang Anda miliki di fungsi MROUND. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63659\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-arrondir-au-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulatkan ke lima terdekat\" width=\"431\" height=\"202\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=FLOOR(D8,5)<\/code><\/pre><p> Dan hal yang sama untuk 50. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63660\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-arrondir-a-la-cinquantaine-inferieure.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulatkan ke lima puluh terdekat\" width=\"436\" height=\"201\"><\/figure><\/div><p> Dan untuk 0,5 juga. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63661\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-arrondir-au-point-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulatkan ke angka lima terdekat\" width=\"442\" height=\"203\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Dibulatkan ke 5 terdekat<\/h2><p> Untuk membulatkan suatu bilangan ke 5 terdekat, Anda harus menggunakan fungsi CEILING. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-arrondir-au-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulatkan ke lima terdekat\" width=\"453\" height=\"200\"><\/figure><\/div><p> Jalan 50. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63663\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-arrondir-a-la-cinquantaine-la-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulatkan ke lima puluh terdekat\" width=\"458\" height=\"210\"><\/figure><\/div><p> Dan pada akhirnya, untuk 0,5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-arrondir-au-point-cinq-le-plus-proche.png\" sizes=\"auto, \" srcset=\"\" alt=\"dibulatkan ke koma lima terdekat\" width=\"455\" height=\"206\"><\/figure><\/div><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-cinq-superieur-le-plus-proche.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\/dibulatkan-ke-ribuan-terdekat\/\">Membulatkan angka ke 1000 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-1606","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>\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?<\/title>\n<meta name=\"description\" content=\"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya\" \/>\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\/bulatkan-ke-5-terdekat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?\" \/>\n<meta property=\"og:description\" content=\"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/\",\"name\":\"\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\",\"datePublished\":\"2023-11-15T12:57:17+00:00\",\"dateModified\":\"2023-12-06T06:14:11+00:00\",\"description\":\"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di excel?\"}]},{\"@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":"\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?","description":"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya","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\/bulatkan-ke-5-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?","og_description":"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya","og_url":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/","url":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/","name":"\u25b7 Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","datePublished":"2023-11-15T12:57:17+00:00","dateModified":"2023-12-06T06:14:11+00:00","description":"Untuk membulatkan ke 5 terdekat, Anda dapat menggunakan fungsi MROUND, yang di dalamnya Anda dapat menentukan argumennya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-ronde.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bulatkan-ke-5-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membulatkan ke 0,5, 5, dan 50 terdekat di excel?"}]},{"@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\/1606","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=1606"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1606\/revisions"}],"predecessor-version":[{"id":2336,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1606\/revisions\/2336"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}