{"id":3112,"date":"2023-07-19T04:02:35","date_gmt":"2023-07-19T04:02:35","guid":{"rendered":"https:\/\/statorials.org\/id\/besar-jika-excel\/"},"modified":"2023-07-19T04:02:35","modified_gmt":"2023-07-19T04:02:35","slug":"besar-jika-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/besar-jika-excel\/","title":{"rendered":"Cara menggunakan fungsi large if di excel (beserta contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menjalankan fungsi BIG IF di Excel:<\/span><\/p>\n

Rumus 1: IF BESAR dengan satu kriteria<\/strong><\/span><\/p>\n

 =LARGE(IF( A2:A16<\/span> =\"A\", C2:C16<\/span> ),2)\n<\/strong><\/pre>\n
 Rumus ini mencari nilai terbesar kedua di C2:C16 dimana nilai di A2:A16 sama dengan “A”.<\/span><\/p>\n
 Rumus 2: IF BESAR dengan beberapa kriteria<\/strong><\/span><\/p>\n
 =LARGE(IF(( A2:A16<\/span> =\"A\")*( B2:B16<\/span> =\"Guard\"), C2:C16<\/span> ),2)\n<\/strong><\/pre>\n
 Rumus ini mencari nilai terbesar kedua di C2:C16 dimana nilai di A2:A16 sama dengan “A” dan<\/strong> nilai di B2:B16 sama dengan “Guard”.<\/span><\/p>\n
 Contoh berikut memperlihatkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Contoh 1: IF BESAR dengan satu kriteria<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk mencari nilai terbesar kedua di C2:C16 dimana nilai di A2:A16 sama dengan “A”:<\/span><\/p>\n
 =LARGE(IF( A2:A16<\/span> =\"A\", C2:C16<\/span> ),2)\n<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"Fungsi<\/p>\n
 Ini memberitahu kita bahwa nilai poin tertinggi kedua di antara semua pemain di Tim A adalah 14<\/strong> .<\/span><\/p>\n
 Contoh 2: IF BESAR dengan beberapa kriteria<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk mencari nilai terbesar kedua di C2:C16 dimana nilai di A2:A16 sama dengan “A” dan<\/strong> nilai di B2:B16 sama dengan “Guard”:<\/span><\/p>\n
 =LARGE(IF(( A2:A16<\/span> =\"A\")*( B2:B16<\/span> =\"Guard\"), C2:C16<\/span> ),2)<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"BIG<\/p>\n
 Ini memberitahu kita bahwa nilai poin tertinggi kedua di antara semua penjaga di Tim A adalah 7<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara Menggunakan Fungsi Median IF di Excel<\/a>
 Cara Menghitung Mean dan Deviasi Standar di Excel<\/a>
 Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk menjalankan fungsi BIG IF di Excel: Rumus 1: IF BESAR dengan satu kriteria =LARGE(IF( A2:A16 =”A”, C2:C16 ),2) Rumus ini mencari nilai terbesar kedua di C2:C16 dimana nilai di A2:A16 sama dengan “A”. Rumus 2: IF BESAR dengan beberapa kriteria =LARGE(IF(( A2:A16 =”A”)*( B2:B16 =”Guard”), C2:C16 ),2) Rumus ini […]<\/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":"\nCara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, 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\/besar-jika-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/besar-jika-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T04:02:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandifexcel1.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\/besar-jika-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/besar-jika-excel\/\",\"name\":\"Cara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T04:02:35+00:00\",\"dateModified\":\"2023-07-19T04:02:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/besar-jika-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/besar-jika-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/besar-jika-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi large if di excel (beserta contoh)\"}]},{\"@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":"Cara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, 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\/besar-jika-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/besar-jika-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T04:02:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandifexcel1.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\/besar-jika-excel\/","url":"https:\/\/statorials.org\/id\/besar-jika-excel\/","name":"Cara Menggunakan Fungsi IF BESAR di Excel (Dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T04:02:35+00:00","dateModified":"2023-07-19T04:02:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF BESAR di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/besar-jika-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/besar-jika-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/besar-jika-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi large if di excel (beserta contoh)"}]},{"@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\/3112"}],"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=3112"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3112\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}