{"id":4904,"date":"2023-07-06T14:45:34","date_gmt":"2023-07-06T14:45:34","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/"},"modified":"2023-07-06T14:45:34","modified_gmt":"2023-07-06T14:45:34","slug":"excel-mengubah-pecahan-menjadi-desimal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/","title":{"rendered":"Cara mengubah pecahan ke desimal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk mengubah pecahan menjadi desimal di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISERROR(SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )),LEFT(A2,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )-1)\/MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )+1.99),LEFT( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )-1)+MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )+1,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )-1-SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> ))\/MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )+1.99))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan mengubah pecahan di sel <strong>A2<\/strong> menjadi desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika sel <strong>A2<\/strong> berisi <strong>1\/5<\/strong> , rumus ini akan mengembalikan <strong>0.2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perlu diperhatikan bahwa rumus ini dapat digunakan untuk semua jenis pecahan, termasuk pecahan biasa, pecahan biasa, dan bilangan campuran.<\/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: Konversi Pecahan ke Desimal di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar pecahan berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fdec1.png\" alt=\"\" width=\"439\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menampilkan setiap pecahan di kolom A sebagai desimal di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(ISERROR(SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )),LEFT(A2,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )-1)\/MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )+1.99),LEFT( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )-1)+MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> )+1,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )-1-SEARCH(\" \", <span style=\"color: #3366ff;\">A2<\/span> ))\/MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )+1.99))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38297\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fdec2.png\" alt=\"Excel mengubah desimal menjadi pecahan\" width=\"545\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang menampilkan setiap pecahan di kolom A dalam bentuk desimal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>1\/5<\/strong> dalam bentuk desimal adalah <strong>0,2.<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3 4\/5<\/strong> dalam desimal adalah <strong>3,8.<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>5 11\/12<\/strong> dalam desimal adalah <strong>5.916667<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>7\/2<\/strong> dalam bentuk desimal adalah <strong>3,5<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda hanya memiliki pecahan biasa (yaitu yang pembilangnya lebih kecil dari penyebutnya), maka Anda dapat menggunakan rumus berikut yang jauh lebih sederhana:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LEFT( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )-1)\/MID( <span style=\"color: #3366ff;\">A2<\/span> ,SEARCH(\"\/\", <span style=\"color: #3366ff;\">A2<\/span> )+1.99)<\/strong><\/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=\"aligncenter wp-image-38298\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fdec3.png\" alt=\"Excel mengonversi pecahan yang sesuai menjadi desimal\" width=\"607\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan setiap pecahan yang tepat di kolom A dalam bentuk desimal.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-mengubah-waktu-menjadi-menit\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengubah durasi menjadi menit<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\" target=\"_blank\" rel=\"noopener\">Excel: cara mengubah persentase menjadi rasio<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/stempel-waktu-excel-terkini\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengonversi stempel waktu UNIX menjadi tanggal<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk mengubah pecahan menjadi desimal di Excel: =IF(ISERROR(SEARCH(&#8221; &#8220;, A2 )),LEFT(A2,SEARCH(&#8220;\/&#8221;, A2 )-1)\/MID( A2 ,SEARCH(&#8220;\/&#8221;, A2 )+1.99),LEFT( A2 ,SEARCH(&#8221; &#8220;, A2 )-1)+MID( A2 ,SEARCH(&#8221; &#8220;, A2 )+1,SEARCH(&#8220;\/&#8221;, A2 )-1-SEARCH(&#8221; &#8220;, A2 ))\/MID( A2 ,SEARCH(&#8220;\/&#8221;, A2 )+1.99)) Rumus khusus ini akan mengubah pecahan di sel A2 menjadi desimal. Misalnya, jika sel [&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 Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, 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\/excel-mengubah-pecahan-menjadi-desimal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T14:45:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fdec1.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-mengubah-pecahan-menjadi-desimal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/\",\"name\":\"Cara Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T14:45:34+00:00\",\"dateModified\":\"2023-07-06T14:45:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah pecahan ke desimal di excel\"}]},{\"@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 Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi","description":"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, 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\/excel-mengubah-pecahan-menjadi-desimal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/","og_site_name":"Statorials","article_published_time":"2023-07-06T14:45:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fdec1.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-mengubah-pecahan-menjadi-desimal\/","url":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/","name":"Cara Mengubah Pecahan Menjadi Nilai Desimal di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T14:45:34+00:00","dateModified":"2023-07-06T14:45:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah pecahan menjadi desimal di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengubah-pecahan-menjadi-desimal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah pecahan ke desimal di excel"}]},{"@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\/4904"}],"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=4904"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4904\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}