{"id":7311,"date":"2024-12-21T17:17:11","date_gmt":"2024-12-21T17:17:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cac-ham-logic-trong-excel-and-or-xor-va-not-cong-thuc-cach-dung-va-vi-du\/"},"modified":"2024-12-21T17:17:11","modified_gmt":"2024-12-21T17:17:11","slug":"cac-ham-logic-trong-excel-and-or-xor-va-not-cong-thuc-cach-dung-va-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cac-ham-logic-trong-excel-and-or-xor-va-not-cong-thuc-cach-dung-va-vi-du\/","title":{"rendered":"C\u00e1c h\u00e0m Logic trong Excel: And, Or, Xor v\u00e0 Not- c\u00f4ng th\u1ee9c, c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y,\u00a0 <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn<strong> c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Logic And, Or, Xor v\u00e0 Not<\/strong> \u0111\u1ed3ng th\u1eddi \u0111\u01b0a ra c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 \u0111\u1ec3 minh h\u1ecda cho c\u00e1ch d\u00f9ng c\u1ee7a ch\u00fang.<\/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-6766f8168429f\" 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\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Tong_quan_ve_ham_logic_trong_Excel\" title=\"T\u1ed5ng quan v\u1ec1 h\u00e0m logic trong Excel\">T\u1ed5ng quan v\u1ec1 h\u00e0m logic trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Su_dung_ham_AND_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m AND trong Excel\">S\u1eed d\u1ee5ng h\u00e0m AND trong Excel<\/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\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Ham_AND_%E2%80%93_cach_dung_thong_thuong\" title=\"H\u00e0m AND \u2013 c\u00e1ch d\u00f9ng th\u00f4ng th\u01b0\u1eddng\">H\u00e0m AND \u2013 c\u00e1ch d\u00f9ng th\u00f4ng th\u01b0\u1eddng<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Ham_AND_ket_hop_%E2%80%93_ham_Excel_cho_dieu_kien_trong_khoang\" title=\"H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng\">H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Su_dung_ham_OR_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m OR trong Excel\">S\u1eed d\u1ee5ng h\u00e0m OR trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Ham_IF_long_ham_OR\" title=\"H\u00e0m IF l\u1ed3ng h\u00e0m OR\">H\u00e0m IF l\u1ed3ng h\u00e0m OR<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Ham_OR_trong_dinh_dang_co_dieu_kien_cua_Excel\" title=\"H\u00e0m OR trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel\">H\u00e0m OR trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Ham_AND_va_OR_trong_mot_cong_thuc\" title=\"H\u00e0m AND v\u00e0\u00a0OR trong m\u1ed9t c\u00f4ng th\u1ee9c\">H\u00e0m AND v\u00e0\u00a0OR trong m\u1ed9t c\u00f4ng th\u1ee9c<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Su_dung_ham_XOR_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m XOR trong Excel\">S\u1eed d\u1ee5ng h\u00e0m XOR trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html#Su_dung_ham_NOT_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m NOT trong Excel\">S\u1eed d\u1ee5ng h\u00e0m NOT trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tong_quan_ve_ham_logic_trong_Excel\"><\/span>T\u1ed5ng quan v\u1ec1 h\u00e0m logic trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel cung c\u1ea5p 4 h\u00e0m logic \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb logic. \u0110\u00f3 l\u00e0 h\u00e0m AND, OR, XOR v\u00e0 NOT. B\u1ea1n nghi\u00ean c\u1ee9u <strong>c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m<\/strong> n\u00e0y khi b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n nhi\u1ec1u h\u01a1n m\u1ed9t so s\u00e1nh trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n ho\u1eb7c ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n thay v\u00ec ch\u1ec9 m\u1ed9t. C\u0169ng nh\u01b0 c\u00e1c ph\u00e9p so s\u00e1nh, c\u00e1c h\u00e0m logic c\u1ee7a Excel tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE khi c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a ch\u00fang \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1.<\/p>\n<p style=\"text-align: justify\">B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y cung c\u1ea5p m\u1ed9t b\u1ea3n t\u00f3m t\u1eaft ng\u1eafn g\u1ecdn v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m logic, gi\u00fap b\u1ea1n ch\u1ecdn \u0111\u00fang c\u00f4ng th\u1ee9c cho c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3.<\/p>\n<table style=\"border-color: #0f0404;height: 550px\" width=\"975\">\n<tbody>\n<tr style=\"height: 55.9204px\">\n<td style=\"width: 40.5682px;height: 55.9204px\"><strong>H\u00e0m<\/strong><\/td>\n<td style=\"width: 205.114px;height: 55.9204px\"><strong>Gi\u1ea3i th\u00edch h\u00e0m<\/strong><\/td>\n<td style=\"width: 126.932px;height: 55.9204px\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<td style=\"width: 426.932px;height: 55.9204px\"><strong>Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 102px\">\n<td style=\"width: 40.5682px;height: 102px\">AND<\/td>\n<td style=\"width: 205.114px;height: 102px\">Tr\u1ea3 v\u1ec1 \u0111\u00fang n\u1ebfu t\u1ea5t c\u1ea3 \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 \u0111\u00fang.<\/td>\n<td style=\"width: 126.932px;height: 102px\"><strong>=AND(A2&gt;=10, B2&lt;5)<\/strong><\/td>\n<td style=\"width: 426.932px;height: 102px\">C\u00f4ng th\u1ee9c n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A2 \u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10, v\u00e0 gi\u00e1 tr\u1ecb trong B2 nh\u1ecf h\u01a1n 5, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 FALSE.<\/td>\n<\/tr>\n<tr style=\"height: 126px\">\n<td style=\"width: 40.5682px;height: 126px\">OR<\/td>\n<td style=\"width: 205.114px;height: 126px\">Tr\u1ea3 v\u1ec1 \u0111\u00fang n\u1ebfu b\u1ea5t k\u00ec \u0111\u1ed1i s\u1ed1 n\u00e0o \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 \u0111\u00fang.<\/td>\n<td style=\"width: 126.932px;height: 126px\"><strong>=OR(A2&gt;=10, B2&lt;5)<\/strong><\/td>\n<td style=\"width: 426.932px;height: 126px\">C\u00f4ng th\u1ee9c n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A2 \u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10, ho\u1eb7c gi\u00e1 tr\u1ecb trong B2 nh\u1ecf h\u01a1n 5, N\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u kh\u00f4ng th\u1ecfa th\u00ec s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 FALSE.<\/td>\n<\/tr>\n<tr style=\"height: 126px\">\n<td style=\"width: 40.5682px;height: 126px\">XOR<\/td>\n<td style=\"width: 205.114px;height: 126px\">Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang n\u1ebfu c\u00f3 ch\u1ec9 m\u1ed9t trong hai<\/td>\n<td style=\"width: 126.932px;height: 126px\"><strong>=XOR(A2&gt;=10, B2&lt;5)<\/strong><\/td>\n<td style=\"width: 426.932px;height: 126px\">C\u00f4ng th\u1ee9c n\u00e0y tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu ho\u1eb7c gi\u00e1 tr\u1ecb trong \u00f4 A2 \u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10, ho\u1eb7c gi\u00e1 tr\u1ecb trong B2 nh\u1ecf h\u01a1n 5, N\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u kh\u00f4ng th\u1ecfa ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u th\u1ecfa th\u00ec s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 FALSE.<\/td>\n<\/tr>\n<tr style=\"height: 126px\">\n<td style=\"width: 40.5682px;height: 126px\">NOT<\/td>\n<td style=\"width: 205.114px;height: 126px\">Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ng\u01b0\u1ee3c v\u1edbi \u0111\u1ed1i s\u1ed1. V\u00ed d\u1ee5: N\u1ebfu \u0111\u1ed1i s\u1ed1 sai, th\u00ec k\u1ebft qu\u1ea3 l\u00e0 \u0111\u00fang v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<td style=\"width: 126.932px;height: 126px\"><strong>=NOT(A2&gt;=10)<\/strong><\/td>\n<td style=\"width: 426.932px;height: 126px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 FALSE n\u1ebfu gi\u00e1 tr\u1ecb trong A1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10; TRUE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>H\u00e0m Logic trong Excel \u2013 s\u1ef1 th\u1eadt v\u00e0 con s\u1ed1:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00e1c h\u00e0m logic, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4, c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 v\u00e0 v\u0103n b\u1ea3n, c\u00e1c gi\u00e1 tr\u1ecb Boolean, to\u00e1n t\u1eed so s\u00e1nh, v\u00e0 c\u00e1c h\u00e0m Excel kh\u00e1c. Tuy nhi\u00ean, t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 <strong>TRUE ho\u1eb7c FALSE<\/strong>, ho\u1eb7c tham chi\u1ebfu ho\u1eb7c m\u1ea3ng c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb logic.<\/li>\n<li>N\u1ebfu m\u1ed9t \u0111\u1ed1i s\u1ed1 c\u1ee7a m\u1ed9t h\u00e0m logic ch\u1ee9a b\u1ea5t k\u1ef3 \u00f4 r\u1ed7ng n\u00e0o, <strong>c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 s\u1ebd b\u1ecb b\u1ecf qua.<\/strong> N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 c\u00e1c \u00f4 r\u1ed7ng, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 <strong>#VALUE! l\u1ed7i.<\/strong><\/li>\n<li>N\u1ebfu m\u1ed9t \u0111\u1ed1i s\u1ed1 c\u1ee7a m\u1ed9t h\u00e0m logic c\u00f3 ch\u1ee9a c\u00e1c s\u1ed1, Th\u00ec <strong>0<\/strong> s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 <strong>FALSE<\/strong>, v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 kh\u00e1c bao g\u1ed3m c\u00e1c s\u1ed1 \u00e2m t\u00ednh l\u00e0 TRUE. V\u00ed d\u1ee5, n\u1ebfu \u00f4 A1: A5 c\u00f3 ch\u1ee9a c\u00e1c con s\u1ed1, c\u00f4ng th\u1ee9c = AND (A1: A5) s\u1ebd tr\u1ea3 v\u1ec1 TRUE n\u1ebfu kh\u00f4ng c\u00f3 \u00f4 n\u00e0o ch\u1ee9a 0, FALSE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/li>\n<li>M\u1ed9t h\u00e0m logic tr\u1ea3 v\u1ec1 <strong>#VALUE<\/strong>! L\u1ed7i n\u1ebfu kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1 n\u00e0o \u0111\u00e1nh gi\u00e1 gi\u00e1 tr\u1ecb logic.<\/li>\n<li>M\u1ed9t h\u00e0m logic tr\u1ea3 v\u1ec1 <strong>#NAME?<\/strong> L\u1ed7i n\u1ebfu b\u1ea1n \u0111\u00e3 b\u1ecf vi\u1ebft sai t\u00ean c\u1ee7a h\u00e0m ho\u1eb7c c\u1ed1 g\u1eafng s\u1eed d\u1ee5ng h\u00e0m trong m\u1ed9t phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc \u0111\u00f3 kh\u00f4ng h\u1ed7 tr\u1ee3 n\u00f3. V\u00ed d\u1ee5, ch\u1ee9c n\u0103ng XOR ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel 2013.<\/li>\n<li>Trong Excel 2013, 2010 v\u00e0 2007, b\u1ea1n c\u00f3 th\u1ec3 bao g\u1ed3m t\u1edbi 255 \u0111\u1ed1i s\u1ed1 trong m\u1ed9t h\u00e0m logic, v\u1edbi \u0111i\u1ec1u ki\u1ec7n t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a c\u00f4ng th\u1ee9c kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 8.192 k\u00fd t\u1ef1. Trong Excel 2003 v\u00e0 th\u1ea5p h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p t\u1ed1i \u0111a 30 \u0111\u1ed1i s\u1ed1 v\u00e0 t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 1.024 k\u00fd t\u1ef1.<\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_AND_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m AND trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong>H\u00e0m AND<\/strong> l\u00e0 h\u00e0m ph\u1ed5 bi\u1ebfn nh\u1ea5t trong c\u00e1c h\u00e0m logic. N\u00f3 c\u00f3 \u00edch khi b\u1ea1n ph\u1ea3i ki\u1ec3m tra m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 ch\u00fang \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, h\u00e0m AND ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n ch\u1ec9 \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e1nh gi\u00e1 l\u00e0 TRUE, FALSE n\u1ebfu kh\u00f4ng.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p cho h\u00e0m AND nh\u01b0 sau:<\/p>\n<pre><code class=\"language-xls\"><strong>AND (logic1, [logical2], ...)<\/strong> <\/code><\/pre>\n<p style=\"text-align: justify\">Logic \u00a0l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 l\u00e0 <strong>TRUE ho\u1eb7c FALSE.<\/strong> \u0110i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean (logic1) \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u, \u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo l\u00e0 t\u00f9y ch\u1ecdn.<\/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-291.gif\" title=\"vba101_92019-nho-291\"><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-658.gif\" title=\"ex101_92019-nho-658\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y nh\u00ecn v\u00e0o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c ch\u1ee9ng minh l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m AND trong c\u00e1c c\u00f4ng th\u1ee9c Excel.<\/p>\n<table style=\"height: 190px\" width=\"921\">\n<tbody>\n<tr>\n<td width=\"197\"><strong>C\u00f4ng th\u1ee9c<\/strong><\/td>\n<td width=\"444\"><strong>Gi\u1ea3i th\u00edch<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"197\"><strong>=AND(A2=\u201dBananas\u201d, B2&gt;C2)<\/strong><\/td>\n<td width=\"444\">Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu A2 ch\u1ee9a \u201cBananas\u201d v\u00e0 B2 l\u1edbn h\u01a1n C2, FALSE n\u1ebfu kh\u00f4ng th\u1ecfa.<\/td>\n<\/tr>\n<tr>\n<td width=\"197\"><strong>=AND(B2&gt;20, B2=C2)<\/strong><\/td>\n<td width=\"444\">Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu B2 l\u1edbn h\u01a1n 20 v\u00e0 B2 b\u1eb1ng C2, FALSE n\u1ebfu kh\u00f4ng th\u1ecfa.<\/td>\n<\/tr>\n<tr>\n<td width=\"197\"><strong>=AND(A2=\u201dBananas\u201d, B2&gt;=30, B2&gt;C2)<\/strong><\/td>\n<td width=\"444\">Tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu A2 ch\u1ee9a \u201cBananas\u201d, B2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 30, v\u00e0 B2 l\u1edbn h\u01a1n C2, FALSE n\u1ebfu kh\u00f4ng th\u1ecfa.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6141\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-136.png\" width=\"600\" height=\"169\" title=\"excel-dialog-box-launcher-1-136\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_AND_%E2%80%93_cach_dung_thong_thuong\"><\/span>H\u00e0m AND \u2013 c\u00e1ch d\u00f9ng th\u00f4ng th\u01b0\u1eddng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu ch\u1ec9 d\u00f9ng h\u00e0m AND th\u00ec n\u00f3 kh\u00f4ng th\u00fa v\u1ecb v\u00e0 c\u00f3 \u00edt h\u1eefu d\u1ee5ng. Nh\u01b0ng n\u1ebfu k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c, AND c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng \u0111\u00e1ng k\u1ec3 kh\u1ea3 n\u0103ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a h\u00e0m AND \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong \u0111\u1ed1i s\u1ed1 logic_test c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF <\/a>\u0111\u1ec3 ki\u1ec3m tra m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n thay v\u00ec ch\u1ec9 m\u1ed9t. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng b\u1ea5t k\u1ef3 h\u00e0m AND n\u00e0o b\u00ean tr\u00ean v\u00e0o h\u00e0m IF v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= IF (and(A2 = \u201cBananas\u201d, B2&gt; C2), \u201cGood\u201d, \u201cBad\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-and-if-functions.png\" alt=\"An example of the IF formula with a nested AND function\" title=\"excel-and-if-functions\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_AND_ket_hop_%E2%80%93_ham_Excel_cho_dieu_kien_trong_khoang\"><\/span>H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c kho\u1ea3ng m\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa hai gi\u00e1 tr\u1ecb, m\u1ed9t c\u00e1ch ph\u1ed5 bi\u1ebfn l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi AND trong ph\u00e9p th\u1eed logic.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 3 gi\u00e1 tr\u1ecb trong c\u1ed9t A, B v\u00e0 C v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t A n\u1eb1m gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb B v\u00e0 C. \u0110\u1ec3 t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady, t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec c\u1ea7n l\u00e0 h\u00e0m IF v\u1edbi c\u00e1c to\u00e1n t\u1eed so s\u00e1nh l\u1ed3ng nhau AND v\u00e0 m\u1ed9t s\u1ed1 to\u00e1n t\u1eed so s\u00e1nh:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra n\u1ebfu X n\u1eb1m gi\u1eefa Y v\u00e0 Z, bao g\u1ed3m:<\/p>\n<p style=\"text-align: justify\">= IF (AND (A2&gt; = B2, A2 &lt;= C2), \u201cYes\u201d, \u201cNo\u201d)<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra n\u1ebfu X n\u1eb1m gi\u1eefa Y v\u00e0 Z, kh\u00f4ng bao g\u1ed3m:<\/p>\n<p style=\"text-align: justify\">= IF (AND (A2&gt; B2, A2 &lt;C2), \u201cYes\u201d, \u201cNo\u201d)<\/p>\n<figure style=\"width: 477px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m AND k\u1ebft h\u1ee3p - h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-between-formula.png\" alt=\"An Excel formula for the BETWEEN condition\" width=\"477\" height=\"374\"><figcaption class=\"wp-caption-text\">H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 tr\u00ecnh b\u00e0y trong h\u00ecnh \u1edf tr\u00ean, c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ho\u00e0n h\u1ea3o cho t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u \u2013 s\u1ed1, ng\u00e0y v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. Khi so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, c\u00f4ng th\u1ee9c s\u1ebd ki\u1ec3m tra t\u1eebng k\u00fd t\u1ef1 theo th\u1ee9 t\u1ef1 ch\u1eef c\u00e1i. V\u00ed d\u1ee5, n\u00f3 n\u00f3i r\u1eb1ng Apples kh\u00f4ng \u1edf gi\u1eefa tr\u00e1i Apricot v\u00e0 Bananas v\u00ec ch\u1eef th\u1ee9 hai \u201cp\u201d trong Apples \u0111\u1ee9ng tr\u01b0\u1edbc \u201cr\u201d trong Apricot.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, h\u00e0m IF \/ AND \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng v\u00e0 g\u1ea7n nh\u01b0 ph\u1ed5 qu\u00e1t. T\u00f4i n\u00f3i \u201cg\u1ea7n nh\u01b0\u201d b\u1edfi v\u00ec n\u00f3 kh\u00f4ng bao g\u1ed3m t\u1ea5t c\u1ea3. C\u00f4ng th\u1ee9c tr\u00ean h\u00e0m \u00fd r\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t B nh\u1ecf h\u01a1n trong c\u1ed9t C, V\u00ed d\u1ee5: c\u1ed9t B lu\u00f4n lu\u00f4n ch\u1ee9a gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n d\u01b0\u1edbi v\u00e0 c\u1ed9t C \u2013 gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean. \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cNo\u201d cho h\u00e0ng 6, trong \u0111\u00f3 A6 c\u00f3 12, B6 \u2013 15 v\u00e0 C6 \u2013 3 c\u0169ng nh\u01b0 cho h\u00e0ng 8, trong \u0111\u00f3 A8 l\u00e0 24-Nov, B8 l\u00e0 26-Dec v\u00e0 C8 l\u00e0 21- Oct.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c kho\u1ea3ng c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c b\u1ea5t k\u1ec3 v\u1ecb tr\u00ed c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n d\u01b0\u1edbi v\u00e0 gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n \u1edf tr\u00ean. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, s\u1eed d\u1ee5ng h\u00e0m MEDIAN tr\u1ea3 l\u1ea1i trung v\u1ecb c\u1ee7a c\u00e1c con s\u1ed1 nh\u1ea5t \u0111\u1ecbnh (ngh\u0129a l\u00e0 s\u1ed1 \u1edf gi\u1eefa m\u1ed9t b\u1ed9 s\u1ed1). V\u00ec v\u1eady, n\u1ebfu b\u1ea1n thay th\u1ebf AND trong ph\u00e9p th\u1eed h\u1ee3p l\u00fd c\u1ee7a h\u00e0m IF v\u1edbi MEDIAN, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= IF (A2 = MEDIAN (A2: C2), \u201cYes\u201d, \u201cNo\u201d)<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau:<\/p>\n<figure style=\"width: 467px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m AND k\u1ebft h\u1ee3p - h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/median-function.png\" alt=\"Using IF with the MEDIAN function to find out all values between the given two values\" width=\"467\" height=\"262\"><figcaption class=\"wp-caption-text\">H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u0103ng ki\u0301 ngay:\u00a0kh\u00f3a h\u1ecdc excel n\u00e2ng cao H\u00e0 N\u1ed9i<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, h\u00e0m MEDIAN ho\u1ea1t \u0111\u1ed9ng ho\u00e0n h\u1ea3o cho s\u1ed1 v\u00e0 ng\u00e0y, nh\u01b0ng tr\u1ea3 v\u1ec1 #NUM! L\u1ed7i cho c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. Than \u00f4i, kh\u00f4ng ai ho\u00e0n h\u1ea3o:) N\u1ebfu b\u1ea1n mu\u1ed1n ho\u00e0n h\u1ea3o gi\u1eefa c\u00f4ng th\u1ee9c cho c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n c\u0169ng nh\u01b0 s\u1ed1 v\u00e0 ng\u00e0y, b\u1ea1n s\u1ebd ph\u1ea3i x\u00e2y d\u1ef1ng m\u1ed9t chu\u1ed7i logic ph\u1ee9c t\u1ea1p h\u01a1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m AND \/ OR nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= IF (OR (and(A2&gt; B2, A2 &lt;C2), and (A2 &lt;B2, A2&gt; C2)), \u201cYes\u201d, \u201cNo\u201d)<\/p>\n<figure style=\"width: 486px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00e0m AND k\u1ebft h\u1ee3p - h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-or-between-formula.png\" alt=\"An Excel Between formula that works for text values as well as for numbers and dates\" width=\"486\" height=\"201\"><figcaption class=\"wp-caption-text\">H\u00e0m AND k\u1ebft h\u1ee3p \u2013 h\u00e0m Excel cho \u0111i\u1ec1u ki\u1ec7n trong kho\u1ea3ng 1<\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_OR_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m OR trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u0169ng nh\u01b0 AND, h\u00e0m OR l\u00e0 m\u1ed9t h\u00e0m c\u01a1 b\u1ea3n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh hai gi\u00e1 tr\u1ecb ho\u1eb7c c\u00e2u l\u1ec7nh. S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 h\u00e0m OR tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t n\u1ebfu c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 \u0111\u00fang, v\u00e0 tr\u1ea3 v\u1ec1 FALSE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 l\u00e0 sai. H\u00e0m OR c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2013-2000.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m OR r\u1ea5t gi\u1ed1ng v\u1edbi AND:<\/p>\n<pre><strong><code class=\"language-xls\">OR (logic1, [logical2], ...)<\/code><\/strong><\/pre>\n<pre><code class=\"language-xls\"><\/code><\/pre>\n<p style=\"text-align: justify\">Tham s\u1ed1 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u, c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung (t\u1ed1i \u0111a 255 trong c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i) l\u00e0 t\u00f9y ch\u1ecdn. V\u00e0 b\u00e2y gi\u1edd, h\u00e3y vi\u1ebft ra m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c \u0111\u1ec3 b\u1ea1n c\u1ea3m nh\u1eadn \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng OR trong Excel ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>C\u00f4ng th\u1ee9c<\/strong><\/td>\n<td><strong>Di\u1ec5n gi\u1ea3i<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>=OR(A2=\u201dBananas\u201d, A2=\u201dOranges\u201d)<\/strong><\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 TRUE n\u1ebfu \u00f4 A2 ch\u1ee9a \u201cBananas\u201d ho\u1eb7c \u201cOranges\u201d, FALSE n\u1ebfu kh\u00f4ng \u0111\u00e1m \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n n\u00e0o.<\/td>\n<\/tr>\n<tr>\n<td><strong>=OR(B2&gt;=40, C2&gt;=20)<\/strong><\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 TRUE n\u1ebfu B2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 40 ho\u1eb7c C2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng \u00a020, FALSE n\u1ebfu kh\u00f4ng \u0111\u00e1m \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n n\u00e0o.<\/td>\n<\/tr>\n<tr>\n<td><strong>=OR(B2=\u201d \u201c, C2=\u201d\u201d)<\/strong><\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 TRUE n\u1ebfu m\u1ed9t trong hai \u00f4 \u00a0B2 ho\u1eb7c C2 r\u1ed7ng ho\u1eb7c c\u1ea3 hai \u00f4 \u0111\u1ec1u r\u1ed7ng, FALSE n\u1ebfu kh\u00f4ng \u0111\u00e1m \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n n\u00e0o.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6142\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-137.png\" width=\"600\" height=\"171\" title=\"excel-dialog-box-launcher-1-137\"><\/p>\n<p style=\"text-align: justify\">C\u0169ng nh\u01b0 h\u00e0m AND, h\u00e0m OR \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i \u0111\u1ec3 m\u1edf r\u1ed9ng t\u00ednh h\u1eefu \u00edch c\u1ee7a c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p th\u1eed logic, v\u00ed d\u1ee5: H\u00e0m If. \u00a0\u0110\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_IF_long_ham_OR\"><\/span>H\u00e0m IF l\u1ed3ng h\u00e0m OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre><strong><code class=\"language-xls\">= IF (OR (B2&gt; 30, C2&gt; 20), \"Good\", \"Bad\")<\/code><\/strong><\/pre>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cGood\u201d n\u1ebfu m\u1ed9t s\u1ed1 trong \u00f4 B3 l\u1edbn h\u01a1n 30 ho\u1eb7c s\u1ed1 trong C2 l\u1edbn h\u01a1n 20, \u201cBad\u201d n\u1ebfu kh\u00f4ng th\u1ecfa c\u1ea3 hai.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_OR_trong_dinh_dang_co_dieu_kien_cua_Excel\"><\/span>H\u00e0m OR trong \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">= OR ($B2 = \u201c\u201d, $C2 = \u201c\u201d)<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c OR l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a \u00f4 tr\u1ed1ng ho\u1eb7c trong c\u1ed9t B ho\u1eb7c trong c\u1ed9t C ho\u1eb7c trong c\u1ea3 hai.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6143 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-138.png\" width=\"600\" height=\"355\" title=\"excel-dialog-box-launcher-1-138\"><\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Vi_du_3_Su_dung_IF_voi_cac_ham_AND_OR\">H\u00e0m IF, l\u1ed3ng gh\u00e9p h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, IFERROR, IFNA v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_AND_va_OR_trong_mot_cong_thuc\"><\/span>H\u00e0m AND v\u00e0\u00a0OR trong m\u1ed9t c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, kh\u00f4ng c\u00f3 g\u00ec ng\u0103n c\u1ea3n b\u1ea1n s\u1eed d\u1ee5ng c\u1ea3 hai h\u00e0m, AND &amp; OR, trong m\u1ed9t c\u00f4ng th\u1ee9c n\u1ebfu b\u1ea1n c\u1ea7n. C\u00f3 th\u1ec3 c\u00f3 c\u00e1c bi\u1ebfn th\u1ec3 v\u00f4 h\u1ea1n c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00f3 trong c\u00e1c m\u00f4 h\u00ecnh c\u01a1 b\u1ea3n sau \u0111\u00e2y:<\/p>\n<pre><strong><code class=\"language-xls\">= AND (OR (Cond1, Cond2), Cond3)<\/code><\/strong><\/pre>\n<pre><strong><code class=\"language-xls\">= AND (OR (Cond1, Cond2), OR (Cond3, Cond4)<\/code><\/strong><\/pre>\n<pre><strong><code class=\"language-xls\">= OR (V\u00c0 (Cond1, Cond2), Cond3)<\/code><\/strong><\/pre>\n<pre><strong><code class=\"language-xls\">= OR (V\u00c0 (Cond1, Cond2), AND (Cond3, Cond4))<\/code><\/strong><\/pre>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft l\u00f4 h\u00e0ng chu\u1ed1i v\u00e0 cam n\u00e0o \u0111\u00e3 b\u00e1n h\u1ebft, ngh\u0129a l\u00e0 s\u1ed1 l\u01b0\u1ee3ng \u201cIn stock\u201d (c\u1ed9t B) b\u1eb1ng v\u1edbi s\u1ed1 \u201cSold\u201d (c\u1ed9t C), h\u00e0m OR \/ AND sau \u0111\u00e2y c\u00f3 th\u1ec3 nhanh ch\u00f3ng hi\u1ec3n th\u1ecb \u0111i\u1ec1u n\u00e0y cho b\u1ea1n:<\/p>\n<p style=\"text-align: justify\">= OR (AND (A2 = \u201cbananas\u201d, B2 = C2) v\u00e0 AND (A2 = \u201coranges\u201d, B2 = C2))<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/and-or-excel.png\" alt=\"The AND\/OR formula to test multiple conditions\" title=\"and-or-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_XOR_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m XOR trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong Excel 2013, Microsoft \u0111\u00e3 gi\u1edbi thi\u1ec7u ch\u1ee9c n\u0103ng XOR, \u0111\u00f3 l\u00e0 m\u1ed9t h\u00e0m logic <strong>Exclusive OR<\/strong>. Thu\u1eadt ng\u1eef n\u00e0y ch\u1eafc ch\u1eafn l\u00e0 quen thu\u1ed9c v\u1edbi nh\u1eefng b\u1ea1n c\u00f3 ki\u1ebfn \u200b\u200bth\u1ee9c v\u1ec1 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh ho\u1eb7c khoa h\u1ecdc m\u00e1y t\u00ednh n\u00f3i chung. \u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng, kh\u00e1i ni\u1ec7m \u2018\u0110\u1ed9c quy\u1ec1n Ho\u1eb7c\u2019 c\u00f3 th\u1ec3 h\u01a1i kh\u00f3 hi\u1ec3u tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m XOR gi\u1ed1ng h\u1ec7t v\u1edbi OR:<\/p>\n<pre><strong><code class=\"language-xls\">XOR (logic1, [logical2], ...)<\/code><\/strong><\/pre>\n<p style=\"text-align: justify\">C\u00e2u l\u1ec7nh logic \u0111\u1ea7u ti\u00ean (Logic 1) l\u00e0 b\u1eaft bu\u1ed9c, c\u00e1c gi\u00e1 tr\u1ecb logic b\u1ed5 sung l\u00e0 t\u00f9y ch\u1ecdn. B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 \u0111\u1ebfn 254 \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0 \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb logic, m\u1ea3ng ho\u1eb7c c\u00e1c tham chi\u1ebfu \u0111\u00e1nh gi\u00e1 theo \u0111\u00fang ho\u1eb7c sai.<\/p>\n<p style=\"text-align: justify\">Trong phi\u00ean b\u1ea3n \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u1ee7a c\u00f4ng th\u1ee9c XOR ch\u1ec9 ch\u1ee9a 2 c\u00e2u l\u1ec7nh logic, h\u00e0m XOR tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t \u0111\u1ed1i s\u1ed1 \u0111\u00e1nh gi\u00e1 l\u00e0 \u0111\u00fang. N\u1ebfu c\u1ea3 hai \u0111\u1ed1i s\u1ed1 l\u00e0 \u0111\u00fang ho\u1eb7c c\u1ea3 hai l\u00e0 sai, XOR tr\u1ea3 v\u1ec1 FALSE. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng h\u01a1n \u0111\u1ec3 hi\u1ec3u t\u1eeb c\u00e1c v\u00ed d\u1ee5:<\/p>\n<table style=\"height: 127px\" width=\"937\">\n<tbody>\n<tr>\n<td width=\"124\"><strong>C\u00f4ng th\u1ee9c<\/strong><\/td>\n<td width=\"77\"><strong>K\u1ebft qu\u1ea3<\/strong><\/td>\n<td><strong>Gi\u1ea3i th\u00edch<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>=XOR(1&gt;0, 2&lt;1)<\/strong><\/td>\n<td>TRUE<\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 TRUE b\u1edfi v\u00ec \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean \u0111\u00fang v\u00e0 \u0111\u1ed1i s\u1ed1 th\u1ee9 2 sai.<\/td>\n<\/tr>\n<tr>\n<td><strong>=XOR(1&lt;0, 2&lt;1)<\/strong><\/td>\n<td>FALSE<\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 FALSE b\u1edfi v\u00ec c\u1ea3 hai \u0111\u1ed1i s\u1ed1 \u0111\u1ec1u sai.<\/td>\n<\/tr>\n<tr>\n<td><strong>=XOR(1&gt;0, 2&gt;1)<\/strong><\/td>\n<td>FALSE<\/td>\n<td>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 FALSE b\u1edfi v\u00ec c\u1ea3 hai \u0111\u1ed1i s\u1ed1 \u0111\u1ec1u \u0111\u00fang.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Khi th\u00eam c\u00e1c c\u00e2u l\u1ec7nh logic, h\u00e0m XOR cho k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<ul style=\"text-align: justify\">\n<li>TRUE n\u1ebfu m\u1ed9t s\u1ed1 l\u1ebb c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u00e1nh gi\u00e1 \u0111\u00fang;<\/li>\n<li>FALSE n\u1ebfu l\u00e0 t\u1ea5t c\u1ea3 \u0111\u1ed1i s\u1ed1 l\u00e0 \u0111\u00fang, ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u1ec1u sai.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y minh ho\u1ea1 cho \u0111i\u1ec3m tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-xor-function.png\" alt=\"Excel XOR formula with multiple logical statements\" title=\"excel-xor-function\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m XOR, h\u00e3y xem x\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch th\u00ed sinh v\u00e0 k\u1ebft qu\u1ea3 2 tr\u00f2 ch\u01a1i \u0111\u1ea7u ti\u00ean c\u1ee7a h\u1ecd. B\u1ea1n mu\u1ed1n bi\u1ebft b\u00ean n\u00e0o trong s\u1ed1 nh\u1eefng ng\u01b0\u1eddi tr\u1ea3 ti\u1ec1n s\u1ebd ch\u01a1i tr\u00f2 ch\u01a1i th\u1ee9 3 d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>C\u00e1c th\u00ed sinh \u0111\u00e3 th\u1eafng tr\u1eadn \u0111\u1ea5u 1 v\u00e0 tr\u1eadn \u0111\u1ea5u 2 t\u1ef1 \u0111\u1ed9ng v\u00e0o v\u00f2ng sau v\u00e0 kh\u00f4ng ph\u1ea3i ch\u01a1i tr\u1eadn 3.<\/li>\n<li>C\u00e1c th\u00ed sinh thua c\u1ea3 hai tr\u00f2 ch\u01a1i \u0111\u1ea7u ti\u00ean \u0111\u1ec1u b\u1ecb lo\u1ea1i ra v\u00e0 c\u0169ng kh\u00f4ng ch\u01a1i tr\u1eadn 3.<\/li>\n<li>C\u00e1c th\u00ed sinh \u0111\u00e3 th\u1eafng trong tr\u1eadn 1 ho\u1eb7c tr\u1eadn 2 s\u1ebd ch\u01a1i tr\u1eadn 3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ai s\u1ebd v\u00e0o v\u00f2ng ti\u1ebfp theo v\u00e0 ai kh\u00f4ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u1ed9t c\u00f4ng th\u1ee9c XOR \u0111\u01a1n gi\u1ea3n ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c nh\u01b0 ch\u00fang ta mu\u1ed1n:<\/p>\n<p style=\"text-align: justify\">= XOR (B2 = \u201cWon\u201d, C2 = \u201cWon\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-xor-formula.png\" alt=\"Using the Excel XOR function in a real-life scenario\" title=\"excel-xor-formula\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 n\u1ebfu b\u1ea1n l\u1ed3ng h\u00e0m XOR n\u00e0y v\u00e0o h\u00e0m logic If, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 th\u1eadm ch\u00ed c\u00f2n t\u1ed1t h\u01a1n:<\/p>\n<p style=\"text-align: justify\">= IF (XOR (B2 = \u201cWon\u201d, C2 = \u201cWon\u201d), \u201cYes\u201d, \u201cNo\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-xor-if.png\" alt=\"The IF formula with a nested XOR function\" title=\"excel-xor-if\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_NOT_trong_Excel\"><\/span>S\u1eed d\u1ee5ng h\u00e0m NOT trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">H\u00e0m NOT l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1ec1 c\u00fa ph\u00e1p:<\/p>\n<pre><strong><code class=\"language-xls\">NOT (logical)<\/code><\/strong><\/pre>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m NOT trong Excel \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3. N\u00f3i c\u00e1ch kh\u00e1c, n\u1ebfu logic \u0111\u00e1nh gi\u00e1 l\u00e0 sai, h\u00e0m NOT s\u1ebd tr\u1ea3 v\u1ec1 \u0111\u00fang v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. V\u00ed d\u1ee5, c\u1ea3 hai c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y tr\u1ea3 v\u1ec1 FALSE:<\/p>\n<p style=\"text-align: justify\">= NOT (TRUE)<\/p>\n<p style=\"text-align: justify\">= NOT (2 * 2 = 4)<\/p>\n<p style=\"text-align: justify\">T\u1ea1i sao ng\u01b0\u1eddi ta l\u1ea1i mu\u1ed1n c\u00f3 \u0111\u01b0\u1ee3c nh\u1eefng k\u1ebft qu\u1ea3 l\u1ed1 b\u1ecbch nh\u01b0 v\u1eady? Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 l\u1ea1i quan t\u00e2m m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng h\u01a1n. V\u00ed d\u1ee5: khi xem l\u1ea1i danh s\u00e1ch trang ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n lo\u1ea1i tr\u1eeb m\u1ed9t s\u1ed1 m\u00e0u kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi b\u1ea1n. T\u00f4i kh\u00f4ng \u0111\u1eb7c bi\u1ec7t th\u00edch m\u00e0u \u0111en, v\u00ec v\u1eady t\u00f4i \u0111\u1eb7t c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p style=\"text-align: justify\">= NOT (C2 = \u201cblack\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-not-function.png\" alt=\"Using the NOT function in Excel\" title=\"excel-not-function\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 th\u01b0\u1eddng l\u1ec7, trong Microsoft Excel c\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 l\u00e0m m\u1ed9t vi\u1ec7c, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed kh\u00f4ng b\u1eb1ng: = C2 &lt;&gt; \u201cblack\u201d.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u00f4\u0309ng h\u01a1\u0323p\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt excel hay<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m NOT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND ho\u1eb7c OR. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i tr\u1eeb m\u00e0u \u0111en v\u00e0 tr\u1eafng, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">= NOT (OR (C2 = \u201cblack\u201d, C2 = \u201cwhite\u201d))<\/p>\n<p style=\"text-align: justify\">V\u00e0 n\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00f3 m\u1ed9t chi\u1ebfc \u00e1o kho\u00e1c \u0111en, m\u1eb7c d\u00f9 c\u00f3 th\u1ec3 xem x\u00e9t m\u1ed9t chi\u1ebfc \u00e1o jacket \u0111en ho\u1eb7c \u00e1o kho\u00e1c long \u0111en, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m NOT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND:<\/p>\n<p style=\"text-align: justify\">= NOT (And (C2 = \u201cblack\u201d, B2 = \u201ccoat\u201d))<\/p>\n<p style=\"text-align: justify\">M\u1ed9t s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn kh\u00e1c c\u1ee7a h\u00e0m NOT l\u00e0 \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c h\u00e0nh vi c\u1ee7a m\u1ed9t s\u1ed1 h\u00e0m kh\u00e1c. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p NOT v\u00e0 ISBLANK \u0111\u1ec3 t\u1ea1o ra ISNOTBLANK c\u00f4ng th\u1ee9c m\u00e0 Microsoft Excel thi\u1ebfu.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u00f4ng th\u1ee9c = ISBLANK (A2) tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u00fang n\u1ebfu \u00f4 A2 tr\u1ed1ng. H\u00e0m NOT c\u00f3 th\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c k\u1ebft qu\u1ea3 n\u00e0y th\u00e0nh sai: = NOT (ISBLANK (A2))<\/p>\n<p style=\"text-align: justify\">V\u00e0 sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 \u0111i th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa v\u00e0 t\u1ea1o ra c\u00e2u l\u1ec7nh l\u1ed3ng IF v\u1edbi h\u00e0m NOT \/ ISBLANK cho m\u1ed9t nhi\u1ec7m v\u1ee5 th\u1ef1c t\u1ebf:<\/p>\n<p style=\"text-align: justify\">= IF (NOT (ISBLANK (C2)), C2 * 0,15, \u201cNo bonus:(\u201c)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/notisblank-excel.png\" alt=\"A nested IF statement with NOT \/ ISBLANK functions\" title=\"notisblank-excel\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u00f4 C2 kh\u00f4ng r\u1ed7ng, h\u00e3y nh\u00e2n s\u1ed1 trong C2 v\u1edbi 0,15, cho ph\u00e9p m\u1ed7i nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng c\u00f3 th\u00eam 15% ti\u1ec1n th\u01b0\u1edfng. N\u1ebfu C2 tr\u1ed1ng, hi\u1ec7n \u201cNo bonus:(\u201c.<\/p>\n<p style=\"text-align: justify\"><strong><em>Ngu\u1ed3<\/em><\/strong><strong><em>n:<\/em><\/strong><em>\u00a0<\/em><em>Ablebits, d\u1ecb<\/em><em>ch v\u00e0 bi\u00ean t\u1ead<\/em><em>p b\u1edf<\/em><em>i Hocexcel Online.<\/em><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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-291.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7312,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7311","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\/7311","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=7311"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7312"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}