{"id":4768,"date":"2023-07-08T03:36:55","date_gmt":"2023-07-08T03:36:55","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/"},"modified":"2023-07-08T03:36:55","modified_gmt":"2023-07-08T03:36:55","slug":"excel-mengonversi-persentase-menjadi-rasio","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/","title":{"rendered":"Bagaimana mengkonversi persentase ke rasio di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Untuk mengonversi persentase menjadi rasio, Anda dapat mengikuti langkah-langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Hapus simbol persen<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Bagi nilainya dengan 100<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>3.<\/strong> Ubah pecahan menjadi pecahan tereduksi<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda ingin mengonversi <strong>22%<\/strong> menjadi suatu rasio.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, ubah 22% menjadi <strong>22<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ubah 22 menjadi <strong>22\/100<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, tulis pecahan tereduksi sebagai <strong>11\/50<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk mengonversi persentase menjadi rasio:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=SUBSTITUTE(TEXT( <span style=\"color: #3366ff;\">A2<\/span> ,\"?\/??\"),,\"\/\",\":\")\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus khusus ini mengubah persentase di sel <strong>A2<\/strong> menjadi rasio.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika sel <strong>A2<\/strong> berisi<\/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: Ubah Persentase menjadi Rasio di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kolom persentase berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37228 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pra1.png\" alt=\"\" width=\"464\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengubah setiap persentase menjadi rasio.<\/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><span class=\" default-formula-text-color\" dir=\"auto\">=SUBSTITUTE(TEXT( <span style=\"color: #3366ff;\">A2<\/span> ,\"?\/??\"),,\"\/\",\":\")<\/span><\/strong><\/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=\"aligncenter wp-image-37229\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pra2.png\" alt=\"Excel mengonversi persentase menjadi rasio\" width=\"518\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan setiap persentase di kolom A sebagai rasio.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><strong>22<\/strong> % sama dengan rasio <strong>11:50<\/strong> .<\/span><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>50<\/strong> % sama dengan perbandingan <strong>1:2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>100<\/strong> % sama dengan rasio <strong>1:1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>25<\/strong> % sama dengan perbandingan <strong>1:4<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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\/excel-menemukan-10-persen-teratas\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan 10% nilai teratas di kolom Excel<\/a><br \/> Cara Menghitung Persentase Kumulatif di Excel<br \/> <a href=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Untuk mengonversi persentase menjadi rasio, Anda dapat mengikuti langkah-langkah berikut: 1. Hapus simbol persen 2. Bagi nilainya dengan 100 3. Ubah pecahan menjadi pecahan tereduksi Misalnya, Anda ingin mengonversi 22% menjadi suatu rasio. Pertama, ubah 22% menjadi 22 . Selanjutnya, ubah 22 menjadi 22\/100 . Terakhir, tulis pecahan tereduksi sebagai 11\/50 . Anda bisa menggunakan [&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>Bagaimana mengkonversi persentase ke rasio di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.\" \/>\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-mengonversi-persentase-menjadi-rasio\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana mengkonversi persentase ke rasio di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T03:36:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pra1.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-mengonversi-persentase-menjadi-rasio\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\",\"name\":\"Bagaimana mengkonversi persentase ke rasio di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T03:36:55+00:00\",\"dateModified\":\"2023-07-08T03:36:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana mengkonversi persentase ke rasio 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":"Bagaimana mengkonversi persentase ke rasio di Excel - Statorials","description":"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.","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-mengonversi-persentase-menjadi-rasio\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana mengkonversi persentase ke rasio di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/","og_site_name":"Statorials","article_published_time":"2023-07-08T03:36:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pra1.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-mengonversi-persentase-menjadi-rasio\/","url":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/","name":"Bagaimana mengkonversi persentase ke rasio di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T03:36:55+00:00","dateModified":"2023-07-08T03:36:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah persentase menjadi rasio di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengonversi-persentase-menjadi-rasio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana mengkonversi persentase ke rasio 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\/4768"}],"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=4768"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4768\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}