{"id":4127,"date":"2023-07-13T10:12:40","date_gmt":"2023-07-13T10:12:40","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/"},"modified":"2023-07-13T10:12:40","modified_gmt":"2023-07-13T10:12:40","slug":"google-sheet-memeriksa-apakah-beberapa-sel-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/","title":{"rendered":"Google spreadsheet: cara memeriksa apakah beberapa sel sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk memeriksa apakah nilai di beberapa sel sama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=AND(ARRAYFORMULA( <span dir=\"auto\" style=\"color: #ff6600;\">B2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> { <span dir=\"auto\" style=\"color: #800080;\">C2<\/span> , <span dir=\"auto\" style=\"color: #008080;\">D2<\/span> , <span dir=\"auto\" style=\"color: #ff0000;\">E2<\/span> }))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Rumus khusus ini memeriksa apakah nilai di sel <strong>B2<\/strong> , <strong>C2<\/strong> , <strong>D2<\/strong> , dan <strong>E2<\/strong> semuanya sama.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika semuanya sama, rumus akan mengembalikan <strong>TRUE<\/strong> . Jika tidak, ia akan mengembalikan <strong>FALSE<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Periksa apakah beberapa sel sama di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet yang menunjukkan jumlah poin yang dicetak oleh pemain bola basket berbeda dalam empat pertandingan berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32820 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ae1.png\" alt=\"\" width=\"590\" height=\"495\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut ke dalam sel <strong>F2<\/strong> untuk memeriksa apakah nilai poin di setiap permainan pemain A semuanya sama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=AND(ARRAYFORMULA( <span dir=\"auto\" style=\"color: #ff6600;\">B2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> { <span dir=\"auto\" style=\"color: #800080;\">C2<\/span> , <span dir=\"auto\" style=\"color: #008080;\">D2<\/span> , <span dir=\"auto\" style=\"color: #ff0000;\">E2<\/span> }))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32821\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ae2.png\" alt=\"Google Spreadsheet memeriksa apakah beberapa sel sama\" width=\"678\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan <strong>TRUE<\/strong> jika nilai keempat himpunan sama dan <strong>FALSE<\/strong> sebaliknya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Pemain A mencetak 10 poin dalam keempat permainan, sehingga rumusnya kembali <strong>BENAR<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Pemain B tidak mencetak jumlah poin yang sama di keempat pertandingan, sehingga rumusnya kembali <strong>FALSE<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengembalikan nilai selain <strong>TRUE<\/strong> dan <strong>FALSE<\/strong> , Anda bisa menggabungkan rumus dalam fungsi <strong>IF<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan rumus berikut untuk mengembalikan nilai <strong>Sama<\/strong> dan <strong>Tidak Sama<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=IF(AND(ARRAYFORMULA( <span dir=\"auto\" style=\"color: #ff6600;\">B2<\/span> <span class=\"  default-formula-text-color\" dir=\"auto\">=<\/span> { <span dir=\"auto\" style=\"color: #800080;\">C2<\/span> , <span dir=\"auto\" style=\"color: #008080;\">D2<\/span> , <span dir=\"auto\" style=\"color: #ff0000;\">E2<\/span> })), \u201c <span style=\"color: #008000;\">Equal<\/span> \u201d, \u201c <span style=\"color: #008000;\">Not Equal<\/span> \u201d)<\/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=\" wp-image-32822 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ae3.png\" alt=\"\" width=\"650\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya sekarang mengembalikan <strong>Equal<\/strong> jika nilai keempat himpunan sama dan <strong>Not Equal<\/strong> sebaliknya.<\/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\/periksa-apakah-selnya-kosong-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara memeriksa apakah sel kosong di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara memeriksa apakah nilainya dalam jangkauan di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kotak-centang-pemformatan-bersyarat-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan pemformatan bersyarat berbasis kotak centang di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk memeriksa apakah nilai di beberapa sel sama: =AND(ARRAYFORMULA( B2 = { C2 , D2 , E2 })) Rumus khusus ini memeriksa apakah nilai di sel B2 , C2 , D2 , dan E2 semuanya sama. Jika semuanya sama, rumus akan mengembalikan TRUE . Jika tidak, ia [&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 memeriksa apakah beberapa sel sama \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, 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\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara memeriksa apakah beberapa sel sama \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T10:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ae1.png\" \/>\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-memeriksa-apakah-beberapa-sel-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/\",\"name\":\"Google Spreadsheet: Cara memeriksa apakah beberapa sel sama \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T10:12:40+00:00\",\"dateModified\":\"2023-07-13T10:12:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memeriksa apakah beberapa sel sama\"}]},{\"@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 memeriksa apakah beberapa sel sama \u2013 Statorial","description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, 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\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memeriksa apakah beberapa sel sama \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-13T10:12:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ae1.png"}],"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-memeriksa-apakah-beberapa-sel-sama\/","url":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/","name":"Google Spreadsheet: Cara memeriksa apakah beberapa sel sama \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T10:12:40+00:00","dateModified":"2023-07-13T10:12:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah beberapa sel sama di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-memeriksa-apakah-beberapa-sel-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memeriksa apakah beberapa sel sama"}]},{"@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\/4127"}],"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=4127"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4127\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}