{"id":4625,"date":"2023-07-09T12:48:07","date_gmt":"2023-07-09T12:48:07","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/"},"modified":"2023-07-09T12:48:07","modified_gmt":"2023-07-09T12:48:07","slug":"excel-dibulatkan-ke-0-25-terdekat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/","title":{"rendered":"Cara membulatkan ke 0,25 terdekat di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membulatkan nilai ke 0,25 terdekat di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda mungkin ingin:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Putaran <strong>1,23<\/strong> hingga <strong>1,25<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Putaran <strong>2.12<\/strong> ke <strong>2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Putaran <strong>3,83<\/strong> hingga <strong>3,75<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=MROUND( <span style=\"color: #3366ff;\">A1<\/span> , 0.25)\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini membulatkan nilai di sel <strong>A1<\/strong> ke kelipatan terdekat <strong>0,25<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Bulatkan ke 0,25 terdekat di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Misalkan kita memiliki daftar nilai berikut di Excel:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36093 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mrond1.png\" alt=\"\" width=\"460\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin membulatkan setiap nilai dalam daftar ke <strong>0,25<\/strong> terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=MROUND( <span style=\"color: #3366ff;\">A2<\/span> , 0.25)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36094 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mrond2.png\" alt=\"\" width=\"483\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan setiap nilai di kolom A yang dibulatkan ke <strong>0,25<\/strong> terdekat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda menggunakan fungsi <strong>MROUND<\/strong> dengan bilangan negatif, perkalian yang Anda pembulatkan juga harus negatif agar rumus dapat berfungsi dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, Anda bisa menggunakan rumus berikut untuk mengalikan nilai fungsi <strong>MROUND<\/strong> dengan <strong>SIGN<\/strong> sel yang Anda bulatkan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=MROUND( <span style=\"color: #3366ff;\">A2<\/span> , SIGN( <span style=\"color: #3366ff;\">A2<\/span> )*0.25)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36095 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mrond3.png\" alt=\"\" width=\"490\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom B sekarang menampilkan setiap nilai di kolom A yang dibulatkan ke <strong>0,25<\/strong> terdekat dan tidak ada kesalahan yang dihasilkan karena kita menggunakan fungsi <strong>SIGN<\/strong> dalam rumus <strong>MROUND<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>MROUND<\/strong> di Excel <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/mround-function-c299c3b0-15a5-426d-aa4b-d2d5b3baf427\" 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>Seringkali Anda mungkin ingin membulatkan nilai ke 0,25 terdekat di Excel. Misalnya, Anda mungkin ingin: Putaran 1,23 hingga 1,25 . Putaran 2.12 ke 2 . Putaran 3,83 hingga 3,75 . Dan seterusnya. Anda dapat menggunakan rumus berikut untuk melakukan ini: =MROUND( A1 , 0.25) Rumus khusus ini membulatkan nilai di sel A1 ke kelipatan terdekat [&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 ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.\" \/>\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\/excel-dibulatkan-ke-0-25-terdekat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membulatkan ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T12:48:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mrond1.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\/excel-dibulatkan-ke-0-25-terdekat\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/\",\"name\":\"Cara Membulatkan ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T12:48:07+00:00\",\"dateModified\":\"2023-07-09T12:48:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membulatkan ke 0,25 terdekat di excel (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 ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.","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\/excel-dibulatkan-ke-0-25-terdekat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membulatkan ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/","og_site_name":"Statorials","article_published_time":"2023-07-09T12:48:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mrond1.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\/excel-dibulatkan-ke-0-25-terdekat\/","url":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/","name":"Cara Membulatkan ke 0,25 Terdekat di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T12:48:07+00:00","dateModified":"2023-07-09T12:48:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membulatkan ke 0,25 terdekat di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-dibulatkan-ke-0-25-terdekat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membulatkan ke 0,25 terdekat di excel (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\/4625"}],"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=4625"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4625\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}