{"id":4258,"date":"2023-07-12T11:33:52","date_gmt":"2023-07-12T11:33:52","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/"},"modified":"2023-07-12T11:33:52","modified_gmt":"2023-07-12T11:33:52","slug":"google-sheet-min-kecualikan-0","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/","title":{"rendered":"Google spreadsheet: cara menggunakan fungsi min dan mengecualikan nol"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada dua cara umum menggunakan fungsi <strong>MIN<\/strong> di Google Spreadsheet untuk menemukan nilai minimum dalam suatu rentang sambil mengecualikan sel yang bernilai nol:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan MIN dan FILTER<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MIN(FILTER( <span style=\"color: #ff6600;\">B2:B15<\/span> , <span style=\"color: #ff6600;\">B2:B15<\/span> &lt;&gt; <span style=\"color: #3366ff;\">0<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan MINIFS<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">MINIFS<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B15<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B15<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">&lt;&gt;0<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kedua rumus tersebut mencari nilai minimum dalam rentang sel <strong>B2:B15<\/strong> , tidak termasuk semua sel yang bernilai nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik dengan kumpulan data berikut<\/span> <span style=\"color: #000000;\">yang menunjukkan jumlah penjualan yang dilakukan oleh karyawan berbeda di suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33620 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minex1.jpg\" alt=\"\" width=\"493\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Menggunakan MIN &amp; FILTER<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut dengan fungsi <strong>MIN<\/strong> dan <strong>FILTER<\/strong> 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>=MIN(FILTER( <span style=\"color: #ff6600;\">B2:B15<\/span> , <span style=\"color: #ff6600;\">B2:B15<\/span> &lt;&gt; <span style=\"color: #3366ff;\">0<\/span> ))<\/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-33622\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minex2-1.jpg\" alt=\"Fungsi Google Sheets MIN tidak termasuk angka nol\" width=\"561\" height=\"487\" 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<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan terlebih dahulu memfilter rentang nilai yang tidak sama dengan nol, lalu mencari nilai minimum yang tersisa.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: menggunakan MINIFS<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Rumus berikut dapat digunakan dengan fungsi <strong>MINIFS<\/strong> 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;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">MINIFS<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B15<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B15<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">&lt;&gt;0<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/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-33623\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minex3.jpg\" alt=\"Fungsi MINIFS Google Sheets tidak termasuk nol\" width=\"537\" height=\"457\" 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<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan mencari nilai minimum dalam rentang hanya <i>jika<\/i> nilai dalam rentang tersebut tidak sama dengan nol.<\/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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/nilai-maksimal-google-sheet-per-grup\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara menemukan nilai maksimum berdasarkan grup<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-google-sheet-tidak-termasuk-outlier\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: hitung rata-rata tidak termasuk outlier<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menghitung rata-rata yang dipangkas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada dua cara umum menggunakan fungsi MIN di Google Spreadsheet untuk menemukan nilai minimum dalam suatu rentang sambil mengecualikan sel yang bernilai nol: Metode 1: Gunakan MIN dan FILTER =MIN(FILTER( B2:B15 , B2:B15 &lt;&gt; 0 )) Metode 2: Gunakan MINIFS = MINIFS ( B2:B15 , B2:B15 , &#8221; &lt;&gt;0 &#8221; ) Kedua rumus tersebut mencari [&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>Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.\" \/>\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\/google-sheet-min-kecualikan-0\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T11:33:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minex1.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\/google-sheet-min-kecualikan-0\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/\",\"name\":\"Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T11:33:52+00:00\",\"dateModified\":\"2023-07-12T11:33:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menggunakan fungsi min dan mengecualikan 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":"Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.","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\/google-sheet-min-kecualikan-0\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.","og_url":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/","og_site_name":"Statorials","article_published_time":"2023-07-12T11:33:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/minex1.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\/google-sheet-min-kecualikan-0\/","url":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/","name":"Google Spreadsheet: Cara menggunakan fungsi MIN dan mengecualikan nol - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T11:33:52+00:00","dateModified":"2023-07-12T11:33:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi MIN di Google Sheets untuk menemukan nilai minimum dalam suatu rentang, tidak termasuk nol.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-min-kecualikan-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menggunakan fungsi min dan mengecualikan 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\/4258"}],"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=4258"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4258\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}