{"id":2686,"date":"2023-07-21T04:32:53","date_gmt":"2023-07-21T04:32:53","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/"},"modified":"2023-07-21T04:32:53","modified_gmt":"2023-07-21T04:32:53","slug":"google-sheet-kalikan-kolom-dengan-konstanta","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/","title":{"rendered":"Google spreadsheet: cara mengalikan kolom dengan konstanta"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus dasar berikut untuk mengalikan kolom dengan konstanta di Google Spreadsheet:<\/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;\">CELL <span style=\"color: #000000;\">* <span style=\"color: #3366ff;\">CONSTANT<\/span><\/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;\">A1 <span style=\"color: #000000;\">* <span style=\"color: #3366ff;\">5<\/span><\/span><\/span> \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengklik dan menyeret rumus ini ke bawah 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 Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar nilai berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23641 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipourcent1.jpg\" alt=\"\" width=\"523\" height=\"408\" 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;\">A2 <span style=\"color: #000000;\">* <span style=\"color: #3366ff;\">5<\/span><\/span><\/span><\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23648 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiconstant1.jpg\" alt=\"\" width=\"505\" height=\"398\" 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-23649 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multiconstant2.jpg\" alt=\"\" width=\"501\" height=\"390\" 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;\">A2 <span style=\"color: #000000;\">* <span style=\"color: #3366ff;\">9<\/span><\/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<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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-persentase\/\">Cara mengalikan kolom dengan persentase di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-perubahan-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung persen perubahan di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentase-kumulatif-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Kumulatif di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus dasar berikut untuk mengalikan kolom dengan konstanta di Google Spreadsheet: = 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 untuk mengalikan setiap nilai di kolom A dengan 5. 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>Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, 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\/google-sheet-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=\"Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T04:32:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipourcent1.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\/google-sheet-kalikan-kolom-dengan-konstanta\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\",\"name\":\"Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T04:32:53+00:00\",\"dateModified\":\"2023-07-21T04:32:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: 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":"Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial","description":"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, 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\/google-sheet-kalikan-kolom-dengan-konstanta\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial","og_description":"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/","og_site_name":"Statorials","article_published_time":"2023-07-21T04:32:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multipourcent1.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\/google-sheet-kalikan-kolom-dengan-konstanta\/","url":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/","name":"Google Spreadsheet: Cara mengalikan kolom dengan konstanta - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T04:32:53+00:00","dateModified":"2023-07-21T04:32:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengalikan kolom dengan konstanta di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: 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\/2686"}],"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=2686"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2686\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}