{"id":4965,"date":"2023-07-05T20:10:04","date_gmt":"2023-07-05T20:10:04","guid":{"rendered":"https:\/\/statorials.org\/id\/unggul-2\/"},"modified":"2023-07-05T20:10:04","modified_gmt":"2023-07-05T20:10:04","slug":"unggul-2","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/unggul-2\/","title":{"rendered":"Cara menggunakan fungsi dmin di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan fungsi <b>DMIN<\/b> di Excel untuk menemukan nilai minimum di kolom yang memenuhi satu atau beberapa kondisi tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>DMIN (database, kolom, kriteria)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>database<\/strong> : Rentang sel yang membentuk \u201cdatabase\u201d yang diinginkan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>field<\/strong> : Kolom untuk mencari nilai minimum<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kriteria<\/strong> : Rentang sel yang berisi kondisi yang harus dipenuhi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi <b>DMIN<\/b> dalam praktik dengan kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38744 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dmax1.png\" alt=\"\" width=\"501\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan DMIN dengan syarat<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mencari nilai minimum pada kolom &#8220;Poin&#8221; dimana nilai pada kolom &#8220;Tim&#8221; adalah Mavs.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa memasukkan kriteria kita di rentang <strong>A2:D3<\/strong> dan kemudian menggunakan rumus berikut dengan fungsi <b>DMIN<\/b> di sel <strong>G2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=DMIN( <span style=\"color: #3366ff;\">A5:D16<\/span> , \"Points\", <span style=\"color: #ff0000;\">A2:D3<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38751\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dmin1.png\" alt=\"Contoh fungsi DMIN Excel\" width=\"582\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai minimum di kolom \u201cPoin\u201d di mana nilai yang sesuai di kolom \u201cTim\u201d adalah Mavs adalah <strong>20<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan DMIN dengan beberapa ketentuan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mencari nilai minimum di kolom \u201cPentalan\u201d jika kondisi berikut terpenuhi:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai pada kolom \u201cTim\u201d adalah Mavs<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai pada kolom \u201cPoin\u201d lebih besar dari 20<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita bisa memasukkan kriteria kita di rentang <strong>A2:D3<\/strong> dan kemudian menggunakan rumus berikut dengan fungsi <b>DMIN<\/b> di sel <strong>G2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=DMIN( <span style=\"color: #3366ff;\">A5:D16<\/span> , \"Rebounds\", <span style=\"color: #ff0000;\">A2:D3<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38752 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dmin2.png\" alt=\"\" width=\"571\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <b>2<\/b> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai minimum di kolom \u201cRebound\u201d di antara pemain tim Mavs dengan nilai poin lebih besar dari 20 adalah <strong>2<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/nilai-minimum-vlookup-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan VLOOKUP untuk Mengembalikan Nilai Minimum<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-min-jika-banyak-kriteria\/\" target=\"_blank\" rel=\"noopener\">Excel: Rumus beberapa kriteria IF minimum<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-min-kecualikan-0\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Menggunakan Fungsi MIN dan Kecualikan Nol<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan fungsi DMIN di Excel untuk menemukan nilai minimum di kolom yang memenuhi satu atau beberapa kondisi tertentu. Fungsi ini menggunakan sintaks dasar berikut: DMIN (database, kolom, kriteria) Emas: database : Rentang sel yang membentuk \u201cdatabase\u201d yang diinginkan field : Kolom untuk mencari nilai minimum kriteria : Rentang sel yang berisi kondisi yang [&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 DMIN di Excel (Dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta 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\/unggul-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi DMIN di Excel (Dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/unggul-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T20:10:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dmax1.png\" \/>\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\/unggul-2\/\",\"url\":\"https:\/\/statorials.org\/id\/unggul-2\/\",\"name\":\"Cara Menggunakan Fungsi DMIN di Excel (Dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T20:10:04+00:00\",\"dateModified\":\"2023-07-05T20:10:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/unggul-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/unggul-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/unggul-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi dmin di excel (dengan 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 DMIN di Excel (Dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta 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\/unggul-2\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi DMIN di Excel (Dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta contoh.","og_url":"https:\/\/statorials.org\/id\/unggul-2\/","og_site_name":"Statorials","article_published_time":"2023-07-05T20:10:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dmax1.png"}],"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\/unggul-2\/","url":"https:\/\/statorials.org\/id\/unggul-2\/","name":"Cara Menggunakan Fungsi DMIN di Excel (Dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T20:10:04+00:00","dateModified":"2023-07-05T20:10:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi DMIN di Excel untuk mencari nilai minimum dalam database berdasarkan kriteria, beserta contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/unggul-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/unggul-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/unggul-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi dmin di excel (dengan 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\/4965"}],"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=4965"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4965\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}