{"id":3736,"date":"2023-07-15T20:39:43","date_gmt":"2023-07-15T20:39:43","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/"},"modified":"2023-07-15T20:39:43","modified_gmt":"2023-07-15T20:39:43","slug":"excel-jika-rentang-fungsi-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/","title":{"rendered":"Excel: cara menggunakan fungsi if dengan rentang nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk membuat fungsi IF dengan rentang nilai di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Buat Fungsi IF dengan Rentang Sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> ,\"Pacers\")&gt;0, \"Exists\", \"Does Not Exist\")\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Untuk rumus ini, jika &#8220;Pacers&#8221; ada di mana saja dalam rentang <strong>A2:A11<\/strong> , fungsi akan mengembalikan &#8220;Exists&#8221;. Kalau tidak, ia akan mengembalikan &#8220;Tidak ada&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Buat Fungsi IF dengan Rentang Nilai Numerik<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF((( <span style=\"color: #3366ff;\">B2<\/span> &gt;=95)*( <span style=\"color: #3366ff;\">B2<\/span> &lt;=105))=1, \"Yes\", \"No\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Untuk rumus ini, jika nilai di sel <strong>B2<\/strong> antara 95 dan 105, maka fungsi akan mengembalikan &#8220;Ya&#8221;. Jika tidak, ia akan mengembalikan &#8220;Tidak&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30445 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage11.jpg\" alt=\"\" width=\"453\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Buat fungsi IF dengan rentang sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk mengembalikan &#8220;Ada&#8221; jika nama tim &#8220;Pacers&#8221; ada dalam rentang <strong>A2:A11<\/strong> atau untuk mengembalikan &#8220;Tidak ada&#8221; jika nama tim tidak ada dalam rentang tersebut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF(COUNTIF( <span style=\"color: #3366ff;\">A2:A11<\/span> ,\"Pacers\")&gt;0, \"Exists\", \"Does Not Exist\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30446\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage12.jpg\" alt=\"Fungsi Excel IF dengan rentang nilai\" width=\"644\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan &#8220;Ada&#8221; karena string &#8220;Pacers&#8221; muncul setidaknya sekali dalam rentang <strong>A2:A11<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Buat fungsi IF dengan rentang nilai numerik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk mengembalikan &#8220;Ya&#8221; jika nilai di kolom Poin antara 95 dan 105:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IF((( <span style=\"color: #3366ff;\">B2<\/span> &gt;=95)*( <span style=\"color: #3366ff;\">B2<\/span> &lt;=105))=1, \"Yes\", \"No\")<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30447 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage13.jpg\" alt=\"\" width=\"573\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut fungsi rumus untuk setiap baris di kolom D:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jika nilai di kolom Poin antara 95 dan 105, kembalikan Ya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika nilai pada kolom Poin <em>tidak<\/em> antara 95 dan 105, kembalikan No.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Anda dapat mengubah dua argumen terakhir fungsi IF menjadi selain &#8220;Ya&#8221; atau &#8220;Tidak&#8221; jika Anda ingin mengembalikan nilai keluaran yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Simbol perkalian ( <strong>*<\/strong> ) pada fungsi IF memberi tahu Excel bahwa kedua kondisi harus dipenuhi untuk mengembalikan &#8220;Ya&#8221;.<\/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> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan COUNTIF dengan banyak rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-jika-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">Excel: rumus sederhana untuk \u201cjika tidak kosong\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengklasifikasikan-jika-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara menggunakan rumus RANK IF<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk membuat fungsi IF dengan rentang nilai di Excel: Metode 1: Buat Fungsi IF dengan Rentang Sel =IF(COUNTIF( A2:A11 ,&#8221;Pacers&#8221;)&gt;0, &#8220;Exists&#8221;, &#8220;Does Not Exist&#8221;) Untuk rumus ini, jika &#8220;Pacers&#8221; ada di mana saja dalam rentang A2:A11 , fungsi akan mengembalikan &#8220;Exists&#8221;. Kalau tidak, ia akan mengembalikan &#8220;Tidak ada&#8221;. Metode 2: [&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 rentang nilai - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, 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\/excel-jika-rentang-fungsi-nilai\/\" \/>\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 rentang nilai - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T20:39:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage11.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=\"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-rentang-fungsi-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/\",\"name\":\"Excel: Cara menggunakan fungsi IF dengan rentang nilai - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T20:39:43+00:00\",\"dateModified\":\"2023-07-15T20:39:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan fungsi if dengan rentang nilai\"}]},{\"@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 rentang nilai - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, 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\/excel-jika-rentang-fungsi-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan fungsi IF dengan rentang nilai - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-15T20:39:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage11.jpg"}],"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-rentang-fungsi-nilai\/","url":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/","name":"Excel: Cara menggunakan fungsi IF dengan rentang nilai - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T20:39:43+00:00","dateModified":"2023-07-15T20:39:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF dengan rentang nilai di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-jika-rentang-fungsi-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan fungsi if dengan rentang nilai"}]},{"@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\/3736"}],"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=3736"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3736\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}