{"id":2738,"date":"2023-07-20T22:47:24","date_gmt":"2023-07-20T22:47:24","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/"},"modified":"2023-07-20T22:47:24","modified_gmt":"2023-07-20T22:47:24","slug":"excel-kalikan-kolom-dengan-persentase","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/","title":{"rendered":"Excel: cara mengalikan kolom dengan persentase"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk mengalikan kolom dengan persentase di Excel:<\/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;\">CELL<\/span> <span style=\"color: #000000;\">*(PERCENT\/100)<\/span><\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk mengalikan nilai di sel A1 dengan 50%:<\/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;\">*(50\/100)<\/span><\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengklik dan menyeret rumus ini ke bawah kolom A untuk mengalikan setiap nilai di kolom A dengan 50%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Kalikan kolom dengan persentase di Excel<\/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=\"492\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mengalikan nilai di sel A2 dengan 50%:<\/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;\">*(50\/100)<\/span><\/span><\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24110 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel5.jpg\" alt=\"\" width=\"497\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita bisa mengarahkan kursor ke pojok kanan bawah sel B2 hingga muncul tanda \u201c <strong>+<\/strong> \u201d kecil. Kemudian klik dan seret ke bawah ke semua sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24111 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel6.jpg\" alt=\"\" width=\"481\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semua nilai pada kolom B sama dengan nilai terkait pada kolom A dikalikan 50%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">10*50% = <strong>5,0<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">15*5 0% = <strong>7,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">18*50% = <strong>9<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">20*50% = <strong>10<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">25*50% = <strong>12,5<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengalikan dengan persentase lain, cukup ubah nilai yang digunakan di sel B2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya untuk mengalikan dengan 90%, cukup gunakan rumus berikut:<\/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;\">*(90\/100)<\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kemudian klik dan seret rumus ini ke semua sel yang tersisa di kolom B.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24112 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel7.jpg\" alt=\"\" width=\"514\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di kolom B sekarang akan sama dengan nilai terkait di kolom A dikalikan 90%.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">10*90% = <strong>9<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">15*90% = <strong>13,5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">18*90% = <strong>16,2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">20*90% = <strong>18<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">25*90% = <strong>22,5<\/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-kalikan-kolom-dengan-konstanta\/\" target=\"_blank\" rel=\"noopener\">Cara mengalikan kolom dengan konstanta di Excel<\/a><br \/> <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 \/> <a href=\"https:\/\/statorials.org\/id\/excel-menemukan-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai unik dari beberapa kolom di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/urutkan-berdasarkan-beberapa-kolom-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan berdasarkan beberapa kolom di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus dasar berikut untuk mengalikan kolom dengan persentase di Excel: = CELL *(PERCENT\/100) Misalnya, Anda bisa menggunakan rumus berikut untuk mengalikan nilai di sel A1 dengan 50%: = A1 *(50\/100) Anda kemudian dapat mengklik dan menyeret rumus ini ke bawah kolom A untuk mengalikan setiap nilai di kolom A dengan 50%. 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>Excel: Cara mengalikan kolom dengan persentase - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, 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-kalikan-kolom-dengan-persentase\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara mengalikan kolom dengan persentase - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:47:24+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-kalikan-kolom-dengan-persentase\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\",\"name\":\"Excel: Cara mengalikan kolom dengan persentase - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:47:24+00:00\",\"dateModified\":\"2023-07-20T22:47:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengalikan kolom dengan persentase\"}]},{\"@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":"Excel: Cara mengalikan kolom dengan persentase - Statologi","description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, 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-kalikan-kolom-dengan-persentase\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengalikan kolom dengan persentase - Statologi","og_description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:47:24+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-kalikan-kolom-dengan-persentase\/","url":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/","name":"Excel: Cara mengalikan kolom dengan persentase - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:47:24+00:00","dateModified":"2023-07-20T22:47:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan persentase tertentu, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-persentase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengalikan kolom dengan persentase"}]},{"@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\/2738"}],"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=2738"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2738\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}