{"id":2691,"date":"2023-07-21T03:55:27","date_gmt":"2023-07-21T03:55:27","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-jika-berisi\/"},"modified":"2023-07-21T03:55:27","modified_gmt":"2023-07-21T03:55:27","slug":"excel-jika-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-jika-berisi\/","title":{"rendered":"Excel: rumus sederhana untuk \u201cjika berisi\u201d"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut di Excel untuk menentukan apakah sel berisi string tertentu:<\/span><\/p>\n

 =<\/span> IF(ISNUMBER(SEARCH(\"this\", A1<\/span> )), \"Yes\", \"No\")<\/span>\n<\/strong><\/pre>\n
 Dalam contoh ini, jika sel A1<\/strong> berisi string ” ini<\/strong> “, maka sel tersebut akan mengembalikan Yes<\/strong> , jika tidak maka akan mengembalikan No.<\/strong><\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Periksa apakah sel berisi string tertentu di Excel<\/strong><\/span><\/h3>\n
 Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa menggunakan rumus berikut untuk memeriksa apakah nilai di kolom Tim berisi string \u201cmavs\u201d:<\/span><\/p>\n
 =<\/span> IF(ISNUMBER(SEARCH(\"mavs\", A2<\/span> )), \"Yes\", \"No\")<\/span><\/strong><\/pre>\n
 Kita bisa mengetikkan rumus ini di sel C2<\/strong> , lalu salin dan tempel ke sel lainnya di kolom C:<\/span> <\/p>\n
\"Excel<\/p>\n
 Tiga baris dengan nilai “mavs” di kolom Tim semuanya menerima Ya<\/strong> di kolom baru sementara semua baris lainnya menerima Tidak.<\/strong><\/span><\/p>\n
 Perhatikan bahwa fungsi SEARCH()<\/strong> di Excel tidak peka huruf besar-kecil.<\/span><\/p>\n
 Jika Anda ingin melakukan penelusuran peka huruf besar\/kecil<\/strong> , Anda dapat mengganti fungsi SEARCH()<\/strong> dalam rumus dengan fungsi FIND()<\/strong> .<\/span><\/p>\n
 Misalnya, kita bisa menggunakan rumus berikut untuk memeriksa apakah nilai di kolom Tim sama dengan \u201cMAVS\u201d:<\/span><\/p>\n
 =<\/span> IF(ISNUMBER(FIND(\"MAVS\", A2<\/span> )), \"Yes\", \"No\")<\/span><\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa setiap nilai di kolom baru sama dengan Tidak<\/strong> karena tidak ada nama tim yang cocok dengan string huruf besar “MAVS” yang kita tentukan dalam rumus.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara menghitung duplikat di excel<\/a>
 Cara menghitung frekuensi teks di Excel<\/a>
 Cara menghitung rata-rata jika sel berisi teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut di Excel untuk menentukan apakah sel berisi string tertentu: = IF(ISNUMBER(SEARCH(“this”, A1 )), “Yes”, “No”) Dalam contoh ini, jika sel A1 berisi string ” ini “, maka sel tersebut akan mengembalikan Yes , jika tidak maka akan mengembalikan No. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Contoh: Periksa […]<\/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":"\nExcel: rumus sederhana untuk "Jika berisi" - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa 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-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: rumus sederhana untuk "Jika berisi" - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-jika-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T03:55:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contient11.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\/excel-jika-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-jika-berisi\/\",\"name\":\"Excel: rumus sederhana untuk "Jika berisi" - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T03:55:27+00:00\",\"dateModified\":\"2023-07-21T03:55:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-jika-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: rumus sederhana untuk \u201cjika berisi\u201d\"}]},{\"@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: rumus sederhana untuk "Jika berisi" - Statorials","description":"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa 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-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: rumus sederhana untuk "Jika berisi" - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-jika-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-21T03:55:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contient11.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\/excel-jika-berisi\/","url":"https:\/\/statorials.org\/id\/excel-jika-berisi\/","name":"Excel: rumus sederhana untuk "Jika berisi" - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T03:55:27+00:00","dateModified":"2023-07-21T03:55:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus "jika berisi" di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-jika-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-jika-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-jika-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: rumus sederhana untuk \u201cjika berisi\u201d"}]},{"@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\/2691"}],"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=2691"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2691\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}