{"id":451229,"date":"2025-04-23T19:27:35","date_gmt":"2025-04-23T12:27:35","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=451229"},"modified":"2025-04-23T19:27:35","modified_gmt":"2025-04-23T12:27:35","slug":"ham-if","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/","title":{"rendered":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5"},"content":{"rendered":"<p class=\"\" data-start=\"396\" data-end=\"934\"><strong>H\u00e0m IF<\/strong> trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t, gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n logic \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 t\u00f9y theo \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh. N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1 li\u1ec7u ho\u1eb7c mu\u1ed1n x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n, h\u00e0m c\u01a1 b\u1ea3n n\u00e0y ch\u00ednh l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi. H\u00f4m nay, Ho\u00e0ng H\u00e0 Mobile s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 h\u00e0m IF, c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y.<\/p>\n<h2 class=\"\" data-start=\"941\" data-end=\"972\">H\u00e0m IF trong Excel l\u00e0 g\u00ec?<\/h2>\n<p class=\"\" data-start=\"974\" data-end=\"1272\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n trong Excel, cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n ph\u00e9p to\u00e1n \u0111i\u1ec1u ki\u1ec7n. C\u01a1 b\u1ea3n nh\u1ea5t, h\u00e0m n\u00e0y s\u1ebd ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t trong hai gi\u00e1 tr\u1ecb tu\u1ef3 theo \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 \u0111\u00fang hay sai. \u0110\u00e2y l\u00e0 h\u00e0m c\u1ef1c k\u1ef3 h\u1eefu \u00edch trong vi\u1ec7c ph\u00e2n lo\u1ea1i, t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u. H\u00e0m c\u00f3 d\u1ea1ng:<\/p>\n<p data-start=\"974\" data-end=\"1272\"><strong>=IF(logical_test, value_if_true, value_if_false)<\/strong><\/p>\n<ul>\n<li data-start=\"1339\" data-end=\"1388\"><strong data-start=\"1339\" data-end=\"1355\">logical_test<\/strong>: \u0110i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/li>\n<li data-start=\"1391\" data-end=\"1444\"><strong data-start=\"1391\" data-end=\"1408\">value_if_true<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n<li data-start=\"1447\" data-end=\"1500\"><strong data-start=\"1447\" data-end=\"1465\">value_if_false<\/strong>: Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n<p style=\"text-align: center;\" data-start=\"1502\" data-end=\"1522\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-451282 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-1.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"1502\" data-end=\"1522\"><em>V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n:<\/em><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;10, &#8220;L\u1edbn h\u01a1n 10&#8221;, &#8220;Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"1585\" data-end=\"1689\">Khi gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n 10, Excel s\u1ebd tr\u1ea3 v\u1ec1 &#8220;L\u1edbn h\u01a1n 10&#8221;, ng\u01b0\u1ee3c l\u1ea1i s\u1ebd l\u00e0 &#8220;Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10&#8221;.<\/p>\n<h2 class=\"\" data-start=\"1696\" data-end=\"1740\">C\u00f4ng th\u1ee9c chu\u1ea9n c\u1ee7a h\u00e0m IF trong Excel<\/h2>\n<p class=\"\" data-start=\"1742\" data-end=\"1844\">\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m hi\u1ec7u qu\u1ea3, b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 c\u00f4ng th\u1ee9c chu\u1ea9n c\u1ee7a n\u00f3. C\u1ea5u tr\u00fac c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(\u0111i\u1ec1u ki\u1ec7n, gi\u00e1 tr\u1ecb khi \u0111\u00fang, gi\u00e1 tr\u1ecb khi sai)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"1910\" data-end=\"1921\"><em>V\u00ed d\u1ee5: Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh trong \u00f4 A2:<\/em><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A2&gt;=5, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"2025\" data-end=\"2127\">N\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;\u0110\u1ea1t&#8221;, n\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.<\/p>\n<p style=\"text-align: center;\" data-start=\"2025\" data-end=\"2127\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-452939 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-21.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"2129\" data-end=\"2228\">H\u00e0m \u0111i\u1ec1u ki\u1ec7n c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c \u0111\u1ec3 l\u00e0m phong ph\u00fa th\u00eam kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n c\u1ee7a b\u1ea1n.<\/p>\n<h2 class=\"\" data-start=\"2235\" data-end=\"2288\">M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda c\u00e1ch d\u00f9ng h\u00e0m IF \u0111\u01a1n gi\u1ea3n<\/h2>\n<p>Tr\u01b0\u1edbc khi \u0111i s\u00e2u v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng s\u1eed d\u1ee5ng n\u00e2ng cao c\u1ee7a h\u00e0m n\u00e0y ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 minh h\u1ecda c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u00fap b\u1ea1n l\u00e0m quen v\u1edbi c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m n\u00e0y. Nh\u1eefng v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n n\u00e0y s\u1ebd cung c\u1ea5p n\u1ec1n t\u1ea3ng v\u1eefng ch\u1eafc \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y v\u00e0o nhi\u1ec1u t\u00ecnh hu\u1ed1ng trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/p>\n<h3 class=\"\" data-start=\"2290\" data-end=\"2333\">V\u00ed d\u1ee5 1: Ki\u1ec3m tra s\u1ed1 li\u1ec7u trong \u00f4 A2<\/h3>\n<p class=\"\" data-start=\"2335\" data-end=\"2439\"><strong data-start=\"2335\" data-end=\"2347\">B\u00e0i to\u00e1n<\/strong>: Ki\u1ec3m tra n\u1ebfu s\u1ed1 trong \u00f4 A2 l\u1edbn h\u01a1n 50, hi\u1ec3n th\u1ecb &#8220;T\u1ed1t&#8221;, n\u1ebfu kh\u00f4ng hi\u1ec3n th\u1ecb &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A2&gt;50, &#8220;T\u1ed1t&#8221;, &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"523\" data-end=\"833\"><strong data-start=\"523\" data-end=\"537\">Gi\u1ea3i th\u00edch<\/strong>: \u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 c\u01a1 b\u1ea3n \u0111\u1ec3 hi\u1ec3u c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m IF trong Excel. C\u00f4ng th\u1ee9c n\u00e0y ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 <strong data-start=\"653\" data-end=\"659\">A2<\/strong>\u00a0c\u00f3 l\u1edbn h\u01a1n 50 kh\u00f4ng. N\u1ebfu \u0111\u00fang, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;T\u1ed1t&#8221;, n\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;. \u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 ph\u1ed5 bi\u1ebfn khi b\u1ea1n c\u1ea7n ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u theo ti\u00eau ch\u00ed \u0111\u01a1n gi\u1ea3n.<\/p>\n<ul>\n<li data-start=\"837\" data-end=\"899\">N\u1ebfu <strong data-start=\"841\" data-end=\"847\">A2<\/strong>\u00a0ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 60, th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 &#8220;T\u1ed1t&#8221;.<\/li>\n<li data-start=\"902\" data-end=\"963\">N\u1ebfu <strong data-start=\"906\" data-end=\"912\">A2<\/strong>\u00a0ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 40, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: center;\" data-start=\"965\" data-end=\"1130\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-452940 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-22.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"965\" data-end=\"1130\"><strong data-start=\"965\" data-end=\"985\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/strong>: V\u00ed d\u1ee5 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 \u0111i\u1ec3m s\u1ed1, s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m, hay b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem c\u00f3 \u0111\u1ea1t y\u00eau c\u1ea7u hay kh\u00f4ng.<\/p>\n<h3 class=\"\" data-start=\"2627\" data-end=\"2665\">V\u00ed d\u1ee5 2: Ki\u1ec3m tra \u0111i\u1ec3m h\u1ecdc sinh<\/h3>\n<p class=\"\" data-start=\"2667\" data-end=\"2735\"><strong data-start=\"2667\" data-end=\"2679\">B\u00e0i to\u00e1n<\/strong>: Ki\u1ec3m tra \u0111i\u1ec3m h\u1ecdc sinh trong \u00f4 A2 \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\">=IF(A2&gt;=6, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/div>\n<\/div>\n<p class=\"\" data-start=\"1403\" data-end=\"1706\"><strong data-start=\"1403\" data-end=\"1417\">Gi\u1ea3i th\u00edch<\/strong>: Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m <strong data-start=\"1440\" data-end=\"1446\">IF<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra xem \u0111i\u1ec3m s\u1ed1 trong \u00f4 <strong data-start=\"1492\" data-end=\"1498\">A2<\/strong>\u00a0c\u00f3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 6 hay kh\u00f4ng. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n n\u00e0y \u0111\u00fang, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 &#8220;\u0110\u1ea1t&#8221;, n\u1ebfu sai th\u00ec tr\u1ea3 v\u1ec1 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;. \u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 r\u1ea5t th\u1ef1c t\u1ebf trong vi\u1ec7c \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh, sinh vi\u00ean.<\/p>\n<ul>\n<li data-start=\"1710\" data-end=\"1760\">N\u1ebfu <strong data-start=\"1714\" data-end=\"1720\">A2<\/strong>\u00a0ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 7, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;\u0110\u1ea1t&#8221;.<\/li>\n<li data-start=\"1763\" data-end=\"1819\">N\u1ebfu <strong data-start=\"1767\" data-end=\"1773\">A2<\/strong>\u00a0ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 5, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: center;\" data-start=\"1821\" data-end=\"2000\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452941 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-23.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"1821\" data-end=\"2000\"><strong data-start=\"1821\" data-end=\"1841\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/strong>: C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng trong vi\u1ec7c \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh, hay \u0111\u00e1nh gi\u00e1 hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean trong c\u00e1c c\u00f4ng ty, doanh nghi\u1ec7p.<\/p>\n<h3 class=\"\" data-start=\"2870\" data-end=\"2895\">V\u00ed d\u1ee5 3: T\u00ednh thu\u1ebf<\/h3>\n<p class=\"\" data-start=\"2897\" data-end=\"2994\"><strong data-start=\"2897\" data-end=\"2909\">B\u00e0i to\u00e1n<\/strong>: Ki\u1ec3m tra thu nh\u1eadp trong \u00f4 A2, n\u1ebfu tr\u00ean 10 tri\u1ec7u th\u00ec t\u00ednh thu\u1ebf 10%, n\u1ebfu d\u01b0\u1edbi th\u00ec 5%.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A2&gt;10000000, &#8220;10%&#8221;, &#8220;5%&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"2233\" data-end=\"2581\"><strong data-start=\"2233\" data-end=\"2247\">Gi\u1ea3i th\u00edch<\/strong>: Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m <strong data-start=\"2270\" data-end=\"2276\">IF<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n thu\u1ebf d\u1ef1a tr\u00ean m\u1ee9c thu nh\u1eadp c\u1ee7a c\u00e1 nh\u00e2n. N\u1ebfu thu nh\u1eadp trong \u00f4 <strong data-start=\"2364\" data-end=\"2370\">A2<\/strong>\u00a0l\u1edbn h\u01a1n 10 tri\u1ec7u \u0111\u1ed3ng, th\u00ec thu\u1ebf s\u1ebd l\u00e0 10% c\u1ee7a thu nh\u1eadp \u0111\u00f3. N\u1ebfu thu nh\u1eadp d\u01b0\u1edbi 10 tri\u1ec7u \u0111\u1ed3ng, thu\u1ebf s\u1ebd l\u00e0 5%. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00ednh to\u00e1n thu\u1ebf, gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m, ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c t\u00e0i ch\u00ednh kh\u00e1c.<\/p>\n<ul>\n<li data-start=\"2585\" data-end=\"2667\">N\u1ebfu <strong data-start=\"2589\" data-end=\"2595\">A2<\/strong>\u00a0l\u00e0 12 tri\u1ec7u \u0111\u1ed3ng, thu\u1ebf s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 12 tri\u1ec7u * 10% = 1.2 tri\u1ec7u \u0111\u1ed3ng.<\/li>\n<li data-start=\"2670\" data-end=\"2747\">N\u1ebfu <strong data-start=\"2674\" data-end=\"2680\">A2<\/strong>\u00a0l\u00e0 8 tri\u1ec7u \u0111\u1ed3ng, thu\u1ebf s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 8 tri\u1ec7u * 5% = 400,000 \u0111\u1ed3ng.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-24-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452942 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-24.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-24\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"2749\" data-end=\"2925\"><strong data-start=\"2749\" data-end=\"2769\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/strong>: C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng trong vi\u1ec7c t\u00ednh to\u00e1n thu\u1ebf thu nh\u1eadp c\u00e1 nh\u00e2n, t\u00ednh to\u00e1n chi\u1ebft kh\u1ea5u d\u1ef1a tr\u00ean doanh thu, ho\u1eb7c trong c\u00e1c c\u00f4ng th\u1ee9c t\u00e0i ch\u00ednh kh\u00e1c.<\/p>\n<h2 class=\"\" data-start=\"3138\" data-end=\"3178\">M\u1ed9t s\u1ed1 c\u00e1ch d\u00f9ng h\u00e0m IF th\u00f4ng d\u1ee5ng<\/h2>\n<p class=\"\" data-start=\"3180\" data-end=\"3312\">Sau khi n\u1eafm v\u1eefng c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng ph\u1ee9c t\u1ea1p h\u01a1n c\u1ee7a h\u00e0m n\u00e0y \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00e1c b\u00e0i to\u00e1n trong Excel.<\/p>\n<h3 class=\"\" data-start=\"3314\" data-end=\"3338\">L\u1ed3ng nhi\u1ec1u h\u00e0m IF<\/h3>\n<p class=\"\" data-start=\"3340\" data-end=\"3459\"><strong data-start=\"3340\" data-end=\"3349\">V\u00ed d\u1ee5<\/strong>: \u0110\u1ec3 ph\u00e2n lo\u1ea1i h\u1ecdc sinh theo \u0111i\u1ec3m s\u1ed1: N\u1ebfu \u0111i\u1ec3m l\u1edbn h\u01a1n 8, cho l\u00e0 &#8220;Gi\u1ecfi&#8221;, t\u1eeb 6 \u0111\u1ebfn 8 l\u00e0 &#8220;Kh\u00e1&#8221;, d\u01b0\u1edbi 6 l\u00e0 &#8220;Y\u1ebfu&#8221;.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A2&gt;8, &#8220;Gi\u1ecfi&#8221;, IF(A2&gt;=6, &#8220;Kh\u00e1&#8221;, &#8220;Y\u1ebfu&#8221;))<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"3518\" data-end=\"3706\"><strong data-start=\"3518\" data-end=\"3532\">Gi\u1ea3i th\u00edch<\/strong>: \u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 c\u1ee7a h\u00e0m IF l\u1ed3ng nhau. N\u1ebfu A2 &gt; 8, tr\u1ea3 v\u1ec1 &#8220;Gi\u1ecfi&#8221;. N\u1ebfu kh\u00f4ng, ti\u1ebfp t\u1ee5c ki\u1ec3m tra xem A2 c\u00f3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 6 kh\u00f4ng, n\u1ebfu c\u00f3 tr\u1ea3 v\u1ec1 &#8220;Kh\u00e1&#8221;, n\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 &#8220;Y\u1ebfu&#8221;.<\/p>\n<p style=\"text-align: center;\" data-start=\"3518\" data-end=\"3706\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-25-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452943 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-25.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 class=\"\" data-start=\"3708\" data-end=\"3745\">S\u1eed d\u1ee5ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<p class=\"\" data-start=\"3747\" data-end=\"3850\"><strong data-start=\"3747\" data-end=\"3756\">V\u00ed d\u1ee5<\/strong>: Ki\u1ec3m tra xem s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m trong kho c\u00f3 l\u1edbn h\u01a1n 100 v\u00e0 doanh thu c\u00f3 v\u01b0\u1ee3t 50 tri\u1ec7u kh\u00f4ng.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\">=IF(AND(A2&gt;100, B2&gt;50000000), &#8220;\u0110\u1ee7 h\u00e0ng&#8221;, &#8220;Ch\u01b0a \u0111\u1ee7&#8221;)<\/div>\n<\/div>\n<p class=\"\" data-start=\"3922\" data-end=\"4052\"><strong data-start=\"3922\" data-end=\"3936\">Gi\u1ea3i th\u00edch<\/strong>: H\u00e0m <strong>AND<\/strong> cho ph\u00e9p b\u1ea1n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi. N\u1ebfu c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 &#8220;\u0110\u1ee7 h\u00e0ng&#8221;.<\/p>\n<p style=\"text-align: center;\" data-start=\"3922\" data-end=\"4052\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-26.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-26-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-26-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452944 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-26.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-26\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-26.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-26-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-26-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 class=\"\" data-start=\"4054\" data-end=\"4093\">K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m AND v\u00e0 OR<\/h3>\n<p class=\"\" data-start=\"4095\" data-end=\"4183\"><strong data-start=\"4095\" data-end=\"4104\">V\u00ed d\u1ee5<\/strong>: Ki\u1ec3m tra n\u1ebfu m\u1ed9t nh\u00e2n vi\u00ean c\u00f3 \u0111i\u1ec3m s\u1ed1 tr\u00ean 7 v\u00e0 tham gia \u0111\u1ea7y \u0111\u1ee7 c\u00e1c kh\u00f3a h\u1ecdc.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(AND(A2&gt;7, B2=&#8221;\u0110\u1ea7y \u0111\u1ee7&#8221;), &#8220;\u0110\u1ea1t y\u00eau c\u1ea7u&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t y\u00eau c\u1ea7u&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"4263\" data-end=\"4353\"><strong data-start=\"4263\" data-end=\"4277\">Gi\u1ea3i th\u00edch<\/strong>: H\u00e0m <strong>AND<\/strong> k\u1ebft h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang ho\u1eb7c sai.<\/p>\n<p style=\"text-align: center;\" data-start=\"4263\" data-end=\"4353\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-27.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-27-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-27-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452945 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-27.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-27\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-27.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-27-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-27-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 class=\"\" data-start=\"4355\" data-end=\"4396\">K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m CONCATENATE<\/h3>\n<p class=\"\" data-start=\"4398\" data-end=\"4462\"><strong data-start=\"4398\" data-end=\"4407\">V\u00ed d\u1ee5<\/strong>: T\u1ea1o th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 cho h\u1ecdc sinh t\u1eeb \u0111i\u1ec3m s\u1ed1 v\u00e0 t\u00ean.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A2&gt;=6, CONCATENATE(&#8220;Ch\u00fac m\u1eebng &#8220;, B2, &#8220;, b\u1ea1n \u0111\u00e3 \u0111\u1ea1t!&#8221;), CONCATENATE(&#8220;Xin l\u1ed7i &#8220;, B2, &#8220;, b\u1ea1n ch\u01b0a \u0111\u1ea1t&#8221;))<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"4584\" data-end=\"4678\"><strong data-start=\"4584\" data-end=\"4598\">Gi\u1ea3i th\u00edch<\/strong>: S\u1eed d\u1ee5ng <strong>CONCATENATE<\/strong> \u0111\u1ec3 k\u1ebft h\u1ee3p t\u00ean h\u1ecdc sinh v\u1edbi th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m.<\/p>\n<p style=\"text-align: center;\" data-start=\"4584\" data-end=\"4678\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-28.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-28-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-28-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-452946 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-28.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-28\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-28.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-28-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-28-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 class=\"\" data-start=\"4685\" data-end=\"4743\">M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/h2>\n<p class=\"\" data-start=\"58\" data-end=\"313\">Khi s\u1eed d\u1ee5ng h\u00e0m \u0111i\u1ec1u ki\u1ec7n trong Excel, d\u00f9 c\u00f4ng th\u1ee9c c\u00f3 v\u1ebb \u0111\u01a1n gi\u1ea3n, nh\u01b0ng \u0111\u00f4i khi ng\u01b0\u1eddi d\u00f9ng v\u1eabn m\u1eafc ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u00f4ng vi\u1ec7c. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 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 h\u00e0m hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<h3 class=\"\" data-start=\"320\" data-end=\"350\">L\u1ed7i 1: Qu\u00ean \u0111\u00f3ng d\u1ea5u ngo\u1eb7c<\/h3>\n<p class=\"\" data-start=\"352\" data-end=\"662\"><strong data-start=\"352\" data-end=\"365\">M\u00f4 t\u1ea3 l\u1ed7i<\/strong>: M\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn khi s\u1eed d\u1ee5ng h\u00e0m <strong data-start=\"412\" data-end=\"418\">IF<\/strong> l\u00e0 qu\u00ean \u0111\u00f3ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n ho\u1eb7c ngo\u1eb7c k\u00e9p, d\u1eabn \u0111\u1ebfn l\u1ed7i c\u00fa ph\u00e1p. Trong Excel, m\u1ed7i c\u00f4ng th\u1ee9c h\u00e0m \u0111\u1ec1u y\u00eau c\u1ea7u ph\u1ea3i c\u00f3 m\u1ed9t c\u1eb7p d\u1ea5u ngo\u1eb7c m\u1edf v\u00e0 \u0111\u00f3ng. N\u1ebfu b\u1ea1n b\u1ecf qua d\u1ea5u ngo\u1eb7c n\u00e0y, Excel s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c v\u00e0 s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i.<\/p>\n<p style=\"text-align: center;\" data-start=\"352\" data-end=\"662\">\u00a0 \u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-451281 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-13.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"664\" data-end=\"678\"><strong data-start=\"664\" data-end=\"677\">V\u00ed d\u1ee5 l\u1ed7i<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;50, &#8220;T\u1ed1t&#8221;, &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"728\" data-end=\"794\">C\u00f4ng th\u1ee9c tr\u00ean b\u1ecb thi\u1ebfu d\u1ea5u ngo\u1eb7c \u0111\u00f3ng \u1edf cu\u1ed1i, g\u00e2y ra l\u1ed7i c\u00fa ph\u00e1p.<\/p>\n<p class=\"\" data-start=\"796\" data-end=\"904\"><strong data-start=\"796\" data-end=\"809\">Gi\u1ea3i ph\u00e1p<\/strong>: H\u00e3y ki\u1ec3m tra k\u1ef9 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng m\u1ed7i h\u00e0m <strong data-start=\"869\" data-end=\"875\">IF<\/strong> c\u00f3 \u0111\u1ee7 d\u1ea5u ngo\u1eb7c m\u1edf v\u00e0 \u0111\u00f3ng.<\/p>\n<p class=\"\" data-start=\"906\" data-end=\"925\"><strong data-start=\"906\" data-end=\"924\">C\u00f4ng th\u1ee9c \u0111\u00fang<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;50, &#8220;T\u1ed1t&#8221;, &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"976\" data-end=\"1094\"><strong data-start=\"976\" data-end=\"985\">L\u01b0u \u00fd<\/strong>: Trong Excel, d\u1ea5u ngo\u1eb7c r\u1ea5t quan tr\u1ecdng, v\u00ec v\u1eady lu\u00f4n ki\u1ec3m tra k\u1ef9 sau m\u1ed7i l\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y.<\/p>\n<h3 class=\"\" data-start=\"1101\" data-end=\"1155\">L\u1ed7i 2: D\u00f9ng sai lo\u1ea1i d\u1ea5u ph\u00e2n c\u00e1ch trong c\u00f4ng th\u1ee9c<\/h3>\n<p class=\"\" data-start=\"1157\" data-end=\"1410\"><strong data-start=\"1157\" data-end=\"1170\">M\u00f4 t\u1ea3 l\u1ed7i<\/strong>: \u1ede m\u1ed9t s\u1ed1 qu\u1ed1c gia, Excel s\u1eed d\u1ee5ng d\u1ea5u ph\u00e2n c\u00e1ch l\u00e0 d\u1ea5u ph\u1ea9y <strong data-start=\"1231\" data-end=\"1238\">(,)<\/strong>, trong khi \u1edf m\u1ed9t s\u1ed1 qu\u1ed1c gia kh\u00e1c, d\u1ea5u ph\u00e2n c\u00e1ch l\u1ea1i l\u00e0 d\u1ea5u ch\u1ea5m ph\u1ea9y <strong data-start=\"1309\" data-end=\"1316\">(;)<\/strong>. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng sai d\u1ea5u ph\u00e2n c\u00e1ch, c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 Excel s\u1ebd b\u00e1o l\u1ed7i c\u00fa ph\u00e1p.<\/p>\n<p style=\"text-align: center;\" data-start=\"1157\" data-end=\"1410\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-451275 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-2.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"1412\" data-end=\"1426\"><strong data-start=\"1412\" data-end=\"1425\">V\u00ed d\u1ee5 l\u1ed7i<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;50, &#8220;T\u1ed1t&#8221;; &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"1477\" data-end=\"1639\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng Excel v\u1edbi c\u1ea5u h\u00ecnh qu\u1ed1c gia y\u00eau c\u1ea7u d\u1ea5u ph\u1ea9y (,) m\u00e0 l\u1ea1i d\u00f9ng d\u1ea5u ch\u1ea5m ph\u1ea9y (;), Excel s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c.<\/p>\n<p class=\"\" data-start=\"1641\" data-end=\"1743\"><strong data-start=\"1641\" data-end=\"1654\">Gi\u1ea3i ph\u00e1p<\/strong>: B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng s\u1eed d\u1ee5ng \u0111\u00fang d\u1ea5u ph\u00e2n c\u00e1ch ph\u00f9 h\u1ee3p v\u1edbi c\u1ea5u h\u00ecnh h\u1ec7 th\u1ed1ng c\u1ee7a m\u00ecnh.<\/p>\n<ul>\n<li data-start=\"1747\" data-end=\"1844\">N\u1ebfu Excel c\u1ee7a b\u1ea1n y\u00eau c\u1ea7u d\u1ea5u ph\u1ea9y <strong data-start=\"1782\" data-end=\"1789\">(,)<\/strong>, h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y gi\u1eefa c\u00e1c \u0111\u1ed1i s\u1ed1 trong c\u00f4ng th\u1ee9c.<\/li>\n<li data-start=\"1847\" data-end=\"1934\">N\u1ebfu Excel c\u1ee7a b\u1ea1n y\u00eau c\u1ea7u d\u1ea5u ch\u1ea5m ph\u1ea9y <strong data-start=\"1887\" data-end=\"1894\">(;)<\/strong>, h\u00e3y thay d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m ph\u1ea9y.<\/li>\n<\/ul>\n<p class=\"\" data-start=\"1936\" data-end=\"1955\"><strong data-start=\"1936\" data-end=\"1954\">C\u00f4ng th\u1ee9c \u0111\u00fang<\/strong>:<\/p>\n<ul data-start=\"1957\" data-end=\"1997\">\n<li class=\"\" data-start=\"1957\" data-end=\"1997\">\n<p class=\"\" data-start=\"1959\" data-end=\"1997\">N\u1ebfu d\u00f9ng d\u1ea5u ph\u1ea9y (,) trong c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m IF:<\/p>\n<\/li>\n<\/ul>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;50, &#8220;T\u1ed1t&#8221;, &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;)<\/strong><\/div>\n<\/div>\n<ul data-start=\"2048\" data-end=\"2093\">\n<li class=\"\" data-start=\"2048\" data-end=\"2093\">\n<p class=\"\" data-start=\"2050\" data-end=\"2093\">N\u1ebfu d\u00f9ng d\u1ea5u ch\u1ea5m ph\u1ea9y (;) trong c\u00f4ng th\u1ee9c:<\/p>\n<\/li>\n<\/ul>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;50; &#8220;T\u1ed1t&#8221;; &#8220;C\u1ea7n c\u1ea3i thi\u1ec7n&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"2144\" data-end=\"2299\"><strong data-start=\"2144\" data-end=\"2153\">L\u01b0u \u00fd<\/strong>: B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra ho\u1eb7c thay \u0111\u1ed5i d\u1ea5u ph\u00e2n c\u00e1ch trong Excel b\u1eb1ng c\u00e1ch v\u00e0o <strong data-start=\"2229\" data-end=\"2258\">File &gt; Options &gt; Advanced<\/strong>, sau \u0111\u00f3 ch\u1ec9nh l\u1ea1i ph\u1ea7n &#8220;List separator&#8221;.<\/p>\n<h3 class=\"\" data-start=\"2306\" data-end=\"2347\">L\u1ed7i 3: K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng ch\u00ednh x\u00e1c<\/h3>\n<p class=\"\" data-start=\"2349\" data-end=\"2574\"><strong data-start=\"2349\" data-end=\"2362\">M\u00f4 t\u1ea3 l\u1ed7i<\/strong>: \u0110\u00f4i khi, d\u00f9 c\u00f4ng th\u1ee9c c\u00f3 v\u1ebb ch\u00ednh x\u00e1c nh\u01b0ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng \u0111\u00fang nh\u01b0 mong \u0111\u1ee3i. Nguy\u00ean nh\u00e2n c\u00f3 th\u1ec3 do \u0111i\u1ec1u ki\u1ec7n logic trong h\u00e0m <strong data-start=\"2496\" data-end=\"2502\">IF<\/strong> kh\u00f4ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh \u0111\u00fang ho\u1eb7c c\u00f3 s\u1ef1 nh\u1ea7m l\u1eabn trong c\u00e1c gi\u00e1 tr\u1ecb so s\u00e1nh.<\/p>\n<p style=\"text-align: center;\" data-start=\"2349\" data-end=\"2574\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-451285 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-7.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"2576\" data-end=\"2590\"><strong data-start=\"2576\" data-end=\"2589\">V\u00ed d\u1ee5 l\u1ed7i<\/strong>:<\/p>\n<p class=\"\" data-start=\"2592\" data-end=\"2748\">Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n ki\u1ec3m tra n\u1ebfu \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh trong \u00f4 <strong data-start=\"2647\" data-end=\"2653\">A1<\/strong> l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 6, th\u00ec k\u1ebft qu\u1ea3 l\u00e0 &#8220;\u0110\u1ea1t&#8221;, n\u1ebfu kh\u00f4ng l\u00e0 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;. C\u00f4ng th\u1ee9c b\u1ea1n s\u1eed d\u1ee5ng l\u00e0:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;=6, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"2795\" data-end=\"2871\">Tuy nhi\u00ean, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng ch\u00ednh x\u00e1c m\u1eb7c d\u00f9 b\u1ea1n ngh\u0129 \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 \u0111\u00fang.<\/p>\n<p class=\"\" data-start=\"2873\" data-end=\"2887\"><strong data-start=\"2873\" data-end=\"2886\">Gi\u1ea3i ph\u00e1p<\/strong>:<\/p>\n<ul>\n<li data-start=\"2890\" data-end=\"3025\">Ki\u1ec3m tra l\u1ea1i \u0111i\u1ec1u ki\u1ec7n logic trong h\u00e0m <strong data-start=\"2929\" data-end=\"2935\">IF<\/strong>. \u0110\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh nh\u01b0 <strong data-start=\"2974\" data-end=\"2980\">&gt;=<\/strong>, <strong data-start=\"2982\" data-end=\"2987\">&lt;<\/strong>, <strong data-start=\"2989\" data-end=\"2994\">&gt;<\/strong>, ho\u1eb7c <strong data-start=\"3001\" data-end=\"3006\">=<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u00fang.<\/li>\n<li data-start=\"3028\" data-end=\"3165\">\u0110\u1ea3m b\u1ea3o d\u1eef li\u1ec7u trong \u00f4 tham chi\u1ebfu (A1) l\u00e0 ch\u00ednh x\u00e1c v\u00e0 kh\u00f4ng ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng mong mu\u1ed1n nh\u01b0 kho\u1ea3ng tr\u1eafng hay d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i s\u1ed1.<\/li>\n<\/ul>\n<p class=\"\" data-start=\"3167\" data-end=\"3186\"><strong data-start=\"3167\" data-end=\"3185\">C\u00f4ng th\u1ee9c \u0111\u00fang<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;=6, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"3233\" data-end=\"3393\">N\u1ebfu sau khi ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00f4ng th\u1ee9c v\u1eabn kh\u00f4ng ch\u00ednh x\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u1ee7a \u00f4 tham chi\u1ebfu (A1) v\u00e0 \u0111\u1ea3m b\u1ea3o n\u00f3 l\u00e0 m\u1ed9t s\u1ed1 h\u1ee3p l\u1ec7.<\/p>\n<h3 class=\"\" data-start=\"3400\" data-end=\"3451\">L\u1ed7i 4: S\u1eed d\u1ee5ng sai ki\u1ec3u d\u1eef li\u1ec7u trong \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<p class=\"\" data-start=\"3453\" data-end=\"3700\"><strong data-start=\"3453\" data-end=\"3466\">M\u00f4 t\u1ea3 l\u1ed7i<\/strong>: M\u1ed9t l\u1ed7i kh\u00e1c m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng m\u1eafc ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m <strong data-start=\"3527\" data-end=\"3533\">IF<\/strong> l\u00e0 s\u1eed d\u1ee5ng sai ki\u1ec3u d\u1eef li\u1ec7u trong \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n so s\u00e1nh m\u1ed9t \u00f4 ch\u1ee9a s\u1ed1, nh\u01b0ng l\u1ea1i c\u1ed1 g\u1eafng so s\u00e1nh n\u00f3 v\u1edbi m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<p style=\"text-align: center;\" data-start=\"3453\" data-end=\"3700\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/04\/ham-if-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-451279 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-11.jpg\" alt=\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p class=\"\" data-start=\"3702\" data-end=\"3716\"><strong data-start=\"3702\" data-end=\"3715\">V\u00ed d\u1ee5 l\u1ed7i<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1=&#8221;60&#8243;, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/div>\n<\/div>\n<p class=\"\" data-start=\"3765\" data-end=\"3916\">Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu \u00f4 <strong data-start=\"3788\" data-end=\"3794\">A1<\/strong> ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 60, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221; v\u00ec b\u1ea1n \u0111ang so s\u00e1nh m\u1ed9t s\u1ed1 v\u1edbi m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n (v\u1edbi d\u1ea5u ngo\u1eb7c k\u00e9p).<\/p>\n<p class=\"\" data-start=\"3918\" data-end=\"4089\"><strong data-start=\"3918\" data-end=\"3931\">Gi\u1ea3i ph\u00e1p<\/strong>: H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n \u0111ang so s\u00e1nh l\u00e0 \u0111\u1ed3ng nh\u1ea5t v\u1ec1 ki\u1ec3u d\u1eef li\u1ec7u.<\/p>\n<p class=\"\" data-start=\"4091\" data-end=\"4110\"><strong data-start=\"4091\" data-end=\"4109\">C\u00f4ng th\u1ee9c \u0111\u00fang<\/strong>:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><strong>=IF(A1&gt;=60, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<\/strong><\/div>\n<\/div>\n<h2 data-start=\"5596\" data-end=\"5607\">T\u1ea1m k\u1ebft<\/h2>\n<p class=\"\" data-start=\"5608\" data-end=\"6050\">H\u00e0m IF trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng \u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. B\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng \u0111\u00fang c\u00f4ng th\u1ee9c, l\u1ed3ng nhi\u1ec1u h\u00e0m IF ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 AND, OR hay CONCATENATE, b\u1ea1n c\u00f3 th\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n c\u1ee7a m\u00ecnh. Hy v\u1ecdng r\u1eb1ng b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <strong>Ho\u00e0ng H\u00e0 Mobile<\/strong> \u0111\u00e3 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p. Ch\u00fac b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel th\u00e0nh c\u00f4ng v\u00e0 hi\u1ec7u qu\u1ea3!<\/p>\n<p data-start=\"5608\" data-end=\"6050\"><em><strong>XEM TH\u00caM:<\/strong><\/em><\/p>\n<ul>\n<li data-start=\"5608\" data-end=\"6050\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\">H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<li data-start=\"5608\" data-end=\"6050\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-xoa-cot-trong-excel-2007\/\">C\u00e1ch x\u00f3a c\u1ed9t trong Excel 2007, 2013, 2003 k\u00e8m v\u00ed d\u1ee5 minh ho\u1ea1<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m IF trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t, gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n logic \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 t\u00f9y theo \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh. N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1 li\u1ec7u ho\u1eb7c mu\u1ed1n x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng d\u1ef1a [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":451288,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-451229","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5<\/title>\n<meta name=\"description\" content=\"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5\" \/>\n<meta property=\"og:description\" content=\"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-23T12:27:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\"},\"headline\":\"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5\",\"datePublished\":\"2025-04-23T12:27:35+00:00\",\"dateModified\":\"2025-04-23T12:27:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\"},\"wordCount\":3331,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\",\"name\":\"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg\",\"datePublished\":\"2025-04-23T12:27:35+00:00\",\"dateModified\":\"2025-04-23T12:27:35+00:00\",\"description\":\"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg\",\"width\":1200,\"height\":628,\"caption\":\"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-14\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5","description":"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5","og_description":"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-04-23T12:27:35+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0"},"headline":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5","datePublished":"2025-04-23T12:27:35+00:00","dateModified":"2025-04-23T12:27:35+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/"},"wordCount":3331,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/","name":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg","datePublished":"2025-04-23T12:27:35+00:00","dateModified":"2025-04-23T12:27:35+00:00","description":"Kh\u00e1m ph\u00e1 t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel. H\u1ecdc c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n trong Excel.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/04\/ham-if-14.jpg","width":1200,"height":628,"caption":"tat-tan-tat-ve-ham-if-trong-excel-cong-thuc-cach-lam-vi-du-14"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/451229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=451229"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/451229\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/451288"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=451229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=451229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=451229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}