{"id":2838,"date":"2023-07-20T11:39:15","date_gmt":"2023-07-20T11:39:15","guid":{"rendered":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/"},"modified":"2023-07-20T11:39:15","modified_gmt":"2023-07-20T11:39:15","slug":"pernyataan-kasus-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/","title":{"rendered":"Cara menulis pernyataan kasus di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Pernyataan kasus<\/strong> adalah jenis pernyataan yang menelusuri kondisi dan mengembalikan nilai ketika kondisi pertama terpenuhi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara termudah untuk mengimplementasikan pernyataan kasus di Google Sheets adalah dengan menggunakan fungsi <strong>SWITCH()<\/strong> , yang menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SWITCH( <span style=\"color: #ff6600;\">A2<\/span> , \"G\", \"Guard\", \"F\", \"Forward\", \"C\", \"Center\", \"None\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Fungsi khusus ini melihat sel A2 dan mengembalikan nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201c <strong>Simpan<\/strong> \u201d jika sel A2 berisi \u201cG\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Teruskan<\/strong> \u201d jika sel A2 berisi \u201cF\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Tengah<\/strong> \u201d jika sel A2 berisi \u201cC\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Tidak Ada<\/strong> \u201d jika sel A2 tidak berisi nilai sebelumnya<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya di Google Spreadsheet.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Pernyataan Kasus di Google Sheets<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar posisi bola basket berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24857 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiches-de-cas1.jpg\" alt=\"\" width=\"467\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita akan menggunakan fungsi <strong>SWITCH()<\/strong> berikut untuk mengembalikan nama posisi tertentu di kolom B berdasarkan nilai di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SWITCH( <span style=\"color: #ff6600;\">A2<\/span> , \"G\", \"Guard\", \"F\", \"Forward\", \"C\", \"Center\", \"None\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyalin dan menempelkannya ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24858 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiches-de-cas2.jpg\" alt=\"\" width=\"630\" height=\"496\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini mengembalikan nilai berikut di kolom B:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201c <strong>Simpan<\/strong> \u201d jika kolom A berisi \u201cG\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Teruskan<\/strong> \u201d jika kolom A berisi \u201cF\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Tengah<\/strong> \u201d jika kolom A berisi \u201cC\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201c <strong>Tidak Ada<\/strong> \u201d jika kolom A tidak berisi nilai sebelumnya<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai terakhir di kolom B mengembalikan &#8221; <strong>Tidak Ada<\/strong> &#8221; karena kami tidak menentukan nilai spesifik yang akan dikembalikan untuk &#8220;Z&#8221; dalam rumus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan rumus berikut untuk mengembalikan nilai asli kolom A jika tidak berisi nilai apa pun yang ditentukan dalam rumus <strong>SWITCH<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SWITCH( <span style=\"color: #ff6600;\">A2<\/span> , \"G\", \"Guard\", \"F\", \"Forward\", \"C\", \"Center\", <span style=\"color: #ff6600;\">A2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>B2<\/strong> , lalu menyalin dan menempelkannya ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24859 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiches-de-cas3.jpg\" alt=\"\" width=\"586\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai terakhir di kolom B hanya mengembalikan nilai <strong>Z<\/strong> karena nilai terakhir di kolom A tidak berisi nilai apa pun yang ditentukan dalam rumus <strong>SWITCH<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>SWITCH<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/7013690?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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-jika-berisi\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/iserror-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan ISERROR di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pernyataan kasus adalah jenis pernyataan yang menelusuri kondisi dan mengembalikan nilai ketika kondisi pertama terpenuhi. Cara termudah untuk mengimplementasikan pernyataan kasus di Google Sheets adalah dengan menggunakan fungsi SWITCH() , yang menggunakan sintaks dasar berikut: =SWITCH( A2 , &#8220;G&#8221;, &#8220;Guard&#8221;, &#8220;F&#8221;, &#8220;Forward&#8221;, &#8220;C&#8221;, &#8220;Center&#8221;, &#8220;None&#8221;) Fungsi khusus ini melihat sel A2 dan mengembalikan nilai 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>Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, 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\/pernyataan-kasus-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T11:39:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiches-de-cas1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/\",\"name\":\"Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T11:39:15+00:00\",\"dateModified\":\"2023-07-20T11:39:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menulis pernyataan kasus di google spreadsheet\"}]},{\"@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":"Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, 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\/pernyataan-kasus-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T11:39:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fiches-de-cas1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/","url":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/","name":"Cara Menulis Pernyataan Kasus di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T11:39:15+00:00","dateModified":"2023-07-20T11:39:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi SWITCH untuk menulis pernyataan kasus di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pernyataan-kasus-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menulis pernyataan kasus di google spreadsheet"}]},{"@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\/2838"}],"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=2838"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2838\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}