{"id":1738,"date":"2023-11-08T19:50:50","date_gmt":"2023-11-08T19:50:50","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/"},"modified":"2023-12-06T06:14:19","modified_gmt":"2023-12-06T06:14:19","slug":"jika-sel-berisi-bagian","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/","title":{"rendered":"Bagaimana cara memeriksa apakah sel berisi sebagian teks?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1605773325\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk memeriksa apakah sel berisi sebagian teks di Excel, Anda perlu membuat rumus menggunakan IF, COUNTIF, dan wildcard. Wildcard membantu Anda mengatur sebagian teks, lalu COUNTIF memeriksa sebagian nilai dan IF mengembalikan hasilnya berdasarkan nilai tersebut. Kombinasi fungsi ini bekerja dengan sempurna. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77750\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"periksa apakah sel berisi sebagian teks\" width=\"558\" height=\"275\"><\/figure><\/div><p> Dalam tutorial ini, kita akan mempelajari cara menulis rumus ini.<\/p><h2 class=\"wp-block-heading\"> Rumus Excel: JIKA sel berisi sebagian teks<\/h2><ol type=\"1\"><li> Pertama, di sel B1, masukkan \u201c=IF(\u201c.<\/li><li> Setelah itu masukkan \u201cCOUNTIF(\u201c.<\/li><li> Lalu, pada argumen pertama COUNTIF, rujuk ke sel A1.<\/li><li> Sekarang masukkan nilai yang ingin Anda periksa menggunakan tanda bintang sebelum dan sesudah nilai ini dan tutup fungsinya.<\/li><li> Terakhir, masukkan &#8220;Y&#8221; untuk value_if_true, &#8220;N&#8221; untuk value_if_false&#8221;, masukkan tanda kurung tutup dan tekan Enter. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77751\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-si-formule-pour-trouver-du-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-rumus-untuk-menemukan-sebagian-teks\" width=\"741\" height=\"167\"><\/figure><\/div><p class=\"formula\"> =IF(COUNTIF(A1,\u201d*Excel*\u201d),\u201dY\u201d,\u201dN\u201d)<\/p><p> Dalam contoh berikut, Anda dapat melihat pada nilai pertama Anda memiliki &#8220;Excel&#8221;, dan nilai tersebut mengembalikan &#8220;Y&#8221;. Namun pada nilai kedua, Anda tidak memiliki nilai ini, dan hasilnya menghasilkan &#8220;N&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77752\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultats-de-valeur-partielle.png\" sizes=\"auto, \" srcset=\"\" alt=\"hasil nilai parsial\" width=\"527\" height=\"272\"><\/figure><\/div><p> Untuk memahami rumus ini, Anda perlu membaginya menjadi dua bagian: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77753\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formule-de-rupture-en-deux-parties.png\" sizes=\"auto, \" srcset=\"\" alt=\"membagi-rumus-menjadi-dua-bagian\" width=\"624\" height=\"352\"><\/figure><\/div><ul><li> Pada bagian pertama, COUNTIF menggunakan wildcard yang memeriksa sebagian nilai sel. Dan jika nilainya ada, maka hasilnya akan menghasilkan 1, dan jika tidak, maka akan dikembalikan 2.<\/li><li> Pada bagian kedua, IF mengambil hasil COUNTIF dan menggunakan 1 sebagai TRUE dan 0 sebagai FALSE. Jadi jika TRUE maka akan menghasilkan Y, dan jika FALSE maka N.<\/li><\/ul><h2 class=\"wp-block-heading\"> JIKA sel berisi sebagian teks (SEARCH + ESTNUM)<\/h2><p> Anda juga bisa menggunakan rumus yang menggabungkan LOOKUP, ISNUM, dan IF untuk memeriksa apakah ada sebagian nilai dalam sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77755\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-si-la-recherche-est-un-nombre-pour-trouver-une-partie-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-pencarian-adalah-angka-untuk-menemukan-teks-sebagian\" width=\"553\" height=\"387\"><\/figure><\/div><p id=\"formula\"> =IF(ISNUMBER(CARI(\u201cExcel*\u201d, A1)),,\u201dY\u201d,\u201dN\u201d)<\/p><p> Rumus ini menggunakan SEARCH dan <a href=\"https:\/\/exceladvisor.org\/id\/karakter-pengganti-2\/\" data-wpil=\"url\">Wildcard<\/a> untuk memeriksa nilainya. Jika nilainya ada, ia mengembalikan angka dan jika nilainya tidak ada, ia mengembalikan #VALUE! kesalahan.<\/p><p> Untuk menangani kesalahan ini Anda perlu menggunakan ISNUMBER dan IF. ISNUMBER memeriksa apakah hasil SEARCH berupa angka atau bukan dan mengembalikan TRUE atau FALSE.<\/p><p> Sekarang jika hasil ISNUMBER TRUE maka IF mengembalikan &#8216;Y&#8217; dan jika FALSE maka IF mengembalikan &#8216;N&#8217;. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/si-les-cellules-contiennent-du-texte-partiel.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-nol-maka-kosong\/\">Centang IF 0 (nol) lalu kosongkan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-ada-nilai-dalam-suatu-rentang\/\">Periksa apakah ada nilai dalam rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan-1\/\">Gabungkan fungsi IF dan AND di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-atau-1\/\">Gabungkan fungsi IF dan OR di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-selnya-kosong\/\">IF Cell kosong (kosong) menggunakan IF + ISBLANK di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-negatif-maka-nol\/\">JIKA negatif maka nol (0) di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1738","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\",\"name\":\"\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png\",\"datePublished\":\"2023-11-08T19:50:50+00:00\",\"dateModified\":\"2023-12-06T06:14:19+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah sel berisi sebagian teks?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?","description":"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks","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:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks","og_url":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/","url":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/","name":"\u25b7 Bagaimana cara memeriksa apakah sel berisi sebagian teks?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png","datePublished":"2023-11-08T19:50:50+00:00","dateModified":"2023-12-06T06:14:19+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menulis kondisi menggunakan fungsi IF untuk memeriksa apakah sel berisi teks","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verifier-si-la-cellule-contient-du-texte-partiel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-sel-berisi-bagian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah sel berisi sebagian teks?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1738"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1738\/revisions"}],"predecessor-version":[{"id":2344,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1738\/revisions\/2344"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}