{"id":3113,"date":"2023-07-19T03:56:25","date_gmt":"2023-07-19T03:56:25","guid":{"rendered":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/"},"modified":"2023-07-19T03:56:25","modified_gmt":"2023-07-19T03:56:25","slug":"kecil-jika-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/","title":{"rendered":"Cara menggunakan fungsi small if di excel (beserta contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menjalankan fungsi IF KECIL di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: IF KECIL dengan satu kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL(IF( <span style=\"color: #3366ff;\">A2:A16<\/span> =\"A\", <span style=\"color: #ff0000;\">C2:C16<\/span> ),2)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari nilai terkecil ke-2 pada C2:C16 dimana nilai pada A2:A16 sama dengan &#8220;A&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: IF KECIL dengan beberapa kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL(IF(( <span style=\"color: #3366ff;\">A2:A16<\/span> =\"A\")*( <span style=\"color: #ff0000;\">B2:B16<\/span> =\"Forward\"), <span style=\"color: #800080;\">C2:C16<\/span> ),2)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini mencari nilai terkecil ke-2 di C2:C16 dimana nilai di A2:A16 sama dengan &#8220;A&#8221; <strong>dan<\/strong> nilai di B2:B16 sama dengan &#8220;Maju&#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-26550 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/grandifexcel1.jpg\" alt=\"\" width=\"456\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: IF KECIL dengan satu kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk mencari nilai terkecil ke-2 pada C2:C16 dimana nilai pada A2:A16 sama dengan \u201cA\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL(IF( <span style=\"color: #3366ff;\">A2:A16<\/span> =\"A\", <span style=\"color: #ff0000;\">C2:C16<\/span> ),2)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26558 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/petitif1.jpg\" alt=\"\" width=\"501\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai poin terendah kedua di antara semua pemain di Tim A adalah <strong>5<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: IF KECIL dengan beberapa kriteria<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk mencari nilai terkecil ke-2 di C2:C16 dimana nilai di A2:A16 sama dengan &#8220;A&#8221; <strong>dan<\/strong> nilai di B2:B16 sama dengan &#8220;Maju&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL(IF(( <span style=\"color: #3366ff;\">A2:A16<\/span> =\"A\")*( <span style=\"color: #ff0000;\">B2:B16<\/span> =\"Forward\"), <span style=\"color: #800080;\">C2:C16<\/span> ),2)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26560 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/petitif2-1.jpg\" alt=\"\" width=\"618\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai poin terendah kedua di antara semua penyerang di Tim A adalah <strong>10<\/strong> .<\/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 Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jika-median-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menggunakan Fungsi Median IF di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/besar-jika-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi IF BESAR di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentil-jika-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan fungsi persentil IF di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menjalankan fungsi IF KECIL di Excel: Rumus 1: IF KECIL dengan satu kriteria =SMALL(IF( A2:A16 =&#8221;A&#8221;, C2:C16 ),2) Rumus ini mencari nilai terkecil ke-2 pada C2:C16 dimana nilai pada A2:A16 sama dengan &#8220;A&#8221;. Rumus 2: IF KECIL dengan beberapa kriteria =SMALL(IF(( A2:A16 =&#8221;A&#8221;)*( B2:B16 =&#8221;Forward&#8221;), C2:C16 ),2) Rumus ini [&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 Fungsi IF KECIL di Excel (Dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL 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\/kecil-jika-unggul\/\" \/>\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 KECIL di Excel (Dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kecil-jika-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T03:56:25+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\/kecil-jika-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/kecil-jika-unggul\/\",\"name\":\"Cara Menggunakan Fungsi IF KECIL di Excel (Dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T03:56:25+00:00\",\"dateModified\":\"2023-07-19T03:56:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kecil-jika-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kecil-jika-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kecil-jika-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi small 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 KECIL di Excel (Dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL 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\/kecil-jika-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi IF KECIL di Excel (Dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-19T03:56:25+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\/kecil-jika-unggul\/","url":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/","name":"Cara Menggunakan Fungsi IF KECIL di Excel (Dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T03:56:25+00:00","dateModified":"2023-07-19T03:56:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi IF KECIL di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kecil-jika-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kecil-jika-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi small 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\/3113"}],"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=3113"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3113\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}