{"id":931,"date":"2024-12-02T03:09:28","date_gmt":"2024-12-02T03:09:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-if-nhieu-dieu-kien-trong-excel\/"},"modified":"2024-12-02T03:09:28","modified_gmt":"2024-12-02T03:09:28","slug":"ham-if-nhieu-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/ham-if-nhieu-dieu-kien-trong-excel\/","title":{"rendered":"H\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel.<\/p>\n<p>Trong Excel, m\u1ed9t trong nh\u1eefng h\u00e0m hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t l\u00e0 h\u00e0m IF, h\u00e0m \u0111i\u1ec1u ki\u1ec7n. Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n gi\u1ea3n, h\u00e0m IF l\u00e0 m\u1ed9t h\u00e0m kh\u00e1 d\u1ec5 vi\u1ebft v\u00e0 s\u1eed d\u1ee5ng, nh\u01b0ng khi c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u1edf n\u00ean nhi\u1ec1u h\u01a1n, ph\u1ee9c t\u1ea1p h\u01a1n, th\u00ec h\u00e0m IF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n hay h\u00e0m IF l\u1ed3ng nhau s\u1ebd g\u00e2y kh\u00f3 kh\u0103n cho c\u00e1c b\u1ea1n ch\u01b0a c\u00f3 kinh nghi\u1ec7m vi\u1ebft h\u00e0m n\u00e0y.<\/p>\n<p>Microsoft Excel c\u00f3 m\u1ed9t gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng h\u00e0m IF b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng nhau. Trong Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng 7 l\u1edbp h\u00e0m IF. Trong nh\u1eefng phi\u00ean b\u1ea3n m\u1edbi h\u01a1n, nh\u01b0 Excel 2021, Excel 2019, Excel 365, Excel 2016, Excel 2013, Excel 2010, Excel 2007, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1edbi 64 l\u1edbp h\u00e0m IF l\u1ed3ng nhau.<\/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-674d24e78e78f\" 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-if-nhieu-dieu-kien-trong-excel.html#Ham_IF_nhieu_dieu_kien_long_nhau\" title=\"H\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau\">H\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau<\/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-if-nhieu-dieu-kien-trong-excel.html#Lam_the_nao_de_hieu_duoc_ham_IF_long_nhau\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c h\u00e0m IF l\u1ed3ng nhau\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c h\u00e0m IF l\u1ed3ng nhau<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/ham-if-nhieu-dieu-kien-trong-excel.html#Ham_IF_long_ghep_voi_cac_ham_tinh_toan_khac\" title=\"H\u00e0m IF l\u1ed3ng gh\u00e9p v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n kh\u00e1c\">H\u00e0m IF l\u1ed3ng gh\u00e9p v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-if-nhieu-dieu-kien-trong-excel.html#Ket_hop_ham_IF_voi_ham_CONCATENATE\" title=\"K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m CONCATENATE\">K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m CONCATENATE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-if-nhieu-dieu-kien-trong-excel.html#Luu_y_khi_viet_ham_IF_nhieu_dieu_kien_long_nhau\" title=\"L\u01b0u \u00fd khi vi\u1ebft h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, l\u1ed3ng nhau\">L\u01b0u \u00fd khi vi\u1ebft h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, l\u1ed3ng nhau<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/ham-if-nhieu-dieu-kien-trong-excel.html#Sap_xep_thu_tu_cua_dieu_kien\" title=\"S\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n\">S\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n<\/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\/ham-if-nhieu-dieu-kien-trong-excel.html#Su_dung_cong_cu_dinh_dang_cong_thuc_de_viet_ham_IF_de_nhin_hon\" title=\"S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c \u0111\u1ec3 vi\u1ebft h\u00e0m IF d\u1ec5 nh\u00ecn h\u01a1n\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c \u0111\u1ec3 vi\u1ebft h\u00e0m IF d\u1ec5 nh\u00ecn h\u01a1n<\/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\/ham-if-nhieu-dieu-kien-trong-excel.html#Cac_ham_va_cong_cu_khac_thay_the_cho_ham_IF_trong_Excel\" title=\"C\u00e1c h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 kh\u00e1c thay th\u1ebf cho h\u00e0m IF trong Excel\">C\u00e1c h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 kh\u00e1c thay th\u1ebf cho h\u00e0m IF trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_nhieu_dieu_kien_long_nhau\"><\/span>H\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n v\u1ec1 h\u00e0m IF l\u1ed3ng nhau v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n: x\u1ebfp lo\u1ea1i sinh vi\u00ean d\u1ef1a tr\u00ean \u0111i\u1ec3m s\u1ed1. \u0110i\u1ec1u ki\u1ec7n x\u1ebfp lo\u1ea1i theo \u0111i\u1ec3m s\u1ed1 nh\u01b0 sau:<\/p>\n<ul>\n<li>Lo\u1ea1i A: tr\u00ean 249 \u0111i\u1ec3m<\/li>\n<li>Lo\u1ea1i B: t\u1eeb 249 \u0111i\u1ec3m t\u1edbi 200 \u0111i\u1ec3m, bao g\u1ed3m \u0111i\u1ec3m 200<\/li>\n<li>Lo\u1ea1i C: t\u1eeb 199 \u0111i\u1ec3m t\u1edbi 150 \u0111i\u1ec3m, bao g\u1ed3m \u0111i\u1ec3m 150<\/li>\n<li>Lo\u1ea1i D: d\u01b0\u1edbi 150 \u0111i\u1ec3m<\/li>\n<\/ul>\n<p>V\u1edbi \u0111i\u1ec1u ki\u1ec7n x\u1ebfp lo\u1ea1i \u0111i\u1ec3m s\u1ed1 nh\u01b0 tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau nh\u01b0 sau:<\/p>\n<pre><code class=\"language-xls\">=IF(\r\n    B2 &gt; 249,\r\n    \"A\",\r\n    IF(\r\n        B2 &gt;= 200,\r\n        \"B\",\r\n        IF(\r\n            B2 &gt; 150,\r\n            \"C\",\r\n            \"D \"\r\n        )\r\n    )\r\n)<\/code><\/pre>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF ph\u00eda tr\u00ean nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37575 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-01-1024x439-2.jpg\" alt=\"ham-if-nhieu-dieu-kien-01\" width=\"1024\" height=\"439\" title=\"ham-if-nhieu-dieu-kien-01-1024x439-2\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-60.gif\" title=\"ex101_92019-nho-60\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span class=\"note-label\">L\u01b0u \u00fd<\/span> Vi\u1ec7c xu\u1ed1ng d\u00f2ng v\u00e0 l\u00f9i v\u00e0o \u0111\u1ea7u d\u00f2ng trong khi vi\u1ebft c\u00f4ng th\u1ee9c Excel s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ecdc c\u00f4ng th\u1ee9c d\u1ec5 d\u00e0ng h\u01a1n, \u0111\u1ec3 xu\u1ed1ng d\u00f2ng trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm <span class=\"xl-shortcut\">ALT + Enter<\/span> ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c Thanh \u0111\u00e3 chu\u1ea9n b\u1ecb \u1edf \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/schoener\" target=\"_blank\" rel=\"noopener\">c\u00f4ng c\u1ee5 l\u00e0m \u0111\u1eb9p c\u00f4ng th\u1ee9c<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_hieu_duoc_ham_IF_long_nhau\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nhi\u1ec1u b\u1ea1n hay g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c hi\u1ec3u h\u00e0m IF c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau. \u0110i\u1ec1u n\u00e0y l\u00e0 ho\u00e0n to\u00e0n b\u00ecnh th\u01b0\u1eddng khi b\u1ea1n ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t h\u00e0m IF ph\u1ee9c t\u1ea1p c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, l\u1ed3ng nhau. Tuy nhi\u00ean, ch\u1ec9 c\u1ea7n ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m IF, th\u00ec vi\u1ec7c hi\u1ec3u h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e0m IF l\u1ed3ng nhau s\u1ebd tr\u1edf n\u00ean r\u1ea5t d\u1ec5 d\u00e0ng. Ch\u00fang ta h\u00e3y c\u00f9ng \u0111i l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1eb1ng bi\u1ec3u \u0111\u1ed3 sau \u0111\u00e2y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37579 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-02-1024x553-2.jpg\" alt=\"ham-if-nhieu-dieu-kien\" width=\"1024\" height=\"553\" title=\"ham-if-nhieu-dieu-kien-02-1024x553-2\"><\/p>\n<p>Qua bi\u1ec3u \u0111\u1ed3 tr\u00ean, h\u00e0m IF l\u1ed3ng nhau c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch nh\u01b0 sau:<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00fang ta s\u1ebd \u0111i:<\/p>\n<p>Ki\u1ec3m tra gi\u00e1 tr\u1ecb c\u1ee7a bi\u1ec3u th\u1ee9c B2 &gt; 249<\/p>\n<p style=\"padding-left: 40px\">N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cA\u201d l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF<\/p>\n<p style=\"padding-left: 40px\">N\u1ebfu sai, \u0111i ki\u1ec3m tra ti\u1ebfp gi\u00e1 tr\u1ecb c\u1ee7a bi\u1ec3u th\u1ee9c B2 &gt;=200<\/p>\n<p style=\"padding-left: 80px\">N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cB\u201d l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF<\/p>\n<p style=\"padding-left: 80px\">N\u1ebfu sai, \u0111i ki\u1ec3m tra ti\u1ebfp gi\u00e1 tr\u1ecb c\u1ee7a bi\u1ec3u th\u1ee9c B2&gt;150<\/p>\n<p style=\"padding-left: 120px\">N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cC\u201d l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF<\/p>\n<p style=\"padding-left: 120px\">N\u1ebfu sai, tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cD\u201d l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_long_ghep_voi_cac_ham_tinh_toan_khac\"><\/span>H\u00e0m IF l\u1ed3ng gh\u00e9p v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong ph\u1ea7n n\u00e0y, ch\u00fang ta l\u1ea1i \u0111i x\u1eed l\u00fd ti\u1ebfp m\u1ed9t t\u00ecnh hu\u1ed1ng hay g\u1eb7p khi l\u1ed3ng gh\u00e9p \u0111i\u1ec1u ki\u1ec7n v\u1edbi vi\u1ec7c t\u00ednh to\u00e1n k\u1ebft qu\u1ea3 kinh doanh. Gi\u1ea3 s\u1eed b\u1ea1n b\u00e1n h\u00e0ng v\u00e0 c\u00f3 gi\u1ea3m gi\u00e1 theo s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng h\u00f3a m\u00e0 kh\u00e1ch h\u00e0ng mua \u2013 \u201cMua s\u1ed1 l\u01b0\u1ee3ng l\u1edbn s\u1ebd c\u00f3 gi\u00e1 t\u1ed1t h\u01a1n\u201d. Ch\u00fang ta c\u00f3 b\u1ea3ng t\u00ednh nh\u01b0 sau:<\/p>\n<table class=\"blog-table\" style=\"height: 185px\" width=\"282\">\n<tbody>\n<tr class=\"head\">\n<td><strong>S\u1ed1 l\u01b0\u1ee3ng<\/strong><\/td>\n<td><strong>\u0110\u01a1n gi\u00e1<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1 \u2013 10<\/td>\n<td>$20<\/td>\n<\/tr>\n<tr>\n<td>11 \u2013 19<\/td>\n<td>$18<\/td>\n<\/tr>\n<tr>\n<td>20 \u2013 49<\/td>\n<td>$16<\/td>\n<\/tr>\n<tr>\n<td>50 \u2013 100<\/td>\n<td>$13<\/td>\n<\/tr>\n<tr>\n<td>Tr\u00ean 101<\/td>\n<td>$12<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Nhi\u1ec7m v\u1ee5 c\u1ee7a ch\u00fang ta \u1edf \u0111\u00e2y l\u00e0 \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o \u00f4 B9, \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n d\u1ef1a tr\u00ean s\u1ed1 l\u01b0\u1ee3ng \u1edf \u00f4 B8<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37580 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-03-1024x439-2.jpg\" alt=\"ham-if-nhieu-dieu-kien-03\" width=\"1024\" height=\"439\" title=\"ham-if-nhieu-dieu-kien-03-1024x439-2\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i B9 s\u1ebd c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau<\/p>\n<pre><code class=\"language-xls\">=B8 *\r\nIF(B8 &gt;= 101,B6,\r\n    IF(B8 &gt;= 50,B5,\r\n        IF(B8 &gt;= 20,B4,\r\n            IF(B8 &gt;= 11,B3,\r\n                IF(B8 &gt;= 1,B2,\"\")\r\n            )\r\n        )\r\n    )\r\n)<\/code><\/pre>\n<p>N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng \u1edf ngo\u00e0i kho\u1ea3ng ch\u00fang ta \u0111\u1ec1 ra, ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF th\u00eam nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37581 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-04-1.png\" alt=\"ham-if-nhieu-dieu-kien-04\" width=\"408\" height=\"267\" title=\"ham-if-nhieu-dieu-kien-04-1\"><\/p>\n<p>V\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n<pre><code class=\"language-xls\">=IF(\r\n    OR(B8 &gt; 200,B8 &lt; 1),\"Qty. out of range\", B8 * IF(B8 &gt;= 101,12,\r\n        IF(B8 &gt;= 50,13,\r\n            IF(B8 &gt;= 20,16,\r\n                IF(B8 &gt;= 11,18,\r\n                    IF(B8 &gt;= 1,20,\"\")\r\n                )\r\n            )\r\n        )\r\n    )\r\n)<\/code><\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_ham_IF_voi_ham_CONCATENATE\"><\/span>K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m CONCATENATE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t v\u00ed d\u1ee5 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m IF v\u1edbi h\u00e0m Concatenate m\u00e0 m\u00ecnh th\u1ea5y r\u1ea5t hay \u0111\u00f3 l\u00e0 v\u00ed d\u1ee5 ch\u00fang ta c\u1ea7n tra c\u1ee9u nhi\u1ec1u gi\u00e1 tr\u1ecb, hay \u0111\u1ed5i gi\u00e1 tr\u1ecb theo m\u1ed9t \u201ct\u1eeb \u0111i\u1ec3n\u201d do ch\u00fang ta \u0111\u1ecbnh ngh\u0129a.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37583 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-nhieu-dieu-kien-05-1.jpg\" alt=\"ham-if-nhieu-dieu-kien-05\" width=\"692\" height=\"350\" title=\"ham-if-nhieu-dieu-kien-05-1\"><\/p>\n<p>C\u00f4ng th\u1ee9c \u1edf C2, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau \u0111\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m Concatenate:<\/p>\n<pre><code class=\"language-xls\">=CONCATENATE(\r\n    IF(B2 = \"a\",\"Excellent\",\"\"),\r\n    IF(B2 = \"b\",\"Good\",\"\"),\r\n    IF(B2 = \"c\",\"Satisfactory\",\"\"),\r\n    IF(B2 = \"d\",\"Poor\",\"\")\r\n)<\/code><\/pre>\n<p><span class=\"note-label\">L\u01b0u \u00fd<\/span> V\u00ec s\u1ef1 so s\u00e1nh s\u1eed d\u1ee5ng d\u1ea5u \u201c=\u201d trong c\u00f4ng th\u1ee9c tr\u00ean kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, v\u1eady n\u00ean b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft <code>B2 = \"a\"<\/code> nh\u01b0 tr\u00ean m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i vi\u1ebft <code>B2 = \"A\"<\/code><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y_khi_viet_ham_IF_nhieu_dieu_kien_long_nhau\"><\/span>L\u01b0u \u00fd khi vi\u1ebft h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Sap_xep_thu_tu_cua_dieu_kien\"><\/span>S\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n c\u00e1c bi\u1ec3u th\u1ee9c trong h\u00e0m IF l\u1ed3ng nhau, Excel s\u1ebd t\u00ednh to\u00e1n c\u00e1c bi\u1ec3u th\u1ee9c n\u00e0y theo th\u1ee9 t\u1ef1 ch\u00fang ta vi\u1ebft trong c\u00f4ng th\u1ee9c, v\u00ec v\u1eady ch\u00fang ta c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn th\u1ee9c t\u1ef1 vi\u1ebft c\u1ee7a c\u00e1c \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p>N\u1ebfu B2 = 283, v\u00e0 ch\u00fang ta s\u1ebd so s\u00e1nh 2 c\u00e1ch vi\u1ebft h\u00e0m IF nh\u01b0 sau<\/p>\n<p><strong>c\u00e1ch th\u1ee9 nh\u1ea5t:<\/strong><\/p>\n<pre><code class=\"language-xls\">=IF(B2 &gt; 249,\"A\",\r\n    IF(B2 &gt;= 200,\"B\",\r\n        IF(B2 &gt; 150,\"C\",\"D\")\r\n    )\r\n)<\/code><\/pre>\n<p><strong>c\u00e1ch th\u1ee9 hai:<\/strong><\/p>\n<pre><code class=\"language-xls\">=IF(B2 &gt; 150,\"C\",\r\n    IF(B2 &gt; 200,\"B\",\r\n        IF(B2 &gt; 249,\"A\",\"D\")\r\n    )\r\n)<\/code><\/pre>\n<p>B\u1edfi v\u00ec Excel s\u1ebd t\u00ednh to\u00e1n v\u00e0 \u0111\u00e1nh gi\u00e1 c\u00e1c bi\u1ec3u th\u1ee9c \u0111\u00fang theo th\u1ee9 t\u1ef1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a, v\u1eady n\u00ean, n\u1ebfu B2 = 283 v\u00e0 b\u1ea1n s\u1eed d\u1ee5ng c\u00e1ch th\u1ee9 2 \u0111\u1ec3 \u0111\u00e1nh gi\u00e1, th\u00ec sinh vi\u00ean \u0111\u01b0\u1ee3c 283 \u0111i\u1ec3m s\u1ebd c\u00f3 x\u1ebfp lo\u1ea1i \u201cC\u201d, b\u1edfi v\u00ec \u0111\u00e2y l\u00e0 bi\u1ec3u th\u1ee9c \u0111\u1ea7u ti\u00ean Excel \u0111\u1ecdc, v\u00e0 n\u1ebfu bi\u1ec3u th\u1ee9c n\u00e0y c\u00f3 gi\u00e1 tr\u1ecb \u0111\u00fang th\u00ec Excel s\u1ebd tr\u1ea3 v\u1ec1 ngay k\u1ebft qu\u1ea3 l\u00e0 \u201cC\u201d v\u00e0 \u201ckh\u00f4ng \u0111\u1ecdc\u201d c\u00e1c bi\u1ec3u th\u1ee9c b\u1ea1n vi\u1ebft ph\u00eda sau c\u1ee7a c\u00f4ng th\u1ee9c n\u1eefa.<\/p>\n<p>V\u1eady n\u00ean, y\u1ebfu t\u1ed1 quan tr\u1ecdng \u1edf \u0111\u00e2y l\u00e0 c\u00e1c b\u1ea1n c\u1ea7n s\u1eafp x\u1ebfp \u0111i\u1ec1u ki\u1ec7n h\u1ee3p l\u00fd khi vi\u1ebft h\u00e0m IF.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cong_cu_dinh_dang_cong_thuc_de_viet_ham_IF_de_nhin_hon\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c \u0111\u1ec3 vi\u1ebft h\u00e0m IF d\u1ec5 nh\u00ecn h\u01a1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>R\u00f5 r\u00e0ng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng, vi\u1ec7c vi\u1ebft c\u00f4ng th\u1ee9c \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc s\u1ebd r\u1ea5t quan tr\u1ecdng khi b\u1ea1n ph\u00e1t tri\u1ec3n c\u00f4ng th\u1ee9c, c\u0169ng nh\u01b0 sau n\u00e0y khi \u0111\u1ecdc l\u1ea1i c\u00f4ng th\u1ee9c, m\u1ed9t c\u00f4ng th\u1ee9c d\u1ec5 \u0111\u1ecdc kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c \u00edt l\u1ed7i h\u01a1n, m\u00e0 c\u00f2n ti\u1ebft ki\u1ec7m cho b\u1ea1n r\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c n\u1ebfu sau n\u00e0y c\u1ea7n tra c\u1ee9u l\u1ea1i. Thanh \u0111\u00e3 chu\u1ea9n b\u1ecb c\u00f4ng c\u1ee5 cho c\u00e1c b\u1ea1n:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/schoener\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c Excel \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc h\u01a1n<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_ham_va_cong_cu_khac_thay_the_cho_ham_IF_trong_Excel\"><\/span>C\u00e1c h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 kh\u00e1c thay th\u1ebf cho h\u00e0m IF trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u00fac n\u00e0o c\u0169ng v\u1eady, khi c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1ec3 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c s\u1ebd t\u1ed1t h\u01a1n, \u0111\u1ed1i v\u1edbi h\u00e0m IF c\u0169ng v\u1eady, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o b\u1ea1n c\u0169ng c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c, b\u1edfi v\u00ec c\u00f2n c\u00f3 m\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 thay th\u1ebf kh\u00e1c:<\/p>\n<ol>\n<li>\u0110\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 nhi\u1ec1u k\u1ebft qu\u1ea3 kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m choose trong Excel thay cho h\u00e0m IF l\u1ed3ng nhau<\/li>\n<li>\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u1ea7n tham chi\u1ebfu theo kho\u1ea3ng, <a href=\"http:\/\/blog.ezworkapp.com\/mot-so-vi-du-cho-cach-dung-ham-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener\">s\u1eed d\u1ee5ng VLOOKUP v\u1edbi b\u1ea3ng tham chi\u1ebfu<\/a> c\u0169ng s\u1ebd l\u00e0m c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u0111i r\u1ea5t nhi\u1ec1u.<\/li>\n<li>M\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p th\u00ec ch\u00fang ta n\u00ean s\u1eed d\u1ee5ng VBA trong Excel \u0111\u1ec3 gi\u00fap cho \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft ra m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 vi\u1ec7c t\u00ednh to\u00e1n s\u1eed d\u1ee5ng h\u00e0m kh\u00f4ng tr\u1edf n\u00ean qu\u00e1 ph\u1ee9c t\u1ea1p, kh\u00f3 b\u1ea3o tr\u00ec v\u1ec1 sau.<\/li>\n<\/ol>\n<p>\u0110\u00e2y l\u00e0 nh\u1eefng th\u00f4ng tin v\u1ec1 h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau m\u00e0 m\u00ecnh mu\u1ed1n chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n trong b\u00e0i vi\u1ebft n\u00e0y, mong r\u1eb1ng ki\u1ebfn th\u1ee9c trong b\u00e0i vi\u1ebft s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 v\u00e0 \u1ee9ng d\u1ee5ng t\u1ed1t h\u01a1n v\u00e0o c\u00f4ng vi\u1ec7c. \u0110\u1eebng qu\u00ean tham kh\u1ea3o c\u00e1c kh\u00f3a h\u1ecdc li\u00ean quan c\u1ee7a m\u00ecnh.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-60.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-931","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/931","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=931"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/931\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/932"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}