{"id":1623,"date":"2024-12-02T05:34:11","date_gmt":"2024-12-02T05:34:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-if-long-ghep-ham-if-voi-nhieu-dieu-kien-ham-iferror-ifna-va-nhieu-hon-nua\/"},"modified":"2024-12-02T05:34:11","modified_gmt":"2024-12-02T05:34:11","slug":"ham-if-long-ghep-ham-if-voi-nhieu-dieu-kien-ham-iferror-ifna-va-nhieu-hon-nua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-if-long-ghep-ham-if-voi-nhieu-dieu-kien-ham-iferror-ifna-va-nhieu-hon-nua\/","title":{"rendered":"H\u00e0m IF, l\u1ed3ng gh\u00e9p h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e0m IFERROR, IFNA v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">\u0110\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch m\u1ea1nh m\u1ebd, b\u1ea1n c\u00f3 th\u1ec3 ph\u1ea3i \u0111\u00e1nh gi\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac, c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n ph\u1ea3i x\u00e2y d\u1ef1ng c\u00e1c ph\u00e9p th\u1eed 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. C\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd cho b\u1ea1n th\u1ea5y l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u00fang. B\u1ea1n c\u0169ng s\u1ebd h\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng IF trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n c\u1ee7a <strong>h\u00e0m IFEFFOR<\/strong> v\u00e0 IFNA. T\u1ea5t c\u1ea3 s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft c\u1ee7a <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong><\/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-674d46d29ce47\" 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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Lam_the_nao_de_su_dung_ham_IF_voi_nhieu_dieu_kien\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<\/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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Vi_du_1_Su_dung_IF_AND_trong_Excel\" title=\"V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF &amp; AND trong Excel\">V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF &amp; 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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Vi_du_2_Su_dung_ham_IF_voi_OR_trong_Excel\" title=\"V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi OR trong Excel\">V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi 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-4\" href=\"https:\/\/blog.hocexcel.online\/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\" 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<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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Su_dung_nhieu_ham_IF_trong_Excel_cac_ham_IF_long_nhau\" title=\"S\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF trong Excel (c\u00e1c h\u00e0m IF l\u1ed3ng nhau):\">S\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m 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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Su_dung_Excel_IF_trong_cac_cong_thuc_mang\" title=\"S\u1eed d\u1ee5ng Excel IF trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng\">S\u1eed d\u1ee5ng Excel IF trong c\u00e1c 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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.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-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Vi_du_1_Su_dung_IF_voi_ham_SUM_AVERAGE_MIN_va_MAX\" title=\"V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX\">V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.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-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.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<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\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html#Ham_IFERROR_va_ham_IFNA\" title=\"H\u00e0m IFERROR v\u00e0 h\u00e0m IFNA\">H\u00e0m IFERROR v\u00e0 h\u00e0m IFNA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_ham_IF_voi_nhieu_dieu_kien\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u00f3i t\u00f3m l\u1ea1i, c\u00f3 th\u1ec3 c\u00f3 2 lo\u1ea1i \u0111i\u1ec1u ki\u1ec7n c\u01a1 b\u1ea3n \u2013 v\u1edbi h\u00e0m logic AND v\u00e0 OR.\u00a0Do \u0111\u00f3, h\u00e0m IF c\u1ee7a b\u1ea1n n\u00ean nh\u00fang m\u1ed9t h\u00e0m AND v\u00e0 OR \u0111\u1ec3 l\u00e0m ph\u00e9p th\u1eed logic t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m AND\u00a0.\u00a0N\u1ebfu ph\u00e9p th\u1eed logic c\u1ee7a b\u1ea1n ch\u1ee9a h\u00e0m AND v\u00e0 Microsoft Excel tr\u1ea3 v\u1ec1 TRUE n\u1ebfu\u00a0<strong>t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n<\/strong>\u00a0\u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng;\u00a0N\u1ebfu kh\u00f4ng n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 FALSE.<\/li>\n<li>H\u00e0m OR.\u00a0Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m OR trong ph\u00e9p th\u1eed logic, Excel tr\u1ea3 v\u1ec1 TRUE n\u1ebfu\u00a0\u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c\u00a0<strong>b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o<\/strong>\u00a0;\u00a0FALSE n\u1ebfu kh\u00f4ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\">H\u00e0m IF v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 minh h\u1ecda t\u1ed1t h\u01a1n v\u1ec1 v\u1ea5n \u0111\u1ec1 n\u00e0y, ch\u00fang ta h\u00e3y c\u00f9ng xem x\u00e9t m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Su_dung_IF_AND_trong_Excel\"><\/span>V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF &amp; AND trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng v\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a hai \u0111i\u1ec3m thi.\u00a0\u0110i\u1ec3m s\u1ed1 \u0111\u1ea7u ti\u00ean, \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong c\u1ed9t C, ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 20. \u0110i\u1ec3m s\u1ed1 th\u1ee9 hai, \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong c\u1ed9t D, ph\u1ea3i b\u1eb1ng ho\u1eb7c h\u01a1n 30. Ch\u1ec9 khi n\u00e0o c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, th\u00ec h\u1ecdc sinh m\u1edbi v\u01b0\u1ee3t qua k\u1ef3 thi.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c th\u00edch h\u1ee3p l\u00e0 ghi l\u1ea1i \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean, v\u00e0 sau \u0111\u00f3 k\u1ebft h\u1ee3p n\u00f3 trong \u0111\u1ed1i s\u1ed1 logic_test c\u1ee7a h\u00e0m IF:<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u ki\u1ec7n: AND (B2&gt; = 20, C2&gt; = 30)<\/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-47.gif\" title=\"vba101_92019-nho-47\"><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-117.gif\" title=\"ex101_92019-nho-117\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c IF \/ AND:\u00a0<strong>=IF((AND(C2&gt;=20, D2&gt;=30)), \u201cPass\u201d, \u201cFail\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">D\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng?\u00a0C\u00f4ng th\u1ee9c cho bi\u1ebft Excel tr\u1ea3 v\u1ec1 \u201cPass\u201d n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb c\u1ed9t C&gt; = 20 v\u00e0 gi\u00e1 tr\u1ecb trong c\u1ed9t D&gt; = 30.\u00a0N\u1ebfu kh\u00f4ng, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 \u201cFail\u201d.\u00a0H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y ch\u1ee9ng minh r\u1eb1ng h\u00e0m IF \/ AND c\u1ee7a ch\u00fang ta l\u00e0 ch\u00ednh x\u00e1c:<\/p>\n<figure style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"1 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-and.png\" alt=\"1 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"530\" height=\"263\"><figcaption class=\"wp-caption-text\">1 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Microsoft Excel ki\u1ec3m tra\u00a0<strong>t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n<\/strong>\u00a0trong h\u00e0m AND v\u00e0 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.\u00a0\u0110i\u1ec1u n\u00e0y l\u00e0 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 kh\u00f4ng c\u1ea7n ki\u1ec3m tra n\u1ebfu b\u1ea5t k\u1ef3 ki\u1ec3m tra tr\u01b0\u1edbc \u0111\u00f3 \u0111\u00e3 tr\u1ea3 v\u1ec1 FALSE.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean th\u1ef1c t\u1ebf, m\u1ed9t c\u00f4ng th\u1ee9c IF \/ AND \u0111\u00fang c\u00f3 th\u1ec3 b\u1ecb l\u1ed7i do t\u00ednh n\u0103ng n\u00e0y.\u00a0V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c\u00a0<strong>=IF(AND(A2&lt;&gt;0,(1\/A2)&gt;0.5),\u201dGood\u201d, \u201cBad\u201d)<\/strong> s\u1ebd tr\u1ea3 l\u1ea1i \u201cl\u1ed7i chia cho 0\u201d (# DIV \/ 0!) N\u1ebfu \u00f4 A2 b\u1eb1ng 0. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng\u00a0IF l\u1ed3ng gh\u00e9p\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(A2&lt;&gt;0, IF((1\/A2)&gt;0.5, \u201cGood\u201d, \u201cBad\u201d), \u201cBad\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel.html\">B\u00e0i t\u1eadp h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m trong Excel<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Su_dung_ham_IF_voi_OR_trong_Excel\"><\/span>V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi OR trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m IF &amp; OR theo m\u1ed9t c\u00e1ch t\u01b0\u01a1ng t\u1ef1.\u00a0S\u1ef1 kh\u00e1c bi\u1ec7t t\u1eeb c\u00f4ng th\u1ee9c IF \/ AND \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean l\u00e0 Excel tr\u1ea3 v\u1ec1 TRUE n\u1ebfu\u00a0\u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c\u00a0<strong>\u00edt nh\u1ea5t m\u1ed9t trong<\/strong>\u00a0c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, n\u1ebfu ch\u00fang ta s\u1eeda \u0111\u1ed5i c\u00f4ng th\u1ee9c tr\u00ean theo c\u00e1ch sau:<\/p>\n<p style=\"text-align: justify\"><strong>=IF((OR(C2&gt;=20, D2&gt;=30)), \u201cPass\u201d, \u201cFail\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u1ed9t E s\u1ebd c\u00f3 d\u1ea5u \u201cPass\u201d n\u1ebfu \u0111i\u1ec3m s\u1ed1 \u0111\u1ea7u ti\u00ean b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 20\u00a0<strong>ho\u1eb7c<\/strong>\u00a0\u0111i\u1ec3m s\u1ed1 th\u1ee9 hai b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 30.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh b\u00ean d\u01b0\u1edbi, nh\u1eefng h\u1ecdc sinh c\u1ee7a ch\u00fang ta c\u00f3 c\u01a1 h\u1ed9i t\u1ed1t h\u01a1n \u0111\u1ec3 v\u01b0\u1ee3t qua k\u1ef3 thi cu\u1ed1i c\u00f9ng v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 v\u1eady (b\u1ea1n Scott th\u1eadt kh\u00f4ng may m\u1eafn khi ch\u1ec9 thi\u1ebfu 1 \u0111i\u1ec3m.)<\/p>\n<figure style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"2 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-or.png\" alt=\"2 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"530\" height=\"261\"><figcaption class=\"wp-caption-text\">2 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n ch\u1ec9 s\u1eed d\u1ee5ng hai h\u00e0m AND \/ OR trong c\u00f4ng th\u1ee9c IF c\u1ee7a m\u00ecnh.\u00a0B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u h\u00e0m logic theo y\u00eau c\u1ea7u c\u1ee7a c\u00f4ng vi\u1ec7c, v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0:<\/p>\n<ul style=\"text-align: justify\">\n<li>Trong Excel 2013, 2010 v\u00e0 2007, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n kh\u00f4ng nhi\u1ec1u h\u01a1n 255 \u0111\u1ed1i s\u1ed1, v\u00e0 t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a c\u00f4ng th\u1ee9c kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 8192 k\u00fd t\u1ef1.<\/li>\n<li>Trong Excel 2003 v\u00e0 c\u00e1c b\u1ea3n c\u0169 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 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<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Su_dung_IF_voi_cac_ham_AND_OR\"><\/span>V\u00ed d\u1ee5 3. S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m AND &amp; OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ph\u1ea3i \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t v\u00e0i \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng c\u1ea3 h\u00e0m AND v\u00e0 OR t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html\">C\u00e1c h\u00e0m Logic trong Excel: And, Or, Xor v\u00e0 Not<\/a><\/p>\n<p style=\"text-align: justify\">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 th\u00e0nh c\u00f4ng c\u1ee7a h\u1ecdc sinh:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110i\u1ec1u ki\u1ec7n 1: c\u1ed9t C&gt; = 20 v\u00e0 c\u1ed9t D&gt; = 25<\/li>\n<li>\u0110i\u1ec1u ki\u1ec7n 2: c\u1ed9t C&gt; = 15 v\u00e0 c\u1ed9t D&gt; = 20<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ed9t trong hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, \u0111\u00e1nh gi\u00e1 cu\u1ed1i c\u00f9ng v\u1eabn l\u00e0 \u0111\u1ea1t, n\u1ebfu kh\u00f4ng \u2013 kh\u00f4ng \u0111\u1ea1ti.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00f4ng c\u00f3 v\u1ebb kh\u00f3 kh\u0103n, nh\u01b0ng ch\u1ec9 m\u1ed9t ch\u1ed1c, b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng n\u00f3 kh\u00f4ng ph\u1ea3i kh\u00f3!\u00a0B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ec3 hi\u1ec7n hai \u0111i\u1ec1u ki\u1ec7n l\u00e0 c\u00e2u l\u1ec7nh AND v\u00e0 \u0111\u00ednh k\u00e8m ch\u00fang trong h\u00e0m OR v\u00ec b\u1ea1n kh\u00f4ng c\u1ea7n c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng:<\/p>\n<p style=\"text-align: justify\"><strong>OR(AND(C2&gt;=20, D2&gt;=25), AND(C2&gt;=15, D2&gt;=20)<\/strong><\/p>\n<p style=\"text-align: justify\">Cu\u1ed1i c\u00f9ng, s\u1eed d\u1ee5ng h\u00e0m OR \u1edf tr\u00ean nh\u01b0 l\u00e0 ph\u00e9p th\u1eed logic trong h\u00e0m IF v\u00e0 cung c\u1ea5p c\u00e1c tham s\u1ed1 value_if_true v\u00e0 value_if_false.\u00a0K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c IF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND \/ OR:<\/p>\n<p style=\"text-align: justify\"><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 style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y ch\u1ec9 ra r\u1eb1ng ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c \u0111\u00fang:<\/p>\n<figure style=\"width: 537px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"3 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-multiple-conditions.png\" alt=\"3 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"537\" height=\"276\"><figcaption class=\"wp-caption-text\">3 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_nhieu_ham_IF_trong_Excel_cac_ham_IF_long_nhau\"><\/span>S\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF trong Excel (c\u00e1c h\u00e0m IF l\u1ed3ng nhau):<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n t\u1ea1o th\u00eam c\u00e1c ph\u00e9p th\u1eed logic cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam 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 c\u1ee7a b\u1ea1n.\u00a0C\u00e1c h\u00e0m IF n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0\u00a0<strong>c\u00e1c h\u00e0m IF l\u1ed3ng nhau<\/strong>\u00a0v\u00e0 ch\u00fang \u00a0\u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n tr\u1ea3 l\u1ea1i ba k\u1ebft qu\u1ea3 tr\u1edf l\u00ean.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh: gi\u1ea3 s\u1eed b\u1ea1n kh\u00f4ng ch\u1ec9 c\u1ea7n \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a sinh vi\u00ean nh\u01b0 Pass \/ Fail, m\u00e0 c\u00f2n x\u00e1c \u0111\u1ecbnh t\u1ed5ng s\u1ed1 \u0111i\u1ec3m l\u00e0 \u201c<em>Good<\/em>\u201c, \u201c<em>Satisfactory<\/em>\u201d v\u00e0 \u201c<em>Poor<\/em>\u201c.\u00a0.\u00a0V\u00ed d\u1ee5:<\/p>\n<ul style=\"text-align: justify\">\n<li>Good: 60 tr\u1edf l\u00ean (&gt; = 60)<\/li>\n<li>Satisfactory: t\u1eeb 40 \u0111\u1ebfn 60 (&gt; 40 v\u00e0 &lt;60)<\/li>\n<li>Poor: 40 ho\u1eb7c \u00edt h\u01a1n (&lt;= 40)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t c\u1ed9t b\u1ed5 sung (E) b\u1eb1ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 c\u1ed9ng c\u00e1c s\u1ed1 trong c\u1ed9t C v\u00e0 D:\u00a0<strong>=C2+D2<\/strong><\/p>\n<figure style=\"width: 537px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"3 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-multiple-conditions.png\" alt=\"3 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"537\" height=\"276\"><figcaption class=\"wp-caption-text\">4 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, h\u00e3y vi\u1ebft m\u1ed9t h\u00e0m IF l\u1ed3ng nhau d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u00ean.\u00a0\u0110\u00f3 \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t b\u00e0i th\u1ef1c h\u00e0nh t\u1ed1t \u0111\u1ec3 b\u1eaft \u0111\u1ea7u v\u1edbi \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng nh\u1ea5t v\u00e0 l\u00e0m cho c\u00e1ch\u00e0m c\u1ee7a b\u1ea1n c\u00e0ng \u0111\u01a1n gi\u1ea3n c\u00e0ng t\u1ed1t.\u00a0C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ee7a ch\u00fang ta nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(E2&gt;=60, \u201cGood\u201d, IF(E2&gt;40, \u201cSatisfactory\u201d, \u201cPoor \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, ch\u1ec9 c\u1ea7n m\u1ed9t h\u00e0m IF l\u1ed3ng nhau l\u00e0 \u0111\u1ee7 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.\u00a0\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c th\u00eam h\u00e0m IF \u00a0n\u1ebfu b\u1ea1n mu\u1ed1n.\u00a0V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><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 style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean b\u1ed5 sung th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u2013 t\u1ed5ng \u0111i\u1ec3m t\u1eeb 70 \u0111i\u1ec3m tr\u1edf l\u00ean \u0111\u01b0\u1ee3c coi x\u1ebfp h\u1ea1ng l\u00e0 \u201c<strong> Excellent<\/strong> \u201c.<\/p>\n<figure id=\"attachment_6385\" aria-describedby=\"caption-attachment-6385\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6385 size-full\" title=\"5 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-176.png\" alt=\"5 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"600\" height=\"257\"><figcaption id=\"caption-attachment-6385\" class=\"wp-caption-text\">5 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">T\u00f4\u0309ng h\u01a1\u0323p ta\u0300i li\u00ea\u0323u ho\u0323c <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a> hay nh\u00e2\u0301t 2018<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_Excel_IF_trong_cac_cong_thuc_mang\"><\/span>S\u1eed d\u1ee5ng Excel IF trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, IF c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong\u00a0c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng\u00a0.\u00a0B\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh gi\u00e1 m\u1ecdi th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ea3ng khi th\u1ef1c hi\u1ec7n l\u1ec7nh IF.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c SUM \/ IF m\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n c\u00e1ch m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ed5ng h\u1ee3p c\u00e1c \u00f4 trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 thay v\u00ec c\u1ed9ng gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf:<\/p>\n<p style=\"text-align: justify\"><strong>=SUM(IF(B1:B5&lt;=1,1,2))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c 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;\u00a0V\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 th\u00eam c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a 1 v\u00e0 2, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<figure style=\"width: 276px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"6 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-array.png\" alt=\"6 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"276\" height=\"167\"><figcaption class=\"wp-caption-text\">6 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>V\u00ec \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e3y nh\u1edb nh\u1ea5n\u00a0Ctrl + Shift + Enter\u00a0\u0111\u1ec3 nh\u1eadp ch\u00ednh x\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_IF_cung_voi_cac_ham_Excel_khac\"><\/span>S\u1eed d\u1ee5ng h\u00e0m IF c\u00f9ng v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc \u0111\u00e2y trong h\u01b0\u1edbng d\u1eabn n\u00e0y, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn m\u1ed9t v\u00e0i\u00a0v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c IF \u00a0th\u1ec3 hi\u1ec7n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m logic AND v\u00e0 OR.\u00a0B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y xem nh\u1eefng g\u00ec c\u00e1c h\u00e0m Excel kh\u00e1c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi IF v\u00e0 l\u1ee3i \u00edch ch\u00fang mang l\u1ea1i cho b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Su_dung_IF_voi_ham_SUM_AVERAGE_MIN_va_MAX\"><\/span>V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng IF v\u1edbi h\u00e0m SUM, AVERAGE, MIN v\u00e0 MAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi th\u1ea3o lu\u1eadn\u00a0c\u00e1c h\u00e0m IF l\u1ed3ng nhau\u00a0, ch\u00fang ta \u0111\u00e3 vi\u1ebft c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 c\u00e1c th\u1ee9 h\u1ea1ng kh\u00e1c nhau (Excellent, Good, Satisfactory ho\u1eb7c Poor) d\u1ef1a tr\u00ean t\u1ed5ng s\u1ed1 \u0111i\u1ec3m c\u1ee7a m\u1ed7i h\u1ecdc sinh.\u00a0Nh\u01b0 b\u1ea1n th\u1ea5y, 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 t\u1eeb c\u00e1c c\u1ed9t C v\u00e0 D.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 m\u1ed9t c\u1ea5u tr\u00fac \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc m\u00e0 kh\u00f4ng cho ph\u00e9p s\u1eeda \u0111\u1ed5i?\u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, thay v\u00ec th\u00eam c\u1ed9t ph\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c gi\u00e1 tr\u1ecb tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c IF c\u1ee7a b\u1ea1n, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=IF((C2+D2)&gt;=60, \u201cGood\u201d, IF((C2+D2)=&gt;40, \u201cSatisfactory\u201d, \u201cPoor \u201c))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u1ee3c r\u1ed3i, nh\u01b0ng n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n ch\u1ee9a nhi\u1ec1u c\u1ed9t \u0111i\u1ec3m, ch\u1eb3ng h\u1ea1n t\u1edbi 5 c\u1ed9t kh\u00e1c nhau ho\u1eb7c nhi\u1ec1u h\u01a1n?\u00a0T\u1ed5ng h\u1ee3p r\u1ea5t nhi\u1ec1u con s\u1ed1 tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c IF s\u1ebd l\u00e0m cho n\u00f3 r\u1ea5t d\u00e0i. C\u00e1ch thay th\u1ebf l\u00e0 nh\u00fang h\u00e0m SUM trong ph\u00e9p th\u1eed logic c\u1ee7a IF, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><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_6386\" aria-describedby=\"caption-attachment-6386\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6386 size-full\" title=\"7 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-177.png\" alt=\"7 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"600\" height=\"240\"><figcaption id=\"caption-attachment-6386\" class=\"wp-caption-text\">7 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m Excel kh\u00e1c \u0111\u1ec3 l\u00e0m ph\u00e9p th\u1eed logic trong c\u00e1c c\u00f4ng th\u1ee9c IF c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>IF v\u00e0 AVERAGE:<\/strong><\/p>\n<p style=\"text-align: justify\">=IF(AVERAGE(C2:F2)&gt;=30,\u201dGood\u201d,IF(AVERAGE(C2:F2)&gt;=25,\u201dSatisfactory\u201d,\u201dPoor \u201c))<\/p>\n<p style=\"text-align: justify\">N\u00f3 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 \u201d Good \u201d n\u1ebfu \u0111i\u1ec3m trung b\u00ecnh trong c\u00e1c c\u1ed9t C: F b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 30, \u201d Satisfactory \u201d n\u1ebfu \u0111i\u1ec3m trung b\u00ecnh t\u1eeb 29 \u0111\u1ebfn 25, v\u00e0 \u201d Poor \u201d n\u1ebfu d\u01b0\u1edbi 25.<\/p>\n<p style=\"text-align: justify\"><strong>IF v\u00e0 MAX \/ MIN:<\/strong><\/p>\n<p style=\"text-align: justify\">\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 c\u00e1c h\u00e0m MAX v\u00e0 MIN, t\u01b0\u01a1ng \u1ee9ng.\u00a0Gi\u1ea3 s\u1eed r\u1eb1ng c\u1ed9t F l\u00e0 c\u1ed9t t\u1ed5ng s\u1ed1 \u0111i\u1ec3m, c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y t\u00ecm ra k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\">MAX:\u00a0=IF(F2=MAX($F$2:$F$10), \u201cBest result\u201d, \u201c\u201d)<\/p>\n<p style=\"text-align: justify\">MIN:\u00a0=IF(F2=MIN($F$2:$F$10), \u201cWorst result\u201d, \u201c\u201d)<\/p>\n<p style=\"text-align: justify\">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 x\u1ebfp m\u1ed9t h\u00e0m l\u1ed3ng trong h\u00e0m kia, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\">=IF(F2=MAX($F$2:$F$10) ,\u201dBest result\u201d, IF(F2=MIN($F$2:$F$10), \u201cWorst result\u201d, \u201c\u201d))<\/p>\n<figure style=\"width: 526px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"8 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-max-min.png\" alt=\"8 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"526\" height=\"283\"><figcaption class=\"wp-caption-text\">8 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m b\u1ea3ng t\u00ednh tu\u1ef3 ch\u1ec9nh c\u1ee7a b\u1ea1n.\u00a0V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 v\u1edbi c\u00e1c h\u00e0m \u00a0GetCellColor \/\u00a0GetCellFontColor \u0111\u1ec3 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 kh\u00e1c nhau d\u1ef1a tr\u00ean m\u00e0u c\u1ee7a m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, Excel 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.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t 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.\u00a0\u0110\u1ec3 t\u00ecm ra m\u1ed9t t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean (c\u00e1c) \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, s\u1eed d\u1ee5ng c\u00e1c h\u00e0m SUMIF ho\u1eb7c SUMIFS.\u00a0\u0110\u1ec3 t\u00ednh trung b\u00ecnh theo c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng AVERAGEIF ho\u1eb7c AVERAGEIFS.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0H\u1ecdc excel n\u00e2ng cao online<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_IF_voi_Ham_ISNUMBER_va_ISTEXT\"><\/span>V\u00ed d\u1ee5 2. IF v\u1edbi H\u00e0m ISNUMBER v\u00e0 ISTEXT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u0111\u1ec3 ph\u00e1t hi\u1ec7n c\u00e1c\u00a0\u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng\u00a0b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ISBLANK.\u00a0Microsoft Excel cung c\u1ea5p c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u00e0 s\u1ed1 \u2013 ISTEXT v\u00e0 ISNUMBER.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF l\u1ed3ng nhau 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 B1 ch\u1ee9a m\u1ed9t gi\u00e1 tr\u1ecb s\u1ed1, v\u00e0 \u201cblank\u201d n\u1ebfu B1 tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><strong>=IF(ISTEXT(B1), \u201cText\u201d, IF(ISNUMBER(B1), \u201cNumber\u201d, IF(ISBLANK(B1), \u201cBlank\u201d, \u201c\u201d)))<\/strong><\/p>\n<figure style=\"width: 275px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"9 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-number-text-blank.png\" alt=\"9 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"275\" height=\"241\"><figcaption class=\"wp-caption-text\">9 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>H\u00e3y l\u01b0u \u00fd r\u1eb1ng c\u00f4ng th\u1ee9c tr\u00ean hi\u1ec3n th\u1ecb \u201d\u00a0<em>number<\/em>\u00a0\u201d cho c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 ng\u00e0y th\u00e1ng.\u00a0\u0110i\u1ec1u n\u00e0y l\u00e0 do Microsoft Excel l\u01b0u tr\u1eef c\u00e1c ng\u00e0y theo 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.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_Su_dung_ket_qua_tra_ve_boi_IF_trong_mot_ham_Excel_khac\"><\/span>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<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\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 IF trong 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 ph\u00e9p th\u1eed logic.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m CONCATINATE v\u00e0 IF c\u00f9ng nhau:<\/p>\n<p style=\"text-align: justify\"><strong>=CONCATENATE(\u201cYou performed \u201c, IF(C1&gt;5,\u201dfantastic!\u201d, \u201cgood\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">T\u00f4i tin r\u1eb1ng b\u1ea1n h\u1ea7u nh\u01b0 kh\u00f4ng c\u1ea7n b\u1ea5t k\u1ef3 l\u1eddi gi\u1ea3i th\u00edch n\u00e0o v\u1ec1 c\u00f4ng th\u1ee9c n\u1eefa, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u00ecn v\u00e0o h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<figure style=\"width: 574px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"10 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-concatenate.png\" alt=\"10 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"574\" height=\"108\"><figcaption class=\"wp-caption-text\">10 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_IFERROR_va_ham_IFNA\"><\/span>H\u00e0m IFERROR v\u00e0 h\u00e0m IFNA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u1ea3 hai h\u00e0m \u2013 <strong>h\u00e0m IFEFFOR<\/strong> v\u00e0 IFNA \u2013 \u0111\u1ec1u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 b\u1eaft nh\u1eefng l\u1ed7i trong c\u00e1c c\u00f4ng th\u1ee9c. V\u00e0 c\u1ea3 hai h\u00e0m c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh n\u1ebfu m\u1ed9t c\u00f4ng th\u1ee9c t\u1ea1o ra l\u1ed7i. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0 h\u00e0m IFEFFOR\u00a0x\u1eed l\u00fd t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i Excel, k\u1ec3 c\u1ea3 #VALUE !, # N \/ A, #NAME ?, #REF !, #NUM !, # DIV \/ 0 !, v\u00e0 #NULL !.\u00a0M\u1eb7c d\u00f9\u00a0<strong>h\u00e0m<\/strong>l\u00a0<strong>IFNA<\/strong>\u00a0ch\u1ec9 chuy\u00ean v\u1ec1 l\u1ed7i # N \/ A, ch\u00ednh x\u00e1c nh\u01b0 t\u00ean c\u1ee7a n\u00f3 v\u1eady.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a c\u00e1c h\u00e0m Error nh\u01b0 sau.<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m<\/strong><strong> IFERROR<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>IFERROR (<\/strong><strong>value<\/strong><strong> value_if_error)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m<\/strong><strong> IFNA<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>IFNA (<\/strong><strong>value<\/strong><strong>, value_if_na)<\/strong><\/p>\n<p style=\"text-align: justify\">Tham s\u1ed1 \u0111\u1ea7u ti\u00ean (gi\u00e1 tr\u1ecb) l\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c ki\u1ec3m tra cho m\u1ed9t l\u1ed7i.<\/p>\n<p style=\"text-align: justify\">Tham s\u1ed1 th\u1ee9 hai (value_if_error \/ value_if_na) l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 l\u1ea1i n\u1ebfu c\u00f4ng th\u1ee9c \u0111\u00e1nh gi\u00e1 l\u1ed7i (b\u1ea5t k\u1ef3 l\u1ed7i n\u00e0o trong tr\u01b0\u1eddng h\u1ee3p h\u00e0m IFEFFOR, \u00a0hay l\u1ed7i # N \/ A trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a IFNA).<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>N\u1ebfu b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 n\u00e0o l\u00e0 m\u1ed9t \u00f4 r\u1ed7ng, c\u1ea3 hai h\u00e0m Error s\u1ebd x\u1eed l\u00fd n\u00f3 nh\u01b0 m\u1ed9t chu\u1ed7i r\u1ed7ng (\u201c\u201d).<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 sau ch\u1ee9ng t\u1ecf vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IFERROR v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n:<\/p>\n<p style=\"text-align: justify\"><strong>=IFERROR(B2\/C2, \u201cSorry, an error has occurred\u201d)<\/strong><\/p>\n<figure style=\"width: 321px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"11 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/iferror.png\" alt=\"11 - h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" width=\"321\" height=\"200\"><figcaption class=\"wp-caption-text\">11 \u2013 h\u00e0m If n\u00e2ng cao: h\u00e0m iferror, h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u1ed9t D hi\u1ec3n th\u1ecb s\u1ed1 chia c\u1ee7a c\u1ed9t B cho c\u1ed9t C. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ea5y hai th\u00f4ng b\u00e1o l\u1ed7i trong c\u00e1c \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 cho 0.<\/p>\n<p style=\"text-align: justify\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, t\u1ed1t h\u01a1n b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 ng\u0103n ch\u1eb7n m\u1ed9t l\u1ed7i sau \u0111\u00f3 ISERROR ho\u1eb7c ISNA \u0111\u1ec3 b\u1eaft l\u1ed7i.\u00a0Th\u1ee9 nh\u1ea5t, \u0111\u00f3 l\u00e0 m\u1ed9t c\u00e1ch nhanh h\u01a1n (v\u1ec1 CPU) v\u00e0 th\u1ee9 hai n\u00f3 l\u00e0 m\u1ed9t \u00a0c\u00e1ch th\u1ef1c h\u00e0nh l\u1eadp tr\u00ecnh t\u1ed1t.\u00a0V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c IF sau \u0111\u00e2y t\u1ea1o ra k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m IFERROR \u0111\u00e3 tr\u00ecnh b\u00e0y \u1edf tr\u00ean:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(C2=0, \u201cSorry, an error has occurred\u201d, B2\/C2)<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng t\u1ea5t nhi\u00ean, c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p khi b\u1ea1n kh\u00f4ng th\u1ec3 ki\u1ec3m tra tr\u01b0\u1edbc t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m tham s\u1ed1, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c r\u1ea5t ph\u1ee9c t\u1ea1p, v\u00e0 d\u1ef1 \u0111o\u00e1n \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra.\u00a0Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p nh\u01b0 v\u1eady, c\u00e1c h\u00e0m ISERROR () v\u00e0 IFNA () th\u1ef1c s\u1ef1 c\u00f3 \u00edch.<\/p>\n<p style=\"text-align: justify\">Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem n\u1eb1m trong\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a> c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y.<\/p>\n<p style=\"text-align: justify\">\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-47.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1624,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1623","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\/1623","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=1623"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1623\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1624"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}