{"id":8549,"date":"2024-12-22T14:51:16","date_gmt":"2024-12-22T14:51:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-su-dung-ham-if-hieu-qua-trong-excel\/"},"modified":"2024-12-22T14:51:16","modified_gmt":"2024-12-22T14:51:16","slug":"huong-dan-su-dung-ham-if-hieu-qua-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-su-dung-ham-if-hieu-qua-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m IF hi\u1ec7u qu\u1ea3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00e2u l\u1ec7nh IF c\u1ef1c k\u1ef3 m\u1ea1nh m\u1ebd, \u0111\u1ed3ng th\u1eddi t\u1ea1o c\u01a1 s\u1edf cho nhi\u1ec1u m\u00f4 h\u00ecnh b\u1ea3ng t\u00ednh nh\u01b0ng \u0111\u1ed3ng th\u1eddi \u0111\u00e2y c\u0169ng l\u00e0 nguy\u00ean nh\u00e2n g\u00e2y ra m\u1ed9t s\u1ed1 s\u1ef1 c\u1ed1. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t s\u1ed1 h\u01b0\u1edbng s\u1eed d\u1ee5ng h\u00e0m IF hi\u1ec7u qu\u1ea3.<\/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-67682763cb656\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-if-hieu-qua.html#Giai_nghia_cong_thuc_IF_don_gian\" title=\"Gi\u1ea3i ngh\u0129a c\u00f4ng th\u1ee9c IF \u0111\u01a1n gi\u1ea3n\">Gi\u1ea3i ngh\u0129a c\u00f4ng th\u1ee9c IF \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-if-hieu-qua.html#Luu_y_ve_ham_IF\" title=\"L\u01b0u \u00fd v\u1ec1 h\u00e0m IF\">L\u01b0u \u00fd v\u1ec1 h\u00e0m IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-if-hieu-qua.html#Vi_du_ve_su_dung_ham_IF\" title=\"V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m IF\">V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-if-hieu-qua.html#Nguyen_tac_cua_IF\" title=\"Nguy\u00ean t\u1eafc c\u1ee7a IF\">Nguy\u00ean t\u1eafc c\u1ee7a IF<\/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\/su-dung-ham-if-hieu-qua.html#Thay_the_IF_bang_IFS_%E2%80%93_ham_moi_trong_Office_365\" title=\"Thay th\u1ebf IF b\u1eb1ng IFS \u2013 h\u00e0m m\u1edbi trong Office 365\">Thay th\u1ebf IF b\u1eb1ng IFS \u2013 h\u00e0m m\u1edbi trong Office 365<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Giai_nghia_cong_thuc_IF_don_gian\"><\/span>Gi\u1ea3i ngh\u0129a c\u00f4ng th\u1ee9c IF \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ec1 c\u01a1 b\u1ea3n, c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng IF\u00a0nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em><strong>=IF(N\u1ebfu \u0111i\u1ec1u ki\u1ec7n t\u1ea1i \u0111\u00e2y \u0111\u00fang, th\u1ef1c hi\u1ec7n \u0111i\u1ec1u trong m\u1ee5c n\u00e0y, kh\u00f4ng th\u00ec th\u1ef1c hi\u1ec7n \u0111i\u1ec1u t\u1ea1i m\u1ee5c n\u00e0y)<\/strong><\/em><\/p>\n<\/blockquote>\n<p>V\u1eady n\u00ean IF s\u1ebd c\u00f3 2 k\u1ebft qu\u1ea3. K\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n \u0111\u00fang, k\u1ebft qu\u1ea3 th\u1ee9 hai \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n sai.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Luu_y_ve_ham_IF\"><\/span>L\u01b0u \u00fd v\u1ec1 h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u00f9 Excel cho ph\u00e9p b\u1ea1n l\u1ed3ng gh\u00e9p 64 b\u1ed9 IF v\u1edbi nhau, ta kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u. T\u1ea1i sao l\u1ea1i nh\u01b0 v\u1eady?<\/p>\n<ul>\n<li>C\u00e0ng nhi\u1ec1u IF l\u1ed3ng nhau, logic \u0111\u1ec3 x\u00e2y d\u1ef1ng ch\u00ednh x\u00e1c qua t\u1eebng \u0111i\u1ec1u ki\u1ec7n s\u1ebd c\u00e0ng ph\u1ee9c t\u1ea1p.<\/li>\n<li>R\u1ea5t kh\u00f3 \u0111\u1ec3 c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t c\u00e1c h\u00e0m IF l\u1ed3ng nhau, \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n quay tr\u1edf l\u1ea1i m\u1ed9t th\u1eddi gian sau \u0111\u1ea5y v\u00e0 kh\u00f4ng nh\u1edb m\u00ecnh \u0111\u00e3 l\u00e0m nh\u1eefng g\u00ec, ho\u1eb7c t\u1ec7 h\u01a1n, \u0111\u1ecdc h\u00e0m c\u1ee7a ng\u01b0\u1eddi kh\u00e1c.<\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n \u0111ang \u0111\u1ecbnh\u00a0s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m l\u1ed3ng nhau \u0111\u1ec3 x\u1eed l\u00fd t\u00e1c v\u1ee5, h\u00e3y ng\u1eebng l\u1ea1i v\u00e0 ngh\u0129 t\u1edbi gi\u1ea3i ph\u00e1p kh\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_su_dung_ham_IF\"><\/span>V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t v\u00ed d\u1ee5 th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u01b0a ra nh\u1ea5t khi s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u00f3 l\u00e0 x\u1ebfp lo\u1ea1i cho h\u1ecdc sinh d\u1ef1a v\u00e0o \u0111i\u1ec3m. B\u00e0i to\u00e1n quen thu\u1ed9c \u0111\u00f3 nh\u01b0 sau:<\/p>\n<p><em>S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 x\u1ebfp lo\u1ea1i\u00a0h\u1ecdc sinh\u00a0theo \u0111i\u1ec3m. N\u1ebfu h\u1ecdc sinh \u0111\u01b0\u1ee3c 8 tr\u1edf l\u00ean x\u1ebfp lo\u1ea1i gi\u1ecfi, 6.5 \u0111\u1ebfn 7.9 x\u1ebfp lo\u1ea1i kh\u00e1, d\u01b0\u1edbi 6.5 x\u1ebfp lo\u1ea1i trung b\u00ecnh.<\/em><\/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-788.gif\" title=\"ex101_92019-nho-788\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27691\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-if-1.png\" width=\"204\" height=\"122\" title=\"su-dung-ham-if-1\"><\/p>\n<p>Ta c\u00f3 th\u1ec3 l\u00e0m v\u1edbi IF nh\u01b0 sau:<\/p>\n<p><strong><em>=IF(B6&lt;6.5,\u201dTrung b\u00ecnh\u201d,IF(B6&lt;8,\u201dKh\u00e1\u201d,\u201dGi\u1ecfi\u201d))<\/em><\/strong><\/p>\n<p>\u0110\u00e2y l\u00e0 b\u00e0i to\u00e1n \u0111\u01a1n gi\u1ea3n v\u00e0 ch\u00fang ta ch\u1ec9 m\u1ea5t 2 h\u00e0m IF cho 3 \u0111i\u1ec1u ki\u1ec7n. Ch\u01b0a c\u00f3 g\u00ec kh\u00f3 kh\u0103n c\u1ea3. V\u1eady c\u00f2n b\u00e0i to\u00e1n m\u1edf r\u1ed9ng v\u1edbi 5 \u0111i\u1ec1u ki\u1ec7n\u00a0<em>Xu\u1ea5t s\u1eafc \u2013 Gi\u1ecfi \u2013 Kh\u00e1 \u2013 Trung b\u00ecnh \u2013 Y\u1ebfu\u00a0<\/em>th\u00ec sao? Ta s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng\u00a0<strong>n-1<\/strong> h\u00e0m IF cho\u00a0<strong>n\u00a0<\/strong>\u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>H\u00e3y\u00a0xem b\u1ea3ng\u00a0ph\u00e2n lo\u1ea1i theo \u0111i\u1ec3m d\u01b0\u1edbi \u0111\u00e2y, li\u1ec7u b\u1ea1n c\u00f2n mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m IF kh\u00f4ng?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27692\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-if-2.png\" width=\"191\" height=\"302\" title=\"su-dung-ham-if-2\"><\/p>\n<p>M\u1eb7c d\u00f9 ta v\u1eabn c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng IF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, tuy nhi\u00ean b\u1ea1n s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 vi\u1ebft v\u00e0 ki\u1ec3m tra li\u1ec7u c\u00f4ng th\u1ee9c c\u00f3 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u1ec3 thay th\u1ebf IF ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-vlookup-thay-the-ham-if-long-nhau-trong-excel.html\">VLOOKUP t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i<\/a><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_tac_cua_IF\"><\/span><strong>Nguy\u00ean t\u1eafc c\u1ee7a IF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m IF s\u1ebd t\u00ednh to\u00e1n \u0111i\u1ec1u ki\u1ec7n theo th\u1ee9 t\u1ef1 <em>t<\/em><em>\u1eeb ngo\u00e0i v\u00e0o trong<\/em>, b\u1edfi v\u1eady trong tr\u01b0\u1eddng h\u1ee3p sau \u0111\u00e2y h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27693\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-if-3.png\" width=\"638\" height=\"256\" title=\"su-dung-ham-if-3\"><\/p>\n<p>L\u00ed do: Khi h\u00e0m IF x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n B2 &gt;= 6.5 l\u00e0\u00a0<strong>TRUE<\/strong>, n\u00f3 s\u1ebd d\u1eebng l\u1ea1i v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c m\u00e0 kh\u00f4ng c\u1ea7n t\u00ednh to\u00e1n v\u1ebf sau. \u0110\u1ec3 theo d\u00f5i th\u1ee9 t\u1ef1 b\u1ea1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng\u00a0<strong>Evaluate Formula<\/strong> trong th\u1ebb\u00a0<strong>Formula<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27694\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-if-4.png\" width=\"722\" height=\"445\" title=\"su-dung-ham-if-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_the_IF_bang_IFS_%E2%80%93_ham_moi_trong_Office_365\"><\/span>Thay th\u1ebf IF b\u1eb1ng IFS \u2013 h\u00e0m m\u1edbi trong Office 365<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Office 365 ch\u00fang ta c\u00f3 h\u00e0m IFS gi\u00fap thay th\u1ebf IF l\u1ed3ng nhau, khi\u1ebfn c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n nhi\u1ec1u:<\/p>\n<p><em>=IFS(\u0111i\u1ec1u ki\u1ec7n 1, gi\u00e1 tr\u1ecb \u0111\u00fang 1, \u0111i\u1ec1u ki\u1ec7n 2, gi\u00e1 tr\u1ecb \u0111\u00fang 2,\u2026)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27695\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-ham-if-5.png\" width=\"636\" height=\"260\" title=\"su-dung-ham-if-5\"><\/p>\n<p>M\u1ed7i h\u00e0m \u0111\u1ec1u c\u00f3 nh\u1eefng \u1ee9ng d\u1ee5ng ri\u00eang, \u0111i\u1ec3m m\u1ea1nh c\u0169ng nh\u01b0 \u0111i\u1ec3m y\u1ebfu c\u1ee7a n\u00f3. Ta c\u1ea7n s\u1eed d\u1ee5ng sao cho h\u1ee3p l\u00fd \u0111\u1ec3 khi\u1ebfn c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7 \u0111\u1ec1:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/19-tips-huu-hieu-cho-ham-if-long-nhau.html\"><strong>19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau (ph\u1ea7n 1)<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html\"><strong>19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau (ph\u1ea7n 2)<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html\"><strong>Vi\u1ebft nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau<\/strong><\/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\/2024\/12\/ex101_92019-nho-788.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8550,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8549","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\/8549","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=8549"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8549\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8550"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}