{"id":3761,"date":"2023-07-15T17:13:09","date_gmt":"2023-07-15T17:13:09","guid":{"rendered":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/"},"modified":"2023-07-15T17:13:09","modified_gmt":"2023-07-15T17:13:09","slug":"bilah-kotak-centang-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/","title":{"rendered":"Google sheets: tambahkan coretan ketika kotak dicentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fitur <strong>rumus khusus<\/strong> di Google Spreadsheet untuk menambahkan coretan ke sel tertentu saat kotak centang dicentang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Pemformatan bersyarat berdasarkan kotak centang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki daftar nama tim bola basket berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30636 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher11.jpg\" alt=\"\" width=\"522\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang anggaplah kita mengetahui bahwa tim-tim berikut telah tersingkir dari babak playoff:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Mav<\/span><\/li>\n<li> <span style=\"color: #000000;\">Prajurit<\/span><\/li>\n<li> <span style=\"color: #000000;\">Elang<\/span><\/li>\n<li> <span style=\"color: #000000;\">matahari<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat kotak centang yang, ketika dicentang, setiap tim yang tereliminasi akan diberi coretan pada nama timnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, pertama-tama kita perlu menyisipkan kotak centang dengan memilih sel <strong>C2<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Kotak Centang<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kotak centang berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30637 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher13.jpg\" alt=\"\" width=\"500\" height=\"468\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik sel <strong>A2<\/strong> , lalu klik tab <strong>Format<\/strong> , lalu klik <strong>Conditional Formatting<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30638 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher14.jpg\" alt=\"\" width=\"580\" height=\"532\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Aturan Format Bersyarat<\/strong> yang muncul di sisi kanan layar, ketikkan sel berikut di kotak yang disebut <strong>Terapkan ke Rentang<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">A2,A5,A7,A10<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Lalu klik daftar drop-down <strong>Format sel jika<\/strong> , pilih <strong>Rumus khusus adalah<\/strong> , lalu ketikkan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=C$2=TRUE\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Penting untuk menyertakan tanda sama dengan ( <strong>=<\/strong> ) di awal rumus, jika tidak, pemformatan bersyarat tidak akan berfungsi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian pada kotak <strong>Formatting Style<\/strong> , klik ikon dengan simbol coretan (di sebelah kanan simbol garis bawah).<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30640 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher15.jpg\" alt=\"\" width=\"336\" height=\"642\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik <strong>Selesai<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang, ketika Anda mencentang kotak di sel <strong>C2<\/strong> , coretan akan diterapkan ke setiap tim yang tersingkir dari babak playoff:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30639\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher16.jpg\" alt=\"Kotak centang Google Spreadsheet dicoret\" width=\"549\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Masing-masing tim yang tersingkir dari babak playoff kini memiliki nama yang dicoret dari nama timnya.<\/span><\/span><\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-google-sheet-jika-kotak-centang-dicentang\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menambahkan jika kotak dicentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memformat-bersyarat-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat dengan berbagai kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-pemformatan-bersyarat-jika-sel-lain-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: pemformatan bersyarat jika sel lain berisi teks<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fitur rumus khusus di Google Spreadsheet untuk menambahkan coretan ke sel tertentu saat kotak centang dicentang. Contoh berikut memperlihatkan cara menggunakan fungsi rumus kustom dalam praktiknya. Contoh: Pemformatan bersyarat berdasarkan kotak centang Katakanlah kita memiliki daftar nama tim bola basket berikut di Google Spreadsheet: Sekarang anggaplah kita mengetahui bahwa tim-tim berikut telah [&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: Tambahkan coretan saat kotak dicentang - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan 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\/bilah-kotak-centang-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Tambahkan coretan saat kotak dicentang - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T17:13:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher11.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\/bilah-kotak-centang-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/\",\"name\":\"Google Spreadsheet: Tambahkan coretan saat kotak dicentang - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T17:13:09+00:00\",\"dateModified\":\"2023-07-15T17:13:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: tambahkan coretan ketika kotak dicentang\"}]},{\"@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: Tambahkan coretan saat kotak dicentang - Statorial","description":"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan 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\/bilah-kotak-centang-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Tambahkan coretan saat kotak dicentang - Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-15T17:13:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/case-a-cocher11.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\/bilah-kotak-centang-google-sheets\/","url":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/","name":"Google Spreadsheet: Tambahkan coretan saat kotak dicentang - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T17:13:09+00:00","dateModified":"2023-07-15T17:13:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan coretan ke sel tertentu di Google Sheets ketika kotak centang dicentang, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bilah-kotak-centang-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: tambahkan coretan ketika kotak dicentang"}]},{"@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\/3761"}],"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=3761"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3761\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}