{"id":4603,"date":"2024-12-07T03:48:27","date_gmt":"2024-12-07T03:48:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/07\/cong-thuc-if-and-trong-excel\/"},"modified":"2024-12-07T03:48:27","modified_gmt":"2024-12-07T03:48:27","slug":"cong-thuc-if-and-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/07\/cong-thuc-if-and-trong-excel\/","title":{"rendered":"C\u00f4ng th\u1ee9c IF AND trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><i><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND trong Excel<\/strong> \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c nh\u00e9!<\/span><\/i><\/p>\n<p><i><span style=\"font-weight: 400\">Tr\u00ean blog c\u1ee7a m\u00ecnh \u0111\u00e3 c\u00f3 m\u1ed9t s\u1ed1 h\u01b0\u1edbng d\u1eabn v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\"><strong>h\u00e0m IF<\/strong><\/a> v\u00e0 v\u1eabn li\u00ean t\u1ee5c \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt nh\u1eefng c\u00e1ch d\u00f9ng m\u1edbi. H\u00f4m nay, m\u00ecnh s\u1ebd ch\u1ec9 b\u1ea1n c\u00e1ch l\u00e0m th\u1ebf n\u00e0o c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 hai ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac.<\/span><\/i><\/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-6753c58a02b06\" 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\/cong-thuc-if-and-trong-excel.html#Cong_thuc_IF_AND_trong_Excel\" title=\"C\u00f4ng th\u1ee9c IF AND trong Excel\">C\u00f4ng th\u1ee9c IF AND trong Excel<\/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\/cong-thuc-if-and-trong-excel.html#Excel_IF_lon_hon_VA_nho_hon\" title=\"Excel IF: l\u1edbn h\u01a1n V\u00c0 nh\u1ecf h\u01a1n\">Excel IF: l\u1edbn h\u01a1n V\u00c0 nh\u1ecf h\u01a1n<\/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\/cong-thuc-if-and-trong-excel.html#NEU_cai_nay_VA_cai_kia\" title=\"N\u1ebeU c\u00e1i n\u00e0y V\u00c0 c\u00e1i kia\">N\u1ebeU c\u00e1i n\u00e0y V\u00c0 c\u00e1i kia<\/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\/cong-thuc-if-and-trong-excel.html#Nhieu_cau_lenh_IF_AND_trong_Excel\" title=\"Nhi\u1ec1u c\u00e2u l\u1ec7nh IF AND trong Excel\">Nhi\u1ec1u c\u00e2u l\u1ec7nh IF AND trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-if-and-trong-excel.html#Cau_lenh_IF_AND_long_nhau\" title=\"C\u00e2u l\u1ec7nh IF AND l\u1ed3ng nhau\">C\u00e2u l\u1ec7nh IF AND l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-if-and-trong-excel.html#Ham_IF_AND_phan_biet_chu_hoa_chu_thuong_trong_Excel\" title=\"H\u00e0m IF AND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\">H\u00e0m IF AND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cong-thuc-if-and-trong-excel.html#IF_OR_AND_cong_thuc_trong_Excel\" title=\"IF OR AND c\u00f4ng th\u1ee9c trong Excel\">IF OR AND c\u00f4ng th\u1ee9c trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cong_thuc_IF_AND_trong_Excel\"><\/span><b>C\u00f4ng th\u1ee9c IF AND trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 x\u00e2y d\u1ef1ng c\u00e2u l\u1ec7nh IF AND, \u0111\u01b0\u01a1ng nhi\u00ean l\u00e0 b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p c\u00e1c <strong>h\u00e0m IF v\u00e0 AND<\/strong> trong m\u1ed9t c\u00f4ng th\u1ee9c. B\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n nh\u01b0 sau<\/span><\/p>\n<p><strong>IF(AND(<i>condition1<\/i>, <i>condition2<\/i>,\u2026), value_if_true, value_if_false)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01a1n gi\u1ea3n nh\u01b0 sau: N\u1ebeU \u0111i\u1ec1u ki\u1ec7n 1 l\u00e0 \u0111\u00fang V\u00c0 \u0111i\u1ec1u ki\u1ec7n 2 l\u00e0 \u0111\u00fang, h\u00e3y l\u00e0m m\u1ed9t vi\u1ec7c, n\u1ebfu kh\u00f4ng h\u00e3y l\u00e0m \u0111i\u1ec1u kh\u00e1c.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">V\u00ed d\u1ee5: H\u00e3y t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c ki\u1ec3m tra xem B2 c\u00f3 \u0111\u01b0\u1ee3c \u201cdelivered\u201d(ph\u00e2n ph\u1ed1i\u201d hay kh\u00f4ng v\u00e0 C2 c\u00f3 ch\u1ee9a ng\u00e0y th\u00e1ng kh\u00f4ng:<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u TRUE, h\u00e3y \u0111\u00e1nh d\u1ea5u \u0111\u01a1n h\u00e0ng l\u00e0 \u201cClosed\u201d.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu m\u1ed9t trong hai \u0111i\u1ec1u ki\u1ec7n l\u00e0 FALSE ho\u1eb7c c\u1ea3 hai \u0111\u1ec1u FALSE, th\u00ec tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng (\u201c\u201d).<\/span><\/li>\n<\/ul>\n<p><strong>=IF(AND(B2=\u201ddelivered\u201d, C2&lt;&gt;\u201d\u201d), \u201cClosed\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi hi\u1ec3n th\u1ecb h\u00e0m IF AND trong Excel:<\/span><\/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-372.gif\" title=\"ex101_92019-nho-372\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_33345\" aria-describedby=\"caption-attachment-33345\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33345 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-1.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 1\" width=\"400\" height=\"217\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-1\"><figcaption id=\"caption-attachment-33345\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb trong tr\u01b0\u1eddng h\u1ee3p FALSE, h\u00e3y cung c\u1ea5p gi\u00e1 tr\u1ecb \u0111\u00f3 trong \u0111\u1ed1i s\u1ed1 value_if_false. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(AND(B2=\u201ddelivered\u201d, C2&lt;&gt;\u201d\u201d), \u201cClosed\u201d, \u201cOpen\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c n\u00e0y xu\u1ea5t ra \u201cClosed\u201d n\u1ebfu c\u1ed9t B l\u00e0 \u201cdelivered\u201d v\u00e0 C c\u00f3 b\u1ea5t k\u1ef3 ng\u00e0y n\u00e0o trong \u0111\u00f3 (kh\u00f4ng tr\u1ed1ng). Trong t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c, n\u00f3 tr\u1ea3 v\u1ec1 \u201cOpen\u201d:<\/span><\/p>\n<figure id=\"attachment_33346\" aria-describedby=\"caption-attachment-33346\" style=\"width: 340px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33346 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-2.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 2\" width=\"340\" height=\"216\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-2\"><figcaption id=\"caption-attachment-33346\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 2<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF AND trong Excel \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 \u0111i\u1ec1u ki\u1ec7n, h\u00e3y l\u01b0u \u00fd r\u1eb1ng ch\u1eef th\u01b0\u1eddng v\u00e0 ch\u1eef hoa \u0111\u01b0\u1ee3c coi l\u00e0 c\u00f9ng m\u1ed9t k\u00fd t\u1ef1 nh\u00e9. N\u1ebfu b\u1ea1n \u0111ang t\u00ecm c AND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, h\u00e3y \u0111\u01b0a m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111\u1ed1i s\u1ed1 c\u1ee7a AND v\u00e0o <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html\"><strong>h\u00e0m EXACT<\/strong><\/a> \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn \u1edf blog tr\u01b0\u1edbc \u0111\u00f3!<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00fa ph\u00e1p c\u1ee7a c\u00e2u l\u1ec7nh IF AND trong Excel, m\u00ecnh s\u1ebd m\u00e1ch cho b\u1ea1n nh\u1eefng lo\u1ea1i t\u00e1c v\u1ee5 n\u00e0o m\u00e0 n\u00f3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_IF_lon_hon_VA_nho_hon\"><\/span><b>Excel IF: l\u1edbn h\u01a1n V\u00c0 nh\u1ecf h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong v\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00f3, ch\u00fang ta \u0111ang th\u1eed nghi\u1ec7m hai \u0111i\u1ec1u ki\u1ec7n trong hai \u00f4 kh\u00e1c nhau. Nh\u01b0ng \u0111\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ch\u1ea1y hai ho\u1eb7c nhi\u1ec1u c\u00f4ng th\u1ee9c ngay tr\u00ean c\u00f9ng m\u1ed9t \u00f4. V\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh l\u00e0 ki\u1ec3m tra xem gi\u00e1 tr\u1ecb \u00f4 c\u00f3 n\u1eb1m gi\u1eefa hai s\u1ed1 hay kh\u00f4ng. H\u00e0m IF AND trong Excel\u00a0 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m \u0111i\u1ec1u \u0111\u00f3!<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 doanh s\u1ed1 b\u00e1n h\u00e0ng trong c\u1ed9t B v\u00e0 b\u1ea1n \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u g\u1eafn c\u1edd s\u1ed1 ti\u1ec1n l\u1edbn h\u01a1n $50 nh\u01b0ng nh\u1ecf h\u01a1n $100. \u0110\u01a1n gi\u1ea3n th\u00f4i, b\u1ea1n h\u00e3y ch\u00e8n c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o C2 v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3 xu\u1ed1ng c\u1ed9t:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;50, B2&lt;100), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33347 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-3.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 3\" width=\"277\" height=\"217\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-3\"><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u1ea7n bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb bi\u00ean (50 v\u00e0 100), h\u00e3y s\u1eed d\u1ee5ng to\u00e1n t\u1eed nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (&lt;=) v\u00e0 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt;=):<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=50, B2&lt;=100), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<figure id=\"attachment_33348\" aria-describedby=\"caption-attachment-33348\" style=\"width: 268px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33348 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-4.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 4\" width=\"268\" height=\"217\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-4\"><figcaption id=\"caption-attachment-33348\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 x\u1eed l\u00fd m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb ranh gi\u1edbi kh\u00e1c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i c\u00f4ng th\u1ee9c, h\u00e3y nh\u1eadp s\u1ed1 t\u1ed1i thi\u1ec3u v\u00e0 s\u1ed1 t\u1ed1i \u0111a v\u00e0o hai \u00f4 ri\u00eang bi\u1ec7t v\u00e0 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. \u0110\u1ec3 c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng, h\u00e3y \u0111\u1ea3m b\u1ea3o s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i cho c\u00e1c \u00f4 ranh gi\u1edbi ($F$1 v\u00e0 $F$2 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y):<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=$F$1, B2&lt;=$F$2), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<figure id=\"attachment_33349\" aria-describedby=\"caption-attachment-33349\" style=\"width: 452px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33349\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-5.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 5\" width=\"452\" height=\"217\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-5\"><figcaption id=\"caption-attachment-33349\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 5<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ki\u1ec3m tra xem m\u1ed9t ng\u00e0y c\u00f3 n\u1eb1m trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh hay kh\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: h\u00e3y g\u1eafn c\u1edd c\u00e1c ng\u00e0y t\u1eeb 10 th\u00e1ng 9 n\u0103m 2018 \u0111\u1ebfn 30 th\u00e1ng 9 n\u0103m 2018. M\u1ed9t tr\u1edf ng\u1ea1i nh\u1ecf l\u00e0 ng\u00e0y th\u00e1ng kh\u00f4ng \u0111\u01b0\u1ee3c cung c\u1ea5p tr\u1ef1c ti\u1ebfp cho c\u00e1c b\u00e0i ki\u1ec3m tra logic. V\u00ec v\u1eady \u0111\u1ec3 Excel hi\u1ec3u ng\u00e0y th\u00e1ng, ch\u00fang ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong h\u00e0m DATEVALUE, nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=DATEVALUE(\u201c9\/10\/2018\u201d), B2&lt;=DATEVALUE(\u201c9\/30\/2018\u201d)), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp ng\u00e0y T\u1eeb v\u00e0 \u0110\u1ebfn trong hai \u00f4 ($F$1 v\u00e0 $F$2 trong v\u00ed d\u1ee5 n\u00e0y) v\u00e0 \u201ck\u00e9o\u201d ch\u00fang t\u1eeb c\u00e1c \u00f4 \u0111\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF AND \u0111\u00e3 quen thu\u1ed9c:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=$F$1, B2&lt;=$F$2), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<figure id=\"attachment_33350\" aria-describedby=\"caption-attachment-33350\" style=\"width: 467px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33350\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-6.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 6\" width=\"467\" height=\"216\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-6\"><figcaption id=\"caption-attachment-33350\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 6<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"NEU_cai_nay_VA_cai_kia\"><\/span><b>N\u1ebeU c\u00e1i n\u00e0y V\u00c0 c\u00e1i kia<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i vi\u1ec7c tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc, <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-if-and-trong-excel.html\"><strong>h\u00e0m IF AND trong Excel<\/strong><\/a> c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o vi\u1ec7c c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 TRUE hay FALSE.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n, ch\u00fang ta s\u1ebd t\u00ednh to\u00e1n kho\u1ea3n ti\u1ec1n th\u01b0\u1edfng 5% cho doanh s\u1ed1 \u201cClosed\u201d v\u1edbi s\u1ed1 ti\u1ec1n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 100 \u0111\u00f4 la.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed s\u1ed1 ti\u1ec1n n\u1eb1m trong c\u1ed9t B v\u00e0 tr\u1ea1ng th\u00e1i \u0111\u01a1n h\u00e0ng trong c\u1ed9t C, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=100, C2=\u201dclosed\u201d), B2*10%, 0)<\/strong><\/p>\n<figure id=\"attachment_33339\" aria-describedby=\"caption-attachment-33339\" style=\"width: 333px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33339\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-7.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 7\" width=\"333\" height=\"216\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-7\"><figcaption id=\"caption-attachment-33339\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 7<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c tr\u00ean ch\u1ec9 \u0111\u1ecbnh s\u1ed1 0 cho c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f2n l\u1ea1i (value_if_false=0). N\u1ebfu b\u1ea1n s\u1eb5n s\u00e0ng \u0111\u01b0a ra m\u1ed9t kho\u1ea3n ti\u1ec1n th\u01b0\u1edfng k\u00edch th\u00edch nh\u1ecf, ch\u1eb3ng h\u1ea1n nh\u01b0 3%, cho c\u00e1c \u0111\u01a1n h\u00e0ng kh\u00f4ng \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n, h\u00e3y th\u00eam v\u00e0o trong \u0111\u1ed1i s\u1ed1 <strong>value_if_false<\/strong>:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=100, C2=\u201dclosed\u201d), B2*10%, B2*3%)<\/strong><\/p>\n<figure id=\"attachment_33340\" aria-describedby=\"caption-attachment-33340\" style=\"width: 345px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33340\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-8.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 8\" width=\"345\" height=\"215\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-8\"><figcaption id=\"caption-attachment-33340\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 8<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Nhieu_cau_lenh_IF_AND_trong_Excel\"><\/span><b>Nhi\u1ec1u c\u00e2u l\u1ec7nh IF AND trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y nh\u1eefng v\u00ed d\u1ee5 tr\u00ean \u0111\u00e2y ch\u00fang ta ch\u1ec9 \u0111\u00e1nh gi\u00e1 hai \u0111i\u1ec1u ki\u1ec7n. V\u1eady n\u1ebfu nhi\u1ec1u h\u01a1n th\u00ec sao? Ch\u1ea3 sao c\u1ea3, kh\u00f4ng c\u00f3 g\u00ec c\u00f3 th\u1ec3 ng\u0103n c\u1ea3n b\u1ea1n x\u00e9t m\u1ed9t l\u00fac nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c IF AND c\u1ee7a m\u00ecnh mi\u1ec5n l\u00e0 ch\u00fang tu\u00e2n th\u1ee7 c\u00e1c gi\u1edbi h\u1ea1n chung sau c\u1ee7a Excel:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2019 \u2013 2007, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1 trong m\u1ed9t c\u00f4ng th\u1ee9c, v\u1edbi t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u00f4ng th\u1ee9c kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 8.192 k\u00fd t\u1ef1.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2003 tr\u1edf xu\u1ed1ng, kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p c\u00f3 h\u01a1n 30 \u0111\u1ed1i s\u1ed1, v\u1edbi t\u1ed5ng \u0111\u1ed9 d\u00e0i kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 1.024 k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<p><b>V\u00ed d\u1ee5 v\u1ec1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND<\/b><span style=\"font-weight: 400\">, ch\u00fang ta h\u00e3y xem x\u00e9t nh\u1eefng \u0111i\u1ec1u ki\u1ec7n sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">S\u1ed1 ti\u1ec1n (B2) ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 100 \u0111\u00f4 la<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tr\u1ea1ng th\u00e1i \u0111\u01a1n h\u00e0ng (C2) l\u00e0 \u201cClosed\u201d(\u0111\u00e3 \u0111\u00f3ng)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ng\u00e0y giao h\u00e0ng (D2) trong th\u00e1ng hi\u1ec7n t\u1ea1i<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, ch\u00fang ta c\u1ea7n c\u00e2u l\u1ec7nh IF AND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c l\u1ec7nh m\u00e0 c\u1ea3 3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0110\u00daNG. C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=100, C2=\u201dClosed\u201d, MONTH(D2)=MONTH(TODAY())), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed th\u00e1ng hi\u1ec7n t\u1ea1i t\u1ea1i th\u1eddi \u0111i\u1ec3m vi\u1ebft b\u00e0i n\u00e0y l\u00e0 th\u00e1ng 10, c\u00f4ng th\u1ee9c s\u1ebd cho k\u1ebft qu\u1ea3 d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<figure id=\"attachment_33341\" aria-describedby=\"caption-attachment-33341\" style=\"width: 470px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33341\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-9.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 9\" width=\"470\" height=\"217\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-9\"><figcaption id=\"caption-attachment-33341\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 9<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cau_lenh_IF_AND_long_nhau\"><\/span><b>C\u00e2u l\u1ec7nh IF AND l\u1ed3ng nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c trang t\u00ednh l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ki\u1ec3m tra m\u1ed9t v\u00e0i b\u1ed9 ti\u00eau ch\u00ed AND kh\u00e1c nhau c\u00f9ng m\u1ed9t l\u00fac. L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau trong Excel c\u1ed5 \u0111i\u1ec3n v\u00e0 m\u1edf r\u1ed9ng c\u00e1c ki\u1ec3m tra logic c\u1ee7a n\u00f3 b\u1eb1ng c\u00e1c c\u00e2u l\u1ec7nh AND, nh\u01b0 sau:<\/span><\/p>\n<p><strong>IF(AND(\u2026), <i>output1<\/i>, IF(AND(\u2026), <i>output2<\/i>, IF(AND(\u2026), <i>output3<\/i>, <i>output4<\/i>)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 h\u00ecnh dung r\u00f5 h\u01a1n, ch\u00fang ta c\u00f9ng xem v\u00ed d\u1ee5 sau: Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng d\u1ecbch v\u1ee5 c\u1ee7a m\u00ecnh d\u1ef1a tr\u00ean chi ph\u00ed v\u1eadn chuy\u1ec3n v\u00e0 th\u1eddi gian giao h\u00e0ng \u01b0\u1edbc t\u00ednh (ETD):<\/span><\/p>\n<p><span style=\"font-weight: 400\">Excellent: chi ph\u00ed v\u1eadn chuy\u1ec3n d\u01b0\u1edbi $20 v\u00e0 ETD d\u01b0\u1edbi 3 ng\u00e0y<\/span><\/p>\n<p><span style=\"font-weight: 400\">Poor: chi ph\u00ed v\u1eadn chuy\u1ec3n tr\u00ean $30 v\u00e0 ETD trong 5 ng\u00e0y<\/span><\/p>\n<p><span style=\"font-weight: 400\">Average: b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec \u1edf gi\u1eefa<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n h\u00e3y vi\u1ebft hai c\u00e2u l\u1ec7nh IF AND ri\u00eang l\u1ebb:<\/span><\/p>\n<p><strong>IF(AND(B2&lt;20, C2&lt;3), \u201cExcellent\u201d, \u2026)<\/strong><\/p>\n<p><strong>IF(AND(B2&gt;30, C2&gt;5), \u201cPoor\u201d, \u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u2026 V\u00e0 l\u1ed3ng c\u00e1i n\u00e0y v\u00e0o c\u00e1i kia:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;30, C2&gt;5), \u201cPoor\u201d, IF(AND(B2&lt;20, C2&lt;3), \u201cExcellent\u201d, \u201cAverage\u201d))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_33342\" aria-describedby=\"caption-attachment-33342\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33342\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-10.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 10\" width=\"605\" height=\"216\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-10\"><figcaption id=\"caption-attachment-33342\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 10<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_AND_phan_biet_chu_hoa_chu_thuong_trong_Excel\"><\/span><b>H\u00e0m IF AND ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp trong ph\u1ea7n \u0111\u1ea7u, c\u00e1c c\u00f4ng th\u1ee9c IF AND trong Excel kh\u00f4ng ph\u00e2n bi\u1ec7t gi\u1eefa k\u00fd t\u1ef1 vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng v\u00ec h\u00e0m AND v\u1ec1 b\u1ea3n ch\u1ea5t l\u00e0 kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng v\u00e0 mu\u1ed1n \u0111\u00e1nh gi\u00e1 \u0111i\u1ec1u ki\u1ec7n AND c\u00f3 t\u00ednh \u0111\u1ebfn tr\u01b0\u1eddng h\u1ee3p v\u0103n b\u1ea3n, h\u00e3y th\u1ef1c hi\u1ec7n t\u1eebng ph\u00e9p th\u1eed logic ri\u00eang l\u1ebb b\u00ean trong h\u00e0m EXACT v\u00e0 l\u1ed3ng c\u00e1c h\u00e0m \u0111\u00f3 v\u00e0o c\u00e2u l\u1ec7nh AND c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p><strong>IF(AND(EXACT(<i>cell<\/i>,\u201d<i>condition1<\/i>\u201c), EXACT(<i>cell<\/i>,\u201d<i>condition2<\/i>\u201c)), value_if_true, value_if_false)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd g\u1eafn c\u1edd c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng c\u1ee7a m\u1ed9t kh\u00e1ch h\u00e0ng c\u1ee5 th\u1ec3 (v\u00ed d\u1ee5: c\u00f4ng ty c\u00f3 t\u00ean l\u00e0 <\/span><i><span style=\"font-weight: 400\">Cyberspace<\/span><\/i><span style=\"font-weight: 400\">) v\u1edbi s\u1ed1 ti\u1ec1n v\u01b0\u1ee3t qu\u00e1 m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n nh\u01b0 $100.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, m\u1ed9t s\u1ed1 t\u00ean c\u00f4ng ty trong c\u1ed9t B tr\u00f4ng gi\u1ed1ng nhau trong ph\u1ea7n tr\u00edch d\u1eabn c\u00e1c k\u00fd t\u1ef1, tuy nhi\u00ean ch\u00fang l\u00e0 c\u00e1c c\u00f4ng ty kh\u00e1c nhau, v\u00ec v\u1eady ch\u00fang ta ph\u1ea3i ki\u1ec3m tra t\u00ean ch\u00ednh x\u00e1c.\u00a0<\/span><\/p>\n<p><strong>=IF(AND(EXACT(B2, \u201cCyberspace\u201d), C2&gt;100), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp t\u00ean v\u00e0 s\u1ed1 ti\u1ec1n c\u1ee7a kh\u00e1ch h\u00e0ng m\u1ee5c ti\u00eau v\u00e0o hai \u00f4 ri\u00eang bi\u1ec7t v\u00e0 tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 \u0111\u00f3. Ch\u1ec9 c\u1ea7n nh\u1edb kh\u00f3a c\u00e1c tham chi\u1ebfu \u00f4 b\u1eb1ng d\u1ea5u $ (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 $G $1 v\u00e0 $G$2) \u0111\u1ec3 ch\u00fang kh\u00f4ng thay \u0111\u1ed5i khi b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c h\u00e0ng kh\u00e1c:<\/span><\/p>\n<p><strong>=IF(AND(EXACT(B2, $G$1), C2&gt;$G$2), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp b\u1ea5t k\u1ef3 t\u00ean v\u00e0 s\u1ed1 ti\u1ec1n n\u00e0o v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd g\u1eafn c\u1edd c\u00e1c \u0111\u01a1n h\u00e0ng t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng c\u1ee7a b\u1ea1n:<\/span><\/p>\n<figure id=\"attachment_33343\" aria-describedby=\"caption-attachment-33343\" style=\"width: 611px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33343\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-11.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 11\" width=\"611\" height=\"257\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-11\"><figcaption id=\"caption-attachment-33343\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 11<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"IF_OR_AND_cong_thuc_trong_Excel\"><\/span><b>IF OR AND c\u00f4ng th\u1ee9c trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong c\u00f4ng th\u1ee9c IF c\u1ee7a Excel, b\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n ch\u1ec9 s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m logic. \u0110\u1ec3 ki\u1ec3m tra c\u00e1c k\u1ebft h\u1ee3p kh\u00e1c nhau c\u1ee7a nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do k\u1ebft h\u1ee3p IF, AND, OR v\u00e0 c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 ch\u1ea1y c\u00e1c b\u00e0i ki\u1ec3m tra logic c\u1ea7n thi\u1ebft. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c IF AND OR ki\u1ec3m tra m\u1ed9t v\u00e0i \u0111i\u1ec1u ki\u1ec7n OR trong AND. V\u00e0 b\u00e2y gi\u1edd, t\u00f4i s\u1ebd ch\u1ec9 cho b\u1ea1n c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n hai ho\u1eb7c nhi\u1ec1u b\u00e0i ki\u1ec3m tra AND trong h\u00e0m OR.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u \u0111\u01a1n \u0111\u1eb7t h\u00e0ng c\u1ee7a hai kh\u00e1ch h\u00e0ng v\u1edbi s\u1ed1 ti\u1ec1n l\u1edbn h\u01a1n m\u1ed9t s\u1ed1 nh\u1ea5t \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n nh\u01b0 100 \u0111\u00f4 la.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong ng\u00f4n ng\u1eef Excel, c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a ch\u00fang t\u00f4i \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n theo c\u00e1ch sau:<\/span><\/p>\n<p><strong>OR(AND(<i>Customer1<\/i>, <i>Amount<\/i>&gt;100), AND(<i>Customer2<\/i>, <i>Amount<\/i>&gt;100)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed t\u00ean kh\u00e1ch h\u00e0ng n\u1eb1m trong c\u1ed9t B, s\u1ed1 ti\u1ec1n trong c\u1ed9t C, 2 t\u00ean m\u1ee5c ti\u00eau l\u00e0 G1 v\u00e0 G2 v\u00e0 s\u1ed1 ti\u1ec1n m\u1ee5c ti\u00eau \u1edf G3, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c \u0111\u01a1n \u0111\u1eb7t h\u00e0ng t\u01b0\u01a1ng \u1ee9ng b\u1eb1ng \u201cx\u201d:<\/span><\/p>\n<p><strong>=IF(OR(AND(B2=$G$1, C2&gt;$G$3), AND(B2=$G$2, C2&gt;$G$3)), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c v\u1edbi c\u00fa ph\u00e1p nh\u1ecf g\u1ecdn h\u01a1n:<\/span><\/p>\n<p><strong>=IF(AND(OR(B2=$G$1,B2= $G$2), C2&gt;$G$3), \u201cx\u201d, \u201c\u201d)<\/strong><\/p>\n<figure id=\"attachment_33344\" aria-describedby=\"caption-attachment-33344\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33344\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cc3b4ng-the1bba9c-if-and-trong-excel-12.png\" alt=\"C\u00f4ng th\u1ee9c IF AND trong Excel 12\" width=\"579\" height=\"256\" title=\"cc3b4ng-the1bba9c-if-and-trong-excel-12\"><figcaption id=\"caption-attachment-33344\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF AND trong Excel 12<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 AND c\u00f9ng nhau trong Excel. \u0110\u1ec3 hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c c\u00f4ng th\u1ee9c, b\u1ea1n h\u00e3y m\u1edf Excel ra v\u00e0 th\u1ef1c h\u00e0nh c\u00f9ng m\u00ecnh nh\u00e9. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u00e3 \u0111\u1ed3ng h\u00e0nh, ti\u1ebfp t\u1ee5c theo d\u00f5i \u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng ki\u1ebfn th\u1ee9c m\u1edbi nh\u1ea5t nh\u00e9!<\/span><\/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-372.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4604,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4603","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\/4603","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=4603"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4604"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}