{"id":2421,"date":"2024-12-02T07:43:17","date_gmt":"2024-12-02T07:43:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and\/"},"modified":"2024-12-02T07:43:17","modified_gmt":"2024-12-02T07:43:17","slug":"cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and\/","title":{"rendered":"C\u00e2u l\u1ec7nh IF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF\/AND"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, <\/span><span style=\"font-weight: 400\">ch\u00fang ta \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m IF<\/strong> v\u1edbi c\u00e1c con s\u1ed1, v\u0103n b\u1ea3n v\u00e0 ng\u00e0y th\u00e1ng trong Excel. Ti\u1ebfp t\u1ee5c b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng kh\u00e1c nh\u00e9!<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel, \u0111\u00f4i l\u00fac b\u1ea1n s\u1ebd \u0111\u1ed1i m\u1eb7t v\u1edbi nh\u1eefng b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p, c\u1ea7n ph\u1ea3i \u0111\u00e1nh gi\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac, ngh\u0129a l\u00e0 b\u1ea1n ph\u1ea3i x\u00e2y d\u1ef1ng c\u00e1c ph\u00e9p logic ph\u1ee9c t\u1ea1p h\u01a1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c. Trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd ch\u1ee9a c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n d\u1ec5 hi\u1ec3u nh\u1ea5t, ngo\u00e0i ra b\u1ea1n c\u00f2n t\u00ecm hi\u1ec3u ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-iferror-trong-power-bi-dax.html\"><strong>h\u00e0m IFERROR<\/strong><\/a> v\u00e0 IFNA n\u1eefa \u0111\u1ea5y!<\/span><\/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-674d65140492e\" 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\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Cach_su_dung_ham_IF_trong_Excel_voi_nhieu_dieu_kien\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_1_Su_dung_ham_IF_AND_trong_Excel\" title=\"V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng h\u00e0m IF &amp; AND trong Excel\">V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng h\u00e0m IF &amp; AND trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_2_Su_dung_IF_voi_ham_OR_trong_Excel\" title=\"V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m OR trong Excel\">V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m OR trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_3_Su_dung_IF_voi_cac_ham_AND_OR\" title=\"V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m AND &amp; OR\">V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m AND &amp; OR<\/a><\/li>\n<\/ul>\n<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Su_dung_nhieu_cau_lenh_IF_trong_Excel_cac_ham_IF_long_nhau\" title=\"S\u1eed d\u1ee5ng nhi\u1ec1u c\u00e2u l\u1ec7nh IF trong Excel (c\u00e1c h\u00e0m IF l\u1ed3ng nhau)\">S\u1eed d\u1ee5ng nhi\u1ec1u c\u00e2u l\u1ec7nh IF trong Excel (c\u00e1c h\u00e0m IF 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\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Su_dung_Excel_IF_trong_cong_thuc_mang\" title=\"S\u1eed d\u1ee5ng Excel IF trong c\u00f4ng th\u1ee9c m\u1ea3ng\">S\u1eed d\u1ee5ng Excel IF trong c\u00f4ng th\u1ee9c m\u1ea3ng<\/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\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Su_dung_ham_IF_cung_voi_cac_ham_Excel_khac\" title=\"S\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c\">S\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_1_Su_dung_IF_voi_cac_ham_SUM_AVERAGE_MIN_va_MAX\" title=\"V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX\">V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_2_IF_voi_ham_ISNUMBER_va_ISTEXT\" title=\"V\u00ed d\u1ee5 2. IF v\u1edbi h\u00e0m ISNUMBER v\u00e0 ISTEXT\">V\u00ed d\u1ee5 2. IF v\u1edbi h\u00e0m ISNUMBER v\u00e0 ISTEXT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Vi_du_3_Su_dung_ket_qua_tra_ve_boi_IF_trong_mot_ham_Excel_khac\" title=\"V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi IF trong m\u1ed9t h\u00e0m Excel kh\u00e1c\">V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi IF trong m\u1ed9t h\u00e0m Excel kh\u00e1c<\/a><\/li>\n<\/ul>\n<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-trong-excel-voi-nhieu-dieu-kien-if-and.html#Ham_IF_so_voi_IFERROR_va_IFNA\" title=\"H\u00e0m IF so v\u1edbi IFERROR v\u00e0 IFNA\">H\u00e0m IF so v\u1edbi IFERROR v\u00e0 IFNA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IF_trong_Excel_voi_nhieu_dieu_kien\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u00f3 2 lo\u1ea1i c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u2013 AND v\u00e0 OR. Do \u0111\u00f3, h\u00e0m IF c\u1ee7a b\u1ea1n ph\u1ea3i nh\u00fang m\u1ed9t <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-trong-excel-co-vi-du-minh-hoa.html\"><strong>h\u00e0m AND<\/strong><\/a> ho\u1eb7c OR t\u01b0\u01a1ng \u1ee9ng trong ph\u00e9p th\u1eed logic.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m AND: N\u1ebfu ki\u1ec3m tra logic c\u1ee7a b\u1ea1n ch\u1ee9a h\u00e0m AND, Microsoft Excel tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng; n\u1ebfu kh\u00f4ng n\u00f3 tr\u1ea3 v\u1ec1 FALSE.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u00e0m OR: Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m OR trong ki\u1ec3m tra logic, Excel s\u1ebd tr\u1ea3 v\u1ec1 TRUE n\u1ebfu b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng; tr\u1ea3 v\u1ec1 FALSE n\u1ebfu kh\u00f4ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n, ch\u00fang ta h\u00e3y xem m\u1ed9t v\u00e0i v\u00ed d\u1ee5 IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Su_dung_ham_IF_AND_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng h\u00e0m IF &amp; AND trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng k\u1ebft qu\u1ea3 c\u1ee7a hai \u0111i\u1ec3m thi. \u0110i\u1ec3m \u0111\u1ea7u ti\u00ean ghi trong c\u1ed9t C ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 20. \u0110i\u1ec3m th\u1ee9 hai ghi trong c\u1ed9t D ph\u1ea3i b\u1eb1ng ho\u1eb7c v\u01b0\u1ee3t 30. Ch\u1ec9 khi \u0111\u00e1p \u1ee9ng c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean, h\u1ecdc sinh m\u1edbi \u0111\u1ea1t \u0111i\u1ec3m cu\u1ed1i c\u00f9ng. thi.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c th\u00edch h\u1ee3p l\u00e0 vi\u1ebft ra \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc, sau \u0111\u00f3 k\u1ebft h\u1ee3p n\u00f3 trong \u0111\u1ed1i s\u1ed1 logic_test c\u1ee7a h\u00e0m IF c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u ki\u1ec7n: AND (B2&gt; = 20, C2&gt; = 30)<\/span><\/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-80.gif\" title=\"vba101_92019-nho-80\"><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-187.gif\" title=\"ex101_92019-nho-187\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c IF\/AND:<\/span><\/p>\n<p><strong>=IF((AND(C2&gt;=20, D2&gt;=30)), \u201cPass\u201d, \u201cFail\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Th\u1eadt d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng? C\u00f4ng th\u1ee9c tr\u00ean y\u00eau c\u1ea7u Excel tr\u1ea3 v\u1ec1 \u201cpass\u201d n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t C&gt; = 20 V\u00c0 gi\u00e1 tr\u1ecb trong c\u1ed9t D&gt; = 30. N\u1ebfu kh\u00f4ng, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cFail\u201d. \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi ch\u1ee9ng minh r\u1eb1ng h\u00e0m IF \/ AND trong Excel c\u1ee7a ch\u00fang ta l\u00e0 \u0111\u00fang:<\/span><\/p>\n<figure id=\"attachment_33357\" aria-describedby=\"caption-attachment-33357\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33357\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"1 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"530\" height=\"263\" title=\"1-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33357\" class=\"wp-caption-text\">1 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd r\u1eb1ng Microsoft Excel s\u1ebd ki\u1ec3m tra t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m AND, ngay c\u1ea3 khi m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 \u0111\u01b0\u1ee3c ki\u1ec3m tra \u0111\u00e1nh gi\u00e1 l\u00e0 FALSE. H\u00e0nh vi nh\u01b0 v\u1eady h\u01a1i b\u1ea5t th\u01b0\u1eddng v\u00ec trong h\u1ea7u h\u1ebft c\u00e1c ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh, c\u00e1c \u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ki\u1ec3m tra n\u1ebfu b\u1ea5t k\u1ef3 ki\u1ec3m tra n\u00e0o tr\u01b0\u1edbc \u0111\u00f3 tr\u1ea3 v\u1ec1 FALSE.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong th\u1ef1c t\u1ebf, m\u1ed9t c\u00f4ng th\u1ee9c IF\/AND c\u00f3 v\u1ebb \u0111\u00fang c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn l\u1ed7i v\u00ec t\u00ednh c\u1ee5 th\u1ec3 n\u00e0y. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd tr\u1ea3 v\u1ec1 \u201c<\/span><span style=\"font-weight: 400\">Divide by Zero Error<\/span><span style=\"font-weight: 400\">\u201d (#DIV\/0!) N\u1ebfu \u00f4 A2 b\u1eb1ng 0:<\/span><\/p>\n<p><strong>=IF(AND(A2&lt;&gt;0,(1\/A2)&gt;0.5),\u201dGood\u201d, \u201cBad\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau:<\/span><\/p>\n<p><strong>=IF(A2&lt;&gt;0, IF((1\/A2)&gt;0.5, \u201cGood\u201d, \u201cBad\u201d), \u201cBad\u201d)<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_2_Su_dung_IF_voi_ham_OR_trong_Excel\"><\/span><b>V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m OR trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m IF &amp; OR theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1. Tuy nhi\u00ean, kh\u00e1c v\u1edbi c\u00f4ng th\u1ee9c IF\/AND \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean l\u00e0 c\u00f4ng th\u1ee9c n\u00e0y tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ec v\u1eady, n\u1ebfu ch\u00fang ta s\u1eeda \u0111\u1ed5i c\u00f4ng th\u1ee9c tr\u00ean theo c\u00e1ch sau:<\/span><\/p>\n<p><strong>=IF((OR(C2&gt;=20, D2&gt;=30)), \u201cPass\u201d, \u201cFail\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u1ed9t E s\u1ebd c\u00f3 d\u1ea5u \u201cPass\u201d n\u1ebfu \u0111i\u1ec3m \u0111\u1ea7u ti\u00ean b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 20 HO\u1eb6C \u0111i\u1ec3m th\u1ee9 hai b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 30.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u00e1c sinh vi\u00ean c\u00f3 c\u01a1 h\u1ed9i t\u1ed1t h\u01a1n \u0111\u1ec3 v\u01b0\u1ee3t qua k\u1ef3 thi cu\u1ed1i k\u1ef3 v\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n nh\u01b0 v\u1eady (Scott \u0111\u1eb7c bi\u1ec7t kh\u00f4ng may m\u1eafn khi ch\u1ec9 tr\u01b0\u1ee3t 1 \u0111i\u1ec3m:)<\/span><\/p>\n<figure id=\"attachment_33358\" aria-describedby=\"caption-attachment-33358\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33358\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"2 C\u00e2u l\u1ec7nh IaF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"530\" height=\"261\" title=\"2-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33358\" class=\"wp-caption-text\">2 C\u00e2u l\u1ec7nh IaF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_3_Su_dung_IF_voi_cac_ham_AND_OR\"><\/span><b>V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m AND &amp; OR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ph\u1ea3i \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh d\u1ef1a tr\u00ean m\u1ed9t s\u1ed1 t\u1eadp h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng c\u1ea3 hai h\u00e0m AND &amp; OR c\u00f9ng m\u1ed9t l\u00fac.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u1ea3ng tr\u00ean, gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u00e1c ti\u00eau ch\u00ed sau \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 m\u1ee9c \u0111\u1ed9 th\u00e0nh c\u00f4ng c\u1ee7a h\u1ecdc sinh:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u ki\u1ec7n 1: c\u1ed9t C&gt;=20 v\u00e0 c\u1ed9t D&gt;=25<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u ki\u1ec7n 2: c\u1ed9t C&gt;=15 v\u00e0 c\u1ed9t D&gt;=20<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu m\u1ed9t trong hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, b\u00e0i ki\u1ec3m tra cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c coi l\u00e0 \u0111\u1ea1t(pass), n\u1ebfu kh\u00f4ng th\u00ec kh\u00f4ng \u0111\u1ea1t(fail).<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c nghe c\u00f3 v\u1ebb ph\u1ee9c t\u1ea1p, nh\u01b0ng trong gi\u00e2y l\u00e1t, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng kh\u00f4ng ph\u1ea3i v\u1eady! B\u1ea1n ch\u1ec9 c\u1ea7n bi\u1ec3u th\u1ecb hai \u0111i\u1ec1u ki\u1ec7n d\u01b0\u1edbi d\u1ea1ng c\u00e2u l\u1ec7nh AND v\u00e0 \u0111\u1eb7t ch\u00fang trong h\u00e0m OR v\u00ec b\u1ea1n kh\u00f4ng y\u00eau c\u1ea7u \u0111\u00e1p \u1ee9ng c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n, ch\u1ec9 c\u1ea7n \u0111\u00e1p \u1ee9ng:<\/span><\/p>\n<p><strong>OR(AND(C2&gt;=20, D2&gt;=25), AND(C2&gt;=15, D2&gt;=20)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, vi\u1ec7c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html\"><strong>h\u00e0m OR<\/strong><\/a> \u1edf tr\u00ean l\u00e0m ph\u00e9p ki\u1ec3m tra logic trong h\u00e0m IF v\u00e0 cung c\u1ea5p c\u00e1c \u0111\u1ed1i s\u1ed1 value_if_true v\u00e0 value_if_false. K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c IF sau v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND\/OR:<\/span><\/p>\n<p><strong>=IF(OR(AND(C2&gt;=20, D2&gt;=25), AND(C2&gt;=15, D2&gt;=20)), \u201cPass\u201d, \u201cFail\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi cho th\u1ea5y r\u1eb1ng ch\u00fang ta \u0111\u00e3 c\u00f3 c\u00f4ng th\u1ee9c \u0111\u00fang:<\/span><\/p>\n<figure id=\"attachment_33359\" aria-describedby=\"caption-attachment-33359\" style=\"width: 537px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33359\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"3 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"537\" height=\"276\" title=\"3-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33359\" class=\"wp-caption-text\">3 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u01b0\u01a1ng nhi\u00ean, kh\u00f4ng ph\u1ea3i b\u1ea1n ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng hai h\u00e0m AND\/OR trong c\u00f4ng th\u1ee9c\u00a0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\">h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel<\/a> <\/strong>m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m logic kh\u00e1c mi\u1ec5n l\u00e0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2016, 2013, 2010 v\u00e0 2007, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n bao g\u1ed3m kh\u00f4ng qu\u00e1 255 \u0111\u1ed1i s\u1ed1 v\u00e0 t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u1ee7a 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 v\u1ec1 tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 30 \u0111\u1ed1i s\u1ed1 v\u00e0 t\u1ed5ng \u0111\u1ed9 d\u00e0i c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n kh\u00f4ng \u0111\u01b0\u1ee3c v\u01b0\u1ee3t qu\u00e1 1.024 k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_nhieu_cau_lenh_IF_trong_Excel_cac_ham_IF_long_nhau\"><\/span><b>S\u1eed d\u1ee5ng nhi\u1ec1u c\u00e2u l\u1ec7nh IF trong Excel (c\u00e1c h\u00e0m IF l\u1ed3ng nhau)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u1ea7n t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c logic ph\u1ee9c t\u1ea1p h\u01a1n cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 bao g\u1ed3m c\u00e1c c\u00e2u l\u1ec7nh IF b\u1ed5 sung trong c\u00e1c \u0111\u1ed1i s\u1ed1 value_if_true v\u00e0 value_if_false c\u1ee7a c\u00f4ng th\u1ee9c IF trong Excel c\u1ee7a b\u1ea1n. Nhi\u1ec1u h\u00e0m IF n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00e1c<strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\"> h\u00e0m IF And<\/a><\/strong> v\u00e0 ch\u00fang c\u00f3 th\u1ec3 t\u1ecf ra \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c c\u1ee7a m\u00ecnh tr\u1ea3 v\u1ec1 3 ho\u1eb7c nhi\u1ec1u k\u1ebft qu\u1ea3 kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh: gi\u1ea3 s\u1eed b\u1ea1n kh\u00f4ng ch\u1ec9 mu\u1ed1n \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3 c\u1ee7a h\u1ecdc sinh l\u00e0 Pass\/Fail, m\u00e0 c\u00f2n x\u00e1c \u0111\u1ecbnh t\u1ed5ng \u0111i\u1ec3m l\u00e0 \u201cGood\u201d, \u201c<\/span><i><span style=\"font-weight: 400\">Satisfactory<\/span><\/i><span style=\"font-weight: 400\">\u201d v\u00e0 \u201cPoor\u201d. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u1ed1t(Good): 60 tr\u1edf l\u00ean (&gt;=60)<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ea1t y\u00eau c\u1ea7u(<\/span><i><span style=\"font-weight: 400\">Satisfactory)<\/span><\/i><span style=\"font-weight: 400\">: t\u1eeb 40 \u0111\u1ebfn 60 (&gt;40 v\u00e0 &lt;60)<\/span><\/p>\n<p><span style=\"font-weight: 400\">K\u00e9m(Bad): 40 tr\u1edf xu\u1ed1ng (&lt;=40)<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t c\u1ed9t b\u1ed5 sung (E) v\u1edbi c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong c\u1ed9t C v\u00e0 D:<\/span><\/p>\n<p><strong>=C2+D2<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33363\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/abc.png\" width=\"353\" height=\"256\" title=\"abc\"><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y vi\u1ebft m\u1ed9t h\u00e0m IF l\u1ed3ng nhau d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u00ean. B\u1ea1n n\u00ean b\u1eaft \u0111\u1ea7u v\u1edbi \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng nh\u1ea5t v\u00e0 l\u00e0m cho c\u00e1c ch\u1ee9c n\u0103ng c\u1ee7a b\u1ea1n c\u00e0ng \u0111\u01a1n gi\u1ea3n c\u00e0ng t\u1ed1t. C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(E2&gt;=60, \u201cGood\u201d, IF(E2&gt;40, \u201cSatisfactory\u201d, \u201cPoor \u201c))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n th\u1ea5y \u0111\u1ea5y, ch\u1ec9 m\u1ed9t h\u00e0m IF l\u1ed3ng nhau l\u00e0 \u0111\u1ee7 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y. \u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng nhi\u1ec1u h\u00e0m IF h\u01a1n n\u1ebfu b\u1ea1n mu\u1ed1n. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(E2&gt;=70, \u201cExcellent\u201d, IF(E2&gt;=60, \u201cGood\u201d, IF(E2&gt;40, \u201cSatisfactory\u201d, \u201cPoor \u201c)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c tr\u00ean b\u1ed5 sung th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n: t\u1ed5ng \u0111i\u1ec3m t\u1eeb 70 \u0111i\u1ec3m tr\u1edf l\u00ean l\u00e0 \u0111\u1ea1t ti\u00eau chu\u1ea9n \u201c<\/span><span style=\"font-weight: 400\">Excellent<\/span><span style=\"font-weight: 400\">\u201c(xu\u1ea5t s\u1eafc).<\/span><\/p>\n<figure id=\"attachment_33361\" aria-describedby=\"caption-attachment-33361\" style=\"width: 618px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33361\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"5 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"618\" height=\"264\" title=\"5-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33361\" class=\"wp-caption-text\">5 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_Excel_IF_trong_cong_thuc_mang\"><\/span><b>S\u1eed d\u1ee5ng Excel IF trong c\u00f4ng th\u1ee9c m\u1ea3ng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, IF c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c m\u1ea3ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c SUM\/IF c\u1ee7a m\u1ea3ng sau minh h\u1ecda c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh thay v\u00ec c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ef1c:<\/span><\/p>\n<p><strong>=SUM(IF(B1:B5&lt;=1,1,2))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd g\u00e1n m\u1ed9t s\u1ed1 \u201c\u0111i\u1ec3m\u201d nh\u1ea5t \u0111\u1ecbnh cho m\u1ed7i gi\u00e1 tr\u1ecb trong c\u1ed9t B \u2013 n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb b\u1eb1ng ho\u1eb7c nh\u1ecf h\u01a1n 1, n\u00f3 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi 1 \u0111i\u1ec3m; v\u00e0 2 \u0111i\u1ec3m \u0111\u01b0\u1ee3c g\u00e1n cho m\u1ed7i gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 1. V\u00e0 sau \u0111\u00f3, h\u00e0m SUM c\u1ed9ng k\u1ebft qu\u1ea3 1 v\u00e0 2, nh\u01b0 th\u1ec3 hi\u1ec7n trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng Excel IF trong c\u00f4ng th\u1ee9c m\u1ea3ng<\/span><\/p>\n<figure id=\"attachment_33362\" aria-describedby=\"caption-attachment-33362\" style=\"width: 276px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33362\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"6 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"276\" height=\"167\" title=\"6-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33362\" class=\"wp-caption-text\">6 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: V\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e3y nh\u1edb nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadp ch\u00ednh x\u00e1c nh\u00e9!<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_IF_cung_voi_cac_ham_Excel_khac\"><\/span><b>S\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1eeba r\u1ed3i ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u1edbi c\u00e1c h\u00e0m logic AND v\u00e0 OR. B\u00e2y gi\u1edd, h\u00e3y xem nh\u1eefng h\u00e0m Excel kh\u00e1c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi IF nh\u00e9!<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Su_dung_IF_voi_cac_ham_SUM_AVERAGE_MIN_va_MAX\"><\/span><b>V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 v\u1ec1 c\u00e1c h\u00e0m IF l\u1ed3ng nhau, ch\u00fang ta \u0111\u00e3 vi\u1ebft c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 x\u1ebfp h\u1ea1ng (Xu\u1ea5t s\u1eafc, T\u1ed1t, \u0110\u1ea1t y\u00eau c\u1ea7u ho\u1eb7c K\u00e9m) d\u1ef1a tr\u00ean t\u1ed5ng \u0111i\u1ec3m c\u1ee7a t\u1eebng h\u1ecdc sinh. Sau \u0111\u00f3, ch\u00fang ta \u0111\u00e3 th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u1edbi c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng \u0111i\u1ec3m trong c\u1ed9t C v\u00e0 D.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 c\u1ea5u tr\u00fac \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0 kh\u00f4ng cho ph\u00e9p b\u1ea5t k\u1ef3 s\u1eeda \u0111\u1ed5i n\u00e0o? Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, thay v\u00ec th\u00eam c\u1ed9t tr\u1ee3 gi\u00fap, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c If c\u1ee7a m\u00ecnh, nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF((C2+D2)&gt;=60, \u201cGood\u201d, IF((C2+D2)=&gt;40, \u201cSatisfactory\u201d, \u201cPoor \u201c))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u01b0\u1ee3c r\u1ed3i, nh\u01b0ng n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n ch\u1ee9a nhi\u1ec1u \u0111i\u1ec3m ri\u00eang l\u1ebb, ch\u1eb3ng h\u1ea1n nh\u01b0 5 c\u1ed9t kh\u00e1c nhau tr\u1edf l\u00ean th\u00ec sao? T\u1ed5ng s\u1ed1 r\u1ea5t nhi\u1ec1u s\u1ed1 li\u1ec7u tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c IF s\u1ebd l\u00e0m cho n\u00f3 c\u1ef1c k\u1ef3 l\u1edbn. M\u1ed9t gi\u1ea3i ph\u00e1p thay th\u1ebf l\u00e0 nh\u00fang h\u00e0m SUM v\u00e0o ki\u1ec3m tra logic c\u1ee7a IF, nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(SUM(C2:F2)&gt;=120, \u201cGood\u201d, IF(SUM(C2:F2)&gt;=90, \u201cSatisfactory\u201d, \u201cPoor \u201c))<\/strong><\/p>\n<figure id=\"attachment_33352\" aria-describedby=\"caption-attachment-33352\" style=\"width: 655px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"7 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"655\" height=\"263\" title=\"7-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33352\" class=\"wp-caption-text\">7 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel kh\u00e1c trong c\u00f4ng th\u1ee9c IF c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p><b>IF v\u00e0 AVERAGE<\/b><span style=\"font-weight: 400\">:<\/span><\/p>\n<p><strong>=IF(AVERAGE(C2:F2)&gt;=30,\u201dGood\u201d,IF(AVERAGE(C2:F2)&gt;=25,\u201dSatisfactory\u201d,\u201dPoor \u201c))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 \u201cGood\u201d n\u1ebfu \u0111i\u1ec3m trung b\u00ecnh trong c\u1ed9t C:F b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 30, \u201cSatisfactory\u201d n\u1ebfu \u0111i\u1ec3m trung b\u00ecnh t\u1eeb 29 \u0111\u1ebfn 25, v\u00e0 \u201cPoor\u201d n\u1ebfu nh\u1ecf h\u01a1n 25.<\/span><\/p>\n<p><b>IF v\u00e0 MAX\/MIN<\/b><span style=\"font-weight: 400\">:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00ecm \u0111i\u1ec3m cao nh\u1ea5t v\u00e0 th\u1ea5p nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MAX v\u00e0 MIN t\u01b0\u01a1ng \u1ee9ng. Gi\u1ea3 s\u1eed r\u1eb1ng c\u1ed9t F l\u00e0 c\u1ed9t t\u1ed5ng \u0111i\u1ec3m, c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y c\u00f3 t\u00e1c d\u1ee5ng:<\/span><\/p>\n<p><strong>MAX: =IF(F2=MAX($F$2:$F$10), \u201cBest result\u201d, \u201c\u201d)<\/strong><\/p>\n<p><strong>MIN: =IF(F2=MIN($F$2:$F$10), \u201cWorst result\u201d, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 c\u1ea3 k\u1ebft qu\u1ea3 Min v\u00e0 Max trong c\u00f9ng m\u1ed9t c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng m\u1ed9t trong c\u00e1c h\u00e0m tr\u00ean v\u00e0o h\u00e0m kia, v\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(F2=MAX($F$2:$F$10) ,\u201dBest result\u201d, IF(F2=MIN($F$2:$F$10), \u201cWorst result\u201d, \u201c\u201d))<\/strong><\/p>\n<figure id=\"attachment_33353\" aria-describedby=\"caption-attachment-33353\" style=\"width: 526px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33353\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"8 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"526\" height=\"283\" title=\"8-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33353\" class=\"wp-caption-text\">8 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m trang t\u00ednh t\u00f9y ch\u1ec9nh c\u1ee7a m\u00ecnh. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 v\u1edbi c\u00e1c h\u00e0m GetCellColor \/ GetCellFontColor \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c k\u1ebft qu\u1ea3 kh\u00e1c nhau d\u1ef1a tr\u00ean m\u00e0u \u00f4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i ra, Excel c\u00f2n cung c\u1ea5p m\u1ed9t s\u1ed1 h\u00e0m IF \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 t\u00ednh to\u00e1n d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1 d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng COUNTIF v\u00e0 COUNTIFS t\u01b0\u01a1ng \u1ee9ng. \u0110\u1ec3 t\u00ecm t\u1ed5ng gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m SUMIF ho\u1eb7c SUMIFS. \u0110\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh theo c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng AVERAGEIF ho\u1eb7c AVERAGEIFS.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_2_IF_voi_ham_ISNUMBER_va_ISTEXT\"><\/span><b>V\u00ed d\u1ee5 2. IF v\u1edbi h\u00e0m ISNUMBER v\u00e0 ISTEXT<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">B\u1ea1n \u0111\u00e3 bi\u1ebft m\u1ed9t c\u00e1ch \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ISBLANK ch\u01b0a? Ngo\u00e0i ra Microsoft Excel cung c\u1ea5p c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0 s\u1ed1 \u2013 ISTEXT v\u00e0 ISNUMBER, c\u00f9ng xem ch\u00fang ho\u1ea1t \u0111\u1ed9ng th\u1ebf n\u00e0o:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF l\u1ed3ng nhau trong Excel tr\u1ea3 v\u1ec1 \u201cText\u201d n\u1ebfu \u00f4 B1 ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n n\u00e0o, \u201cNumber\u201d n\u1ebfu \u00f4 B1 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 v\u00e0 \u201cBlank\u201d n\u1ebfu \u00f4 B1 tr\u1ed1ng.<\/span><\/p>\n<p><strong>=IF(ISTEXT(B1), \u201cText\u201d, IF(ISNUMBER(B1), \u201cNumber\u201d, IF(ISBLANK(B1), \u201cBlank\u201d, \u201c\u201d)))<\/strong><\/p>\n<figure id=\"attachment_33354\" aria-describedby=\"caption-attachment-33354\" style=\"width: 275px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33354\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"9 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"275\" height=\"241\" title=\"9-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33354\" class=\"wp-caption-text\">9 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: c\u00f4ng th\u1ee9c tr\u00ean hi\u1ec3n th\u1ecb \u201cNumber\u201d cho c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng. \u0110i\u1ec1u n\u00e0y l\u00e0 do Microsoft Excel l\u01b0u tr\u1eef ng\u00e0y th\u00e1ng d\u01b0\u1edbi d\u1ea1ng s\u1ed1, b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1900, t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi 1.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_3_Su_dung_ket_qua_tra_ve_boi_IF_trong_mot_ham_Excel_khac\"><\/span><b>V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi IF trong m\u1ed9t h\u00e0m Excel kh\u00e1c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400\">\u0110\u00f4i khi, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n b\u1eb1ng c\u00e1ch nh\u00fang c\u00e2u l\u1ec7nh IF v\u00e0o m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c, thay v\u00ec s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m kh\u00e1c trong m\u1ed9t b\u00e0i ki\u1ec3m tra logic.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m CONCATENATE v\u00e0 h\u00e0m IF c\u00f9ng nhau:<\/span><\/p>\n<p><strong>=CONCATENATE(\u201cYou performed \u201c, IF(C1&gt;5,\u201dfantastic!\u201d, \u201cwell\u201d))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 l\u1ebd b\u1ea1n kh\u00f4ng kh\u00f4ng c\u1ea7n b\u1ea5t k\u1ef3 l\u1eddi gi\u1ea3i th\u00edch n\u00e0o v\u1ec1 ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u00ecn v\u00e0o \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_33355\" aria-describedby=\"caption-attachment-33355\" style=\"width: 574px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33355\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"10 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"574\" height=\"105\" title=\"10-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33355\" class=\"wp-caption-text\">10 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_so_voi_IFERROR_va_IFNA\"><\/span><b>H\u00e0m IF so v\u1edbi IFERROR v\u00e0 IFNA<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">C\u1ea3 hai h\u00e0m IFERROR v\u00e0 IFNA, \u0111\u1ec1u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaby l\u1ed7i trong c\u00f4ng th\u1ee9c Excel v\u00e0 thay th\u1ebf ch\u00fang b\u1eb1ng m\u1ed9t ph\u00e9p t\u00ednh kh\u00e1c, gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc ho\u1eb7c tin nh\u1eafn v\u0103n b\u1ea3n. Trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p IF ISERROR v\u00e0 IF ISNA \u0111\u1ec3 thay th\u1ebf<\/span><\/p>\n<p><span style=\"font-weight: 400\">S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 IFERROR v\u00e0 ISERROR x\u1eed l\u00fd t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i Excel c\u00f3 th\u1ec3 x\u1ea3y ra, bao g\u1ed3m <\/span><span style=\"font-weight: 400\">#VALUE!, #N\/A, #NAME?, #REF!, #NUM!, #DIV\/0!, and #NULL!<\/span><span style=\"font-weight: 400\">. Trong khi IFNA v\u00e0 ISNA ch\u1ec9 chuy\u00ean v\u1ec1 l\u1ed7i #N\/A.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1ec1 c\u00f4ng th\u1ee9c IFERROR:<\/span><\/p>\n<p><strong>=IFERROR(B2\/C2, \u201cSorry, an error has occurred\u201d)<\/strong><\/p>\n<figure id=\"attachment_33356\" aria-describedby=\"caption-attachment-33356\" style=\"width: 321px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33356\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and.png\" alt=\"11 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND\" width=\"321\" height=\"200\" title=\"11-cc3a2u-le1bb87nh-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-if-and\"><figcaption id=\"caption-attachment-33356\" class=\"wp-caption-text\">11 C\u00e2u l\u1ec7nh IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF AND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u1ed9t D hi\u1ec3n th\u1ecb th\u01b0\u01a1ng s\u1ed1 c\u1ee7a ph\u00e9p chia m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t B cho m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t C. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ea5y hai th\u00f4ng b\u00e1o l\u1ed7i trong \u00f4 D2 v\u00e0 D5 v\u00ec m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u bi\u1ebft r\u1eb1ng b\u1ea1n kh\u00f4ng th\u1ec3 chia m\u1ed9t s\u1ed1 b\u1eb1ng kh\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng mu\u1ed1n b\u1eaby t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i m\u00e0 thay v\u00e0o \u0111\u00f3 l\u00e0 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n g\u00e2y ra m\u1ed9t l\u1ed7i c\u1ee5 th\u1ec3. V\u00ed d\u1ee5: \u0111\u1ec3 thay th\u1ebf l\u1ed7i chia cho 0 b\u1eb1ng th\u00f4ng b\u00e1o c\u1ee7a ri\u00eang b\u1ea1n, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF sau:<\/span><\/p>\n<p><strong>=IF(C2=0, \u201cSorry, an error has occurred\u201d, B2\/C2)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t c\u1ea3 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ed3ng h\u00e0nh c\u00f9ng <strong>H\u1ecdc Excel Online<\/strong>, 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\/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-80.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2421","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\/2421","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=2421"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2422"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}