{"id":2737,"date":"2023-07-20T22:51:48","date_gmt":"2023-07-20T22:51:48","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/"},"modified":"2023-07-20T22:51:48","modified_gmt":"2023-07-20T22:51:48","slug":"excel-kalikan-kolom-dengan-konstanta","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/","title":{"rendered":"Excel: cara mengalikan kolom dengan konstanta"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus dasar berikut untuk mengalikan kolom dengan konstanta 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;\">*CONSTANT<\/span><\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk mengalikan nilai sel A1 dengan 5:<\/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;\">*5<\/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 5.<\/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: mengalikan kolom dengan konstanta 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=\"486\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mengalikan nilai sel A2 dengan 5:<\/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;\">*5<\/span><\/span><\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24100 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel2.jpg\" alt=\"\" width=\"464\" height=\"427\" 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=\"aligncenter wp-image-24103\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel3.jpg\" alt=\"Excel mengalikan kolom dengan konstanta\" width=\"469\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semua nilai pada kolom B sama dengan 5 kali nilai pada kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">10*5 = <strong>50<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">15*5 = <strong>75<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">18*5 = <strong>90<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">20*5 = <strong>100<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">25*5 = <strong>125<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengalikan dengan konstanta lain, cukup ubah nilai yang digunakan di sel B2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya untuk mengalikan dengan 9 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;\">*9<\/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-24104 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multitexcel4.jpg\" alt=\"\" width=\"508\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai di kolom B sekarang akan sama dengan 9 kali nilai di kolom A:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">10*9 = <strong>90<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">15*9 = <strong>135<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">18*9 = <strong>162<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">20*9 = <strong>180<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">25*9 = <strong>225<\/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 \/> <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 konstanta di Excel: = CELL *CONSTANT Misalnya, Anda bisa menggunakan rumus berikut untuk mengalikan nilai sel A1 dengan 5: = A1 *5 Anda kemudian dapat mengklik dan menyeret rumus ini ke bawah kolom A untuk mengalikan setiap nilai di kolom A dengan 5. Contoh berikut [&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 konstanta - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, 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\/excel-kalikan-kolom-dengan-konstanta\/\" \/>\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 konstanta - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:51:48+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-konstanta\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/\",\"name\":\"Excel: Cara mengalikan kolom dengan konstanta - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:51:48+00:00\",\"dateModified\":\"2023-07-20T22:51:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara mengalikan kolom dengan konstanta\"}]},{\"@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 konstanta - Statologi","description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, 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\/excel-kalikan-kolom-dengan-konstanta\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara mengalikan kolom dengan konstanta - Statologi","og_description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:51:48+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-konstanta\/","url":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/","name":"Excel: Cara mengalikan kolom dengan konstanta - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:51:48+00:00","dateModified":"2023-07-20T22:51:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengalikan setiap nilai dalam kolom di Excel dengan konstanta, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-kalikan-kolom-dengan-konstanta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara mengalikan kolom dengan konstanta"}]},{"@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\/2737"}],"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=2737"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2737\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}