{"id":4688,"date":"2023-07-08T22:51:54","date_gmt":"2023-07-08T22:51:54","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/"},"modified":"2023-07-08T22:51:54","modified_gmt":"2023-07-08T22:51:54","slug":"excel-min-jika-banyak-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/","title":{"rendered":"Excel: rumus beberapa kriteria if minimum"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan basis berikut di Excel untuk menemukan nilai minimum dalam suatu rentang hanya jika lebih dari satu kriteria terpenuhi:<\/span><\/p>\n

 =MINIFS( C2:C11<\/span> , A2:A11<\/span> , \"Mavs\", B2:B11<\/span> , \"<5\")\n<\/strong><\/pre>\n
 Rumus khusus ini menemukan nilai minimum dalam rentang sel C2:C11<\/strong> hanya jika nilai dalam rentang A2:A11<\/strong> sama dengan “Mavs” dan nilai dalam rentang B2:B11<\/strong> kurang dari 5.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh: Rumus MIN IF Beberapa Kriteria di Excel<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin mencari nilai minimum di kolom poin hanya jika<\/em> nilai terkait di kolom tim adalah “Mavs” dan nilai terkait di kolom assist kurang dari 5.<\/span><\/p>\n
 Untuk melakukannya, kita dapat menggunakan rumus berikut:<\/span><\/p>\n
 =MINIFS( C2:C11<\/span> , A2:A11<\/span> , \"Mavs\", B2:B11<\/span> , \"<5\")<\/strong><\/pre>\n
 Kami akan mengetikkan rumus ini di sel E2<\/strong> , lalu tekan Enter:<\/span> <\/p>\n
\"\"<\/p>\n
 Rumusnya mengembalikan nilai 22<\/strong> .<\/span><\/p>\n
 Ini adalah nilai poin minimum di antara garis-garis di mana tim sama dengan “Mavs” dan assist kurang dari 5.<\/span><\/p>\n
 Kami dapat mengonfirmasi hal ini dengan memeriksa secara manual baris mana yang memenuhi dua persyaratan berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Dua garis yang disorot dengan warna hijau adalah satu-satunya dua garis di mana tim sama dengan “Mavs” dan<\/em> nilai assistnya kurang dari 5.<\/span><\/p>\n
 Di antara dua garis ini, garis dengan nilai titik terendah adalah 22<\/strong> , yang merupakan nilai yang dikembalikan oleh rumus kita.<\/span><\/p>\n
 Perhatikan bahwa dalam contoh ini kami menggunakan fungsi MINIFS<\/strong> dengan dua kriteria, namun Anda dapat menggunakan kriteria sebanyak yang Anda inginkan.<\/span><\/p>\n
 Anda dapat menemukan dokumentasi lengkap fungsi MINIFS<\/strong> di Excel di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/span><\/strong><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Excel: Cara mencari nilai maksimum berdasarkan kelompok<\/a>
 Excel: cara menghitung rata-rata berdasarkan kelompok<\/a>
 Excel: Cara Menggunakan Fungsi MIN dan Kecualikan Nol<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan basis berikut di Excel untuk menemukan nilai minimum dalam suatu rentang hanya jika lebih dari satu kriteria terpenuhi: =MINIFS( C2:C11 , A2:A11 , “Mavs”, B2:B11 , “<5″) Rumus khusus ini menemukan nilai minimum dalam rentang sel C2:C11 hanya jika nilai dalam rentang A2:A11 sama dengan “Mavs” dan nilai dalam rentang B2:B11 kurang […]<\/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 untuk beberapa kriteria minimum IF - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF 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-min-jika-banyak-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Rumus untuk beberapa kriteria minimum IF - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T22:51:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mini1.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\/excel-min-jika-banyak-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/\",\"name\":\"Excel: Rumus untuk beberapa kriteria minimum IF - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T22:51:54+00:00\",\"dateModified\":\"2023-07-08T22:51:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: rumus beberapa kriteria if minimum\"}]},{\"@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 untuk beberapa kriteria minimum IF - Statorials","description":"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF 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-min-jika-banyak-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Rumus untuk beberapa kriteria minimum IF - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-08T22:51:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mini1.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\/excel-min-jika-banyak-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/","name":"Excel: Rumus untuk beberapa kriteria minimum IF - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T22:51:54+00:00","dateModified":"2023-07-08T22:51:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus beberapa kriteria MIN IF di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: rumus beberapa kriteria if minimum"}]},{"@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\/4688"}],"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=4688"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4688\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}