{"id":9952,"date":"2025-01-06T03:56:10","date_gmt":"2025-01-06T03:56:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-ham-if-trong-excel-co-ban-qua-cac-vi-du-don-gian\/"},"modified":"2025-01-06T03:56:10","modified_gmt":"2025-01-06T03:56:10","slug":"huong-dan-ham-if-trong-excel-co-ban-qua-cac-vi-du-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/06\/huong-dan-ham-if-trong-excel-co-ban-qua-cac-vi-du-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m IF trong Excel c\u01a1 b\u1ea3n qua c\u00e1c v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m IF trong Excel l\u00e0 h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng cao. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/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-677b5459ee099\" 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\/ham-if-co-ban-qua-cac-vi-du-don-gian.html#Cau_truc_ham_if_trong_Excel\" title=\"C\u1ea5u tr\u00fac h\u00e0m if trong Excel\">C\u1ea5u tr\u00fac h\u00e0m if trong Excel<\/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\/ham-if-co-ban-qua-cac-vi-du-don-gian.html#Vi_du_ve_ham_IF\" title=\"V\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF\">V\u00ed d\u1ee5 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\/ham-if-co-ban-qua-cac-vi-du-don-gian.html#Ham_IF_long_nhau\" title=\"H\u00e0m IF l\u1ed3ng nhau\">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-4\" href=\"https:\/\/blog.hocexcel.online\/ham-if-co-ban-qua-cac-vi-du-don-gian.html#Ket_hop_ham_IF_voi_cac_ham_co_ban_khac\" title=\"K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m c\u01a1 b\u1ea3n kh\u00e1c\">K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m c\u01a1 b\u1ea3n kh\u00e1c<\/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\/ham-if-co-ban-qua-cac-vi-du-don-gian.html#Chu_y\" title=\"Ch\u00fa \u00fd\">Ch\u00fa \u00fd<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cau_truc_ham_if_trong_Excel\"><\/span>C\u1ea5u tr\u00fac h\u00e0m if trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>IF<\/strong> ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t ra c\u00f3 \u0111\u00fang hay kh\u00f4ng, sau \u0111\u00f3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng n\u1ebfu \u0111\u00fang ho\u1eb7c sai.<\/p>\n<p>H\u00e0m\u00a0<strong>IF\u00a0<\/strong>c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=IF(Logical_test,Value_if_true,Value_if_false)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>Logical_test<\/strong> l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb b\u1ea5t k\u00ec ho\u1eb7c m\u1ed9t bi\u1ec3u th\u1ee9c, di\u1ec5n gi\u1ea3i\u2026 m\u00e0 c\u00f3 th\u1ec3 tr\u1ea3 l\u1eddi \u0110\u00daNG hay SAI.<\/p>\n<p><strong>Value_if_true<\/strong> l\u00e0 gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong>Logical_test\u00a0<\/strong>l\u00e0 \u0110\u00daNG.<\/p>\n<p><strong>Value_if_false<\/strong> l\u00e0 gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a\u00a0<strong>Logical_test\u00a0<\/strong>l\u00e0 SAI.<\/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-113.gif\" title=\"ex101_92019-nho-113\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_ham_IF\"><\/span>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y theo d\u00f5i v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y:<br \/>\n[iframe width=\u201d700\u2033 height=\u201d494\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21104&amp;authkey=%21ALgL1OQ_a5n9ZDA&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019VDIF1\u2032!A1%3AK22&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p>H\u00e0m IF \u1edf \u0111\u00e2y c\u00f3 c\u1ea5u tr\u00fac:<\/p>\n<blockquote>\n<p>N\u1ebfu A4=C4, tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201c\u0110\u00fang\u201d, n\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cSai\u201d.<\/p>\n<\/blockquote>\n<p>Ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 E4 l\u00e0 \u201cSai\u201d. Sau \u0111\u00f3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng AutoFill \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00e0o nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IF_long_nhau\"><\/span>H\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta \u0111\u00e3 hi\u1ec3u c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m\u00a0<strong>IF<\/strong> \u0111\u01a1n gi\u1ea3n. V\u1eady v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u logic \u0111an xem nhau, ta s\u1ebd gi\u1ea3i quy\u1ebft nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<ul>\n<li><em>H\u00e3y l\u1ed3ng c\u00e1c h\u00e0m IF v\u00e0o v\u1edbi nhau.<\/em><\/li>\n<\/ul>\n<p>[iframe width=\u201d700\u2033 height=\u201d364\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21104&amp;authkey=%21ALgL1OQ_a5n9ZDA&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019VDIF2\u2032!A1%3AQ15&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<p>\u00a0<\/p>\n<p>V\u1edbi v\u00ed d\u1ee5 n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u00f5 y\u00eau c\u1ea7u bao g\u1ed3m 4 y\u00eau c\u1ea7u nh\u1ecf h\u01a1n t\u1ed5 h\u1ee3p th\u00e0nh. \u0110\u1ec3 x\u1eed l\u00fd, ta s\u1ebd l\u1ed3ng c\u00e1c h\u00e0m IF v\u00e0o v\u1edbi nhau theo c\u1ea5u tr\u00fac:<\/p>\n<blockquote>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d&gt;8, x\u1ebfp lo\u1ea1i \u201cGi\u1ecfi\u201d;<\/p>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d &gt;=6.5 v\u00e0 &lt;8, x\u1ebfp lo\u1ea1i \u201cKh\u00e1\u201d;<\/p>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d &gt;=5 v\u00e0 &lt;6.5, x\u1ebfp lo\u1ea1i \u201cTrung b\u00ecnh\u201d;<\/p>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d &lt;5, x\u1ebfp lo\u1ea1i \u201cY\u1ebfu\u201d.<\/p>\n<\/blockquote>\n<p>Khi Excel x\u1eed l\u00ed, c\u1ea5u tr\u00fac tr\u00ean c\u00f3 th\u1ec3 hi\u1ec3u g\u1ecdn th\u00e0nh:<\/p>\n<blockquote>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d&gt;8, x\u1ebfp lo\u1ea1i \u201cGi\u1ecfi\u201d; &lt;n\u1ebfu kh\u00f4ng th\u00ec x\u00e9t c\u00f4ng th\u1ee9c \u1edf d\u01b0\u1edbi&gt;<\/p>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d&gt;6.5, x\u1ebfp lo\u1ea1i \u201cKh\u00e1\u201d; &lt;n\u1ebfu kh\u00f4ng th\u00ec x\u00e9t c\u00f4ng th\u1ee9c \u1edf d\u01b0\u1edbi&gt;<\/p>\n<p>N\u1ebfu \u201c\u0110i\u1ec3m\u201d&gt;5, x\u1ebfp lo\u1ea1i \u201cTrung b\u00ecnh\u201d; &lt;n\u1ebfu kh\u00f4ng th\u00ec ch\u1ec9 c\u00f2n 1 lo\u1ea1i l\u00e0\u00a0\u201cY\u1ebfu\u201d&gt;<\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<p>T\u1eeb \u0111\u00f3 ta c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c vi\u1ebft g\u1ecdn ph\u00eda tr\u00ean thay v\u00ec ph\u1ea3i di\u1ec5n gi\u1ea3i b\u1eb1ng m\u1ed9t h\u00e0m AND \u0111i k\u00e8m.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_ham_IF_voi_cac_ham_co_ban_khac\"><\/span>K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m c\u01a1 b\u1ea3n kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u01a1n nh\u1ea5t, h\u00e0m IF l\u1ed3ng nhau, ta c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c trong Excel. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 2 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 c\u00e1c b\u1ea1n tham kh\u1ea3o:<\/p>\n<p>[iframe width=\u201d700\u2033 height=\u201d458\u2033 frameborder=\u201d0\u2033 scrolling=\u201dno\u201d src=\u201dhttps:\/\/onedrive.live.com\/embed?resid=B21F9331F704AFCF%21104&amp;authkey=%21ALgL1OQ_a5n9ZDA&amp;em=2&amp;wdAllowInteractivity=False&amp;AllowTyping=True&amp;Item=\u2019VDIF3\u2032!A1%3AS19&amp;wdHideGridlines=True&amp;wdDownloadButton=True&amp;wdInConfigurator=True\u201d]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chu_y\"><\/span>Ch\u00fa \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Khi s\u1eed d\u1ee5ng h\u00e0m IF hay b\u1ea5t k\u00ec h\u00e0m n\u00e0o kh\u00e1c, c\u1ea7n ghi nh\u1edb vi\u1ec7c c\u1ed1 \u0111\u1ecbnh m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb tham chi\u1ebfu tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p sai s\u00f3t.<\/li>\n<li>H\u00e0m IF l\u1ed3ng nhau th\u01b0\u1eddng d\u00e0i v\u00e0 kh\u00f3 nh\u1edb, k\u00e8m theo vi\u1ec7c d\u1ec5 x\u1ea3y ra lo\u1ea1n logic. B\u1edfi v\u1eady c\u1ea7n ph\u00e2n t\u00edch y\u00eau c\u1ea7u th\u1eadt r\u00f5, v\u00e0 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c c\u00e1ch kh\u00e1c thay th\u1ebf.<\/li>\n<li>K\u1ebft h\u1ee3p linh \u0111\u1ed9ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c. V\u00ed d\u1ee5: <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-ket-hop-ham.html\">h\u00e0m VLOOKUP<\/a>.<\/li>\n<\/ul>\n<p>Ngo\u00e0i nh\u1eefng v\u00ed d\u1ee5 tr\u00ean c\u00f2n r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m IF m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u trong c\u00e1c b\u00e0i vi\u1ebft tr\u00ean trang <strong><a href=\"http:\/\/blog.ezworkapp.com\/?s=h%C3%A0m+if\">H\u1ecdc Excel Online<\/a>. <\/strong>H\u00e3y d\u00e0nh th\u1eddi gian \u0111\u1ecdc, h\u1ecdc v\u00e0 quan tr\u1ecdng nh\u1ea5t l\u00e0 th\u1ef1c h\u00e0nh \u0111\u1ec3 c\u00f3 th\u1ec3 n\u1eafm v\u1eefng nh\u1eefng ki\u1ebfn th\u1ee9c n\u1ec1n t\u1ea3ng n\u00e0y nh\u00e9.\u00a0Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<p><strong>Xem c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m if trong excel m\u1ed9t c\u00e1ch chi ti\u1ebft, v\u1edbi c\u00e1c v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt li\u00ean t\u1ee5c t\u1ea1i b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n nh\u00e9! <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">C\u00e1ch d\u00f9ng h\u00e0m IF trong Excel<\/a>, c\u00f3 v\u00ed d\u1ee5 h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3<\/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\/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-113.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9953,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9952","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\/9952","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=9952"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9952\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9953"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}