{"id":1692,"date":"2023-07-25T08:56:39","date_gmt":"2023-07-25T08:56:39","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/"},"modified":"2023-07-25T08:56:39","modified_gmt":"2023-07-25T08:56:39","slug":"google-sheet-jika-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/","title":{"rendered":"Google spreadsheet: rumus sederhana untuk \u201cjika berisi\u201d"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk menentukan apakah sel berisi string tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">IF<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">REGEXMATCH<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">B1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">\"<\/span> <span class=\" string \" dir=\"auto\"><span style=\"color: #008000;\">this<\/span><\/span> <span class=\" default-formula-text-color\" dir=\"auto\">\"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1,0<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, jika sel B1 berisi string &#8220;ini&#8221;, sel tersebut akan mengembalikan <strong>1<\/strong> , jika tidak maka akan mengembalikan <strong>0<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/google-sheet-jika-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: Rumus Sederhana untuk &#8220;Jika Tidak Kosong&#8221;<\/a><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan \u201cJika Berisi\u201d untuk sebuah String<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Rumus berikut memperlihatkan cara membuat kolom baru yang menghasilkan angka <strong>1<\/strong> jika nama tim sama dengan Lakers dan <strong>0<\/strong> jika nama tim tidak sama dengan Lakers:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16686 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expression-reguliere1.png\" alt=\"\" width=\"531\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat mengembalikan nilai string seperti &#8220;Ya&#8221; atau &#8220;Tidak&#8221; alih-alih nilai numerik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16687 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expression-reguliere2.png\" alt=\"\" width=\"505\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan \u201cJika Berisi\u201d untuk salah satu dari beberapa string<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Rumus berikut memperlihatkan cara membuat kolom baru yang mengembalikan <strong>1<\/strong> jika nama tim sama dengan Lakers <em>atau<\/em> Mavericks dan <strong>0<\/strong> jika nama tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16688 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expression-reguliere3.png\" alt=\"\" width=\"474\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<hr>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial Google Sheets lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut di Google Spreadsheet untuk menentukan apakah sel berisi string tertentu: = IF ( REGEXMATCH ( B1 , &#8221; this &#8221; ) , 1,0 ) Dalam contoh ini, jika sel B1 berisi string &#8220;ini&#8221;, sel tersebut akan mengembalikan 1 , jika tidak maka akan mengembalikan 0 . Contoh berikut menunjukkan cara [&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>Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, 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\/google-sheet-jika-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:56:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expression-reguliere1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/\",\"name\":\"Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:56:39+00:00\",\"dateModified\":\"2023-07-25T08:56:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: 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":"Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, 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\/google-sheet-jika-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:56:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expression-reguliere1.png"}],"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\/google-sheet-jika-berisi\/","url":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/","name":"Google Spreadsheet: rumus sederhana untuk \u201cJika berisi\u201d \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:56:39+00:00","dateModified":"2023-07-25T08:56:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi &quot;jika berisi&quot; di Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-jika-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: 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\/1692"}],"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=1692"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1692\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}