{"id":6869,"date":"2024-12-21T16:20:30","date_gmt":"2024-12-21T16:20:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-if-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat\/"},"modified":"2024-12-21T16:20:30","modified_gmt":"2024-12-21T16:20:30","slug":"ham-if-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-if-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat\/","title":{"rendered":"H\u00e0m IF l\u1ed3ng gh\u00e9p, k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong> v\u00e0 \u0111\u01b0a ra c\u00e1c v\u00ed d\u1ee5 v\u1ec1 nh\u1eefng<strong> h\u00e0m IF l\u1ed3ng nhau<\/strong> hay \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00f4ng vi\u1ec7c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u01b0\u1ee3c h\u1ecfi 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? V\u1edbi r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi, \u0111\u00f3 ch\u00ednh l\u00e0 ch\u1ee9c n\u0103ng <strong>h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> trong Excel. C\u00f4ng th\u1ee9c h\u00e0m IF n\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n s\u1ebd r\u1ea5t d\u1ec5 vi\u1ebft. Nh\u01b0ng n\u1ebfu s\u1ed1 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 ch\u1ee9c n\u0103ng IF trong m\u1ed9t c\u00f4ng th\u1ee9c, v\u00e0 c\u00f4ng th\u1ee9c h\u00e0m IF l\u00fac n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <strong>h\u00e0m IF l\u1ed3ng nhau hay h\u00e0m if and<\/strong>. \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 \u0111i\u1ec1u ki\u1ec7n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau ph\u1ee5 thu\u1ed9c v\u00e0 k\u1ebft qu\u1ea3 ki\u1ec3m tra v\u1edbi duy nh\u1ea5t m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">Trong c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010 v\u00e0 Excel 2007, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p \u0111\u1ebfn 64 \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c. Nh\u01b0ng v\u1edbi Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, c\u00f4ng th\u1ee9c ch\u1ec9 c\u00f3 t\u1ed1i \u0111a 7 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF l\u1ed3ng nhau <strong>(h\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n)<\/strong> c\u00f9ng v\u1edbi ph\u1ea7n gi\u1ea3i th\u00edch chi ti\u1ebft v\u1ec1 c\u1ea5u tr\u00fac v\u00e0 logic c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m IF \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a><\/li>\n<\/ul>\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-6766eacde8716\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html#CONG_THUC_HAM_IF_LONG_NHAU_CO_BAN\" title=\"C\u00d4NG TH\u1ee8C H\u00c0M IF L\u1ed2NG NHAU C\u01a0 B\u1ea2N \u00a0\u00a0\">C\u00d4NG TH\u1ee8C H\u00c0M IF L\u1ed2NG NHAU C\u01a0 B\u1ea2N \u00a0\u00a0<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html#CACH_HIEU_LOGIC_HAM_IF_LONG_NHAU\" title=\"C\u00c1CH HI\u1ec2U LOGIC H\u00c0M IF L\u1ed2NG NHAU:\">C\u00c1CH HI\u1ec2U LOGIC H\u00c0M IF L\u1ed2NG NHAU:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html#HAM_IF_LONG_NHAU_BAO_GOM_PHEP_TINH\" title=\"H\u00c0M IF L\u1ed2NG NHAU BAO G\u1ed2M PH\u00c9P T\u00cdNH\">H\u00c0M IF L\u1ed2NG NHAU BAO G\u1ed2M PH\u00c9P T\u00cdNH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html#HAM_IF_LONG_NHAU_NHUNG_DIEU_CAN_NHO\" title=\"H\u00c0M IF L\u1ed2NG NHAU, NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda\">H\u00c0M IF L\u1ed2NG NHAU, NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html#THAY_THE_CHO_HAM_IF_LONG_NHAU_TRONG_EXCEL\" title=\"THAY TH\u1ebe CHO H\u00c0M IF L\u1ed2NG NHAU TRONG EXCEL\">THAY TH\u1ebe CHO H\u00c0M IF L\u1ed2NG NHAU TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_HAM_IF_LONG_NHAU_CO_BAN\"><\/span><strong>C\u00d4NG TH\u1ee8C H\u00c0M IF L\u1ed2NG NHAU C\u01a0 B\u1ea2N \u00a0\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh v\u1ec1 h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch h\u1ecdc sinh \u1edf c\u1ed9t A v\u00e0 \u0111i\u1ec3m s\u1ed1 t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t B, b\u1ea1n mu\u1ed1n ph\u00e2n lo\u1ea1i ra theo nh\u1eefng \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Excellent: tr\u00ean 249<\/li>\n<li>Good: t\u1eeb 200 \u0111\u1ebfn 249<\/li>\n<li>Satisfactory: t\u1eeb 150 \u0111\u1ebfn 199<\/li>\n<li>Poor: d\u01b0\u1edbi 150<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u00fang ta h\u00e3y c\u00f9ng vi\u1ebft h\u00e0m IF l\u1ed3ng nau d\u1ef1a tr\u00ean nh\u1eefng ti\u00eau ch\u00ed tr\u00ean. H\u00e3y coi \u0111\u00e2y l\u00e0 c\u01a1 h\u1ed9i th\u1ef1c h\u00e0nh, b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng nh\u1ea5t v\u00e0 vi\u1ebft c\u00f4ng th\u1ee9c c\u00e0ng \u0111\u01a1n gi\u1ea3n c\u00e0ng t\u1ed1t. C\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau c\u1ee7a ch\u00fang ta s\u1ebd nh\u01b0 sau:<\/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-616.gif\" title=\"ex101_92019-nho-616\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">=IF(B2&gt;249, \u201cExcellent\u201d, IF(B2&gt;=200, \u201cGood\u201d, IF(B2&gt;150, \u201cSatisfactory\u201d, \u201cPoor \u201c)))<\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4748 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-nested-if-formula.png\" width=\"513\" height=\"266\" title=\"excel-nested-if-formula\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_HIEU_LOGIC_HAM_IF_LONG_NHAU\"><\/span><strong>C\u00c1CH HI\u1ec2U LOGIC H\u00c0M IF L\u1ed2NG NHAU:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1edbi nhi\u1ec1u ng\u01b0\u1eddi, h\u00e0m IF l\u1ed3ng nhau c\u00f3 th\u1ec3 kh\u00f3 hi\u1ec3u. Nh\u01b0ng s\u1ebd d\u1ec5 h\u01a1n n\u1ebfu b\u1ea1n nh\u00ecn c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau tr\u00ean theo c\u00e1ch n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=IF(B2&gt;249, \u201cExcellent\u201d,<\/p>\n<p style=\"text-align: justify\">=IF(B2&gt;=200, \u201cGood\u201d,<\/p>\n<p style=\"text-align: justify\">=IF(B2&gt;150, \u201cSatisfactory\u201d, \u201cPoor\u201d)))<\/p>\n<p style=\"text-align: justify\">Th\u1ef1c t\u1ebf, c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u Excel \u0111\u00e1nh gi\u00e1 xem \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m IF c\u00f3 logic kh\u00f4ng, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n logic, Excel s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n cung c\u1ea5p khi \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n 2 v\u00e0 ti\u1ebfp t\u1ee5c.<\/p>\n<p style=\"text-align: justify\">IF(ki\u1ec3m tra if B2&gt;=249, if \u0111\u00fang \u2013 tr\u1ea3 \u201cExcellent\u201d, n\u1ebfu kh\u00f4ng<\/p>\n<p style=\"text-align: justify\">IF(ki\u1ec3m tra if B2&gt;=200, if \u0111\u00fang \u2013 tr\u1ea3 \u201cGood\u201d, n\u1ebfu kh\u00f4ng<\/p>\n<p style=\"text-align: justify\">IF(ki\u1ec3m tra if B2&gt;150, if \u0111\u00fang \u2013 tr\u1ea3 \u201cSatisfactory\u201d, if sai \u2013<\/p>\n<p style=\"text-align: justify\">Tr\u1ea3 \u201d Poor \u201c)))<\/p>\n<p style=\"text-align: justify\"><strong>Th\u1ee9 t\u1ef1 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n r\u1ea5t quan tr\u1ecdng<\/strong><\/p>\n<p style=\"text-align: justify\">T\u1eeb v\u00ed d\u1ee5 tr\u00ean, c\u00f3 th\u1ec3 th\u1ea5y \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng nh\u1ea5t s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft \u0111\u1ea7u ti\u00ean. V\u00ec Excel s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n theo th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c, v\u00e0 ngay khi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, \u0111i\u1ec1u ki\u1ec7n sau \u0111\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_IF_LONG_NHAU_BAO_GOM_PHEP_TINH\"><\/span><strong>H\u00c0M IF L\u1ed2NG NHAU BAO G\u1ed2M PH\u00c9P T\u00cdNH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Y\u00eau c\u1ea7u nh\u01b0 sau: gi\u00e1 c\u1ea3 h\u00e0ng ho\u00e1 s\u1ebd thay \u0111\u1ed5i ph\u1ee5 thu\u1ed9c v\u00e0o s\u1ed1 l\u01b0\u1ee3ng c\u1ee5 th\u1ec3. V\u00e0 b\u1ea1n mu\u1ed1n vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n t\u1ed5ng gi\u00e1 v\u1edbi s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng ho\u00e1 b\u1ea5t k\u00ec v\u00e0 \u0111\u01b0a 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 ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh tu\u1ef3 v\u00e0o s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0 gi\u00e1 c\u1ea3 \u0111\u01b0\u1ee3c t\u00ednh nh\u01b0 sau:<\/p>\n<table style=\"height: 362px\" width=\"453\">\n<tbody>\n<tr>\n<td style=\"width: 218px;text-align: center\"><strong>S\u1ed1 l\u01b0\u1ee3ng h\u00e0ng<\/strong><\/td>\n<td style=\"width: 219px;text-align: center\"><strong>Gi\u00e1 c\u1ea3 m\u1ed7i \u0111\u01a1n v\u1ecb<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 218px;text-align: center\">1 to 10<\/td>\n<td style=\"width: 219px;text-align: center\">$20<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 218px;text-align: center\">11 to 19<\/td>\n<td style=\"width: 219px;text-align: center\">$18<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 218px;text-align: center\">20 to 49<\/td>\n<td style=\"width: 219px;text-align: center\">$16<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 218px;text-align: center\">50 to 100<\/td>\n<td style=\"width: 219px;text-align: center\">$13<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 218px;text-align: center\">Over 101<\/td>\n<td style=\"width: 219px;text-align: center\">$12<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">C\u00f4ng vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m IF l\u1ed3ng nhau. C\u00e1ch hi\u1ec3u t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u00ed d\u1ee5 1, \u0111i\u1ec3m kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n nh\u00e2n s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u1ee5 th\u1ec3 v\u1edbi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 b\u1edfi h\u00e0m IF (v\u00ed d\u1ee5: gi\u00e1 ti\u1ec1n t\u01b0\u01a1ng \u1ee9ng m\u1ed7i \u0111\u01a1n v\u1ecb h\u00e0ng)<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng v\u00e0o \u00f4 B8, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">=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)))))<\/p>\n<p style=\"text-align: justify\">V\u00e0 k\u1ebft qu\u1ea3 s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4752 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-calculations.png\" width=\"534\" height=\"245\" title=\"nested-if-calculations\"><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 n\u00e0y ch\u1ec9 h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m c\u01a1 b\u1ea3n, n\u1ebfu b\u1ea1n \u0111\u00e3 hi\u1ec3u, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau n\u00e0y v\u00e0o nh\u1eefng c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, thay v\u00ec \u0111\u1eb7t s\u1eb5n gi\u00e1 c\u1ea3 h\u00e0ng ho\u00e1 trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 d\u1eabn t\u1edbi c\u00e1c \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb n\u00e0y (\u00f4 B2 \u0111\u1ebfn B6). Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1ebd gi\u00fap b\u1ea1n thay \u0111\u1ed5i ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o m\u00e0 kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">=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)))))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4753 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-multiple-calculations.png\" width=\"528\" height=\"244\" title=\"nested-if-multiple-calculations\"><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 th\u00eam \u0111i\u1ec1u ki\u1ec7n IF n\u1eefa gi\u00fap ch\u1eb7n tr\u00ean, ch\u1eb7n d\u01b0\u1edbi ho\u1eb7c c\u1ea3 2 \u0111\u1ea7u c\u1ee7a kho\u1ea3ng gi\u00e1 tr\u1ecb. Khi s\u1ed1 l\u01b0\u1ee3ng kh\u00f4ng n\u1eb1m trong kho\u1ea3ng gi\u00e1 tr\u1ecb, c\u00f4ng th\u1ee9c s\u1ebd hi\u1ec7n th\u1ecb c\u1ee5m t\u1eeb \u201cout of the range\u201d. V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\">=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))))))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4754 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-fixed-range-1.png\" width=\"408\" height=\"267\" title=\"nested-if-fixed-range-1\"><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <strong>h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> \u0111\u01b0\u1ee3c mi\u00eau t\u1ea3 b\u00ean tr\u00ean c\u00f3 trong m\u1ecdi phi\u00ean b\u1ea3n Excel t\u1eeb 2016-2000. Trong Excel 2016 thu\u1ed9c Office 365, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IF theo c\u00e1ch nh\u01b0 tr\u00ean.<\/p>\n<p style=\"text-align: justify\">Nh\u1eefng ng\u01b0\u1eddi l\u00e0m Excel chuy\u00ean nghi\u1ec7p \u0111\u00e3 quen d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-excel-tim-hieu-ve-cong-thuc-mang-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00f4ng th\u1ee9c M\u1ea3ng<\/a> (array), th\u00ec h\u00e0m n\u00e0y c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng h\u00e0m IF l\u1ed3ng nhau \u1edf b\u00ean tr\u00ean. Tuy hi\u1ec3u c\u00f4ng th\u1ee9c array kh\u00f3 h\u01a1n r\u1ea5t nhi\u1ec1u, ch\u01b0a n\u00f3i \u0111\u1ebfn vi\u1ec7c vi\u1ebft ra, h\u00e0m M\u1ea3ng c\u00f3 m\u1ed9t \u01b0u \u0111i\u1ec3m \u2013 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng m\u1ed9t d\u00e3y \u00f4 c\u00f3 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n b\u1ea1n c\u1ea7n, kh\u00f4ng c\u1ea7n vi\u1ebft t\u1eebng \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec3m n\u00e0y gi\u00fap c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n, v\u00e0 n\u1ebfu ng\u01b0\u1eddi d\u00f9ng c\u1ee7a b\u1ea1n c\u1ea7n thay \u0111\u1ed5i m\u1ed9t \u0111i\u1ec1u ki\u1ec7n b\u1ea5t k\u00ec hay th\u00eam \u0111i\u1ec1u ki\u1ec7n m\u1edbi, b\u1ea1n ch\u1ec9 c\u1ea7n c\u1eadp nh\u1eadt l\u1ea1i d\u00e3y \u00f4 trong c\u00f4ng th\u1ee9c c\u1ee7a m\u00ecnh.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"HAM_IF_LONG_NHAU_NHUNG_DIEU_CAN_NHO\"><\/span><strong>H\u00c0M IF L\u1ed2NG NHAU, NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N NH\u1eda<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, d\u00f9ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel kh\u00f4ng \u0111\u00f2i h\u1ecfi ph\u01b0\u01a1ng ph\u00e1p, c\u00f4ng th\u1ee9c cao si\u00eau. \u0110\u1ec3 c\u1ea3i thi\u1ec7n c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau v\u00e0 tr\u00e1nh nh\u1eefng l\u1ed7i th\u00f4ng th\u01b0\u1eddng, h\u00e3y lu\u00f4n nh\u1edb 3 \u0111i\u1ec1u c\u01a1 b\u1ea3n sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong Excel 2016-2007, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p 64 \u0111i\u1ec1u ki\u1ec7n. Trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n t\u1eeb Excel 2003 v\u1ec1 tr\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng t\u1ed1i \u0111a 7 \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<li>Lu\u00f4n ngh\u0129 t\u1edbi th\u1ee9 t\u1ef1 c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c h\u00e0m IF l\u1ed3ng nhau \u2013 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u00fang, nh\u1eefng \u0111i\u1ec1u ki\u1ec7n sau s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ki\u1ec3m tra.<\/li>\n<li>N\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u h\u01a1n 5 ch\u1ee9c n\u0103ng h\u00e0m IF, c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y c\u00f3 th\u1ec3 s\u1ebd t\u1ed1i \u01b0u h\u01a1n.<\/li>\n<\/ol>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THAY_THE_CHO_HAM_IF_LONG_NHAU_TRONG_EXCEL\"><\/span><strong>THAY TH\u1ebe CHO H\u00c0M IF L\u1ed2NG NHAU TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ebf tr\u00e1nh kh\u1ecfi m\u1ee9c gi\u1edbi h\u1ea1n 7 \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF \u1edf nh\u1eefng phi\u00ean b\u1ea3n Excel c\u0169 v\u00e0 gi\u00fap c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean ng\u1eafn g\u1ecdn v\u00e0 nhanh h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p sau thay th\u1ebf cho <strong>h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/strong><\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LOOKUP<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-tim-kiem-vlookup-va-hlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX<\/a>\/MATCH ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">CHOOSE<\/a>.<\/li>\n<li>D\u00f9ng IF k\u1ebft h\u1ee3p v\u1edbi OR\/AND<\/li>\n<li>D\u00f9ng c\u00f4ng th\u1ee9c array<\/li>\n<li>D\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m CONCATENATE<\/a> v\u00e0 ph\u01b0\u01a1ng ph\u00e1p n\u1ed1i chu\u1ed7i<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m Excel kh\u00e1c, h\u00e0m CONCATENATE c\u00f3 th\u1ec3 bao g\u1ed3m 30 \u0111i\u1ec1u ki\u1ec7n trong c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 v\u00e0 255 \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3n Excel\u00a0 2016 \u2013 2007.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 tr\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 kh\u00e1c nhau d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb trong \u00f4 B2, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng m\u1ed9t trong s\u1ed1 nh\u1eefng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\">H\u00e0m IF l\u1ed3ng nhau:<\/p>\n<p style=\"text-align: justify\">=IF(B2&gt;249, \u201cExcellent\u201d, IF(B2&gt;=200, \u201cGood\u201d, IF(B2&gt;150, \u201cSatisfactory\u201d, \u201cPoor \u201c)))<\/p>\n<p style=\"text-align: justify\">H\u00e0m CONCATENATE:<\/p>\n<p style=\"text-align: justify\">=CONCATENATE(IF(C1=\u201da\u201d, \u201cExcellent\u201d, \u201c\u201d), IF(C1=\u201db\u201d, \u201cGood\u201d, \u201c\u201d), IF(C1=\u201dc\u201d, \u201cPoor \u201c, \u201c\u201d))<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4755 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-concatenate.png\" width=\"499\" height=\"243\" title=\"excel-concatenate\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ee9c n\u0103ng n\u1ed1i chu\u1ed7i:<\/p>\n<p style=\"text-align: justify\">=IF(B2=\u201da\u201d, \u201cExcellent\u201d, \u201c\u201d) &amp; IF(B2=\u201db\u201d, \u201cGood\u201d, \u201c\u201d) &amp; IF(B2=\u201dc\u201d, \u201cPoor \u201c, \u201c\u201d) &amp; IF(B2=\u201dd\u201d, \u201cPoor \u201c, \u201c\u201d)<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: H\u1ecdc Excel Online<\/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-616.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6869","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\/6869","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=6869"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6870"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}