{"id":2782,"date":"2023-07-20T17:44:02","date_gmt":"2023-07-20T17:44:02","guid":{"rendered":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/"},"modified":"2023-07-20T17:44:02","modified_gmt":"2023-07-20T17:44:02","slug":"besar-jika-meninggalkan-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/","title":{"rendered":"Cara menggunakan rumus big if di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan cara berikut untuk membuat rumus <strong>IF BESAR<\/strong> di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: IF BESAR dengan satu kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=ArrayFormula(LARGE(IF( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">value<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C11<\/span> ), <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">2<\/span> ))<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari nilai terbesar kedua pada kolom <strong>C<\/strong> dimana nilai pada kolom <strong>A<\/strong> sama dengan \u201cnilai\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: IF BESAR dengan beberapa kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=ArrayFormula(LARGE(IF(( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">value1<\/span> \"<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">*<\/span> ( <span dir=\"auto\" style=\"color: #800080;\">B2:B11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">value2<\/span> \"<\/span> ) <span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> , <span dir=\"auto\" style=\"color: #008080;\">C2:C11<\/span> ), <span style=\"color: #3366ff;\">5<\/span> ))\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari nilai terbesar kelima pada kolom <strong>C<\/strong> dimana nilai pada kolom <strong>A<\/strong> sama dengan \u201cnilai1\u201d dan nilai pada kolom B sama dengan \u201cnilai2\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24425 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandif1.jpg\" alt=\"\" width=\"553\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: IF BESAR dengan satu kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung nilai terbesar kedua di kolom <strong>Poin<\/strong> hanya untuk baris yang kolom <b>Timnya<\/b> sama dengan &#8220;Spurs&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=ArrayFormula(LARGE(IF( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> = <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Spurs<\/span> \"<\/span> , <span dir=\"auto\" style=\"color: #800080;\">C2:C11<\/span> ), <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">2<\/span> ))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24426\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandif2.jpg\" alt=\"Rumus JIKA BESAR di Google Spreadsheet\" width=\"611\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat melihat bahwa nilai <strong>poin<\/strong> tertinggi kedua di antara garis di mana <strong>Tim<\/strong> sama dengan \u201cSpurs\u201d adalah <strong>26<\/strong> .<\/span><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: IF BESAR dengan beberapa kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung nilai terbesar kedua pada kolom <strong>Poin<\/strong> hanya untuk baris dimana kolom <b>Tim<\/b> sama dengan &#8220;Spurs&#8221; dan kolom <strong>Posisi<\/strong> sama dengan &#8220;Penjaga&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=ArrayFormula(LARGE(IF(( <span dir=\"auto\" style=\"color: #ff6600;\">A2:A11<\/span> = <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Spurs<\/span> \"<\/span> )*( <span dir=\"auto\" style=\"color: #800080;\">B2:B11<\/span> = <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">Guard<\/span> \"<\/span> )= <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> , <span dir=\"auto\" style=\"color: #008080;\">C2:C11<\/span> ), <span style=\"color: #3366ff;\">2<\/span> ))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24427\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandif3.jpg\" alt=\"\" width=\"666\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai <strong>poin<\/strong> tertinggi kedua di antara garis di mana <strong>tim<\/strong> sama dengan \u201cSpurs\u201d dan <strong>posisinya<\/strong> sama dengan \u201cGuard\u201d adalah <strong>24<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>LARGE<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3094008?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara mengalikan kolom dengan konstanta<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara mengalikan kolom dengan persentase<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memberi-peringkat-pada-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara mengurutkan item di beberapa kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan cara berikut untuk membuat rumus IF BESAR di Google Spreadsheet: Metode 1: IF BESAR dengan satu kriteria =ArrayFormula(LARGE(IF( A2:A11 = &#8221; value &#8221; , C2:C11 ), 2 )) Rumus ini mencari nilai terbesar kedua pada kolom C dimana nilai pada kolom A sama dengan \u201cnilai\u201d. Metode 2: IF BESAR dengan beberapa kriteria [&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>Cara menggunakan rumus BIG IF di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, 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-meninggalkan-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan rumus BIG IF di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T17:44:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandif1.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-meninggalkan-google\/\",\"url\":\"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/\",\"name\":\"Cara menggunakan rumus BIG IF di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T17:44:02+00:00\",\"dateModified\":\"2023-07-20T17:44:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan rumus big if di google sheets\"}]},{\"@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 rumus BIG IF di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, 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-meninggalkan-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan rumus BIG IF di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/","og_site_name":"Statorials","article_published_time":"2023-07-20T17:44:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandif1.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-meninggalkan-google\/","url":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/","name":"Cara menggunakan rumus BIG IF di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T17:44:02+00:00","dateModified":"2023-07-20T17:44:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus IF BESAR di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/besar-jika-meninggalkan-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan rumus big if di google sheets"}]},{"@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\/2782"}],"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=2782"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2782\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}