{"id":9015,"date":"2024-12-31T10:57:35","date_gmt":"2024-12-31T10:57:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/cach-su-dung-ham-min-trong-excel-co-ban-de-hieu-nhat\/"},"modified":"2024-12-31T10:57:35","modified_gmt":"2024-12-31T10:57:35","slug":"cach-su-dung-ham-min-trong-excel-co-ban-de-hieu-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/cach-su-dung-ham-min-trong-excel-co-ban-de-hieu-nhat\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MIN trong Excel c\u01a1 b\u1ea3n d\u1ec5 hi\u1ec3u nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft l\u1ea7n tr\u01b0\u1edbc v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-max-so-sanh-hai-hoac-nhieu-gia-tri.html\"><strong>h\u00e0m MAX<\/strong><\/a>, ta \u0111\u00e3 hi\u1ec3u c\u00e1ch m\u00e0 h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng trong Excel ra sao. L\u1ea7n n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd \u0111\u01b0a t\u1edbi c\u00e1c b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 <strong>h\u00e0m MIN<\/strong> t\u1eeb l\u00fd thuy\u1ebft cho t\u1edbi c\u00e1ch n\u00f3 v\u1eadn h\u00e0nh.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6773ce1f06c86\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-min-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel.html#Cong_dung_va_cong_thuc_cua_ham_MIN\" title=\"C\u00f4ng d\u1ee5ng v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m MIN\">C\u00f4ng d\u1ee5ng v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m MIN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-min-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel.html#Luu_y\" title=\"L\u01b0u \u00fd:\">L\u01b0u \u00fd:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-min-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-min-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel.html#Su_dung_ham_MIN_thay_cho_ham_IF\" title=\"S\u1eed d\u1ee5ng h\u00e0m MIN thay cho h\u00e0m IF\">S\u1eed d\u1ee5ng h\u00e0m MIN thay cho h\u00e0m IF<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_dung_va_cong_thuc_cua_ham_MIN\"><\/span>C\u00f4ng d\u1ee5ng v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m MIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m MIN s\u1ebd tra\u0309 v\u00ea\u0300 s\u00f4\u0301 nho\u0309 nh\u1ea5t trong t\u1eadp gi\u00e1 tr\u1ecb.<\/p>\n<p>H\u00e0m MIN c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=MIN(s\u1ed1 th\u1ee9 nh\u1ea5t, [s\u1ed1 th\u1ee9 hai],\u2026)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>s\u1ed1 th\u1ee9 nh\u1ea5t<\/strong> v\u00e0\u00a0<strong>s\u1ed1 th\u1ee9 hai<\/strong> l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb nh\u1eadp v\u00e0o t\u1eeb b\u00e0n ph\u00edm, nh\u1eefng c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu t\u1edbi \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb. T\u1ed1i \u0111a l\u00e0 255 s\u1ed1.<\/p>\n<p>N\u1ebfu h\u00e0m MIN ch\u1ec9 ch\u1ee9a\u00a0<strong>s\u1ed1 th\u1ee9 nh\u1ea5t<\/strong>, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb c\u1ee7a s\u1ed1 \u0111\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y\"><\/span><strong>L\u01b0u \u00fd:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<ul>\n<li>\n<p class=\"\">\u0110\u00f4\u0301i s\u00f4\u0301 co\u0301 th\u00ea\u0309 la\u0300 s\u00f4\u0301 ho\u0103\u0323c t\u00ean, ma\u0309ng ho\u0103\u0323c tham chi\u00ea\u0301u co\u0301 ch\u01b0\u0301a s\u00f4\u0301.<\/p>\n<\/li>\n<li>Ca\u0301c gia\u0301 tri\u0323 l\u00f4-gic va\u0300 tri\u0300nh ba\u0300y s\u00f4\u0301 da\u0323ng v\u0103n ba\u0309n ma\u0300 ba\u0323n go\u0303 tr\u01b0\u0323c ti\u00ea\u0301p va\u0300o danh sa\u0301ch ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 se\u0303 \u0111\u01b0\u01a1\u0323c \u0111\u00ea\u0301m.<\/li>\n<li>N\u00ea\u0301u \u0111\u00f4\u0301i s\u00f4\u0301 la\u0300 ma\u0309ng hay tham chi\u00ea\u0301u, chi\u0309 ca\u0301c s\u00f4\u0301 trong ma\u0309ng hay tham chi\u00ea\u0301u \u0111o\u0301 m\u01a1\u0301i \u0111\u01b0\u01a1\u0323c du\u0300ng. Ca\u0301c \u00f4 tr\u00f4\u0301ng, gia\u0301 tri\u0323 l\u00f4-gic ho\u0103\u0323c v\u0103n ba\u0309n trong ma\u0309ng ho\u0103\u0323c tham chi\u00ea\u0301u bi\u0323 bo\u0309 qua.<\/li>\n<li>N\u00ea\u0301u ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 kh\u00f4ng ch\u01b0\u0301a s\u00f4\u0301, ha\u0300m MIN tra\u0309 v\u00ea\u0300 0.<\/li>\n<li>Ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 la\u0300 v\u0103n ba\u0309n hay gia\u0301 tri\u0323 l\u00f4\u0303i kh\u00f4ng th\u00ea\u0309 chuy\u00ea\u0309n \u0111\u00f4\u0309i tha\u0300nh s\u00f4\u0301 se\u0303 khi\u00ea\u0301n xa\u0309y ra l\u00f4\u0303i.<\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n bao g\u1ed3m gi\u00e1 tr\u1ecb l\u00f4-gic v\u00e0 bi\u1ec3u th\u1ecb v\u0103n b\u1ea3n c\u1ee7a s\u1ed1 v\u00e0o m\u1ed9t tham chi\u1ebfu nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a ph\u00e9p t\u00ednh, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m MINA.<\/li>\n<\/ul>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26078\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-min-1.png\" width=\"580\" height=\"296\" title=\"ham-min-1\"><\/p>\n<p>H\u00e0m MIN s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n trong danh s\u00e1ch c\u00e1c s\u1ed1.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-848.gif\" title=\"ex101_92019-nho-848\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_MIN_thay_cho_ham_IF\"><\/span>S\u1eed d\u1ee5ng h\u00e0m MIN thay cho h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MIN thay cho IF, v\u00ed d\u1ee5:<\/p>\n<p><strong>=IF(s\u1ed1 th\u1ee9 nh\u1ea5t &lt; s\u1ed1 th\u1ee9 hai, s\u1ed1 th\u1ee9 nh\u1ea5t, s\u1ed1 th\u1ee9 hai)<\/strong><\/p>\n<p>Ta c\u00f3 th\u1ec3 thay c\u00f4ng th\u1ee9c \u0111\u00f3 b\u1eb1ng h\u00e0m MIN:<\/p>\n<p><strong>=MIN(s\u1ed1 th\u1ee9 nh\u1ea5t, s\u1ed1 th\u1ee9 hai)<\/strong><\/p>\n<p>V\u1ec1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 trong th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft sau:\u00a0<strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/dung-ham-max-thay-cho-if.html\">MIN MAX thay th\u1ebf IF<\/a> trong 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p.<\/strong><\/p>\n<p>Xem th\u00eam c\u00e1c h\u00e0m li\u00ean quan:<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-co-ban-qua-cac-vi-du-don-gian.html\">H\u00e0m IF<\/a> cho ng\u01b0\u1eddi m\u1edbi<\/strong><\/p>\n<p><strong>19 tips h\u1eefu hi\u1ec7u v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/19-tips-huu-hieu-cho-ham-if-long-nhau.html\">h\u00e0m IF l\u1ed3ng nhau<\/a> (Ph\u1ea7n 1)<\/strong><\/p>\n<p><strong>19 tips h\u1eefu hi\u1ec7u v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html\">h\u00e0m IF l\u1ed3ng nhau<\/a> (Ph\u1ea7n 2)<\/strong><\/p>\n<p><em>Kh\u00f4ng h\u1ec1 kh\u00f3 \u0111\u1ec3 s\u1eed d\u1ee5ng <strong>h\u00e0m MIN<\/strong> so s\u00e1nh hai ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb trong Excel ph\u1ea3i kh\u00f4ng n\u00e0o? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> nh\u00e9.<\/em><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-848.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9015","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9015"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9015\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9016"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}