{"id":3941,"date":"2023-07-14T15:05:37","date_gmt":"2023-07-14T15:05:37","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/"},"modified":"2023-07-14T15:05:37","modified_gmt":"2023-07-14T15:05:37","slug":"excel-min-kecualikan-0","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/","title":{"rendered":"Excel: cara menggunakan fungsi min dan kecualikan nol"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan fungsi <strong>MIN<\/strong> di Excel untuk menemukan nilai minimum dalam suatu rentang sambil mengecualikan sel yang bernilai nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL( <span style=\"color: #3366ff;\">B2:B15<\/span> ,COUNTIF( <span style=\"color: #3366ff;\">$B$2:$B$15<\/span> ,0)+1)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menemukan nilai minimum dalam rentang sel B2:B15, tidak termasuk semua sel yang bernilai nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan terlebih dahulu menggunakan <strong>COUNTIF()<\/strong> untuk menghitung jumlah angka nol dan menambahkan satu, kemudian menggunakan fungsi <strong>SMALL()<\/strong> untuk mengembalikan nilai bukan nol terkecil ke- <sup>k<\/sup> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Menggunakan Fungsi MIN dan Mengecualikan Nol di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan jumlah penjualan yang dilakukan oleh berbagai karyawan sebuah perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31681 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/min1.jpg\" alt=\"\" width=\"465\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk mencari nilai minimum pada kolom penjualan tidak termasuk semua nilai yang sama dengan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SMALL( <span style=\"color: #3366ff;\">B2:B15<\/span> ,COUNTIF( <span style=\"color: #3366ff;\">$B$2:$B$15<\/span> ,0)+1)<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>D2<\/strong> , lalu tekan Enter:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31682\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/min2.jpg\" alt=\"Excel min tidak termasuk nol\" width=\"572\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya terlihat bahwa nilai minimum pada kolom penjualan (tidak termasuk semua nilai nol) adalah <strong>2<\/strong> .<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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\">Excel: Cara mencari nilai maksimum berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung median berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung rata-rata berdasarkan kelompok<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan fungsi MIN di Excel untuk menemukan nilai minimum dalam suatu rentang sambil mengecualikan sel yang bernilai nol: =SMALL( B2:B15 ,COUNTIF( $B$2:$B$15 ,0)+1) Rumus khusus ini menemukan nilai minimum dalam rentang sel B2:B15, tidak termasuk semua sel yang bernilai nol. Rumus ini bekerja dengan terlebih dahulu menggunakan COUNTIF() [&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 fungsi MIN dan mengecualikan nol - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.\" \/>\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-kecualikan-0\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menggunakan fungsi MIN dan mengecualikan nol - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T15:05:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/min1.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-min-kecualikan-0\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/\",\"name\":\"Excel: Cara menggunakan fungsi MIN dan mengecualikan nol - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T15:05:37+00:00\",\"dateModified\":\"2023-07-14T15:05:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menggunakan fungsi min dan kecualikan nol\"}]},{\"@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 fungsi MIN dan mengecualikan nol - Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.","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-kecualikan-0\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menggunakan fungsi MIN dan mengecualikan nol - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.","og_url":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/","og_site_name":"Statorials","article_published_time":"2023-07-14T15:05:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/min1.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-min-kecualikan-0\/","url":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/","name":"Excel: Cara menggunakan fungsi MIN dan mengecualikan nol - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T15:05:37+00:00","dateModified":"2023-07-14T15:05:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai minimum di Excel, tidak termasuk sel yang mungkin memiliki nilai 0.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menggunakan fungsi min dan kecualikan nol"}]},{"@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\/3941"}],"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=3941"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3941\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}