{"id":2761,"date":"2024-12-02T08:41:17","date_gmt":"2024-12-02T08:41:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-dung-ham-if-trong-excel-2016-2010-2019-de-hieu\/"},"modified":"2024-12-02T08:41:17","modified_gmt":"2024-12-02T08:41:17","slug":"huong-dan-dung-ham-if-trong-excel-2016-2010-2019-de-hieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-dung-ham-if-trong-excel-2016-2010-2019-de-hieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m IF trong Excel 2016, 2010, 2019 D\u1ec5 Hi\u1ec3u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m ph\u1ed5 bi\u1ebfn v\u00e0 quan tr\u1ecdng nh\u1ea5t trong excel. B\u1ea1n d\u00f9ng h\u00e0m \u0111\u1ec3 y\u00eau c\u1ea7u Excel ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, ho\u1eb7c tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng.<\/em><\/p>\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>Blog H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 c\u00fa ph\u00e1p v\u00e0 <strong>c\u00e1ch d\u00f9ng h\u00e0m IF<\/strong> ph\u1ed5 bi\u1ebfn trong Excel, sau \u0111\u00f3 s\u1ebd c\u00f3 c\u00e1i nh\u00ecn s\u00e2u h\u01a1n b\u1eb1ng c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c m\u00e0 hy v\u1ecdng l\u00e0 s\u1ebd b\u1ed5 \u00edch cho c\u1ea3 nh\u1eefng ng\u01b0\u1eddi m\u1edbi d\u00f9ng Excel v\u00e0 nh\u1eefng ng\u01b0\u1eddi c\u00f3 kinh nghi\u1ec7m.<\/em><\/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-674d72ac0db06\" 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\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Cu_phap_ham_IF_va_cach_dung\" title=\"C\u00fa ph\u00e1p h\u00e0m IF v\u00e0 c\u00e1ch d\u00f9ng:\">C\u00fa ph\u00e1p h\u00e0m IF v\u00e0 c\u00e1ch d\u00f9ng:<\/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\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Nhung_dieu_can_nho_ve_ham_IF_trong_Excel\" title=\"Nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb v\u1ec1 h\u00e0m IF trong Excel:\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb v\u1ec1 h\u00e0m IF trong Excel:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#1_Neu_nhu_value_if_true_bi_bo_qua\" title=\"1. N\u1ebfu nh\u01b0 value_if_true b\u1ecb b\u1ecf qua\">1. N\u1ebfu nh\u01b0 value_if_true b\u1ecb b\u1ecf qua<\/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\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#2_Neu_nhu_value_if_false_bi_bo_qua\" title=\"2. N\u1ebfu nh\u01b0 value_if_false b\u1ecb b\u1ecf qua\">2. N\u1ebfu nh\u01b0 value_if_false b\u1ecb b\u1ecf qua<\/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\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#3_Lam_cho_ham_IF_hien_len_gia_tri_TRUE_hoac_FALSE\" title=\"3. L\u00e0m cho h\u00e0m IF hi\u1ec7n l\u00ean gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE\">3. L\u00e0m cho h\u00e0m IF hi\u1ec7n l\u00ean gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#4_Lam_cho_ham_IF_hien_thi_mot_phep_toan_va_tra_ve_mot_ket_qua\" title=\"4. L\u00e0m cho h\u00e0m IF hi\u1ec3n th\u1ecb m\u1ed9t ph\u00e9p to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3\">4. L\u00e0m cho h\u00e0m IF hi\u1ec3n th\u1ecb m\u1ed9t ph\u00e9p to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Cach_su_dung_ham_IF_trong_Excel_va_cac_vi_du\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u00e0 c\u00e1c v\u00ed\u00a0 d\u1ee5:\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u00e0 c\u00e1c v\u00ed\u00a0 d\u1ee5:<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Cong_thuc_vi_du_ve_ham_IF_cho_phep_so_sanh_so_hoc_nhu_lon_hon_nho_hon_bang\" title=\"C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF cho ph\u00e9p so s\u00e1nh s\u1ed1 h\u1ecdc nh\u01b0: l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, b\u1eb1ng\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m IF cho ph\u00e9p so s\u00e1nh s\u1ed1 h\u1ecdc nh\u01b0: l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, b\u1eb1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Ham_IF_trong_van_ban\" title=\"H\u00e0m IF trong v\u0103n b\u1ea3n:\">H\u00e0m IF trong v\u0103n b\u1ea3n:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_1_Cong_thuc_ham_IF_khong_phan_biet_chu_hoa_hay_chu_thuong_cho_cac_ky_tu\" title=\"V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m IF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1\">V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m IF kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_2_Cong_thuc_ham_IF_phan_biet_chu_hoa_hay_chu_thuong_cho_cac_ky_tu\" title=\"V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m IF ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1\">V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m IF ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_3_Cong_thuc_IF_cho_gia_tri_van_ban_voi_viec_tham_chieu_tung_phan\" title=\"V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c IF cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u1edbi vi\u1ec7c tham chi\u1ebfu t\u1eebng ph\u1ea7n\">V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c IF cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u1edbi vi\u1ec7c tham chi\u1ebfu t\u1eebng ph\u1ea7n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_ve_cong_thuc_ham_IF_cho_ngay_thang\" title=\"V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho ng\u00e0y, th\u00e1ng:\">V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho ng\u00e0y, th\u00e1ng:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_1_Cong_thuc_ham_IF_cho_ngay_thang_voi_ham_DATEVALUE\" title=\"V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m IF cho ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m DATEVALUE \">V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m IF cho ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m DATEVALUE <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_2_Cong_thuc_ham_IF_voi_ham_TODAY\" title=\"V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m IF v\u1edbi h\u00e0m TODAY() \">V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m IF v\u1edbi h\u00e0m TODAY() <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_3_Cong_thuc_ham_IF_mo_rong_cho_ngay_thang_trong_qua_khu_va_tuong_lai\" title=\"V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c h\u00e0m IF m\u1edf r\u1ed9ng cho ng\u00e0y th\u00e1ng trong qu\u00e1 kh\u1ee9 v\u00e0 t\u01b0\u01a1ng lai\">V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c h\u00e0m IF m\u1edf r\u1ed9ng cho ng\u00e0y th\u00e1ng trong qu\u00e1 kh\u1ee9 v\u00e0 t\u01b0\u01a1ng lai<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_ve_cong_thuc_ham_IF_cho_du_lieu_va_o_trong\" title=\"V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho d\u1eef li\u1ec7u v\u00e0 \u00f4 tr\u1ed1ng:\">V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho d\u1eef li\u1ec7u v\u00e0 \u00f4 tr\u1ed1ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html#Vi_du_su_dung_ham_IF_trong_viec_xep_loai_theo_diem_so\" title=\"V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IF trong vi\u1ec7c x\u1ebfp lo\u1ea1i theo \u0111i\u1ec3m s\u1ed1\">V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IF trong vi\u1ec7c x\u1ebfp lo\u1ea1i theo \u0111i\u1ec3m s\u1ed1<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_ham_IF_va_cach_dung\"><\/span>C\u00fa ph\u00e1p h\u00e0m IF v\u00e0 c\u00e1ch d\u00f9ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic cho ph\u00e9p \u0111\u00e1nh gi\u00e1 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh n\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 <strong><em>TRUE<\/em><\/strong> v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 <strong><em>FALSE<\/em><\/strong><\/p>\n<p>C\u00fa ph\u00e1p cho h\u00e0m <strong>IF<\/strong> nh\u01b0 sau:<\/p>\n<pre><code class=\"language-xls\">IF <strong>(logical_test, [value_if_true], [value_if_false])<\/strong><\/code><\/pre>\n<p>Nh\u01b0 b\u1ea1n th\u1ea5y, h\u00e0m <strong><em>IF <\/em><\/strong>c\u00f3 3 tham s\u1ed1, nh\u01b0ng ch\u1ec9 c\u00f3 tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, c\u00f2n 2 tham s\u1ed1 c\u00f2n l\u1ea1i l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c<\/p>\n<ul>\n<li><strong>logical_test<\/strong>: L\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb hay bi\u1ec3u th\u1ee9c logic c\u00f3 gi\u00e1 tr\u1ecb <strong><em>TRUE<\/em><\/strong> (\u0111\u00fang) ho\u1eb7c <strong><em>FALSE<\/em><\/strong> (sai). B\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3. \u0110\u1ed1i v\u1edbi tham s\u1ed1 n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 r\u00f5 \u0111\u00f3 l\u00e0 k\u00fd t\u1ef1, ng\u00e0y th\u00e1ng, con s\u1ed1 hay b\u1ea5t c\u1ee9 bi\u1ec3u th\u1ee9c so s\u00e1nh n\u00e0o.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: Bi\u1ec3u th\u1ee9c logic c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 l\u00e0 ho\u1eb7c B1=\u201dsold\u201d, B1&lt;12\/1\/2014, B1=10 ho\u1eb7c B1&gt;10.<\/p>\n<ul>\n<li><strong>Value_if_true<\/strong>: L\u00e0 gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu bi\u1ec3u th\u1ee9c logic cho gi\u00e1 tr\u1ecb <strong><em>TRUE<\/em><\/strong> hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 \u0111i\u1ec1u ki\u1ec7n th\u1ecfa m\u00e3n. Kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: C\u00f4ng th\u1ee9c sau s\u1ebd tr\u1ea3 v\u1ec1 t\u1eeb \u201cGood\u201d n\u1ebfu gi\u00e1 tr\u1ecb \u1edf \u00f4 B1 l\u1edbn h\u01a1n 10: <strong>=IF(B1&gt;10, \u201cGood\u201d)<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-89.gif\" title=\"vba101_92019-nho-89\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-213.gif\" title=\"ex101_92019-nho-213\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><strong>Value_if_false<\/strong>: l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu bi\u1ec3u th\u1ee9c logic cho gi\u00e1 tr\u1ecb <strong><em>FALSE<\/em><\/strong> hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng th\u1ecfa m\u00e3n. Kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n th\u00eam bi\u1ebfn th\u1ee9 3 l\u00e0 \u201cBad\u201d v\u00e0o c\u00f4ng th\u1ee9c \u1edf v\u00ed d\u1ee5 tr\u00ean, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 t\u1eeb \u201cGood\u201d n\u1ebfu gi\u00e1 tr\u1ecb \u1edf trong \u00f4 B1 l\u1edbn h\u01a1n 10, c\u00f2n n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i th\u00ec gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 \u201cBad\u201d:<\/p>\n<pre><code class=\"language-xls\"><strong>=IF(B1&gt;10, \"Good\", \"Bad\")<\/strong><\/code><\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-function.png\" alt=\"Excel IF function - formula example\" title=\"excel-if-function\"><\/p>\n<blockquote>\n<p>\u00a0<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_dieu_can_nho_ve_ham_IF_trong_Excel\"><\/span>Nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb v\u1ec1 h\u00e0m IF trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1eb7c d\u00f9 hai bi\u1ebfn cu\u1ed1i c\u00f9ng trong h\u00e0m <strong><em>IF <\/em><\/strong>l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c nh\u01b0ng c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 nh\u1eefng gi\u00e1 tr\u1ecb kh\u00f4ng mong \u0111\u1ee3i n\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng n\u1eafm v\u1eefng nh\u1eefng quy t\u1eafc c\u01a1 b\u1ea3n nh\u1ea5t<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Neu_nhu_value_if_true_bi_bo_qua\"><\/span>1. N\u1ebfu nh\u01b0 <em>value_if_true <\/em>b\u1ecb b\u1ecf qua<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu value_if_true b\u1ecb b\u1ecf qua trong c\u00f4ng th\u1ee9c IF (v\u00ed d\u1ee5 ch\u1ec9 c\u00f3 d\u1ea5u ph\u1ea3i sau logical_test), th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 0 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n ch\u00ednh \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. \u0110\u00e2y l\u00e0 v\u00ed d\u1ee5:<\/p>\n<pre><strong><code class=\"language-xls\">=If(B1&gt;10,,\u201dBad\u201d)<\/code><\/strong><\/pre>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n h\u00e0m If c\u1ee7a m\u00ecnh kh\u00f4ng hi\u1ec3n th\u1ecb b\u1ea5t c\u1ee9 \u0111i\u1ec1u g\u00ec khi \u0111i\u1ec1u ki\u1ec7n th\u1ecfa, h\u00e3y nh\u1eadp 2 l\u1ea7n d\u1ea5u nh\u1ea5y trong tham s\u1ed1 th\u1ee9 2 nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<pre><strong><code class=\"language-xls\">=If(B1&gt;10,\u201d\u201d,\u201dBad\u201d)<\/code><\/strong><\/pre>\n<p>. V\u1ec1 c\u01a1 b\u1ea3n, tr\u01b0\u1eddng h\u1ee3p n\u00e0y h\u00e0m if s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i tr\u1ed1ng.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-formulas.png\" alt=\"IF formulas with the value_if_true argument omitted\" title=\"excel-if-formulas\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Neu_nhu_value_if_false_bi_bo_qua\"><\/span>2. N\u1ebfu nh\u01b0 <em>value_if_false <\/em>b\u1ecb b\u1ecf qua<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng quan t\u00e2m \u0111\u1ebfn \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu \u0111i\u1ec1u ki\u1ec7n quy \u0111\u1ecbnh kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua bi\u1ebfn th\u1ee9 3 trong c\u00f4ng th\u1ee9c h\u00e0m IF, \u0111i\u1ec1u n\u00e0y s\u1ebd d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 nh\u01b0 sau<\/p>\n<p>N\u1ebfu bi\u1ec3u th\u1ee9c logic \u0111\u01b0\u1ee3c cho l\u00e0 <strong><em>FALSE<\/em><\/strong> v\u00e0 th\u00f4ng s\u1ed1 <strong><em>value_if_false<\/em><\/strong> b\u1ecb b\u1ecf qua (ch\u1ec9 c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb duy nh\u1ea5t \u1ee9ng v\u1edbi tham s\u1ed1 <strong><em>value_if_false<\/em><\/strong>)\u00a0th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb <strong><em>FALSE<\/em><\/strong>. \u0110\u00e2y qu\u1ea3 l\u00e0 m\u1ed9t \u0111i\u1ec1u kh\u00f4ng mong mu\u1ed1n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 cho c\u00f4ng th\u1ee9c<\/p>\n<pre><code class=\"language-xls\">=IF(B1&gt;10, \"Good\")<\/code><\/pre>\n<p>N\u1ebfu b\u1ea1n \u0111\u1eb7t d\u1ea5u ph\u1ea9y sau tham s\u1ed1 value_if_true th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb b\u1eb1ng 0, \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a r\u1eb1ng gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00f4ng th\u1ee9c <strong>=IF(B1&gt;10, \u201cGood\u201d,).<\/strong><\/p>\n<p>L\u1ea7n n\u1eefa, l\u00fd do thuy\u1ebft ph\u1ee5c nh\u1ea5t \u0111\u1ec3 \u0111\u1eb7t \u201c\u201d trong tham s\u1ed1 th\u1ee9 ba l\u00e0 b\u1ea1n s\u1ebd nh\u1eadn gi\u00e1 tr\u1ecb r\u1ed7ng n\u1ebfu \u0111i\u1ec1u khi\u1ec7n kh\u00f4ng th\u1ecfa m\u00e3n <strong>=IF(B1&gt;10, \u201cGood\u201d, \u201c\u201d).<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-omit-argument.png\" alt=\"IF formulas with the value_if_false argument omitted\" title=\"excel-if-omit-argument\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Lam_cho_ham_IF_hien_len_gia_tri_TRUE_hoac_FALSE\"><\/span>3. L\u00e0m cho h\u00e0m<em> IF<\/em> hi\u1ec7n l\u00ean gi\u00e1 tr\u1ecb <em>TRUE<\/em> ho\u1eb7c <em>FALSE<\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n c\u00e1c c\u00f4ng th\u1ee9c Excel c\u00f3 th\u1ec3 hi\u1ec7n l\u00ean c\u00e1c gi\u00e1 tr\u1ecb logic nh\u01b0 <strong><em>TRUE<\/em><\/strong> ho\u1eb7c <strong><em>FALSE<\/em><\/strong> khi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n th\u00ec b\u1ea1n ph\u1ea3i g\u00f5 TRUE trong \u00f4 tham s\u1ed1 <strong><em>value_if_true<\/em><\/strong><strong>. <\/strong>\u00d4 <strong><em>value_if_false<\/em><\/strong>\u00a0 c\u00f3 th\u1ec3 \u0111i\u1ec1n v\u00e0o l\u00e0 <strong><em>FALSE<\/em><\/strong> ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng. \u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 cho c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(B1&gt;10, TRUE, FALSE)<\/code><\/strong><\/pre>\n<p>ho\u1eb7c<\/p>\n<pre><strong><code class=\"language-xls\">=IF(B1&gt;10, TRUE)<\/code><\/strong><\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-true-false.png\" alt=\"an example of the IF function that displays logical values TRUE or FALSE\" title=\"excel-if-true-false\"><br \/>\n<strong>L\u01b0u \u00fd.<\/strong>\u00a0N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n h\u00e0m <em>IF<\/em> tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb <em>TRUE<\/em> v\u00e0 <em>FALSE<\/em> nh\u01b0 gi\u00e1 tr\u1ecb logic (Boolean) m\u00e0 c\u00f4ng th\u1ee9c excel kh\u00e1c c\u00f3 th\u1ec3 nh\u1eadn d\u1ea1ng th\u00ec b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng kh\u00f4ng \u0111\u1eb7t ch\u00fang trong d\u1ea5u ngo\u1eb7c k\u00e9p. D\u1ea5u hi\u1ec7u c\u1ee7a m\u1ed9t Boolean trong m\u1ed9t \u00f4 nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong h\u00ecnh minh h\u1ecda tr\u00ean.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n gi\u00e1 tr\u1ecb \u201c<strong><em>TRUE<\/em><\/strong>\u201d v\u00e0 \u201c<strong><em>FALSE<\/em><\/strong>\u201d l\u00e0 k\u00fd t\u1ef1 th\u00ec h\u00e3y \u0111\u1eb7t ch\u00fang trong d\u1ea5u ngo\u1eb7c k\u00e9p. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 s\u1ebd n\u1eb1m b\u00ean tr\u00e1i v\u00e0 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 d\u1ea1ng <strong><em>General<\/em><\/strong>. Kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c Excel n\u00e0o nh\u1eadn d\u1ea1ng \u201c<strong><em>TRUE<\/em><\/strong>\u201d v\u00e0 \u201c<strong><em>FALSE<\/em><\/strong>\u201d l\u00e0 gi\u00e1 tr\u1ecb logic c\u1ea3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Lam_cho_ham_IF_hien_thi_mot_phep_toan_va_tra_ve_mot_ket_qua\"><\/span>4. L\u00e0m cho h\u00e0m <em>IF<\/em> hi\u1ec3n th\u1ecb m\u1ed9t ph\u00e9p to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thay v\u00ec tr\u1ea3 v\u1ec1 m\u1ed9t g\u00e1i tr\u1ecb nh\u1ea5t \u0111\u1ecbnh th\u00ec b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF<\/em><\/strong> ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0a ra, t\u00ednh to\u00e1n m\u1ed9t c\u00f4ng th\u1ee9c to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p to\u00e1n \u0111\u00f3. B\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch d\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c s\u00f4 h\u1ecdc ho\u1eb7c c\u00e1c h\u00e0m kh\u00e1c c\u1ee7a Excel trong \u00f4 tham s\u1ed1 <strong><em>value_if_true<\/em><\/strong>\u00a0v\u00e0 \/ho\u1eb7c\u00a0<strong><em>value_if_false<\/em><\/strong><strong>. <\/strong>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh:<\/p>\n<p><strong>V\u00ed d\u1ee5 1:<\/strong><\/p>\n<pre><strong><code class=\"language-xls\">=IF(A1&gt;B1, C3*10, C3*5)<\/code><\/strong><\/pre>\n<p>C\u00f4ng th\u1ee9c so s\u00e1nh gi\u00e1 tr\u1ecb trong c\u1ed9t A1 v\u00e0 B1, v\u00e0 n\u1ebfu gi\u00e1 tr\u1ecb trong c\u1ed9t A1 l\u1edbn h\u01a1n trong c\u1ed9t B1 th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 vi\u1ec7c nh\u00e2n gi\u00e1 tr\u1ecb trong \u00f4 C3 v\u1edbi C10, c\u00f2n ng\u01b0\u1ee3c l\u1ea1i s\u1ebd nh\u00e2n v\u1edbi 5<\/p>\n<p><strong>V\u00ed d\u1ee5 2:<\/strong><\/p>\n<pre><strong><code class=\"language-xls\">=IF(A1&lt;&gt;B1, SUM(A1:D1), \"\")<\/code><\/strong><\/pre>\n<p>C\u00f4ng th\u1ee9c s\u1ebd so s\u00e1nh gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 A1 v\u00e0 B1, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 kh\u00f4ng b\u1eb1ng B1 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A1 t\u1edbi D1, ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd l\u00e0 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IF_trong_Excel_va_cac_vi_du\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u00e0 c\u00e1c v\u00ed\u00a0 d\u1ee5:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 quen thu\u1ed9c v\u1edbi c\u00fa ph\u00e1p c\u1ee7a h\u00e0m <em>IF<\/em>, h\u00e3y xem x\u00e9t m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c v\u00e0 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <em>IF<\/em> nh\u01b0 l\u00e0 m\u1ed9t h\u00e0m t\u00ednh to\u00e1n trong Excel<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_vi_du_ve_ham_IF_cho_phep_so_sanh_so_hoc_nhu_lon_hon_nho_hon_bang\"><\/span>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m <em>IF<\/em> cho ph\u00e9p so s\u00e1nh s\u1ed1 h\u1ecdc nh\u01b0: l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, b\u1eb1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m <strong><em>IF<\/em><\/strong> v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 d\u1ef1a tr\u00ean vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh kh\u00e1c nhau \u0111\u1ec3 di\u1ec5n t\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n. B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 c\u00e1c to\u00e1n t\u1eed logic \u0111\u01b0\u1ee3c minh h\u1ecda b\u1eb1ng c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td><strong>To\u00e1n t\u1eed<\/strong><\/td>\n<td><strong>V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td>L\u1edbn h\u01a1n<\/td>\n<td>&gt;<\/td>\n<td><strong>=IF(A2&gt;5, \u201cOK\u201d,)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 l\u1edbn h\u01a1n 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cOK\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec tr\u1ea3 v\u1ec1 0<\/td>\n<\/tr>\n<tr>\n<td>Nh\u1ecf h\u01a1n<\/td>\n<td>&lt;<\/td>\n<td><strong>=IF(A2&lt;5, \u201cOK\u201d, \u201c\u201d)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 nh\u1ecf h\u01a1n 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cOK\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng<\/td>\n<\/tr>\n<tr>\n<td>B\u1eb1ng<\/td>\n<td>=<\/td>\n<td><strong>=IF(A2=5, \u201cOK\u201d, \u201cWrong number\u201d)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 b\u1eb1ng 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cOK\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd hi\u1ec3n th\u1ecb \u201cWrong Number\u201d<\/td>\n<\/tr>\n<tr>\n<td>Kh\u00e1c<\/td>\n<td>&lt;&gt;<\/td>\n<td><strong>=IF(A2&lt;&gt;5, \u201cWrong number\u201d, \u201cOK\u201d)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 kh\u00e1c 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cWrong Number\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd hi\u1ec3n th\u1ecb \u201cOK\u201d<\/td>\n<\/tr>\n<tr>\n<td>L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td>&gt;=<\/td>\n<td><strong>=IF(A2&gt;=5, \u201cOK\u201d, \u201cPoor\u201d)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cOK\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd hi\u1ec3n th\u1ecb \u201cPoor\u201d<\/td>\n<\/tr>\n<tr>\n<td>Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td>&lt;=<\/td>\n<td><strong>=IF(A2&lt;=5, \u201cOK\u201d, \u201c\u201d)<\/strong><\/td>\n<td>N\u1ebfu s\u1ed1 trong \u00f4 A2 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 5 th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 \u201cOK\u201d, ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 r\u1ed7ng<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>H\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c so s\u00e1nh \u201cl\u1edbn ho\u0103n ho\u1eb7c b\u1eb1ng\u201d<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-function-greater-than.png\" alt=\"the IF formula with the\" title=\"if-function-greater-than\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IF_trong_van_ban\"><\/span>H\u00e0m IF trong v\u0103n b\u1ea3n:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u00ecn chung, khi b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF<\/em><\/strong> cho c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n thay v\u00ec c\u00e1c to\u00e1n t\u1eed \u201cb\u1eb1ng\u201d ho\u1eb7c \u201ckh\u00f4ng b\u1eb1ng\u201d th\u00ec h\u00e3y theo d\u00f5i m\u1ed9t v\u00e0i v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_thuc_ham_IF_khong_phan_biet_chu_hoa_hay_chu_thuong_cho_cac_ky_tu\"><\/span>V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m <em>IF<\/em> kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Gi\u1ed1ng nh\u01b0 ph\u1ea7n l\u1edbn c\u00e1c ch\u1ee9c n\u0103ng c\u1ee7a Excel, h\u00e0m <strong><em>IF<\/em><\/strong> \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a r\u1eb1ng c\u00e1c bi\u1ec3u th\u1ee9c logic c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng th\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ki\u1ec3u ch\u1eef hoa hay th\u01b0\u1eddng trong c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF <\/em><\/strong><\/p>\n<p>V\u00ed d\u1ee5, C\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF<\/em><\/strong> d\u01b0\u1edbi \u0111\u00e2y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cYes\u201d ho\u1eb7c \u201cNo\u201d d\u1ef1a tr\u00ean tr\u1ea1ng th\u00e1i giao h\u00e0ng (c\u1ed9t C)<\/p>\n<pre><strong><code class=\"language-xls\">=IF(C2=\"delivered\", \"No\", \"Yes\")<\/code><\/strong><\/pre>\n<p>C\u00f4ng th\u1ee9c n\u00e0y n\u00f3i l\u00ean r\u1eb1ng Excel\u00a0 s\u1ebd tr\u1ea3 v\u1ec1 \u201cNo\u201d n\u1ebfu m\u1ed9t \u00f4 trong c\u1ed9t C bao g\u1ed3m t\u1eeb \u201cDelivered\u201d, c\u00f2n ng\u01b0\u1ee3c l\u1ea1i th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 \u201cYes\u201d. Kh\u00f4ng quan tr\u1ecdng l\u00e0 b\u1ea1n g\u00f5 t\u1eeb \u201cDelivered\u201d nh\u01b0 th\u1ebf n\u00e0o trong tham s\u1ed1 bi\u1ec3u th\u1ee9c logic \u2013 \u201cdelivered\u201d, \u201cDelivered\u201d, hay \u201cDELIVERED\u201d. C\u0169ng kh\u00f4ng quan tr\u1ecdng li\u1ec7u t\u1eeb \u201cDelivered\u201d \u0111\u01b0\u1ee3c vi\u1ebft hoa hay th\u01b0\u1eddng \u1edf trong b\u1ea3ng, nh\u01b0 minh h\u1ecda trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6367 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-169.png\" width=\"600\" height=\"242\" title=\"excel-dialog-box-launcher-1-169\"><\/p>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c h\u01a1n \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng ph\u00e9p so s\u00e1nh \u201ckh\u00f4ng b\u1eb1ng\u201d v\u00e0 tr\u00e1o \u0111\u1ed5i hai tham s\u1ed1 <strong><em>value_if_true<\/em><\/strong> v\u00e0 <strong><em>value_if_false<\/em><\/strong><\/p>\n<pre><strong><code class=\"language-xls\">=IF(C2&lt;&gt;\"delivered\", \"Yes\", \"No\")<\/code><\/strong><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_2_Cong_thuc_ham_IF_phan_biet_chu_hoa_hay_chu_thuong_cho_cac_ky_tu\"><\/span>V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m <em>IF<\/em> ph\u00e2n bi\u1ec7t ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng cho c\u00e1c k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t bi\u1ec3u th\u1ee9c logic c\u00f3 ph\u00e2n bi\u1ec7t ki\u1ec3u ch\u1eef hoa hay th\u01b0\u1eddng th\u00ec d\u00f9ng k\u1ebft h\u1ee3p h\u00e0m <strong><em>IF<\/em><\/strong> v\u1edbi h\u00e0m <strong><em>EXACT<\/em><\/strong> b\u1eb1ng c\u00e1ch so s\u00e1nh hai chu\u1ed7i gi\u00e1 tr\u1ecb v\u00e0 tr\u1ea3 v\u1ec1 <strong><em>TRUE <\/em><\/strong>n\u1ebfu x\u00e2u \u0111\u00fang, ng\u01b0\u1ee3c l\u1ea1i th\u00ec tr\u1ea3 v\u1ec1 <strong><em>FALSE<\/em><\/strong>. M\u1eb7c d\u00f9 h\u00e0m <strong><em>EXACT<\/em><\/strong> c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t hoa hay th\u01b0\u1eddng nh\u01b0ng v\u1eabn b\u1ecf qua s\u1ef1 kh\u00e1c bi\u1ec7t v\u1ec1 \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p>B\u1ea1n s\u1eed d\u1ee5ng h\u00e0m <strong><em>EXACT<\/em><\/strong> b\u1eb1ng c\u00e1ch nh\u01b0 sau:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(EXACT(C2,\"DELIVERED\"), \"No\", \"Yes\")<\/code><\/strong><\/pre>\n<p>Bi\u1ec3u th\u1ee9c logic b\u1ea1n \u00e1p d\u1ee5ng v\u00e0 \u201cDELIVERED\u201d l\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n in hoa m\u00e0 b\u1ea1n ph\u1ea3i hi\u1ec7n th\u1ecb m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t C.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-case-sensitive.png\" alt=\"Case-sensitive IF formula for text values\" title=\"excel-if-case-sensitive\"><\/p>\n<p>M\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng h\u01a1n, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch tham chi\u1ebfu \u00f4 thay v\u00ec tham s\u1ed1 ch\u1ee9a k\u00fd t\u1ef1 th\u1ee9 hai trong h\u00e0m <strong>EXACT<\/strong> n\u1ebfu b\u1ea1n mu\u1ed1n.<\/p>\n<p><strong>L\u01b0u \u00fd.<\/strong>\u00a0Khi s\u1eed d\u1ee5ng v\u0103n b\u1ea3n nh\u01b0 m\u1ed9t bi\u1ebfn trong h\u00e0m <em>IF<\/em> th\u00ec h\u00e3y nh\u1edb lu\u00f4n ph\u1ea3i \u0111i k\u00e8m v\u1edbi d\u1ea5u ngo\u1eb7c k\u00e9p.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_3_Cong_thuc_IF_cho_gia_tri_van_ban_voi_viec_tham_chieu_tung_phan\"><\/span>V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c <em>IF<\/em> cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u1edbi vi\u1ec7c tham chi\u1ebfu t\u1eebng ph\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u01b0a ra d\u1ef1a tr\u00ean vi\u1ec7c tham chi\u1ebfu t\u1eebng ph\u1ea7n h\u01a1n m\u00e0 tham chi\u1ebfu ch\u00ednh x\u00e1c, m\u1ed9t gi\u1ea3i ph\u00e1p t\u1ee9c th\u00ec cho \u0111i\u1ec1u n\u00e0y \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (ho\u1eb7c) trong bi\u1ec3u th\u1ee9c logic. Tuy nhi\u00ean c\u00e1ch ti\u1ebfp c\u1eadn \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng n\u00e0y s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. R\u1ea5t nhi\u1ec1u h\u00e0m trong Excel ch\u1ea5p nh\u1eadn k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n nh\u01b0ng h\u00e0m <strong><em>IF<\/em><\/strong> l\u00e0 ngo\u1ea1i l\u1ec7.<\/p>\n<p>M\u1ed9t gi\u1ea3i ph\u00e1p kh\u00e1c \u0111\u00f3 l\u00e0 d\u00f9ng h\u00e0m <strong><em>IF<\/em><\/strong> k\u1ebft h\u1ee3p v\u1edbi h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong><em>ISNUMBER<\/em><\/strong><\/a><strong><em>\u00a0<\/em><\/strong>v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ung-dung-ham-search-va-countifs-de-thong-ke-tinh-trang-lam-viec.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong><em>SEARCH<\/em><\/strong><\/a> (kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng) ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/ham-find-va-search-voi-cac-cong-thuc-vi-du.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong><em>FIND<\/em><\/strong><\/a> (ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng).<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu vi\u1ec7c th\u1ef1c hi\u1ec7n \u0111i\u1ec1u ki\u1ec7n No l\u00e0 b\u1eaft bu\u1ed9c cho c\u1ea3 hai m\u1ee5c \u201cDelivered\u201d v\u00e0 \u201cOut for delivery\u201d th\u00ec c\u00f4ng th\u1ee9c sau s\u1ebd hi\u1ec7u qu\u1ea3:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(ISNUMBER(SEARCH(\"deliv\",C2)), \"No\", \"Yes\")<\/code><\/strong><\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-partial-match.png\" alt=\"IF formula for text values with partial match\" title=\"excel-if-partial-match\"><br \/>\nCh\u00fang t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m <strong><em>SEARCH<\/em><\/strong> cho c\u00f4ng th\u1ee9c tr\u00ean v\u00ec vi\u1ec7c \u0111\u1ed1i chi\u1ebfu c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa hay th\u01b0\u1eddng c\u00f3 v\u1ebb h\u1ee3p l\u00fd h\u01a1n v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0a ra. N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed1i chi\u1ebfu c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa hay th\u01b0\u1eddng th\u00ec \u0111\u01a1n gi\u1ea3n ch\u1ec9 c\u1ea7n thay th\u1ebf h\u00e0m <strong><em>SEARCH<\/em><\/strong> b\u1eb1ng h\u00e0m <strong><em>FIND<\/em><\/strong> theo c\u00e1ch n\u00e0y:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(ISNUMBER(FIND(\"<em>k\u00fd t\u1ef1<\/em>\",\u00a0<em>n\u01a1i \u0111\u1ec3 t\u00ecm ki\u1ebfm<\/em>)), value_if_true, value_if_false)<\/code><\/strong><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_cong_thuc_ham_IF_cho_ngay_thang\"><\/span>V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho ng\u00e0y, th\u00e1ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tho\u1ea1t nh\u00ecn th\u00ec c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF <\/em><\/strong>\u0111\u1ed1i v\u1edbi ng\u00e0y th\u00e1ng gi\u1ed1ng nh\u01b0 \u0111\u1ed1i v\u1edbi s\u1ed1 v\u00e0 k\u00fd t\u1ef1 ch\u00fang ta v\u1eeba \u0111\u1ec1 c\u1eadp. Nh\u01b0ng \u0111\u00e1ng ti\u1ebfc l\u00e0 kh\u00f4ng ph\u1ea3i nh\u01b0 v\u1eady.<\/p>\n<p>Kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m kh\u00e1c trong Excel, h\u00e0m <strong><em>IF<\/em><\/strong> kh\u00f4ng th\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng v\u00e0 di\u1ec5n gi\u1ea3i n\u00f3 ra nh\u01b0 m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c, \u0111i\u1ec1u n\u00e0y gi\u1ea3i th\u00edch t\u1ea1i sao b\u1ea1n kh\u00f4ng th\u1ec3 di\u1ec5n t\u1ea3 m\u1ed9t bi\u1ec3u th\u1ee9c logic \u0111\u01a1n gi\u1ea3n nh\u01b0 &gt;\u201d11\/19\/2014\u2033 hay &gt;11\/19\/2014.\u00a0 Kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c n\u00e0o l\u00e0 \u0111\u00fang c\u1ea3!<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_thuc_ham_IF_cho_ngay_thang_voi_ham_DATEVALUE\"><\/span>V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c h\u00e0m <em>IF<\/em> cho ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m <em>DATEVALUE <\/em><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 h\u00e0m IF c\u00f3 th\u1ec3 nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng trong m\u1ed9t bi\u1ec3u th\u1ee9c logic, b\u1ea1n ph\u1ea3i \u0111\u1eb7t n\u00f3 trong h\u00e0m <strong><em>DATEVALUE<\/em> nh\u01b0 th\u1ebf n\u00e0y: <\/strong>DATEVALUE(\u201c11\/19\/2014\u201d). C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(C2&lt;DATEVALUE(\"11\/19\/2014\"), \"Completed\", \"Coming soon\")<\/code><\/strong><\/pre>\n<p>Nh\u01b0 minh h\u1ecda c\u1ee7a h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF<\/em><\/strong> n\u00e0y \u0111\u00e1ng gi\u00e1 ng\u00e0y th\u00e1ng trong c\u1ed9t C v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cCompleted\u201d n\u1ebfu nh\u01b0 tr\u00f2 ch\u01a1i n\u00e0y di\u1ec5n tra tr\u01b0\u1edbc ng\u00e0y 11 th\u00e1ng 11, c\u00f2n ng\u01b0\u1ee3c l\u1ea1i th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201cComing soon\u201d.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-function-dates.png\" alt=\"An example of the IF formula with the DATEVALUE function\" title=\"if-function-dates\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_2_Cong_thuc_ham_IF_voi_ham_TODAY\"><\/span>V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c h\u00e0m <em>IF<\/em> v\u1edbi h\u00e0m <em>TODAY() <\/em><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111\u01b0a ra ph\u1ee5 thu\u1ed9c v\u00e0o ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m <strong><em>TODAY()<\/em><\/strong> trong bi\u1ec3u th\u1ee9c logic. V\u00ed d\u1ee5 nh\u01b0:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(C2&lt;DATEVALUE(\"11\/19\/2014\"), \"Completed\", \"Coming soon\")<\/code><\/strong><\/pre>\n<p>H\u00e0m <strong><em>IF<\/em><\/strong> c\u00f2n c\u00f3 th\u1ec3 hi\u1ec3u nh\u1eefng bi\u1ec3u th\u1ee9c logic ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 v\u00ed d\u1ee5 ti\u1ebfp theo:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_3_Cong_thuc_ham_IF_mo_rong_cho_ngay_thang_trong_qua_khu_va_tuong_lai\"><\/span>V\u00ed d\u1ee5 3. C\u00f4ng th\u1ee9c h\u00e0m <em>IF<\/em> m\u1edf r\u1ed9ng cho ng\u00e0y th\u00e1ng trong qu\u00e1 kh\u1ee9 v\u00e0 t\u01b0\u01a1ng lai<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Gi\u1ea3 s\u1eed nh\u01b0 b\u1ea1n ch\u1ec9 mu\u1ed1n \u0111\u00e1nh d\u1ea5u trong kho\u1ea3ng h\u01a1n 30 ng\u00e0y t\u00ednh t\u1eeb th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i th\u00ec b\u1ea1n c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n bi\u1ec3u th\u1ee9c logic nh\u01b0 sau A2-TODAY()&gt;30. C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh c\u00f3 d\u1ea1ng:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(A2-TODAY()&gt;30, \"Future date\", \"\")<\/code><\/strong><\/pre>\n<p>\u0110\u1ec3 ch\u1ec9 ra nh\u1eefng ng\u00e0y \u0111\u00e3 di\u1ec5n ra c\u00e1ch \u0111\u00e2y h\u01a1n 30 ng\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c sau:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(TODAY()-A2&gt;30, \"Past date\", \"\")<\/code><\/strong><\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/if-function-dates-advanced.png\" alt=\"Advanced IF formulas for future and past dates\" title=\"if-function-dates-advanced\"><br \/>\nN\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 c\u1ea3 hai d\u1ea5u hi\u1ec7u trong c\u00f9ng m\u1ed9t c\u1ed9t b\u1ea1n s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ebfn h\u00e0m <strong><em>IF<\/em><\/strong> \u0111\u01b0\u1ee3c l\u1ed3ng gh\u00e9p nh\u01b0 sau:<\/p>\n<pre><strong><code class=\"language-xls\">=IF(A2-TODAY()&gt;30, \"Future date\", IF(TODAY()-A2&gt;30, \"Past date\", \"\"))<\/code><\/strong><\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nested-if-dates.png\" alt=\"A nested IF formula for dates\" title=\"nested-if-dates\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_ve_cong_thuc_ham_IF_cho_du_lieu_va_o_trong\"><\/span>V\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c h\u00e0m IF cho d\u1eef li\u1ec7u v\u00e0 \u00f4 tr\u1ed1ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00f4i khi b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u \u00f4 d\u1eef li\u1ec7u hay \u00f4 tr\u1ed1ng nh\u1ea5t \u0111\u1ecbnh th\u00ec b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c c\u00e1ch sau:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi ISBLANK<\/li>\n<li>S\u1eed d\u1ee5ng c\u00e1c bi\u1ec3u th\u1ee9c logic =\u201d\u201d (b\u1eb1ng \u00f4 tr\u1ed1ng) ho\u1eb7c &lt;&gt;\u201d\u201d (kh\u00e1c \u00f4 tr\u1ed1ng).<\/li>\n<\/ul>\n<p>B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u1ea3i th\u00edch r\u00f5 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa hai c\u00e1ch tr\u00ean v\u00e0 \u0111\u01b0a ra v\u00ed d\u1ee5<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><strong>Bi\u1ec3u th\u1ee9c logic<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>V\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00d4 tr\u1ed1ng<\/td>\n<td>=\u201d\u201d<\/td>\n<td>\u0110\u01b0\u1ee3c cho l\u00e0 <strong><em>TRUE<\/em><\/strong> n\u1ebfu \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 \u00f4 tr\u1ed1ng, bao g\u1ed3m c\u1ea3 c\u00e1c \u00f4 v\u1edbi \u0111\u1ed9 d\u00e0i x\u00e2u b\u1eb1ng 0.<\/p>\n<p>Ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0 <strong><em>FALSE<\/em><\/strong><\/p>\n<\/td>\n<td><strong>=IF(A1=\u201d\u201d, 0, 1)<\/strong><\/p>\n<p>Tr\u1ea3 v\u1ec1 0 n\u1ebfu A1 l\u00e0 \u00f4 tr\u1ed1ng. Ng\u01b0\u1ee3c l\u1ea1i th\u00ec tr\u1ea3 v\u1ec1 1<\/p>\n<p>N\u1ebfu A1 l\u00e0 m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb r\u1ed7ng th\u00ec tr\u1ea3 v\u1ec1 0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td><strong><em>ISBLANK()<\/em><\/strong><\/td>\n<td>\u0110\u01b0\u1ee3c cho l\u00e0 <strong><em>TRUE<\/em><\/strong> n\u1ebfu \u00f4 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh l\u00e0 \u00f4 r\u00f4ng ho\u00e0n to\u00e0n \u2013 kh\u00f4ng c\u00f3 c\u00f4ng th\u1ee9c, kh\u00f4ng c\u00f3 c\u1ea3 chu\u1ed7i gi\u00e1 tr\u1ecb r\u1ed7ng \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 t\u1eeb c\u00f4ng th\u1ee9c kh\u00e1c.<\/p>\n<p>Ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0 <strong><em>FALSE<\/em><\/strong><\/p>\n<\/td>\n<td><strong>=IF(ISBLANK(A1), 0, 1)<\/strong><\/p>\n<p>Tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0ng x\u1eed l\u00fd c\u00e1c \u00f4 c\u00f3 \u0111\u1ed9 d\u00e0i chu\u1ed7i b\u1eb1ng 0 nh\u01b0 c\u00e1c \u00f4 r\u1ed7ng.<\/p>\n<p>T\u1ee9c l\u00e0, n\u1ebfu A1 ch\u1ee9a m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb r\u1ed7ng, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 1.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00d4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u<\/td>\n<td>&lt;&gt;\u201d\u201d<\/td>\n<td>\u0110\u01b0\u1ee3c cho l\u00e0 <strong><em>TRUE<\/em><\/strong> n\u1ebfu \u00f4 ch\u1ec9 \u0111\u1ecbnh c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u. Ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0 <strong><em>FALSE<\/em><\/strong><\/p>\n<p>Nh\u1eefng \u00f4 v\u1edbi \u0111\u1ed9 d\u00e0i chu\u1ed7i b\u1eb1ng 0 th\u00ec l\u00e0 \u00f4 tr\u1ed1ng<\/p>\n<\/td>\n<td><strong>=IF(A1&lt;&gt;\u201d\u201d, 1, 0)<\/strong><\/p>\n<p>Tr\u1ea3 v\u1ec1 1 n\u1ebfu A1 \u00f4 c\u00f3 d\u1eef li\u1ec7u, ng\u01b0\u1ee3c l\u1ea1i th\u00ec tr\u1ea3 v\u1ec1 0<\/p>\n<p>N\u1ebfu A1 c\u00f3 chu\u1ed7i gi\u00e1 tr\u1ecb r\u1ed7ng th\u00ec c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td><strong><em>ISBLANK()=FALSE<\/em><\/strong><\/td>\n<td>\u0110\u01b0\u1ee3c cho l\u00e0 <strong><em>TRUE<\/em><\/strong> n\u1ebfu \u00f4 \u1ea5n \u0111\u1ecbnh kh\u00f4ng ph\u1ea3i \u00f4 r\u1ed7ng. Ng\u01b0\u1ee3c l\u1ea1i th\u00ec l\u00e0 <strong><em>FALSE<\/em><\/strong><\/p>\n<p>\u00d4 v\u1edbi \u0111\u1ed9 d\u00e0i chu\u1ed7i b\u1eb1ng o th\u00ec l\u00e0 \u00f4 kh\u00f4ng r\u1ed7ng<\/p>\n<\/td>\n<td><strong>=IF(ISBLANK(A1)=FALSE, 0, 1)<\/strong><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, nh\u01b0ng tr\u1ea3 v\u1ec1 1 n\u1ebfu A1 c\u00f3 bao g\u1ed3m m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb r\u1ed7ng<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd bi\u1ec3u di\u1ec5n bi\u1ec3u th\u1ee9c logic c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u\/ r\u1ed7ng s\u1ebd nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<p>Gi\u1ea3 s\u1eed nh\u01b0 d\u1eef li\u1ec7u trong c\u1ed9t C ch\u1ec9 c\u00f3 \u0111\u01b0\u1ee3c sau khi \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u trong c\u1ed9t B t\u01b0\u01a1ng \u1ee9ng v\u1edbi game \u0111\u00e3 di\u1ec5n ra th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c h\u00e0m <strong><em>IF<\/em><\/strong> sau \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u nh\u1eefng game \u0111\u00e3 ho\u00e0n th\u00e0nh<\/p>\n<pre><strong><code class=\"language-xls\">=IF($C2&lt;&gt;\"\", \"Completed\", \"\")<\/code><\/strong><\/pre>\n<p><strong>=IF(ISBLANK($C2)=FALSE, \u201cCompleted\u201d, \u201c\u201d)<\/strong><\/p>\n<p>V\u00ec kh\u00f4ng c\u00f3 \u0111\u1ed9 d\u00e0i chu\u1ed7i b\u1eb1ng 0 trong b\u1ea3ng n\u00ean c\u1ea3 hai c\u00f4ng th\u1ee9c \u0111\u1ec1u tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 nhau:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-if-function-blanks.png\" alt=\"The IF formula for blank \/ non-blank cells\" title=\"excel-if-function-blanks\"><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n xem h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel n\u00e0y d\u01b0\u1edbi d\u1ea1ng video, th\u00ec m\u1eddi b\u1ea1n theo d\u00f5i video sau \u0111\u00e2y:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/n08r5_tkuGs\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_su_dung_ham_IF_trong_viec_xep_loai_theo_diem_so\"><\/span>V\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m IF trong vi\u1ec7c x\u1ebfp lo\u1ea1i theo \u0111i\u1ec3m s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u00f3 m\u1ed9t y\u00eau c\u1ea7u s\u1eafp x\u1ebfp \u0111i\u1ec3m s\u1ed1 nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1eeb 5 \u0111\u1ebfn 6.5: x\u1ebfp lo\u1ea1i trung b\u00ecnh<\/li>\n<li>T\u1eeb 6.5 \u0111\u1ebfn 8: x\u1ebfp lo\u1ea1i kh\u00e1<\/li>\n<li>T\u1eeb 8 tr\u1edf l\u00ean: x\u1ebfp lo\u1ea1i gi\u1ecfi<\/li>\n<\/ul>\n<p>gi\u1ea3 s\u1eed \u0111i\u1ec3m s\u1ed1 n\u1eb1m trong \u00f4 A1, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft <strong>h\u00e0m IF l\u1ed3ng nhau\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<p><strong><code>=IF(<\/code><code>AND(A1&gt;=5,A1&lt;6.5),\"Trung b\u00ecnh\",<\/code><\/strong><br \/>\n<strong><code>\u00a0 \u00a0 IF(AND(A1&gt;=6.5, A1&lt;8), \"Kh\u00e1\",<\/code><\/strong><br \/>\n<strong><code>\u00a0 \u00a0 \u00a0 \u00a0IF(A1&gt;=8,\"Gi\u1ecfi\",\"Kh\u00f4ng x\u1ebfp lo\u1ea1i\")))<\/code><\/strong><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u1ebfu b\u1ea1n th\u1ea5y vi\u1ec7c vi\u1ebft h\u00e0m IF l\u1ed3ng nhau qu\u00e1 ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f3 hi\u1ec3u, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1ch l\u00e0m kh\u00e1c ng\u1eafn g\u1ecdn v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n b\u1eb1ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a><\/strong><\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi b\u00e0i vi\u1ebft n\u00e0y, blog.hocexcel.online \u0111\u00e3 chia s\u1ebb cho c\u00e1c b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c cho s\u1ed1, k\u00fd t\u1ef1, d\u1eef li\u1ec7u v\u00e0 \u00f4 tr\u1ed1ng v\u00e0 m\u1ed9t s\u1ed1 c\u00e1c v\u00ed d\u1ee5. N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc g\u00ec c\u00f3 th\u1ec3 comment ngay d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 ch\u00fang t\u00f4i c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft m\u1ecdi th\u1eafc m\u1eafc c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch s\u1edbm nh\u1ea5t.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><strong><em>Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/em><\/strong><\/a> c\u1ee7a H\u1ecdc Excel Online. 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<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-89.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2761","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=2761"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2761\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2762"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}