{"id":3824,"date":"2023-07-15T08:16:33","date_gmt":"2023-07-15T08:16:33","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/"},"modified":"2023-07-15T08:16:33","modified_gmt":"2023-07-15T08:16:33","slug":"persentase-penuh-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/","title":{"rendered":"Cara menghitung persentase lengkap di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung persentase penyelesaian suatu proyek di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan dua contoh penghitungan persentase penyelesaian dalam skenario berbeda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung Persentase Selesai Berdasarkan Sel yang Hilang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar tugas dengan statusnya di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30963 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp1.jpg\" alt=\"\" width=\"490\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase tugas yang telah kita selesaikan, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTA( <span style=\"color: #3366ff;\">B2:B11<\/span> )\/COUNTA( <span style=\"color: #ff0000;\">A2:A11<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita akan mengetikkan rumus ini di sel <strong>D2<\/strong> lalu tekan <strong>Enter<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30964 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp2.jpg\" alt=\"\" width=\"564\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat bahwa <strong>0,3<\/strong> atau <strong>30%<\/strong> tugas telah selesai.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Untuk memformat angka sebagai persentase, klik menu drop-down <strong>Format Number<\/strong> pada tab <strong>Beranda<\/strong> Excel dan pilih <strong>Persentase<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30965 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp3.jpg\" alt=\"\" width=\"416\" height=\"575\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Angka tersebut secara otomatis akan diformat sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30966\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp4.jpg\" alt=\"persentase selesai di Excel\" width=\"539\" height=\"499\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>COUNTA<\/strong> menghitung jumlah sel dalam rentang yang tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi pada rumus ini, kita cukup menghitung jumlah sel yang tidak kosong pada kolom <strong>Status<\/strong> dan membaginya dengan jumlah sel yang tidak kosong pada kolom <strong>Tugas<\/strong> untuk mendapatkan persentase penyelesaian.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Menghitung Persentase Kelengkapan Berdasarkan Teks dalam Sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar tugas dengan statusnya di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30967 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp5.jpg\" alt=\"\" width=\"485\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung persentase tugas yang berstatus \u201cSelesai\u201d, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">B2:B11<\/span> , \"Done\")\/COUNTA( <span style=\"color: #ff0000;\">A2:A11<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita akan mengetikkan rumus ini di sel <strong>D2<\/strong> lalu tekan <strong>Enter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30968 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp6.jpg\" alt=\"\" width=\"558\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasil tersebut terlihat <strong>40%<\/strong> dari total tugas telah selesai.<\/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\/carilah-persentase-dua-angka-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara mencari persentase dua angka di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Tertimbang di Excel<\/a><br \/> Cara Menghitung Persentase Kumulatif di Excel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung persentase penyelesaian suatu proyek di Excel. Tutorial ini memberikan dua contoh penghitungan persentase penyelesaian dalam skenario berbeda. Contoh 1: Hitung Persentase Selesai Berdasarkan Sel yang Hilang Misalkan kita memiliki daftar tugas dengan statusnya di Excel: Untuk menghitung persentase tugas yang telah kita selesaikan, kita dapat menggunakan rumus berikut: =COUNTA( B2:B11 [&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 Menghitung Persentase Lengkap di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek 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\/persentase-penuh-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Persentase Lengkap di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-penuh-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T08:16:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp1.jpg\" \/>\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\/persentase-penuh-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-penuh-excel\/\",\"name\":\"Cara Menghitung Persentase Lengkap di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T08:16:33+00:00\",\"dateModified\":\"2023-07-15T08:16:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-penuh-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-penuh-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-penuh-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung persentase lengkap 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 Menghitung Persentase Lengkap di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek 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\/persentase-penuh-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Persentase Lengkap di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-15T08:16:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comp1.jpg"}],"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\/persentase-penuh-excel\/","url":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/","name":"Cara Menghitung Persentase Lengkap di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T08:16:33+00:00","dateModified":"2023-07-15T08:16:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung persentase penyelesaian proyek di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-penuh-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-penuh-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung persentase lengkap 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\/3824"}],"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=3824"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3824\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}