{"id":5573,"date":"2024-12-16T16:40:00","date_gmt":"2024-12-16T16:40:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-su-dung-cong-thuc-mang-trong-excel\/"},"modified":"2024-12-16T16:40:00","modified_gmt":"2024-12-16T16:40:00","slug":"huong-dan-cach-su-dung-cong-thuc-mang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-su-dung-cong-thuc-mang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00e0o c\u00e1c b\u1ea1n,<\/p>\n<p>\u0110\u00f4i khi ch\u00fang ta b\u1eaft g\u1eb7p tr\u00ean\u00a0Excel m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c n\u1eb1m trong d\u1ea5u\u00a0{ \u2026\u00a0} v\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13020 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-me1baa3ng-pic01.png\" width=\"509\" height=\"263\" title=\"cc3b4ng-the1bba9c-me1baa3ng-pic01\"><\/p>\n<p>C\u00f4ng th\u1ee9c\u00a0\u1edf\u00a0\u00f4 C7 c\u00f3 k\u1ebft qu\u1ea3 =4, n\u1ed9i dung c\u00f4ng th\u1ee9c l\u00e0\u00a0{=MAX(B2:B5_C2:C5)}<\/p>\n<p>Nh\u01b0ng n\u1ebfu nh\u01b0 ch\u1ec9 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0=MAX(B2:B5_C2:C5) th\u00ec s\u1ebd ra k\u1ebft qu\u1ea3 l\u1ed7i.<\/p>\n<p>=&gt;\u00a0\u1ede\u00a0\u0111\u00e2y\u00a0\u0111\u00e3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng t\u1ea1i\u00a0\u00f4 C7, k\u00fd hi\u1ec7u\u00a0{\u00a0} l\u00e0 k\u00fd hi\u1ec7u ch\u1ee9ng t\u1ecf c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3 l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng.<\/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-676057dfdab31\" 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\/ung-dung-excel-tim-hieu-ve-cong-thuc-mang-trong-excel.html#1_Cong_thuc_mang_la_gi\" title=\"1.\u00a0C\u00f4ng th\u1ee9c m\u1ea3ng l\u00e0 g\u00ec?\">1.\u00a0C\u00f4ng th\u1ee9c m\u1ea3ng l\u00e0 g\u00ec?<\/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\/ung-dung-excel-tim-hieu-ve-cong-thuc-mang-trong-excel.html#2_Cach_hoat_dong_cua_cong_thuc_mang\" title=\"2. C\u00e1ch ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng\">2. C\u00e1ch ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng<\/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\/ung-dung-excel-tim-hieu-ve-cong-thuc-mang-trong-excel.html#3_Dac_diem_cua_cong_thuc_mang\" title=\"3.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng\">3.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Cong_thuc_mang_la_gi\"><\/span>1.\u00a0C\u00f4ng th\u1ee9c m\u1ea3ng l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\"><strong>C\u00f4ng th\u1ee9c m\u1ea3ng<\/strong><\/a> l\u00e0 c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a tham chi\u1ebfu t\u1edbi c\u00e1c m\u1ea3ng.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-201.gif\" title=\"vba101_92019-nho-201\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-485.gif\" title=\"ex101_92019-nho-485\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>M\u1ea3ng c\u00f3 th\u1ec3 l\u00e0 1 v\u00f9ng\u00a0\u00f4, ho\u1eb7c m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ed7i ph\u1ea7n t\u1eed trong v\u00f9ng\u00a0\u00f4\u00a0\u0111\u00f3.<\/p>\n<p><em>V\u00ed d\u1ee5: C\u00f4ng th\u1ee9c m\u1ea3ng x\u00e9t ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a m\u1ed7i ph\u1ea7n t\u1eed trong v\u00f9ng A2:A5, x\u00e9t 4 k\u00fd t\u1ef1 ph\u00eda b\u00ean tr\u00e1i c\u1ee7a m\u1ed7i ph\u1ea7n t\u1eed.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13021 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-me1baa3ng-pic02.png\" width=\"493\" height=\"268\" title=\"cc3b4ng-the1bba9c-me1baa3ng-pic02\"><\/p>\n<p>C\u00f4ng th\u1ee9c m\u1ea3ng c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t\u00a0\u1edf nhi\u1ec1u\u00a0\u00f4, ho\u1eb7c\u00a0\u1edf 1\u00a0nh\u00f3m\u00a0\u00f4. Khi\u00a0\u0111\u1eb7t cho 1 nh\u00f3m\u00a0\u00f4 th\u00ec to\u00e0n b\u1ed9 nh\u00f3m\u00a0\u00f4\u00a0\u0111\u00f3\u00a0\u0111\u1ec1u ch\u1ee9a c\u00f9ng 1 c\u00f4ng th\u1ee9c m\u1ea3ng, t\u1ea1i m\u1ed7i v\u1ecb tr\u00ed s\u1ebd cho 1 k\u1ebft qu\u1ea3 kh\u00e1c nhau t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u00e1c ph\u1ea7n t\u1eed trong m\u1ea3ng<\/p>\n<p><em>V\u00ed d\u1ee5: l\u1ea5y 2 k\u00fd t\u1ef1 b\u00ean tr\u00e1i c\u1ee7a m\u1ed7i ph\u1ea7n t\u1eed trong m\u1ea3ng t\u1eeb A2:A5<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13022 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-me1baa3ng-pic03.png\" width=\"470\" height=\"360\" title=\"cc3b4ng-the1bba9c-me1baa3ng-pic03\"><\/p>\n<p>C\u00f4ng th\u1ee9c m\u1ea3ng\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n khi k\u1ebft th\u00fac c\u00f4ng th\u1ee9c b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter (thay v\u00ec ch\u1ec9 s\u1eed d\u1ee5ng ph\u00edm Enter th\u00f4ng th\u01b0\u1eddng)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Cach_hoat_dong_cua_cong_thuc_mang\"><\/span>2. C\u00e1ch ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u1edf l\u1ea1i v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13020 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-me1baa3ng-pic01.png\" width=\"509\" height=\"263\" title=\"cc3b4ng-the1bba9c-me1baa3ng-pic01\"><\/p>\n<p>Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng n\u00e0y\u00a0\u0111\u1ec3 gi\u1ea3i th\u00edch t\u1ea1i sao k\u1ebft qu\u1ea3 l\u1ea1i = 4<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13023 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-me1baa3ng-pic04.png\" width=\"587\" height=\"271\" title=\"cc3b4ng-the1bba9c-me1baa3ng-pic04\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c m\u1ea3ng\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c ho\u1ea1t\u00a0\u0111\u1ed9ng nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e9t hi\u1ec7u\u00a0t\u1eebng ph\u1ea7n t\u1eed trong m\u1ed7i m\u1ea3ng (Ph\u1ea7n t\u1eed B2 c\u1ee7a m\u1ea3ng B2:B5 \u2013 Ph\u1ea7n t\u1eed C2 c\u1ee7a m\u1ea3ng C2:C5)<\/li>\n<li>T\u00ednh s\u1ed1 l\u1edbn nh\u1ea5t trong k\u1ebft qu\u1ea3 t\u1ea1o b\u1edfi vi\u1ec7c x\u00e9t hi\u1ec7u t\u1eebng ph\u1ea7n t\u1eed trong m\u1ed7i m\u1ea3ng<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi 1 c\u00f4ng th\u1ee9c m\u1ea3ng\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 gi\u00fap ch\u00fang ta thu g\u1ecdn qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n\u00a0\u0111i r\u1ea5t nhi\u1ec1u, v\u1eeba ti\u1ebft ki\u1ec7m t\u00e0i nguy\u00ean, v\u1eeba ti\u1ebft ki\u1ec7m th\u1eddi gian x\u1eed l\u00fd b\u1ea3ng t\u00ednh\u00a0\u0111\u1ec3 ra k\u1ebft qu\u1ea3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Dac_diem_cua_cong_thuc_mang\"><\/span>3.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u01afu\u00a0\u0111i\u1ec3m<\/strong><\/p>\n<ul>\n<li>\u0110\u1ed3ng nh\u1ea5t c\u00f4ng th\u1ee9c trong m\u1ed9t v\u00f9ng\u00a0\u00f4 k\u1ebft qu\u1ea3 =&gt; Gi\u00fap\u00a0\u0111\u1ea3m b\u1ea3o m\u1ed7i ph\u1ea7n t\u1eed trong\u00a0\u0111\u00f3\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c t\u00ednh\u00a0\u0111\u00fang<\/li>\n<li>H\u1ea1n ch\u1ebf sai s\u00f3t: B\u1ea1n kh\u00f4ng th\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c c\u1ee7a t\u1eebng ph\u1ea7n t\u1eed trong v\u00f9ng\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c m\u1ea3ng. Khi mu\u1ed1n thay\u00a0\u0111\u1ed5i b\u1ea1n ph\u1ea3i ch\u1ecdn c\u1ea3 v\u00f9ng\u00a0\u0111\u00f3 v\u00e0 s\u1eeda c\u00f4ng th\u1ee9c m\u1ea3ng chung, sau\u00a0\u0111\u00f3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c ph\u1ea3i d\u00f9ng l\u1ea1i thao t\u00e1c ctrl + shift + enter<\/li>\n<li>K\u00edch c\u1ee1 ch\u01b0\u01a1ng tr\u00ecnh nh\u1ecf g\u1ecdn h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian vi\u1ebft c\u00f4ng th\u1ee9c: Thay v\u00ec s\u1eed d\u1ee5ng m\u1ed7i\u00a0\u00f4 1 c\u00f4ng th\u1ee9c g\u1ea7n gi\u1ed1ng nhau, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng duy nh\u1ea5t 1 c\u00f4ng th\u1ee9c m\u1ea3ng. Nh\u01b0 v\u1eady ch\u01b0\u01a1ng tr\u00ecnh t\u00ednh c\u0169ng nhanh h\u01a1n, dung l\u01b0\u1ee3ng th\u1ea5p h\u01a1n.<\/li>\n<\/ul>\n<p><strong>Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m<\/strong><\/p>\n<ul>\n<li>Qu\u00ean s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter =&gt; X\u1ea3y ra l\u1ed7i #N\/A<\/li>\n<li>N\u1ebfu ch\u01b0a hi\u1ec3u v\u1ec1 c\u00f4ng th\u1ee9c m\u1ea3ng th\u00ec r\u1ea5t kh\u00f3 hi\u1ec3u, kh\u00f3 s\u1eed d\u1ee5ng<\/li>\n<li>C\u00f4ng th\u1ee9c m\u1ea3ng tr\u00ean ph\u1ea1m vi qu\u00e1 l\u1edbn, b\u1ecb l\u1ea1m d\u1ee5ng c\u00f3 th\u1ec3 l\u00e0m t\u1ed1c\u00a0\u0111\u1ed9 t\u00ednh to\u00e1n b\u1ecb ch\u1eadm\u00a0\u0111i do kh\u1ed1i l\u01b0\u1ee3ng t\u00ednh to\u00e1n t\u0103ng l\u00ean nhi\u1ec1u<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng th\u1ee9c m\u1ea3ng r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o. C\u00e1c b\u1ea1n c\u1ea7n c\u00e2n nh\u1eafc k\u1ef9 \u01b0u \u0111i\u1ec3m v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 s\u1eed d\u1ee5ng sao cho hi\u1ec7u qu\u1ea3 nh\u1ea5t nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-201.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5573","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=5573"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5573\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5574"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}