{"id":3399,"date":"2023-07-17T16:59:22","date_gmt":"2023-07-17T16:59:22","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/"},"modified":"2023-07-17T16:59:22","modified_gmt":"2023-07-17T16:59:22","slug":"excel-max-jika-banyak-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/","title":{"rendered":"Excel: cara menggunakan max if dengan beberapa kriteria"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan MAX IF dengan beberapa kriteria di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=MAX(IF( <span style=\"color: #3366ff;\">A2:A11<\/span> =\"Mavs\", IF( <span style=\"color: #ff0000;\">B2:B11<\/span> =\"Forward\", <span style=\"color: #800080;\">C2:C11<\/span> )))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan nilai maksimum dalam rentang <strong>C2:C11<\/strong> di mana nilai terkait dalam rentang <strong>A2:A11<\/strong> sama dengan &#8220;Mavs&#8221; dan nilai terkait dalam rentang <strong>B2:B11<\/strong> sama dengan &#8220;Maju&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: MAX IF dengan beberapa kriteria di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28513 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/maxif1.jpg\" alt=\"\" width=\"446\" height=\"491\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung nilai maksimal pemain yang ada di tim Mavs dan memiliki posisi forward:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=MAX(IF( <span style=\"color: #3366ff;\">A2:A11<\/span> =\"Mavs\", IF( <span style=\"color: #ff0000;\">B2:B11<\/span> =\"Forward\", <span style=\"color: #800080;\">C2:C11<\/span> )))<\/span><\/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=\" wp-image-28514 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/maxif2.jpg\" alt=\"\" width=\"669\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terlihat pemain dengan nilai maksimal pada kolom Poin dengan nilai tim \u201cMavs\u201d dan nilai posisi \u201cForward\u201d adalah <strong>30<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mengubah nilai dalam tanda kutip dalam rumus untuk menemukan poin maksimum di antara pemain yang memenuhi kriteria berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya kita bisa mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung nilai maksimal pemain yang berada di tim Heat dan memiliki posisi Guard:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=MAX(IF( <span style=\"color: #3366ff;\">A2:A11<\/span> =\"Heat\", IF( <span style=\"color: #ff0000;\">B2:B11<\/span> =\"Guard\", <span style=\"color: #800080;\">C2:C11<\/span> )))<\/span><\/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=\" wp-image-28515 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/maxif3.jpg\" alt=\"\" width=\"642\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pemain dengan nilai maksimal pada kolom Poin dengan nilai tim &#8220;Heat&#8221; dan nilai posisi &#8220;Guard&#8221; adalah <strong>21<\/strong> .<\/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\/nilai-maksimal-excel-per-grup\/\" target=\"_blank\" rel=\"noopener\">Cara mencari nilai maksimal berdasarkan grup di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengklasifikasikan-jika-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menggunakan Rumus RANK IF di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan MAX IF dengan beberapa kriteria di Excel: =MAX(IF( A2:A11 =&#8221;Mavs&#8221;, IF( B2:B11 =&#8221;Forward&#8221;, C2:C11 ))) Rumus khusus ini menemukan nilai maksimum dalam rentang C2:C11 di mana nilai terkait dalam rentang A2:A11 sama dengan &#8220;Mavs&#8221; dan nilai terkait dalam rentang B2:B11 sama dengan &#8220;Maju&#8221;. 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>Excel: Cara menggunakan MAX IF dengan beberapa kriteria - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk 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-max-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: Cara menggunakan MAX IF dengan beberapa kriteria - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T16:59:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/maxif1.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=\"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-max-jika-banyak-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/\",\"name\":\"Excel: Cara menggunakan MAX IF dengan beberapa kriteria - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T16:59:22+00:00\",\"dateModified\":\"2023-07-17T16:59:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan max if dengan beberapa kriteria\"}]},{\"@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 MAX IF dengan beberapa kriteria - Statorial","description":"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk 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-max-jika-banyak-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan MAX IF dengan beberapa kriteria - Statorial","og_description":"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-17T16:59:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/maxif1.jpg"}],"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-max-jika-banyak-kriteria\/","url":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/","name":"Excel: Cara menggunakan MAX IF dengan beberapa kriteria - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T16:59:22+00:00","dateModified":"2023-07-17T16:59:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat rumus MAX IF dengan beberapa kriteria, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-max-jika-banyak-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan max if dengan beberapa kriteria"}]},{"@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\/3399"}],"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=3399"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3399\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}