{"id":3770,"date":"2024-12-03T03:58:25","date_gmt":"2024-12-03T03:58:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-ham-max-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel\/"},"modified":"2024-12-03T03:58:25","modified_gmt":"2024-12-03T03:58:25","slug":"huong-dan-ham-max-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-ham-max-so-sanh-hai-hoac-nhieu-gia-tri-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m MAX so s\u00e1nh hai ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm c\u00e1ch so s\u00e1nh hai ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb trong Excel xem gi\u00e1 tr\u1ecb n\u00e0o l\u1edbn h\u01a1n. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta s\u1eed d\u1ee5ng <strong>h\u00e0m MAX.\u00a0<\/strong>C\u1ee5 th\u1ec3, h\u00e3y xem b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/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-674e81e09fd55\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-max-so-sanh-hai-hoac-nhieu-gia-tri.html#Cong_thuc_ham_MAX_%E2%80%93_giup_tim_gia_tri_lon_nhat\" title=\"C\u00f4ng th\u1ee9c h\u00e0m MAX \u2013 gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\">C\u00f4ng th\u1ee9c h\u00e0m MAX \u2013 gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-max-so-sanh-hai-hoac-nhieu-gia-tri.html#Ung_dung_ham\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m\">\u1ee8ng d\u1ee5ng h\u00e0m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-max-so-sanh-hai-hoac-nhieu-gia-tri.html#Mot_cach_so_sanh_khac_su_dung_IF\" title=\"M\u1ed9t c\u00e1ch so s\u00e1nh kh\u00e1c s\u1eed d\u1ee5ng IF\">M\u1ed9t c\u00e1ch so s\u00e1nh kh\u00e1c s\u1eed d\u1ee5ng IF<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_MAX_%E2%80%93_giup_tim_gia_tri_lon_nhat\"><\/span>C\u00f4ng th\u1ee9c h\u00e0m MAX \u2013 gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m MAX c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=MAX(s\u1ed1 th\u1ee9 nh\u1ea5t, [s\u1ed1 th\u1ee9 2], \u2026)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>s\u1ed1 th\u1ee9 nh\u1ea5t<\/strong> l\u00e0 b\u1eaft bu\u1ed9c. \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, bi\u1ec3u th\u1ee9c ho\u1eb7c tham chi\u1ebfu.<\/p>\n<p>N\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1 kh\u00f4ng ch\u1ee9a s\u1ed1, h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0\u00a0<strong>0.<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_ham\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MAX \u0111\u1ec3 so s\u00e1nh hai ho\u1eb7c nhi\u1ec1u gi\u00e1 tr\u1ecb xem \u0111\u00e2u l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u1ee7a m\u1ea3ng gi\u00e1 tr\u1ecb.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25763\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-max-1.png\" width=\"354\" height=\"270\" title=\"ham-max-1\"><\/p>\n<p>T\u1ea1i \u00f4 C3, nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<strong>=MAX(A3,B3)<\/strong> sau \u0111\u00f3 s\u1eed d\u1ee5ng Filldown \u0111i\u1ec1n cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/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-295.gif\" title=\"ex101_92019-nho-295\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ta c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng v\u1edbi nhi\u1ec1u gi\u00e1 tr\u1ecb h\u01a1n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25764\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-max-2.png\" width=\"452\" height=\"272\" title=\"ham-max-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mot_cach_so_sanh_khac_su_dung_IF\"><\/span>M\u1ed9t c\u00e1ch so s\u00e1nh kh\u00e1c s\u1eed d\u1ee5ng IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c tr\u00ean ta c\u00f3 th\u1ec3 vi\u1ebft l\u1ea1i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-co-ban-qua-cac-vi-du-don-gian.html\"><strong>h\u00e0m IF<\/strong><\/a> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=IF(s\u1ed1 th\u1ee9 nh\u1ea5t &gt; s\u1ed1 th\u1ee9 hai, s\u1ed1 th\u1ee9 nh\u1ea5t, s\u1ed1 th\u1ee9 hai)<\/strong><\/p>\n<\/blockquote>\n<p>Ho\u1eb7c c\u1ee5 th\u1ec3:<\/p>\n<p><strong><em>=IF(A3&gt;B3,A3,B3)<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25765\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-max-3.png\" width=\"363\" height=\"270\" title=\"ham-max-3\"><\/p>\n<p>Tuy nhi\u00ean, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>MAX<\/strong> nhanh g\u1ecdn hi\u1ec7u qu\u1ea3 h\u01a1n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>\u00a0<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-if-co-ban-qua-cac-vi-du-don-gian.html\"><strong>H\u00e0m IF cho ng\u01b0\u1eddi m\u1edbi<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-excel-co-loi-phan-1.html\"><strong>B\u00e0i t\u1eadp Excel li\u00ean quan c\u00e1c h\u00e0m c\u01a1 b\u1ea3n<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-min-max-theo-dieu-kien-trong-excel.html\">T\u00ednh min max theo \u0111i\u1ec1u ki\u1ec7n Excel<\/a><\/strong><\/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-295.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3770","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\/3770","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=3770"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3770\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3771"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}