{"id":10910,"date":"2025-01-15T00:37:42","date_gmt":"2025-01-15T00:37:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-ifs-trong-excel\/"},"modified":"2025-01-15T00:37:42","modified_gmt":"2025-01-15T00:37:42","slug":"ham-ifs-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-ifs-trong-excel\/","title":{"rendered":"H\u00e0m IFS trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-ifs-trong-excel.html\" target=\"_blank\">H\u00e0m IFS \u2013 m\u1ed9t h\u00e0m logic<\/a> c\u00f3 m\u1eb7t trong c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel Online \u2026 ki\u1ec3m tra m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f3 tho\u1ea3 m\u00e3n hay kh\u00f4ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n TRUE \u0111\u1ea7u ti\u00ean. L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IFS l\u00e0 c\u00f3 th\u1ec3 thay th\u1ebf \u0111\u01b0\u1ee3c nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau v\u00e0 gi\u00fap cho vi\u1ec7c \u0111\u1ecdc c\u00f4ng th\u1ee9c Excel tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u.<\/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-67870355a9533\" 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-ifs-trong-excel.html#Cu_phap_cach_su_dung_ham_IFS\" title=\"C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFS\">C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFS<\/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\/ham-ifs-trong-excel.html#Mot_so_vi_du_su_dung_ham_IFS\" title=\"M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IFS\">M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IFS<\/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\/ham-ifs-trong-excel.html#Mot_so_luu_y_khi_su_dung_ham_IFS\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IFS\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IFS<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_cach_su_dung_ham_IFS\"><\/span>C\u00fa ph\u00e1p, <a href=\"http:\/\/blog.ezworkapp.com\/ham-ifs-trong-excel.html\" target=\"_blank\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFS<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><code>=IFS ( &lt;bi\u1ec3u th\u1ee9c logic 1&gt;, &lt;gi\u00e1 tr\u1ecb n\u1ebfu bi\u1ec3u th\u1ee9c logic 1 l\u00e0 TRUE&gt;,<\/code><\/p>\n<p><code>[ &lt;bi\u1ec3u th\u1ee9c logic 2&gt; ], [&lt;gi\u00e1 tr\u1ecb n\u1ebfu bi\u1ec3u th\u1ee9c logic 2 l\u00e0 TRUE&gt;\u00a0],<\/code><\/p>\n<p><code>...<\/code><\/p>\n<p><code>[ &lt;bi\u1ec3u th\u1ee9c logic 127&gt; ], [&lt;gi\u00e1 tr\u1ecb n\u1ebfu bi\u1ec3u th\u1ee9c logic 127 l\u00e0 TRUE&gt;\u00a0] )<\/code><\/p>\n<p>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IFS:<\/p>\n<ul>\n<li>H\u00e0m IFS h\u1ed7 tr\u1ee3 t\u1ed1i \u0111a 127 \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau<\/li>\n<li>Th\u01b0\u1eddng th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng ho\u1eb7c h\u00e0m IFS nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n s\u1ebd r\u1ea5t kh\u00f3 \u0111\u1ec3 thi\u1ebft l\u1eadp, ki\u1ec3m so\u00e1t v\u00e0 ch\u1ec9nh s\u1eeda<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_vi_du_su_dung_ham_IFS\"><\/span>M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IFS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>X\u1ebfp h\u1ea1ng \u0111i\u1ec3m d\u1ef1a tr\u00ean c\u00e1c m\u1ed1c \u0111i\u1ec3m l\u00e0 89, 79, 69, 59, d\u01b0\u1edbi 59:<\/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\/2025\/01\/ex101_92019-nho-240.gif\" title=\"ex101_92019-nho-240\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i B2:<\/p>\n<p><code>=IFS(A2&gt;89,\"A\",A2&gt;79,\"B\",A2&gt;69,\"C\",A2&gt;59,\"D\",TRUE,\"F\")<\/code><\/p>\n<figure id=\"attachment_11543\" aria-describedby=\"caption-attachment-11543\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/11\/ham-ifs-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-11543\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-ifs-trong-excel-1024x640-1.png\" alt=\"H\u00e0m ifs trong excel\" width=\"1024\" height=\"640\" title=\"ham-ifs-trong-excel-1024x640-1\"><\/a><figcaption id=\"caption-attachment-11543\" class=\"wp-caption-text\">H\u00e0m IFS trong excel<\/figcaption><\/figure>\n<p>\u1ede \u0111\u00e2y h\u00e0m IFS s\u1ebd\u00a0<strong>d\u1eebng l\u1ea1i\u00a0<\/strong>khi g\u1eb7p \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u0111\u1ea7u ti\u00ean, v\u00ec v\u1eady vi\u1ec7c s\u1eafp x\u1ebfp c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111i\u1ec1u ki\u1ec7n ti\u00ean quy\u1ebft \u0111\u1ec3 thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c 1 h\u00e0m IFS cho k\u1ebft qu\u1ea3 \u0111\u00fang!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_su_dung_ham_IFS\"><\/span>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IFS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>N\u1ebfu c\u00e1c b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m IFS n\u00e0y: \u0111\u1ec3 c\u00f3 m\u1ed9t k\u1ebft qu\u1ea3 m\u1eb7c \u0111\u1ecbnh khi c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc \u0111\u00f3 kh\u00f4ng tho\u1ea3 m\u00e3n (\u1edf trong v\u00ed d\u1ee5 tr\u00ean l\u00e0 tr\u01b0\u1edbc h\u1ee3p \u0111i\u1ec3m s\u1ed1 &lt; 59 \u0111i\u1ec3m) th\u00ec b\u1ea1n nh\u1eadp TRUE v\u00e0o \u0111i\u1ec1u ki\u1ec7n cu\u1ed1i c\u00f9ng c\u1ee7a tham s\u1ed1 trong c\u00e2u l\u1ec7nh IFS.<\/li>\n<li>C\u00e1c c\u1eb7p &lt;bi\u1ec3u th\u1ee9c logic&gt; v\u00e0 &lt;gi\u00e1 tr\u1ecb n\u1ebfu bi\u1ec3u th\u1ee9c logic \u0111\u00fang&gt; c\u1ea7n \u0111i v\u1edbi nhau v\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c thi\u1ebfu 1 trong 2 th\u1ee9, n\u1ebfu kh\u00f4ng, Excel s\u1ebd b\u00e1o l\u1ed7i \u201cYou\u2019ve entered too few arguments for this function\u201d<\/li>\n<li>N\u1ebfu &lt;bi\u1ec3u th\u1ee9c logic&gt; tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ph\u1ea3i l\u00e0 TRUE ho\u1eb7c FALSE th\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IFS tr\u1ea3 v\u1ec1 cu\u1ed1i c\u00f9ng l\u00e0 l\u1ed7i #VALUE!<\/li>\n<li>N\u1ebfu trong c\u00e1c &lt;bi\u1ec3u th\u1ee9c logic&gt; kh\u00f4ng c\u00f3 bi\u1ec3u th\u1ee9c n\u00e0o tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 TRUE, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IFS s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t ch\u01b0\u01a1ng tr\u00ecnh h\u1ecdc s\u00e1t th\u1ef1c t\u1ebf, \u0111\u01b0\u1ee3c gi\u1ea3ng d\u1ea1y b\u1edfi chuy\u00ean gia \u0111\u00e3 c\u00f3 10 n\u0103m kinh nghi\u1ec7m trong c\u00f4ng vi\u1ec7c t\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p c\u00f4ng ngh\u1ec7 cho c\u00e1c t\u1eadp \u0111o\u00e0n l\u1edbn c\u1ee7a qu\u1ed1c t\u1ebf, l\u00e0m vi\u1ec7c t\u1ea1i \u0110\u1ee9c, h\u00e3y tham kh\u1ea3o <a href=\"https:\/\/www.hocexcel.online\/category\/1-excel-co-ban\" target=\"_blank\">c\u00e1c kho\u00e1 h\u1ecdc Excel<\/a> t\u1ea1i platform <a href=\"https:\/\/www.hocexcel.online\" target=\"_blank\">H\u1ecdc Excel Online<\/a> c\u1ee7a Thanh t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/category\/1-excel-co-ban\" target=\"_blank\">C\u00e1c kho\u00e1 h\u1ecdc Excel C\u01a1 B\u1ea3n<\/a><\/p>\n<p><a href=\"https:\/\/hocexcel.online\/category\/2-excel-nang-cao\" target=\"_blank\">C\u00e1c kho\u00e1 h\u1ecdc Excel N\u00e2ng Cao<\/a><\/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\/2025\/01\/ex101_92019-nho-240.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10911,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10910","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\/10910","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=10910"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10910\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10911"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}