{"id":115433,"date":"2025-02-02T18:55:23","date_gmt":"2025-02-02T11:55:23","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=115433"},"modified":"2025-02-02T18:55:26","modified_gmt":"2025-02-02T11:55:26","slug":"ham-if","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/","title":{"rendered":"H\u00e0m IF l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"\n<p>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic quan tr\u1ecdng trong Excel, gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, gi\u00fap t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. H\u00e3y c\u00f9ng xem qua nh\u00e9!<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-round-cach-su-dung-ham-round-trong-excel\/\">H\u00e0m ROUND l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/3-cach-tao-bang-trong-excel-don-gian\/\">3 C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel \u0111\u01a1n gi\u1ea3n cho m\u1ecdi phi\u00ean b\u1ea3n<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/\">10 c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel, Google Sheet \u0111\u01a1n gi\u1ea3n nh\u1ea5t 2024<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a1b14050d846\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a1b14050d846\"  type=\"checkbox\" id=\"item-6a1b14050d846\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Ham_IF_trong_Excel_va_cach_su_dung\" title=\"H\u00e0m IF trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng\">H\u00e0m IF trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Cong_thuc_co_ban_cua_ham_IF_trong_Excel\" title=\"C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m IF trong Excel\">C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m IF trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Vi_du_minh_hoa_ham_IF\" title=\"V\u00ed d\u1ee5 minh h\u1ecda h\u00e0m IF\">V\u00ed d\u1ee5 minh h\u1ecda h\u00e0m IF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Cac_cach_ap_dung_ham_IF_pho_bien\" title=\"C\u00e1c c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m IF ph\u1ed5 bi\u1ebfn\">C\u00e1c c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m IF ph\u1ed5 bi\u1ebfn<\/a><ul class='ez-toc-list-level-4'><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Ket_hop_nhieu_ham_IF_trong_mot_cong_thuc\" title=\"K\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c\">K\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Long_ham_IF_voi_cac_ham_khac\" title=\"L\u1ed3ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c\">L\u1ed3ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Ham_IF_voi_nhieu_dieu_kien\" title=\"H\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">H\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Ham_IF_ket_hop_voi_AND\" title=\"H\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi AND\">H\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi AND<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Loi_thuong_gap_khi_su_dung_ham_IF_va_cach_khac_phuc\" title=\"L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\">L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#O_hien_thi_gia_tri_0_khong\" title=\"\u00d4 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 0 (kh\u00f4ng)\">\u00d4 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 0 (kh\u00f4ng)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#O_hien_thi_loi_NAME\" title=\"\u00d4 hi\u1ec3n th\u1ecb l\u1ed7i #NAME?\">\u00d4 hi\u1ec3n th\u1ecb l\u1ed7i #NAME?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Cac_ham_dieu_kien_trong_Excel_khac\" title=\"C\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n trong Excel kh\u00e1c\">C\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n trong Excel kh\u00e1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-if\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_IF_trong_Excel_va_cach_su_dung\"><\/span><strong>H\u00e0m IF trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m IF trong Excel l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng. V\u1edbi kh\u1ea3 n\u0103ng x\u1eed l\u00fd linh ho\u1ea1t, IF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng, t\u1eeb c\u00e1c ph\u00e9p to\u00e1n \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00f4ng th\u1ee9c, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 c\u00e1c c\u00e1ch \u00e1p d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a h\u00e0m IF trong Excel:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_co_ban_cua_ham_IF_trong_Excel\"><\/span><strong>C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m IF trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m IF c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n\n\n\n<p><strong>=IF(logical_test,[value_if_true],[value_if_false])<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li><strong>logical_test: <\/strong>Bi\u1ec3u th\u1ee9c logic c\u1ea7n ki\u1ec3m tra.<\/li>\n\n\n\n<li><strong>value_if_true:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n\n\n\n<li><strong>value_if_false:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_minh_hoa_ham_IF\"><\/span><strong>V\u00ed d\u1ee5 minh h\u1ecda h\u00e0m IF<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n ki\u1ec3m tra h\u1ecdc sinh c\u00f3 \u0111\u1ea1t hay kh\u00f4ng d\u1ef1a tr\u00ean \u0111i\u1ec3m s\u1ed1:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 minh h\u1ecda h\u00e0m IF\" class=\"wp-image-115435\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 minh h\u1ecda h\u00e0m IF<\/figcaption><\/figure>\n\n\n\n<p><strong>=IF(B2&gt;=5, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/p>\n\n\n\n<p>N\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 B2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 &#8220;\u0110\u1ea1t&#8221;, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cac_cach_ap_dung_ham_IF_pho_bien\"><\/span><strong>C\u00e1c c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m IF ph\u1ed5 bi\u1ebfn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m IF kh\u00f4ng ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u01a1n l\u1ebb m\u00e0 c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u c\u00f4ng th\u1ee9c kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch \u00e1p d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a IF trong Excel, gi\u00fap b\u1ea1n linh ho\u1ea1t h\u01a1n trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u:<\/p>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"Ket_hop_nhieu_ham_IF_trong_mot_cong_thuc\"><\/span><strong>K\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>K\u1ef9 thu\u1eadt k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c hay c\u00f2n g\u1ecdi l\u00e0 IF l\u1ed3ng nhau, l\u00e0 vi\u1ec7c \u0111\u1eb7t m\u1ed9t h\u00e0m IF b\u00ean trong m\u1ed9t h\u00e0m IF kh\u00e1c. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch li\u00ean ti\u1ebfp. M\u1ed7i h\u00e0m s\u1ebd x\u1eed l\u00fd m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ri\u00eang bi\u1ec7t. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u00fang, k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. N\u1ebfu sai, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd chuy\u1ec3n sang ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m ti\u1ebfp theo v\u00e0 c\u1ee9 th\u1ebf ti\u1ebfp di\u1ec5n.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau v\u00e0 b\u1ea1n c\u1ea7n t\u00ednh to\u00e1n c\u00e1c ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5 nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c\" class=\"wp-image-115436\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: <strong>=IF(C2=&#8221;Nh\u00e2n vi\u00ean&#8221;, 500000, IF(C2=&#8221;Chuy\u00ean vi\u00ean&#8221;, 700000, 1000000))<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li><strong>IF1<\/strong>: N\u1ebfu \u00f4 C2 c\u00f3 gi\u00e1 tr\u1ecb &#8216;Nh\u00e2n vi\u00ean&#8217;, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 500000. N\u1ebfu kh\u00f4ng, \u0111i\u1ec1u ki\u1ec7n ti\u1ebfp theo s\u1ebd \u0111\u01b0\u1ee3c ki\u1ec3m tra.<\/li>\n\n\n\n<li><strong>IF2<\/strong>: N\u1ebfu \u00f4 C2 c\u00f3 gi\u00e1 tr\u1ecb &#8216;Chuy\u00ean vi\u00ean&#8217;, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 700000. N\u1ebfu kh\u00f4ng, gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh s\u1ebd l\u00e0 1000000, v\u00ec l\u00fac n\u00e0y ch\u1ec9 c\u00f2n tr\u01b0\u1eddng h\u1ee3p &#8216;Tr\u01b0\u1edfng ph\u00f2ng&#8217;.<\/li>\n<\/ul>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"Long_ham_IF_voi_cac_ham_khac\"><\/span><strong>L\u1ed3ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Ngo\u00e0i vi\u1ec7c l\u1ed3ng c\u00e1c h\u00e0m IF v\u1edbi nhau, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p ch\u00fang v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd nh\u1eefng \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau v\u00e0 b\u1ea1n c\u1ea7n x\u00e9t x\u1ebfp lo\u1ea1i theo 2 lo\u1ea1i \u0111i\u1ec3m nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 l\u1ed3ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c\" class=\"wp-image-115437\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 l\u1ed3ng h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: <strong>=IF(AND(C2&gt;=5,D2&gt;=5),&#8221;\u0110\u1ea1t&#8221;,&#8221;Kh\u00f4ng \u0110\u1ea1t&#8221;)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li><strong>AND(C2&gt;=5, D2&gt;=5): <\/strong>Ki\u1ec3m tra xem c\u1ea3 hai \u00f4 C2 v\u00e0 D2 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5 hay kh\u00f4ng.<\/li>\n\n\n\n<li><strong>&#8220;\u0110\u1ea1t&#8221;: <\/strong>Tr\u1ea3 v\u1ec1 n\u1ebfu c\u1ea3 C2 v\u00e0 D2 \u0111\u1ec1u t\u1eeb 5 tr\u1edf l\u00ean.<\/li>\n\n\n\n<li><strong>&#8220;Kh\u00f4ng \u0110\u1ea1t&#8221;: <\/strong>Tr\u1ea3 v\u1ec1 n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong hai \u00f4 c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 5.<\/li>\n<\/ul>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"Ham_IF_voi_nhieu_dieu_kien\"><\/span><strong>H\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>S\u1eed d\u1ee5ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel l\u00e0 ph\u01b0\u01a1ng ph\u00e1p k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong c\u00f9ng m\u1ed9t h\u00e0m. C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n ki\u1ec3m tra l\u1ea7n l\u01b0\u1ee3t t\u1eebng \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p:<\/p>\n\n\n\n<p><strong>=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2]\u2026)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li><strong>logical_test1<\/strong>: \u0110i\u1ec1u ki\u1ec7n ki\u1ec3m tra th\u1ee9 nh\u1ea5t.<\/li>\n\n\n\n<li><strong>value_if_true1<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n th\u1ee9 nh\u1ea5t \u0111\u00fang.<\/li>\n\n\n\n<li><strong>logical_test2:<\/strong> \u0110i\u1ec1u ki\u1ec7n ki\u1ec3m tra th\u1ee9 hai.<\/li>\n\n\n\n<li><strong>value_if_true2<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai \u0111\u00fang.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau v\u00e0 b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u01a1n h\u00e0ng \u0111\u00f3 l\u00e0 bao nhi\u00eau.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\" class=\"wp-image-115438\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 h\u00e0m IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n\n\n\n<p>B\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c: <strong>=B8*IF(B8=1000,12,IF(B8=500,14,IF(B8=200,16,IF(B8=110,18,20))))<\/strong><\/p>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"Ham_IF_ket_hop_voi_AND\"><\/span><strong>H\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi AND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi AND l\u00e0 m\u1ed9t k\u1ef9 thu\u1eadt quan tr\u1ecdng \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p. H\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 FALSE.<\/p>\n\n\n\n<p>C\u00fa ph\u00e1p:<\/p>\n\n\n\n<p><strong>=AND(logical1, [logical2], &#8230;)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul>\n<li><strong>logical1<\/strong> l\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1eaft bu\u1ed9c.<\/li>\n\n\n\n<li><strong>logical2 <\/strong>l\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau v\u00e0 b\u1ea1n x\u00e9t x\u1ebfp lo\u1ea1i \u0110\u1ea1t v\u00e0 Kh\u00f4ng \u0111\u1ea1t. \u0110i\u1ec1u ki\u1ec7n l\u00e0 \u1ed5ng \u0111i\u1ec3m c\u1ee7a c\u1ea3 3 m\u00f4n ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 18 v\u00e0 kh\u00f4ng c\u00f3 m\u00f4n n\u00e0o d\u01b0\u1edbi 2 \u0111i\u1ec3m.<\/p>\n\n\n\n<p><strong>=IF(AND(F2&gt;18,C2&gt;=2,D2&gt;=2,E2&gt;=2),&#8221;\u0110\u1ea1t&#8221;,&#8221;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi AND\" class=\"wp-image-115439\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi AND<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Loi_thuong_gap_khi_su_dung_ham_IF_va_cach_khac_phuc\"><\/span><strong>L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m IF trong Excel, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn khi\u1ebfn c\u00f4ng th\u1ee9c kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong mu\u1ed1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c \u0111\u1ec3 gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng IF hi\u1ec7u qu\u1ea3 h\u01a1n:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"O_hien_thi_gia_tri_0_khong\"><\/span><strong>\u00d4 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 0 (kh\u00f4ng)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi IF kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 r\u00f5 r\u00e0ng ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng kh\u1edbp v\u1edbi b\u1ea5t k\u1ef3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li>Kh\u00f4ng \u0111\u1eb7t gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 cho tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n\n\n\n<li>C\u00f4ng th\u1ee9c IF tr\u1ea3 v\u1ec1 m\u1ed9t \u00f4 tr\u1ed1ng ho\u1eb7c gi\u00e1 tr\u1ecb kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li>\u0110\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c IF c\u00f3 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 cho c\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p \u0111\u00fang v\u00e0 sai.<\/li>\n\n\n\n<li>N\u1ebfu mu\u1ed1n \u00f4 tr\u1ed1ng thay v\u00ec hi\u1ec3n th\u1ecb s\u1ed1 0, c\u00f3 th\u1ec3 d\u00f9ng &#8220;&#8221; trong c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-1024x640.jpg\" alt=\"L\u1ed7i \u00f4 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 0 khi s\u1eed d\u1ee5ng h\u00e0m IF\" class=\"wp-image-115440\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ed7i \u00f4 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb 0 khi s\u1eed d\u1ee5ng h\u00e0m IF<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"O_hien_thi_loi_NAME\"><\/span><strong>\u00d4 hi\u1ec3n th\u1ecb l\u1ed7i #NAME?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>L\u1ed7i #NAME? th\u01b0\u1eddng x\u1ea3y ra khi Excel kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c h\u00e0m ho\u1eb7c t\u00ean tham chi\u1ebfu trong c\u00f4ng th\u1ee9c.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul>\n<li>Nh\u1eadp sai t\u00ean h\u00e0m (v\u00ed d\u1ee5: =if( thay v\u00ec =IF().<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng v\u0103n b\u1ea3n trong c\u00f4ng th\u1ee9c nh\u01b0ng thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p &#8221; &#8220;.<\/li>\n\n\n\n<li>Tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t t\u00ean kh\u00f4ng t\u1ed3n t\u1ea1i trong Excel.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n\n\n\n<ul>\n<li>Ki\u1ec3m tra l\u1ea1i ch\u00ednh t\u1ea3 c\u1ee7a h\u00e0m, \u0111\u1ea3m b\u1ea3o vi\u1ebft \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng.<\/li>\n\n\n\n<li>N\u1ebfu c\u00f4ng th\u1ee9c ch\u1ee9a v\u0103n b\u1ea3n, \u0111\u1eb7t v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p &#8221; &#8220;.<\/li>\n\n\n\n<li>Ki\u1ec3m tra l\u1ea1i c\u00e1c tham chi\u1ebfu \u0111\u1ebfn t\u00ean ho\u1eb7c ph\u1ea1m vi d\u1eef li\u1ec7u c\u00f3 t\u1ed3n t\u1ea1i hay kh\u00f4ng.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cac_ham_dieu_kien_trong_Excel_khac\"><\/span><strong>C\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n trong Excel kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-1024x640.jpg\" alt=\"C\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n kh\u00e1c trong Excel\" class=\"wp-image-115441\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/ham-if-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n kh\u00e1c trong Excel<\/figcaption><\/figure>\n\n\n\n<p>Ngo\u00e0i h\u00e0m IF, Excel c\u00f2n cung c\u1ea5p nhi\u1ec1u h\u00e0m \u0111i\u1ec1u ki\u1ec7n kh\u00e1c gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 h\u00e0m ph\u1ed5 bi\u1ebfn m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p:<\/p>\n\n\n\n<ul>\n<li><strong>H\u00e0m IFS &#8211; Ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n l\u1ed3ng IF: <\/strong>N\u00e2ng cao c\u1ee7a IF, cho ph\u00e9p ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n l\u1ed3ng qu\u00e1 nhi\u1ec1u h\u00e0m IF.<\/li>\n\n\n\n<li><strong>H\u00e0m SWITCH &#8211; Thay th\u1ebf gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean danh s\u00e1ch c\u00f3 s\u1eb5n: <\/strong>Ki\u1ec3m tra m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng m\u00e0 kh\u00f4ng c\u1ea7n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n nh\u01b0 IF ho\u1eb7c IFS.<\/li>\n\n\n\n<li><strong>H\u00e0m AND &#8211; Ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi: <\/strong>H\u00e0m AND tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 FALSE.<\/li>\n\n\n\n<li><strong>H\u00e0m OR &#8211; Ki\u1ec3m tra \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang: <\/strong>H\u00e0m OR tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 FALSE.<\/li>\n<\/ul>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><strong>K\u1ebft lu\u1eadn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m IF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch trong Excel, gi\u00fap b\u1ea1n x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n s\u1ebd gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c v\u00e0 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p d\u1ec5 d\u00e0ng h\u01a1n. Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n \u0111\u00e3 c\u00f3 c\u00e1i nh\u00ecn r\u00f5 r\u00e0ng h\u01a1n v\u1ec1 h\u00e0m IF v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a n\u00f3. H\u00e3y th\u1eed \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng vi\u1ec7c \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic quan tr\u1ecdng trong Excel, gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u1ea3ng t\u00ednh m\u1ed9t [&hellip;]<\/p>\n","protected":false},"author":34,"featured_media":115434,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[24,1029],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115433"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=115433"}],"version-history":[{"count":2,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115433\/revisions"}],"predecessor-version":[{"id":115443,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115433\/revisions\/115443"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/115434"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=115433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=115433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=115433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}