{"id":4626,"date":"2023-07-09T12:36:35","date_gmt":"2023-07-09T12:36:35","guid":{"rendered":"https:\/\/statorials.org\/id\/unggul\/"},"modified":"2023-07-09T12:36:35","modified_gmt":"2023-07-09T12:36:35","slug":"unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/unggul\/","title":{"rendered":"Excel: cara menggunakan mround agar selalu membulat"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>MROUND<\/strong> di Excel untuk membulatkan nilai ke kelipatan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk membulatkan nilai di sel <strong>A2<\/strong> ke sepuluh terdekat:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=MROUND( <span style=\"color: #3366ff;\">A2<\/span> , 10)\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Jika nilai di sel <strong>A2<\/strong> adalah <strong>23<\/strong> , fungsi <strong>MROUND<\/strong> akan membulatkan nilainya menjadi <strong>20<\/strong> karena merupakan kelipatan terdekat dari 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Atau jika nilai di sel <strong>A2<\/strong> adalah <strong>28<\/strong> , <strong>MROUND<\/strong> akan membulatkan nilainya menjadi <strong>30<\/strong> karena merupakan kelipatan terdekat dari 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, misalkan Anda ingin menggunakan fungsi <strong>MROUND<\/strong> untuk selalu melakukan pembulatan ke sepuluh terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sayangnya hal ini tidak mungkin dilakukan dengan fungsi <strong>MROUND<\/strong> tetapi Anda dapat menggunakan fungsi <strong>CEILING<\/strong> untuk mencapai hal ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk membulatkan nilai di sel <strong>A2<\/strong> ke sepuluh terdekat:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=CEILING( <span style=\"color: #3366ff;\">A2,10<\/span> )<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Baik nilai di sel <strong>A2<\/strong> adalah <strong>23<\/strong> atau <strong>28<\/strong> , nilai tersebut akan dibulatkan menjadi <strong>30<\/strong> setiap kali.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi <strong>CEILING<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Pembulatan ke kelipatan terdekat di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36104 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mroundup1.png\" alt=\"\" width=\"431\" height=\"397\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin membulatkan setiap nilai dalam daftar <em>ke<\/em> sepuluh terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan perbedaan antara penggunaan fungsi <strong>MROUND<\/strong> dan <strong>CEILING<\/strong> di Excel untuk mencapai hal ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36101 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mroundup2.png\" alt=\"\" width=\"451\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan perbedaan antara kedua fungsi tersebut:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>(1)<\/strong> Fungsi <strong>MROUND<\/strong> membulatkan setiap nilai di kolom A ke kelipatan 10 terdekat. Terkadang hal ini memerlukan pembulatan nilai ke atas dan terkadang memerlukan pembulatan nilai ke bawah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, fungsi <strong>MROUND<\/strong> membulatkan <strong>23<\/strong> menjadi <strong>20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>(2)<\/strong> Fungsi <strong>CEILING<\/strong> selalu membulatkan setiap nilai pada kolom A <em>ke<\/em> kelipatan 10 terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, fungsi <strong>CEILING<\/strong> membulatkan <strong>23<\/strong> menjadi <strong>30<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <b>CEILING<\/b> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ceiling-function-0a5cd7c8-0720-4f0a-bd2c-c943e510899f#:~:text=Description,up%20to%20the%20nearest%20nickel.\" 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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/angka-penting-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan ke angka penting di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-nilai-pertama\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10 nilai teratas dalam daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi MROUND di Excel untuk membulatkan nilai ke kelipatan tertentu. Misalnya, Anda bisa menggunakan rumus berikut untuk membulatkan nilai di sel A2 ke sepuluh terdekat: =MROUND( A2 , 10) Jika nilai di sel A2 adalah 23 , fungsi MROUND akan membulatkan nilainya menjadi 20 karena merupakan kelipatan terdekat dari 10. Atau jika [&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>Excel: Cara menggunakan MROUND agar selalu membulat - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, 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\/unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan MROUND agar selalu membulat - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T12:36:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mroundup1.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\/unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/unggul\/\",\"name\":\"Excel: Cara menggunakan MROUND agar selalu membulat - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T12:36:35+00:00\",\"dateModified\":\"2023-07-09T12:36:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan mround agar selalu membulat\"}]},{\"@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":"Excel: Cara menggunakan MROUND agar selalu membulat - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, 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\/unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan MROUND agar selalu membulat - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-09T12:36:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mroundup1.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\/unggul\/","url":"https:\/\/statorials.org\/id\/unggul\/","name":"Excel: Cara menggunakan MROUND agar selalu membulat - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T12:36:35+00:00","dateModified":"2023-07-09T12:36:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi MROUND di Excel untuk selalu membulatkan nilai ke kelipatan tertentu, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan mround agar selalu membulat"}]},{"@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\/4626"}],"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=4626"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4626\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}