{"id":2436,"date":"2024-12-02T07:47:18","date_gmt":"2024-12-02T07:47:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel\/"},"modified":"2024-12-02T07:47:18","modified_gmt":"2024-12-02T07:47:18","slug":"cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y,<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i th\u00edch cho c\u00e1c b\u1ea1n <strong>c\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong> v\u00e0 cung c\u1ea5p m\u1ed9t <strong>s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 nh\u1eefng h\u00e0m IF l\u1ed3ng nhau<\/strong> ph\u1ed5 bi\u1ebfn nh\u1ea5t hay \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00f4ng vi\u1ec7c.<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu \u0111\u01b0\u1ee3c m\u1ed9t ng\u01b0\u1eddi n\u00e0o \u0111\u00f3 h\u1ecfi r\u1eb1ng ch\u1ee9c n\u0103ng n\u00e0o trong Excel m\u00e0 b\u1ea1n d\u00f9ng nhi\u1ec1u nh\u1ea5t, b\u1ea1n s\u1ebd tr\u1ea3 l\u1eddi nh\u01b0 th\u1ebf n\u00e0o? Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, \u0111\u00f3 ch\u00ednh l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\"><strong>h\u00e0m IF trong Excel<\/strong><\/a>. H\u00e0m IF n\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n s\u1ebd r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 vi\u1ebft. Nh\u01b0ng \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c ki\u1ec3m tra b\u1eb1ng thu\u1eadt to\u00e1n ph\u1ee9c t\u1ea1p v\u1edbi r\u1ea5t nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n? Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c, v\u00e0 h\u00e0m IF l\u00fac n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m IF l\u1ed3ng nhau. \u01afu \u0111i\u1ec3m l\u1edbn nh\u1ea5t c\u1ee7a h\u00e0m IF l\u1ed3ng nhau l\u00e0 n\u00f3 s\u1ebd cho ph\u00e9p b\u1ea1n ki\u1ec3m tra nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c l\u1ea7n ki\u1ec3m tra \u0111\u00f3 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i h\u01a1n c\u1ee7a Excel 2016, Excel 2013, Excel 2010 v\u00e0 Excel 2007, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng t\u1ed1i \u0111a 64 h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c. Trong Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, ch\u1ec9 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 7 h\u00e0m IF l\u1ed3ng nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF l\u1ed3ng nhau c\u00f9ng v\u1edbi ph\u1ea7n gi\u1ea3i th\u00edch chi ti\u1ebft v\u1ec1 c\u1ea5u tr\u00fac c\u00fa ph\u00e1p v\u00e0 logic c\u1ee7a ch\u00fang.<\/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-674d660507d0a\" 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\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Vi_du_1_Cong_thuc_IF_long_nhau_co_dienco_ban\" title=\"V\u00ed d\u1ee5 1: C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ed5 \u0111i\u1ec3n\/c\u01a1 b\u1ea3n\">V\u00ed d\u1ee5 1: C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ed5 \u0111i\u1ec3n\/c\u01a1 b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Vi_du_2_Ham_IF_long_nhau_voi_cac_phep_tinh_so_hoc\" title=\"V\u00ed d\u1ee5 2. H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc\">V\u00ed d\u1ee5 2. H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Ham_IF_long_nhau_trong_Excel_%E2%80%93_meo_va_cac_thu_thuat\" title=\"H\u00e0m IF l\u1ed3ng nhau trong Excel \u2013 m\u1eb9o v\u00e0 c\u00e1c th\u1ee7 thu\u1eadt\">H\u00e0m IF l\u1ed3ng nhau trong Excel \u2013 m\u1eb9o v\u00e0 c\u00e1c th\u1ee7 thu\u1eadt<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Gioi_han_IF_long_nhau\" title=\"Gi\u1edbi h\u1ea1n IF l\u1ed3ng nhau\">Gi\u1edbi h\u1ea1n IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Thu_tu_cua_cac_dieu_kien_trong_ham_IF_long_nhau_rat_quan_trong\" title=\"Th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF l\u1ed3ng nhau r\u1ea5t quan tr\u1ecdng\">Th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF l\u1ed3ng nhau r\u1ea5t quan tr\u1ecdng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Danh_gia_tinh_logic_cua_cong_thuc\" title=\"\u0110\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c\">\u0110\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Can_bang_dau_ngoac_cua_cac_ham_IF_long_nhau\" title=\"C\u00e2n b\u1eb1ng d\u1ea5u ngo\u1eb7c c\u1ee7a c\u00e1c h\u00e0m IF l\u1ed3ng nhau\">C\u00e2n b\u1eb1ng d\u1ea5u ngo\u1eb7c c\u1ee7a c\u00e1c h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Cach_xu_ly_cac_van_ban_va_cac_so_la_khac_nhau\" title=\"C\u00e1ch x\u1eed l\u00fd c\u00e1c v\u0103n b\u1ea3n v\u00e0 c\u00e1c s\u1ed1 l\u00e0 kh\u00e1c nhau\">C\u00e1ch x\u1eed l\u00fd c\u00e1c v\u0103n b\u1ea3n v\u00e0 c\u00e1c s\u1ed1 l\u00e0 kh\u00e1c nhau<\/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\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Them_dau_cach_hoac_ngat_dong_de_lam_cho_cac_IF_long_nhau_de_doc_hon\" title=\"Th\u00eam d\u1ea5u c\u00e1ch ho\u1eb7c ng\u1eaft d\u00f2ng \u0111\u1ec3 l\u00e0m cho c\u00e1c IF l\u1ed3ng nhau d\u1ec5 \u0111\u1ecdc h\u01a1n\">Th\u00eam d\u1ea5u c\u00e1ch ho\u1eb7c ng\u1eaft d\u00f2ng \u0111\u1ec3 l\u00e0m cho c\u00e1c IF l\u1ed3ng nhau d\u1ec5 \u0111\u1ecdc h\u01a1n<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-if-voi-nhieu-dieu-kien-trong-excel.html#Cac_lua_chon_thay_the_cho_IF_long_nhau_trong_Excel\" title=\"C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho IF l\u1ed3ng nhau trong Excel\">C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho IF l\u1ed3ng nhau trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_thuc_IF_long_nhau_co_dienco_ban\"><\/span><b>V\u00ed d\u1ee5 1: C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ed5 \u0111i\u1ec3n\/c\u01a1 b\u1ea3n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 danh s\u00e1ch h\u1ecdc sinh n\u1eb1m \u1edf c\u1ed9t A v\u00e0 \u0111i\u1ec3m thi c\u1ee7a h\u1ecd n\u1eb1m \u1edf c\u1ed9t B v\u00e0 b\u1ea1n mu\u1ed1n ph\u00e2n lo\u1ea1i \u0111i\u1ec3m v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Excellent: tr\u00ean 249<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Good: t\u1eeb 200 \u0111\u1ebfn 249<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Satisfactory: t\u1eeb 150 \u0111\u1ebfn 199<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Poor: d\u01b0\u1edbi 150<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng vi\u1ebft m\u1ed9t h\u00e0m IF l\u1ed3ng nhau d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed tr\u00ean. \u0110\u00e2y l\u00e0 m\u1ed9t c\u01a1 h\u1ed9i th\u1ef1c h\u00e0nh t\u1ed1t, b\u1eaft \u0111\u1ea7u v\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng nh\u1ea5t v\u00e0 vi\u1ebft h\u00e0m IF c\u1ee7a b\u1ea1n c\u00e0ng \u0111\u01a1n gi\u1ea3n c\u00e0ng t\u1ed1t. C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(B2&gt;249, \u201cExcellent\u201d, IF(B2&gt;=200, \u201cGood\u201d, IF(B2&gt;150, \u201cSatisfactory\u201d, \u201cPoor \u201c)))<\/strong><\/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-81.gif\" title=\"vba101_92019-nho-81\"><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-188.gif\" title=\"ex101_92019-nho-188\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">V\u00e0 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c s\u1ebd l\u00e0:<\/span><\/p>\n<figure id=\"attachment_33367\" aria-describedby=\"caption-attachment-33367\" style=\"width: 513px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33367\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ed5 \u0111i\u1ec3n\/c\u01a1 b\u1ea3n\" width=\"513\" height=\"266\" title=\"1-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33367\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ed5 \u0111i\u1ec3n\/c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n<p><b>C\u00e1ch hi\u1ec3u logic c\u1ee7a h\u00e0m IF l\u1ed3ng nhau:<\/b><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi nhi\u1ec1u ng\u01b0\u1eddi, <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\"><strong>h\u00e0m IF l\u1ed3ng nhau<\/strong> <\/a>c\u00f3 th\u1ec3 r\u1ea5t kh\u00f3 hi\u1ec3u. Nh\u01b0ng s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n nhi\u1ec1u n\u1ebfu b\u1ea1n nh\u00ecn nh\u1eadn ch\u00fang theo c\u00e1ch n\u00e0y:<\/span><\/p>\n<figure id=\"attachment_33368\" aria-describedby=\"caption-attachment-33368\" style=\"width: 259px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33368\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"2 C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"259\" height=\"64\" title=\"2-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33368\" class=\"wp-caption-text\">C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong th\u1ef1c t\u1ebf, nh\u1eefng g\u00ec c\u00f4ng th\u1ee9c th\u1ef1c s\u1ef1 y\u00eau c\u1ea7u Excel l\u00e0m l\u00e0 \u0111\u00e1nh gi\u00e1 ki\u1ec3m tra t\u00ednh logic c\u1ee7a \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m IF, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n logic, Excel s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c cung c\u1ea5p khi \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m If th\u1ee9 nh\u1ea5t kh\u00f4ng logic th\u00ec ti\u1ebfp t\u1ee5c ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai, \u0111i\u1ec1u ki\u1ec7n th\u1ee9 th\u1ee9 ba,\u2026<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra n\u1ebfu<strong> B2 &gt;= 249<\/strong> th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft\u00a0 qu\u1ea3 <strong>\u201cExcellent\u201d<\/strong>, n\u1ebfu kh\u00f4ng th\u00ec ki\u1ec3m tra ti\u1ebfp <strong>B2 &gt;=200<\/strong>, n\u1ebfu \u0111\u00fang th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 <strong>\u201cGood\u201d<\/strong>, n\u1ebfu kh\u00f4ng th\u00ec ki\u1ec3m tra ti\u1ebfp <strong>B2 &gt;=150<\/strong>, n\u1ebfu \u0111\u00fang th\u00ec <strong>\u201cSatisfactory\u201d<\/strong>, n\u1ebfu sai th\u00ec tr\u1ea3 v\u1ec1 <strong>\u201cPoor\u201d<\/strong><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_2_Ham_IF_long_nhau_voi_cac_phep_tinh_so_hoc\"><\/span><b>V\u00ed d\u1ee5 2. H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 m\u1ed9t y\u00eau c\u1ea7u \u0111i\u1ec3n h\u00ecnh kh\u00e1c: \u0111\u01a1n gi\u00e1 thay \u0111\u1ed5i t\u00f9y thu\u1ed9c v\u00e0o s\u1ed1 l\u01b0\u1ee3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh c\u1ee5 th\u1ec3 v\u00e0 nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 vi\u1ebft c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng gi\u00e1 cho s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng b\u1ea5t k\u1ef3 v\u00e0 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh. N\u00f3i c\u00e1ch kh\u00e1c, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u1ea7n ph\u1ea3i ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o ph\u1ea1m vi s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0 gi\u00e1 c\u1ea3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong b\u1ea3ng sau:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">S\u1ed1 l\u01b0\u1ee3ng h\u00e0ng<\/span><\/td>\n<td><span style=\"font-weight: 400\">Gi\u00e1 c\u1ea3 m\u1ed7i \u0111\u01a1n v\u1ecb<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1 \u2013 10<\/span><\/td>\n<td><span style=\"font-weight: 400\">20$<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">11 \u2013 19<\/span><\/td>\n<td><span style=\"font-weight: 400\">18$<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">20 \u2013 49<\/span><\/td>\n<td><span style=\"font-weight: 400\">16$<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">50 \u2013 100<\/span><\/td>\n<td><span style=\"font-weight: 400\">13$<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">H\u01a1n 101<\/span><\/td>\n<td><span style=\"font-weight: 400\">12$<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng vi\u1ec7c n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau. C\u00e1ch hi\u1ec3u logic t\u01b0\u01a1ng t\u1ef1 nh\u01b0 trong v\u00ed d\u1ee5 tr\u00ean, s\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n nh\u00e2n s\u1ed1 l\u01b0\u1ee3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u1edbi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c IF l\u1ed3ng nhau (t\u1ee9c l\u00e0 gi\u00e1 t\u01b0\u01a1ng \u1ee9ng tr\u00ean m\u1ed7i \u0111\u01a1n v\u1ecb h\u00e0ng h\u00f3a).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed ng\u01b0\u1eddi d\u00f9ng nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng v\u00e0o \u00f4 B8, c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c th\u1ebf hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">=B8*IF(B8&gt;=101, 12, IF(B8&gt;=50, 13, IF(B8&gt;=20, 16, IF( B8&gt;=11, 18, IF(B8&gt;=1, 20, \u201c\u201d)))))<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00e0 k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_33369\" aria-describedby=\"caption-attachment-33369\" style=\"width: 534px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33369\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc\" width=\"534\" height=\"245\" title=\"3-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33369\" class=\"wp-caption-text\">H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5 n\u00e0y ch\u1ec9 tr\u00ecnh b\u00e0y c\u00e1ch l\u00e0m chung v\u00e0 c\u01a1 b\u1ea3n, n\u1ebfu b\u1ea1n \u0111\u00e3 hi\u1ec3u, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh h\u00e0m If l\u1ed3ng nhau n\u00e0y t\u00f9y thu\u1ed9c v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3 c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p: thay v\u00ec \u1ea5n \u0111\u1ecbnh s\u1eb5n gi\u00e1 trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu c\u00e1c \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 (\u00f4 B2 \u0111\u1ebfn B6). C\u00e1ch n\u00e0y s\u1ebd cho ph\u00e9p b\u1ea1n ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u ngu\u1ed3n m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>=B8*IF(B8&gt;=101,B6, IF(B8&gt;=50, B5, IF(B8&gt;=20, B4, IF( B8&gt;=11, B3, IF(B8&gt;=1, B2, \u201c\u201d)))))<\/strong><\/p>\n<figure id=\"attachment_33370\" aria-describedby=\"caption-attachment-33370\" style=\"width: 528px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33370\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"4 C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"528\" height=\"244\" title=\"4-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33370\" class=\"wp-caption-text\">4 C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 th\u00eam (c\u00e1c) \u0111i\u1ec1u ki\u1ec7n IF b\u1ed5 sung \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh gi\u1edbi h\u1ea1n tr\u00ean, d\u01b0\u1edbi ho\u1eb7c c\u1ea3 hai \u0111\u1ea7u c\u1ee7a ph\u1ea1m vi s\u1ed1 ti\u1ec1n. Khi s\u1ed1 l\u01b0\u1ee3ng n\u1eb1m ngo\u00e0i ph\u1ea1m vi, c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o \u201cout of the range\u201d. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IF(OR(B8&gt;200,B8&lt;1), \u201cQty. out of range\u201d, B8*IF(B8&gt;=101,12, IF(B8&gt;=50, 13, IF(B8&gt;=20, 16, IF( B8&gt;=11, 18, IF(B8&gt;=1, 20, \u201c\u201d))))))<\/strong><\/p>\n<figure style=\"width: 408px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00ecnh 2: H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-fixed-range.png\" alt=\"Nested IF's formula with fixed bounds\" width=\"408\" height=\"267\"><figcaption class=\"wp-caption-text\">H\u00ecnh 2: H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">C\u00e1c c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 \u1edf tr\u00ean \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016 \u2013 2000. Trong Excel 2016 \u2013 Office 365, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFS theo c\u00e1c c\u00e1ch n\u00eau tr\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Excel chuy\u00ean nghi\u1ec7p \u0111\u00e3 quen thu\u1ed9c v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, v\u1ec1 c\u01a1 b\u1ea3n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y th\u1ef1c hi\u1ec7n \u0111i\u1ec1u t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m IF l\u1ed3ng nhau m\u00e0 ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn \u1edf tr\u00ean. M\u1eb7c d\u00f9 c\u00f4ng th\u1ee9c m\u1ea3ng kh\u00f3 hi\u1ec3u v\u00e0 kh\u00f3 vi\u1ebft h\u01a1n nhi\u1ec1u nh\u01b0ng n\u00f3 c\u00f3 m\u1ed9t l\u1ee3i th\u1ebf kh\u00f4ng th\u1ec3 ch\u1ed1i c\u00e3i \u2013 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh ph\u1ea1m vi \u00f4 (m\u1ed9t d\u00e3y \u00f4) ch\u1ee9a c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u00ecnh c\u1ea7n thay v\u00ec tham chi\u1ebfu t\u1eebng \u0111i\u1ec1u ki\u1ec7n ri\u00eang l\u1ebb. \u0110i\u1ec1u n\u00e0y l\u00e0m cho c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n v\u00e0 n\u1ebfu ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n hi\u1ec7n c\u00f3 n\u00e0o ho\u1eb7c th\u00eam \u0111i\u1ec1u ki\u1ec7n m\u1edbi, b\u1ea1n s\u1ebd ch\u1ec9 ph\u1ea3i c\u1eadp nh\u1eadt l\u1ea1i d\u00e3y \u00f4 trong c\u00f4ng th\u1ee9c c\u1ee7a m\u00ecnh.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_long_nhau_trong_Excel_%E2%80%93_meo_va_cac_thu_thuat\"><\/span><b>H\u00e0m IF l\u1ed3ng nhau trong Excel \u2013 m\u1eb9o v\u00e0 c\u00e1c th\u1ee7 thu\u1eadt<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel kh\u00f4ng \u0111\u00f2i h\u1ecfi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p khoa h\u1ecdc qu\u00e1 cao si\u00eau. C\u00e1c m\u1eb9o sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n c\u1ea3i thi\u1ec7n c\u00e1c c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau v\u00e0 ng\u0103n ng\u1eeba c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_han_IF_long_nhau\"><\/span><b>Gi\u1edbi h\u1ea1n IF l\u1ed3ng nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Trong Excel 2016 \u2013 2007, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng t\u1ed1i \u0111a 64 h\u00e0m IF hay k\u1ebft h\u1ee3p 64 \u0111i\u1ec1u ki\u1ec7n. Trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n c\u1ee7a Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed1i \u0111a 7 h\u00e0m IF l\u1ed3ng nhau. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n n\u00ean l\u00e0m nh\u01b0 v\u1eady. Xin l\u01b0u \u00fd r\u1eb1ng l\u01b0\u1ee3t b\u1ed5 sung \u0111i\u1ec1u ki\u1ec7n s\u1ebd l\u00e0m cho c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n kh\u00f3 hi\u1ec3u v\u00e0 kh\u00f3 kh\u1eafc ph\u1ee5c l\u1ed7i h\u01a1n. N\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 t\u1ed1i \u01b0u h\u00f3a n\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t trong nh\u1eefng l\u1ef1a ch\u1ecdn thay th\u1ebf sau \u0111\u00e2y.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thu_tu_cua_cac_dieu_kien_trong_ham_IF_long_nhau_rat_quan_trong\"><\/span><b>Th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF l\u1ed3ng nhau r\u1ea5t quan tr\u1ecdng<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">H\u00e0m IF l\u1ed3ng nhau trong Excel \u0111\u00e1nh gi\u00e1 t\u00ednh logic theo th\u1ee9 t\u1ef1 ch\u00fang xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c v\u00e0 ngay sau khi m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e1nh gi\u00e1 l\u00e0 TRUE, c\u00e1c \u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo sau \u0111\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ki\u1ec3m tra. N\u00f3i c\u00e1ch kh\u00e1c, c\u00f4ng th\u1ee9c s\u1ebd d\u1eebng sau khi k\u1ebft qu\u1ea3 l\u00e0 TRUE.<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e3y xem n\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o trong th\u1ef1c t\u1ebf. V\u1edbi B2 b\u1eb1ng 274, c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau b\u00ean d\u01b0\u1edbi \u0111\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean (B2&gt; 249) v\u00e0 tr\u1ea3 v\u1ec1 \u201cXu\u1ea5t s\u1eafc\u201d v\u00ec k\u1ebft qu\u1ea3 ki\u1ec3m tra t\u00ednh logic n\u00e0y l\u00e0 TRUE:<\/span><\/p>\n<p><strong>=IF(B2&gt;249, \u201cExcellent\u201d, IF(B2&gt;=200, \u201cGood\u201d, IF(B2&gt;150, \u201cSatisfactory\u201d, \u201cPoor\u201d)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, h\u00e3y \u0111\u1ea3o ng\u01b0\u1ee3c th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><strong>=IF(B2&gt;150, \u201cSatisfactory\u201d, IF(B2&gt;200, \u201cGood\u201d, IF(B2&gt;249, \u201cExcellent\u201d, \u201cPoor\u201d)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean, b\u1edfi v\u00ec 274 &gt; 150, k\u1ebft qu\u1ea3 c\u1ee7a ki\u1ec3m tra t\u00ednh logic n\u00e0y c\u0169ng s\u1ebd l\u00e0 TRUE. Do \u0111\u00f3, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cSatisfactory\u201d m\u00e0 kh\u00f4ng c\u1ea7n ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n th\u1ea5y \u0111\u00f3, vi\u1ec7c thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c h\u00e0m IF s\u1ebd thay \u0111\u1ed5i k\u1ebft qu\u1ea3:<\/span><\/p>\n<figure id=\"attachment_33372\" aria-describedby=\"caption-attachment-33372\" style=\"width: 632px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33372\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"H\u00ecnh 2: H\u00e0m IF l\u1ed3ng nhau v\u1edbi c\u00e1c ph\u00e9p t\u00ednh s\u1ed1 h\u1ecdc\" width=\"632\" height=\"144\" title=\"6-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33372\" class=\"wp-caption-text\">H\u00ecnh 2: H\u00e0m IF l\u1ed3ng nhau trong Excel \u2013 m\u1eb9o v\u00e0 c\u00e1c th\u1ee7 thu\u1eadt<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Danh_gia_tinh_logic_cua_cong_thuc\"><\/span><b>\u0110\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 theo d\u00f5i d\u00f2ng logic c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau theo t\u1eebng b\u01b0\u1edbc m\u1ed9t, h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Evaluate Formula n\u1eb1m tr\u00ean tab Formula, trong nh\u00f3m Formula Auditing. Bi\u1ec3u th\u1ee9c \u0111\u01b0\u1ee3c g\u1ea1ch ch\u00e2n l\u00e0 ph\u1ea7n \u0111ang \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 v\u00e0 vi\u1ec7c nh\u1ea5p v\u00e0o n\u00fat Evaluate s\u1ebd hi\u1ec3n th\u1ecb cho b\u1ea1n t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc trong quy tr\u00ecnh \u0111\u00e1nh gi\u00e1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: vi\u1ec7c \u0111\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean trong c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u1ea3nh b\u00ean d\u01b0\u1edbi s\u1ebd nh\u01b0 sau: B2 &gt; 249; 274 &gt; 249; TRUE; Excellent.<\/span><\/p>\n<figure id=\"attachment_33365\" aria-describedby=\"caption-attachment-33365\" style=\"width: 578px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33365\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"\u0110\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c\" width=\"578\" height=\"516\" title=\"7-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33365\" class=\"wp-caption-text\">\u0110\u00e1nh gi\u00e1 t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Can_bang_dau_ngoac_cua_cac_ham_IF_long_nhau\"><\/span><b>C\u00e2n b\u1eb1ng d\u1ea5u ngo\u1eb7c c\u1ee7a c\u00e1c h\u00e0m IF l\u1ed3ng nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng th\u00e1ch th\u1ee9c ch\u00ednh v\u1edbi h\u00e0m IF l\u1ed3ng nhau trong Excel l\u00e0 kh\u1edbp c\u00e1c c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n. N\u1ebfu d\u1ea5u ngo\u1eb7c \u0111\u01a1n kh\u00f4ng kh\u1edbp, c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. Nh\u01b0ng \u0111\u1eebng lo, Microsoft Excel cung c\u1ea5p m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n c\u00e2n b\u1eb1ng c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u01a1n khi ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u01a1n, th\u00ec c\u00e1c c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 b\u1eb1ng c\u00e1c m\u00e0u kh\u00e1c nhau \u0111\u1ec3 d\u1ea5u ngo\u1eb7c m\u1edf \u0111\u1ea7u kh\u1edbp v\u1edbi d\u1ea5u ngo\u1eb7c \u0111\u00f3ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Khi b\u1ea1n \u0111\u00f3ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n, Excel s\u1ebd \u0111\u00e1nh d\u1ea5u c\u1eb7p ph\u00f9 h\u1ee3p. S\u1ebd c\u00f3 hi\u1ec7u \u1ee9ng in \u0111\u1eadm ho\u1eb7c \u201cnh\u1ea5p nh\u00e1y\u201d khi b\u1ea1n di chuy\u1ec3n qua c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean.<\/span><\/li>\n<\/ul>\n<figure style=\"width: 513px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e2n b\u1eb1ng d\u1ea5u ngo\u1eb7c c\u1ee7a c\u00e1c h\u00e0m IF l\u1ed3ng nhau\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-match-parantheses.png\" alt=\"Balance the parenthesis of nested IF functions\" width=\"513\" height=\"53\"><figcaption class=\"wp-caption-text\">C\u00e2n b\u1eb1ng d\u1ea5u ngo\u1eb7c c\u1ee7a c\u00e1c h\u00e0m IF l\u1ed3ng nhau<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_xu_ly_cac_van_ban_va_cac_so_la_khac_nhau\"><\/span><b>C\u00e1ch x\u1eed l\u00fd c\u00e1c v\u0103n b\u1ea3n v\u00e0 c\u00e1c s\u1ed1 l\u00e0 kh\u00e1c nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi x\u00e2y d\u1ef1ng c\u00e1c b\u00e0i ki\u1ec3m tra t\u00ednh logic cho c\u00e1c h\u00e0m IF l\u1ed3ng nhau c\u1ee7a b\u1ea1n, h\u00e3y nh\u1edb r\u1eb1ng v\u0103n b\u1ea3n v\u00e0 s\u1ed1 ph\u1ea3i \u0111\u01b0\u1ee3c x\u1eed l\u00fd theo c\u00e1ch kh\u00e1c nhau \u2013 lu\u00f4n \u0111\u1eb7t c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p nh\u01b0ng v\u1edbi s\u1ed1 th\u00ec kh\u00f4ng:<\/span><\/p>\n<p><strong>\u0110\u00fang: =IF(B2&gt;249, \u201cExcellent\u201d,\u2026)<\/strong><\/p>\n<p><strong>Sai: =IF(B2&gt;\u201d249\u2033, \u201cExcellent\u201d,\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c th\u1ee9 hai s\u1ebd tr\u1ea3 v\u1ec1 FALSE ngay c\u1ea3 khi gi\u00e1 tr\u1ecb trong B2 &gt; 249 V\u00ec 249 l\u00e0 m\u1ed9t s\u1ed1 v\u00e0 \u201c249\u201d l\u00e0 m\u1ed9t chu\u1ed7i s\u1ed1, ch\u00fang l\u00e0 hai th\u1ee9 kh\u00e1c nhau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Them_dau_cach_hoac_ngat_dong_de_lam_cho_cac_IF_long_nhau_de_doc_hon\"><\/span><b>Th\u00eam d\u1ea5u c\u00e1ch ho\u1eb7c ng\u1eaft d\u00f2ng \u0111\u1ec3 l\u00e0m cho c\u00e1c IF l\u1ed3ng nhau d\u1ec5 \u0111\u1ecdc h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi x\u00e2y d\u1ef1ng m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m cho t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c r\u00f5 r\u00e0ng h\u01a1n b\u1eb1ng c\u00e1ch t\u00e1ch c\u00e1c h\u00e0m IF kh\u00e1c nhau b\u1eb1ng d\u1ea5u c\u00e1ch ho\u1eb7c d\u1ea5u ng\u1eaft d\u00f2ng. Excel kh\u00f4ng quan t\u00e2m \u0111\u1ebfn kho\u1ea3ng c\u00e1ch th\u1eeba trong c\u00f4ng th\u1ee9c, v\u00ec v\u1eady b\u1ea1n kh\u00f4ng c\u1ea7n lo l\u1eafng v\u1ec1 vi\u1ec7c sai l\u1ec7ch c\u1ee7a n\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 di chuy\u1ec3n m\u1ed9t ph\u1ea7n nh\u1ea5t \u0111\u1ecbnh c\u1ee7a c\u00f4ng th\u1ee9c sang d\u00f2ng ti\u1ebfp theo, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n ng\u1eaft d\u00f2ng v\u00e0 nh\u1ea5n Alt + Enter. Sau \u0111\u00f3, m\u1edf r\u1ed9ng thanh c\u00f4ng th\u1ee9c \u0111\u1ebfn m\u1ee9c c\u1ea7n thi\u1ebft v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd tr\u1edf n\u00ean d\u1ec5 hi\u1ec3u h\u01a1n nhi\u1ec1u.<\/span><\/p>\n<figure id=\"attachment_33366\" aria-describedby=\"caption-attachment-33366\" style=\"width: 406px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33366\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel.png\" alt=\"8 C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel\" width=\"406\" height=\"142\" title=\"8-cc3a1ch-dc3b9ng-hc3a0m-if-ve1bb9bi-nhie1bb81u-c491ie1bb81u-kie1bb87n-trong-excel\"><figcaption id=\"caption-attachment-33366\" class=\"wp-caption-text\">8 C\u00e1ch d\u00f9ng h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cac_lua_chon_thay_the_cho_IF_long_nhau_trong_Excel\"><\/span><b>C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho IF l\u1ed3ng nhau trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 v\u01b0\u1ee3t qua gi\u1edbi h\u1ea1n c\u1ee7a 7 h\u00e0m IF l\u1ed3ng nhau trong Excel 2003 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n v\u00e0 \u0111\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n nh\u1ecf g\u1ecdn v\u00e0 nhanh h\u01a1n, h\u00e3y xem x\u00e9t s\u1eed d\u1ee5ng c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf sau nh\u00e9:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 c\u1ee7a nh\u1eefng ki\u1ec3m tra \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\"><strong>h\u00e0m CHOOSE<\/strong><\/a>.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">X\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng tham chi\u1ebfu v\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\"><strong>h\u00e0m VLOOKUP<\/strong><\/a> v\u1edbi \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng IF v\u1edbi c\u00e1c h\u00e0m logic OR\/AND.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng (array).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">K\u1ebft h\u1ee3p nhi\u1ec1u c\u00e2u l\u1ec7nh IF b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\"><strong>h\u00e0m CONCATENATE<\/strong><\/a> ho\u1eb7c ph\u01b0\u01a1ng ph\u00e1p n\u1ed1i chu\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng Excel c\u00f3 kinh nghi\u1ec7m, gi\u1ea3i ph\u00e1p thay th\u1ebf t\u1ed1t nh\u1ea5t \u0111\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau l\u00e0 t\u1ea1o m\u1ed9t h\u00e0m trang t\u00ednh t\u00f9y ch\u1ec9nh b\u1eb1ng VBA.<\/span><\/li>\n<\/ul>\n<p><strong>Xem th\u00eam:<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<\/a> trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/strong><\/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-81.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2437,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2436","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\/2436","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=2436"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2436\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2437"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}