{"id":4917,"date":"2023-07-06T10:52:25","date_gmt":"2023-07-06T10:52:25","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/"},"modified":"2023-07-06T10:52:25","modified_gmt":"2023-07-06T10:52:25","slug":"excel-jika-berfungsi-dengan-wildcard","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/","title":{"rendered":"Excel: cara menggunakan fungsi if dengan wildcard"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk membuat fungsi IF dengan wildcard di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah sel berisi sebagian teks<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2<\/span> , \"*hello*\"),\"Yes\", \"No\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini memeriksa apakah sel <strong>A2<\/strong> berisi teks &#8220;halo&#8221; di mana pun dalam sel dan mengembalikan &#8220;Ya&#8221; atau &#8220;Tidak&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah sel berisi format tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2<\/span> ,\"???-???\"),\"Yes\", \"No\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini memeriksa apakah sel <strong>A2<\/strong> berisi format yang berisi tepat dua karakter diikuti dengan tanda hubung diikuti tepat tiga karakter, lalu mengembalikan &#8220;Ya&#8221; atau &#8220;Tidak&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan daftar ID karyawan berikut untuk perusahaan tertentu di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38387 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/si-sauvage1.png\" alt=\"\" width=\"474\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Periksa apakah sel berisi sebagian teks<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk memeriksa apakah sel <strong>A2<\/strong> berisi sebagian teks &#8220;AB&#8221; di mana saja di ID karyawan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2<\/span> , \"*AB*\"),\"Yes\", \"No\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38388\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/si-sauvage2.png\" alt=\"Fungsi Excel IF dengan wildcard\" width=\"558\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan &#8220;Ya&#8221; atau &#8220;Tidak&#8221; untuk menunjukkan apakah setiap ID karyawan berisi &#8220;AB&#8221; atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>AB-009<\/strong> berisi <strong>AB<\/strong> sehingga kolom B menghasilkan \u201cYa\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>AA-3345<\/strong> tidak mengandung <strong>AB<\/strong> sehingga kolom B mengembalikan \u201cTidak\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>AA-390<\/strong> tidak mengandung <strong>AB<\/strong> sehingga kolom B menghasilkan \u201cTidak\u201d<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Periksa apakah sel berisi format tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk memeriksa apakah sel <strong>A2<\/strong> memiliki format yang berisi tepat dua karakter diikuti dengan tanda hubung diikuti oleh tepat tiga karakter:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2<\/span> ,\"???-???\"),\"Yes\", \"No\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38389 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/siwild3.png\" alt=\"\" width=\"516\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B menampilkan &#8220;Ya&#8221; atau &#8220;Tidak&#8221; untuk menunjukkan apakah setiap ID karyawan memiliki format yang kami tentukan.<\/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 Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-jika-fungsi-teks\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan Fungsi IF dengan Nilai Teks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-jika-fungsinya-ya-atau-tidak\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membuat fungsi IF untuk mengembalikan ya atau tidak<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan fungsi IF dengan rentang nilai<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk membuat fungsi IF dengan wildcard di Excel: Metode 1: Periksa apakah sel berisi sebagian teks =IF(COUNTIF( A2 , &#8220;*hello*&#8221;),&#8221;Yes&#8221;, &#8220;No&#8221;) Rumus ini memeriksa apakah sel A2 berisi teks &#8220;halo&#8221; di mana pun dalam sel dan mengembalikan &#8220;Ya&#8221; atau &#8220;Tidak&#8221;. Metode 2: Periksa apakah sel berisi format tertentu =IF(COUNTIF( A2 [&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>Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, 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\/excel-jika-berfungsi-dengan-wildcard\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T10:52:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/si-sauvage1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/\",\"name\":\"Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T10:52:25+00:00\",\"dateModified\":\"2023-07-06T10:52:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan fungsi if dengan wildcard\"}]},{\"@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":"Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, 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\/excel-jika-berfungsi-dengan-wildcard\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/","og_site_name":"Statorials","article_published_time":"2023-07-06T10:52:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/si-sauvage1.png"}],"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\/excel-jika-berfungsi-dengan-wildcard\/","url":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/","name":"Excel: Cara menggunakan fungsi IF dengan wildcard - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T10:52:25+00:00","dateModified":"2023-07-06T10:52:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan wildcard di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-jika-berfungsi-dengan-wildcard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan fungsi if dengan wildcard"}]},{"@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\/4917"}],"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=4917"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4917\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}