{"id":2739,"date":"2023-07-20T22:38:13","date_gmt":"2023-07-20T22:38:13","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/"},"modified":"2023-07-20T22:38:13","modified_gmt":"2023-07-20T22:38:13","slug":"excel-terapkan-persentase-peningkatan-penurunan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/","title":{"rendered":"Cara menerapkan persentase kenaikan atau penurunan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk menerapkan persentase kenaikan atau penurunan nilai di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Terapkan kenaikan persentase<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #3366ff;\">A1<\/span> <span style=\"color: #000000;\">*(1+ <span style=\"color: #ff0000;\">B1<\/span> )<\/span><\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Terapkan penurunan persentase<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">A1<\/span><\/span><\/span> <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\">*(1- <span style=\"color: #ff0000;\">B1<\/span> )<\/span><\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam kedua rumus, sel <strong>A1<\/strong> berisi nilai asli dan sel <strong>B1<\/strong> adalah persentase kita menambah atau mengurangi nilai asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Terapkan peningkatan persentase pada nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24099 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel1.jpg\" alt=\"\" width=\"486\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut di sel <strong>C2<\/strong> untuk menerapkan peningkatan 25% pada nilai di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">A2<\/span><\/span><\/span> <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\">*(1+ <span style=\"color: #ff0000;\">B2<\/span> )<\/span><\/span><\/span><\/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-24116\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentageexcel1.jpg\" alt=\"Excel meningkatkan nilainya sebesar persen\" width=\"503\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setiap nilai di kolom A telah ditingkatkan sebesar 25%.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>10<\/strong> meningkat sebesar 25% menjadi <strong>12,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>15<\/strong> meningkat sebesar 25% menjadi <strong>18,75<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>18<\/strong> meningkat sebesar 25% menjadi <strong>22,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>20<\/strong> meningkat sebesar 25% menjadi <strong>25<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Terapkan persentase penurunan nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita asumsikan lagi bahwa kita memiliki daftar nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24099 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel1.jpg\" alt=\"\" width=\"486\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut di sel <strong>C2<\/strong> untuk menerapkan penurunan 10% pada nilai di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">A2<\/span><\/span><\/span> <span dir=\"auto\" style=\"color: #ff6600;\"><span style=\"color: #000000;\">*(1- <span style=\"color: #ff0000;\">B2<\/span> )<\/span><\/span><\/span><\/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-24117\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pourcentageexcel2.jpg\" alt=\"Penurunan persentase Excel\" width=\"491\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di kolom A telah dikurangi sebesar 10%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>10<\/strong> berkurang 10% menjadi <strong>9<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>15<\/strong> berkurang 10% menjadi <strong>13,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>18<\/strong> berkurang 10% menjadi <strong>16,2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>20<\/strong> berkurang 10% menjadi <strong>18<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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>Anda bisa menggunakan rumus dasar berikut untuk menerapkan persentase kenaikan atau penurunan nilai di Excel: Metode 1: Terapkan kenaikan persentase = A1 *(1+ B1 ) Metode 2: Terapkan penurunan persentase = A1 *(1- B1 ) Dalam kedua rumus, sel A1 berisi nilai asli dan sel B1 adalah persentase kita menambah atau mengurangi nilai asli. Contoh [&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 menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa 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-terapkan-persentase-peningkatan-penurunan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:38:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel1.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\/excel-terapkan-persentase-peningkatan-penurunan\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/\",\"name\":\"Cara menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:38:13+00:00\",\"dateModified\":\"2023-07-20T22:38:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menerapkan persentase kenaikan atau penurunan 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 menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa 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-terapkan-persentase-peningkatan-penurunan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:38:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel1.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\/excel-terapkan-persentase-peningkatan-penurunan\/","url":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/","name":"Cara menerapkan persentase kenaikan atau penurunan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:38:13+00:00","dateModified":"2023-07-20T22:38:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menerapkan persentase kenaikan atau penurunan nilai di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-terapkan-persentase-peningkatan-penurunan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menerapkan persentase kenaikan atau penurunan 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\/2739"}],"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=2739"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2739\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}