{"id":3373,"date":"2023-07-17T20:13:58","date_gmt":"2023-07-17T20:13:58","guid":{"rendered":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/"},"modified":"2023-07-17T20:13:58","modified_gmt":"2023-07-17T20:13:58","slug":"carilah-persentase-dua-angka-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/","title":{"rendered":"Cara mencari persentase dua angka di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghitung persentase perubahan antara dua angka:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Persentase perubahan: (Nilai baru \u2013 Nilai lama) \/ Nilai lama<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di Excel, Anda bisa mengetikkan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">C2<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #ff0000;\">B2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mencari persentase perubahan antara nilai di sel <strong>B2<\/strong> dan <strong>C2<\/strong> yang mana nilai baru di sel <strong>C2<\/strong> dan nilai lama di sel <strong>B2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <strong>Contoh: Temukan persentase dua angka di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin yang dicetak dalam dua tahun berbeda oleh pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28309 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre1.jpg\" alt=\"\" width=\"495\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin menghitung persentase perubahan antara tahun 1 dan tahun 2 untuk setiap pemain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita bisa mengetikkan rumus berikut di sel D2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">C2<\/span> - <span style=\"color: #ff0000;\">B2<\/span> )\/ <span style=\"color: #ff0000;\">B2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>Enter<\/strong> , persentase perubahan untuk pemain pertama akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28310 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre2.jpg\" alt=\"\" width=\"446\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai <strong>0,25<\/strong> menunjukkan bahwa nilai poin meningkat sebesar <strong>25%<\/strong> untuk Andy antara tahun 1 dan tahun 2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenarannya secara manual dengan menghitung persentase perubahan secara manual:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase perubahan: (Nilai baru \u2013 Nilai lama) \/ Nilai lama<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase perubahan: (15 \u2013 12) \/ 12<\/span><\/li>\n<li> <span style=\"color: #000000;\">Persentase perubahan: 0,25<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28311 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre3.jpg\" alt=\"\" width=\"471\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai positif pada kolom <strong>% Perubahan<\/strong> menunjukkan bahwa nilai poin meningkat antara tahun pertama dan kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebaliknya, nilai negatif menunjukkan nilai poin menurun antara tahun pertama dan kedua.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat memformat nilai-nilai ini sebagai persentase dengan menyorot rentang sel <strong>D2:D11<\/strong> dan kemudian mengklik ikon <strong>%<\/strong> pada tab Beranda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28312 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre4.jpg\" alt=\"\" width=\"672\" height=\"110\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Masing-masing persentase kini akan ditampilkan sebagai persentase, bukan angka desimal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28313\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre5.jpg\" alt=\"temukan persentase antara dua angka di Excel\" width=\"498\" height=\"468\" srcset=\"\" sizes=\"\"><\/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\/persentase-tertimbang-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan persentase di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/peringkat-persentil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Peringkat Persentil di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghitung persentase perubahan antara dua angka: Persentase perubahan: (Nilai baru \u2013 Nilai lama) \/ Nilai lama Di Excel, Anda bisa mengetikkan rumus berikut: =( C2 &#8211; B2 )\/ B2 Rumus khusus ini mencari persentase perubahan antara nilai di sel B2 dan C2 yang mana nilai baru di sel C2 [&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 Mencari Persentase Dua Angka di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta 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\/carilah-persentase-dua-angka-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mencari Persentase Dua Angka di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T20:13:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre1.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\/carilah-persentase-dua-angka-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/\",\"name\":\"Cara Mencari Persentase Dua Angka di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T20:13:58+00:00\",\"dateModified\":\"2023-07-17T20:13:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mencari persentase dua angka 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 Mencari Persentase Dua Angka di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta 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\/carilah-persentase-dua-angka-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mencari Persentase Dua Angka di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-17T20:13:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentage-entre1.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\/carilah-persentase-dua-angka-unggul\/","url":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/","name":"Cara Mencari Persentase Dua Angka di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T20:13:58+00:00","dateModified":"2023-07-17T20:13:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari persentase antara dua angka di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/carilah-persentase-dua-angka-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mencari persentase dua angka 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\/3373"}],"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=3373"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3373\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}