{"id":2741,"date":"2023-07-20T22:27:44","date_gmt":"2023-07-20T22:27:44","guid":{"rendered":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/"},"modified":"2023-07-20T22:27:44","modified_gmt":"2023-07-20T22:27:44","slug":"pernyataan-kasus-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/","title":{"rendered":"Cara menulis pernyataan kasus di excel (dengan contoh)"},"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 Excel 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: #3366ff;\">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.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh: Pernyataan kasus di Excel<\/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-24129 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/declaration-de-cas1.jpg\" alt=\"\" width=\"479\" height=\"456\" 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: #3366ff;\">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=\"aligncenter wp-image-24130\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/declaration-de-cas2.jpg\" alt=\"pernyataan kasus di Excel\" width=\"671\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa 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<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-nilai-unik-di-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menemukan nilai unik dari beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-cocokkan-dua-kolom-kembalikan-ketiga\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Mencocokkan Dua Kolom dan Mengembalikan Kolom Ketiga<\/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 Excel 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: \u201c [&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 Excel (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), 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\/pernyataan-kasus-di-excel\/\" \/>\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 Excel (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T22:27:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/declaration-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=\"1 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-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/\",\"name\":\"Cara Menulis Pernyataan Kasus di Excel (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T22:27:44+00:00\",\"dateModified\":\"2023-07-20T22:27:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menulis pernyataan kasus di excel (dengan contoh)\"}]},{\"@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 Excel (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), 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\/pernyataan-kasus-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menulis Pernyataan Kasus di Excel (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T22:27:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/declaration-de-cas1.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\/pernyataan-kasus-di-excel\/","url":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/","name":"Cara Menulis Pernyataan Kasus di Excel (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T22:27:44+00:00","dateModified":"2023-07-20T22:27:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menulis pernyataan kasus di Excel menggunakan fungsi SWITCH(), beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pernyataan-kasus-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menulis pernyataan kasus di excel (dengan contoh)"}]},{"@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\/2741"}],"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=2741"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2741\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}