{"id":2304,"date":"2023-07-22T20:49:54","date_gmt":"2023-07-22T20:49:54","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/"},"modified":"2023-07-22T20:49:54","modified_gmt":"2023-07-22T20:49:54","slug":"google-sheet-menemukan-nilai-dalam-jangkauan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/","title":{"rendered":"Google spreadsheet: cara memeriksa apakah nilainya berada dalam jangkauan"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan rumus berikut untuk memeriksa apakah ada nilai tertentu dalam suatu rentang di Google Spreadsheet:<\/span><\/p>\n

Metode 1: Periksa apakah nilainya berada dalam kisaran<\/strong><\/span><\/p>\n

 =IF(ISERROR(MATCH(\" Value to Find<\/span> \", A1:A16<\/span> , 0<\/span> )), \" Not Found<\/span> \", \" Found<\/span> \")\n<\/strong><\/pre>\n
 Metode 2: Hitung Kemunculan Nilai dalam Rentang<\/strong><\/span><\/p>\n
 =<\/span> COUNTIF<\/span> (<\/span> A2:A16<\/span> ,<\/span> \" Value<\/span> \"<\/span><\/span> )<\/span><\/strong><\/pre>\n
 Metode 1: Periksa apakah nilainya berada dalam kisaran<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara memeriksa apakah nama tim “Suns” berada dalam rentang nama tim tertentu:<\/span> <\/p>\n
\"Google<\/p>\n
 Nama tim ada dalam rentang tersebut, sehingga fungsi MATCH()<\/strong> mengembalikan “Ditemukan”.<\/span><\/p>\n
 Perhatikan bahwa kita dapat mengganti “Ditemukan” dan “Tidak Ditemukan” dengan nilai numerik seperti 1 dan 0 jika kita ingin:<\/span> <\/p>\n
\"\"<\/p>\n
 Nilai 1<\/strong> menunjukkan bahwa “Matahari” ditemukan dalam rentang nilai tim.<\/span><\/p>\n
 Metode 2: Hitung Kemunculan Nilai dalam Rentang<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan fungsi COUNTIF()<\/strong> untuk mencari berapa kali suatu nilai tertentu muncul dalam suatu rentang:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat melihat bahwa nama tim \u201cSuns\u201d muncul 3<\/strong> kali dalam rentang tersebut.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: Cara menggunakan COUNTIF dengan banyak rentang<\/a>
 Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a>
 Google Sheets: Cara menggunakan SUMIF dengan banyak kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan rumus berikut untuk memeriksa apakah ada nilai tertentu dalam suatu rentang di Google Spreadsheet: Metode 1: Periksa apakah nilainya berada dalam kisaran =IF(ISERROR(MATCH(” Value to Find “, A1:A16 , 0 )), ” Not Found “, ” Found “) Metode 2: Hitung Kemunculan Nilai dalam Rentang = COUNTIF ( A2:A16 , ” Value […]<\/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":"\nGoogle Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.\" \/>\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-menemukan-nilai-dalam-jangkauan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:49:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouver1.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-menemukan-nilai-dalam-jangkauan\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\",\"name\":\"Google Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:49:54+00:00\",\"dateModified\":\"2023-07-22T20:49:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara memeriksa apakah nilainya berada dalam jangkauan\"}]},{\"@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: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial","description":"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.","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-menemukan-nilai-dalam-jangkauan\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:49:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouver1.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-menemukan-nilai-dalam-jangkauan\/","url":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/","name":"Google Spreadsheet: Cara memeriksa apakah nilainya berada dalam jangkauan \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:49:54+00:00","dateModified":"2023-07-22T20:49:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa ada tidaknya nilai tertentu dalam suatu rentang di Google Spreadsheet, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara memeriksa apakah nilainya berada dalam jangkauan"}]},{"@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\/2304"}],"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=2304"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2304\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}