{"id":280538,"date":"2023-11-04T10:52:27","date_gmt":"2023-11-04T03:52:27","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=280538"},"modified":"2025-10-18T15:50:46","modified_gmt":"2025-10-18T08:50:46","slug":"ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/","title":{"rendered":"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao"},"content":{"rendered":"<p><b>H\u00e0m IF trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n n\u1ebfu \u0111\u00e1p \u1ee9ng s\u1ebd tr\u1ea3 gi\u00e1 tr\u1ecb v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. \u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch d\u00f9ng c\u1ee7a h\u00e0m IF ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb chi ti\u1ebft trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. \u0110\u1ed3ng th\u1eddi, ch\u00fang t\u00f4i s\u1ebd \u0111\u01b0a ra nh\u1eefng v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m IF thu\u1eadn ti\u1ec7n.\u00a0<\/span><\/p>\n<h2><strong>H\u00e0m IF trong Excel l\u00e0 g\u00ec?<\/strong><\/h2>\n<p>H\u00e0m IF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel, cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n so s\u00e1nh m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 \u0110\u00daNG (TRUE), v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 SAI (FALSE). \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 n\u1ec1n t\u1ea3ng \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c ph\u00e2n lo\u1ea1i, ki\u1ec3m tra v\u00e0 ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-280541 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-2.jpg\" alt=\"ham-if-trong-excel-2\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-2-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-2-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><strong>C\u00f4ng th\u1ee9c h\u00e0m IF<\/strong><\/h3>\n<p>C\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m IF nh\u01b0 sau:<br \/>\n<code>=IF(logical_test, [value_if_true], [value_if_false])<\/code><br \/>\nTrong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>logical_test (b\u1eaft bu\u1ed9c):<\/strong>\u00a0L\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n ki\u1ec3m tra (v\u00ed d\u1ee5: A2 &gt; 50). \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t ph\u00e9p so s\u00e1nh, m\u1ed9t h\u00e0m kh\u00e1c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE.<\/li>\n<li><strong>value_if_true (t\u00f9y ch\u1ecdn):<\/strong>\u00a0L\u00e0 gi\u00e1 tr\u1ecb s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n\u00a0<code>logical_test<\/code>\u00a0l\u00e0 \u0111\u00fang. N\u1ebfu b\u1ecf qua, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0.<\/li>\n<li><strong>value_if_false (t\u00f9y ch\u1ecdn):<\/strong>\u00a0L\u00e0 gi\u00e1 tr\u1ecb s\u1ebd tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n\u00a0<code>logical_test<\/code>\u00a0l\u00e0 sai. N\u1ebfu b\u1ecf qua, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE.<\/li>\n<\/ul>\n<p><em>L\u01b0u \u00fd: Khi gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 v\u0103n b\u1ea3n, b\u1ea1n c\u1ea7n \u0111\u1eb7t ch\u00fang trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;&#8221;). V\u00ed d\u1ee5: &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0110\u1ea1t&#8221;.<\/em><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-280543 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-4.jpg\" alt=\"ham-if-trong-excel-4\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-4-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-4-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel v\u00e0 v\u00ed d\u1ee5 minh ho\u1ea1<\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n, tham chi\u1ebfu gi\u00e1 tr\u1ecb c\u00f2n g\u1eb7p kh\u00f3 kh\u0103n. Sau \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p v\u00e0 v\u00ed d\u1ee5 minh ho\u1ea1 cho c\u00e1c b\u1ea1n tham kh\u1ea3o nh\u00e9!\u00a0<\/span><\/p>\n<h3>S\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 so s\u00e1nh<\/h3>\n<p><strong>V\u00ed d\u1ee5 c\u01a1 b\u1ea3n: X\u00e9t k\u1ebft qu\u1ea3 &#8220;\u0110\u1ea1t&#8221; \/ &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221; cho h\u1ecdc sinh<\/strong><br \/>\nGi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m v\u00e0 c\u1ea7n x\u00e1c \u0111\u1ecbnh h\u1ecdc sinh n\u00e0o &#8220;\u0110\u1ea1t&#8221; n\u1ebfu \u0111i\u1ec3m trung b\u00ecnh (c\u1ed9t B) t\u1eeb 5.0 tr\u1edf l\u00ean.<br \/>\nT\u1ea1i \u00f4 C2, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c:<br \/>\n=IF(B2&gt;=5, &#8220;\u0110\u1ea1t&#8221;, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;)<br \/>\n<strong>Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<ul>\n<li>B2&gt;=5\u00a0l\u00e0 \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m tra.<\/li>\n<li>N\u1ebfu \u0111i\u1ec3m \u1edf \u00f4 B2 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 ch\u1eef &#8220;\u0110\u1ea1t&#8221;.<\/li>\n<li>Ng\u01b0\u1ee3c l\u1ea1i, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 ch\u1eef &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.<\/li>\n<\/ul>\n<p>Sau \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o fill handle (\u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 C2) xu\u1ed1ng \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c h\u1ecdc sinh c\u00f2n l\u1ea1i.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-280545 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-6.jpg\" alt=\"ham-if-trong-excel-6\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-6-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-6-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3>S\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng<\/h3>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i s\u1eed d\u1ee5ng<\/span><b> h\u00e0m IF trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb b\u1eb1ng con s\u1ed1, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u1edbi gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m IF s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a ng\u01b0\u1eddi d\u00f9ng. N\u1ebfu b\u1ea1n c\u1ea7n ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng trong b\u1ea3ng t\u00ednh Excel th\u00ec h\u00e3y s\u1eed d\u1ee5ng h\u00e0m IF. C\u00f4ng th\u1ee9c nh\u1eadp h\u00e0m IF \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ch\u1eef in hoa, in th\u01b0\u1eddng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= IF (\u00f4 c\u1ea7n \u0111\u1ed1i chi\u1ebfu \u201cdelivered\u201d, \u201cYes\u201d, \u201cNo\u201d)\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280546 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-7.jpg\" alt=\"ham-if-trong-excel-7\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-7-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-7-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e2u l\u1ec7nh n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu \u00f4 trong c\u1ed9t c\u00f3 ch\u1ee9a t\u1eeb delivered \u0111\u01b0\u1ee3c vi\u1ebft th\u01b0\u1eddng th\u00ec tr\u1ea3 gi\u00e1 tr\u1ecb Yes c\u00f2n sai th\u00ec ng\u01b0\u1ee3c l\u1ea1i. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1ebd \u0111\u1ed1i chi\u1ebfu v\u00e0 lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c t\u1eeb Delivered ho\u1eb7c DELIVERED.\u00a0<\/span><\/p>\n<h3>S\u1eed d\u1ee5ng h\u00e0m IF trong Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec1 b\u00e0i y\u00eau c\u1ea7u x\u00e9t \u0111i\u1ec3m ch\u1ee9ng ch\u1ec9 ngo\u1ea1i ng\u1eef (IELTS) c\u1ee7a sinh vi\u00ean \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n t\u1ed1t nghi\u1ec7p. L\u00fac n\u00e0y, c\u00e1c b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m =IF(\u00f4 c\u1ea7n x\u00e9t \u0111i\u1ec3m&gt;=4, \u201c\u0110\u1ea1t\u201d; \u201cKh\u00f4ng \u0111\u1ea1t\u201d). M\u1ec7nh \u0111\u1ec1 n\u00e0y c\u00f3 \u00fd ngh\u0129a l\u00e0 n\u1ebfu \u0111i\u1ec3m IELTS l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 4 th\u00ec \u0111\u1ea1t v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t \u0111i\u1ec1u ki\u1ec7n x\u00e9t.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280547 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-8.jpg\" alt=\"ham-if-trong-excel-8\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-8-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-8-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: L\u01b0u \u00fd, b\u1ea1n c\u1ea7n nh\u1eadp \u0111\u1ea7y \u0111\u1ee7, ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 h\u1ec7 th\u1ed1ng tr\u1ea3 k\u1ebft qu\u1ea3 nhanh ch\u00f3ng.\u00a0\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280548 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-10.jpg\" alt=\"ham-if-trong-excel-10\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-10-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-10-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Sau khi c\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y b\u1ea5m v\u00e0o \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng sau \u0111\u00f3 d\u00f9ng chu\u1ed9t k\u00e9o \u0111\u1ebfn ng\u01b0\u1eddi cu\u1ed1i c\u00f9ng. Thao t\u00e1c n\u00e0y \u0111\u1ec3 g\u00e1n c\u00f4ng th\u1ee9c sau \u0111\u00f3 h\u1ec7 th\u1ed1ng s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a nh\u1eefng ng\u01b0\u1eddi ti\u1ebfp theo.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280549 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-11.jpg\" alt=\"ham-if-trong-excel-11\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-11-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-11-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2><strong>C\u00e1ch d\u00f9ng h\u00e0m IF n\u00e2ng cao<\/strong><\/h2>\n<p>Khi b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p h\u01a1n, m\u1ed9t h\u00e0m IF \u0111\u01a1n l\u1ebb l\u00e0 kh\u00f4ng \u0111\u1ee7. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c c\u00e1ch k\u1ebft h\u1ee3p v\u00e0 s\u1eed d\u1ee5ng h\u00e0m IF n\u00e2ng cao ph\u1ed5 bi\u1ebfn nh\u1ea5t.<\/p>\n<h3><strong>1. H\u00e0m IF l\u1ed3ng nhau (Nested IF) \u0111\u1ec3 x\u1eed l\u00fd nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h3>\n<p>H\u00e0m 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, th\u01b0\u1eddng l\u00e0 \u1edf v\u1ecb tr\u00ed\u00a0value_if_false. C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n ki\u1ec3m tra m\u1ed9t chu\u1ed7i c\u00e1c \u0111i\u1ec1u ki\u1ec7n.<br \/>\n<strong>V\u00ed d\u1ee5: X\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c (Gi\u1ecfi\/Kh\u00e1\/Trung B\u00ecnh)<\/strong><br \/>\nV\u1edbi \u0111i\u1ec3m trung b\u00ecnh \u1edf c\u1ed9t B, ta x\u1ebfp lo\u1ea1i: &gt;=8 l\u00e0 &#8220;Gi\u1ecfi&#8221;, t\u1eeb 6.5 \u0111\u1ebfn d\u01b0\u1edbi 8 l\u00e0 &#8220;Kh\u00e1&#8221;, c\u00f2n l\u1ea1i l\u00e0 &#8220;Trung B\u00ecnh&#8221;.<br \/>\nC\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C2:<br \/>\n=IF(B2&gt;=8, &#8220;Gi\u1ecfi&#8221;, IF(B2&gt;=6.5, &#8220;Kh\u00e1&#8221;, &#8220;Trung B\u00ecnh&#8221;))<br \/>\n<strong>Gi\u1ea3i th\u00edch:<\/strong><\/p>\n<ol>\n<li>\u0110\u1ea7u ti\u00ean, Excel ki\u1ec3m tra\u00a0B2&gt;=8. N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 &#8220;Gi\u1ecfi&#8221; v\u00e0 d\u1eebng l\u1ea1i.<\/li>\n<li>N\u1ebfu sai, n\u00f3 s\u1ebd th\u1ef1c hi\u1ec7n h\u00e0m IF th\u1ee9 hai: ki\u1ec3m tra\u00a0B2&gt;=6.5. N\u1ebfu \u0111\u00fang, tr\u1ea3 v\u1ec1 &#8220;Kh\u00e1&#8221;.<\/li>\n<li>N\u1ebfu c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n tr\u00ean \u0111\u1ec1u sai, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng l\u00e0 &#8220;Trung B\u00ecnh&#8221;.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280542 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-3.jpg\" alt=\"ham-if-trong-excel-3\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-3-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-3-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><strong>2. K\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi AND, OR<\/strong><\/h3>\n<ul>\n<li>H\u00e0m\u00a0AND\u00a0tr\u1ea3 v\u1ec1 TRUE ch\u1ec9 khi\u00a0<strong>t\u1ea5t c\u1ea3<\/strong>\u00a0c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u00ean trong n\u00f3 \u0111\u1ec1u \u0111\u00fang.<\/li>\n<li>H\u00e0m\u00a0OR\u00a0tr\u1ea3 v\u1ec1 TRUE n\u1ebfu\u00a0<strong>\u00edt nh\u1ea5t m\u1ed9t<\/strong>\u00a0\u0111i\u1ec1u ki\u1ec7n b\u00ean trong n\u00f3 \u0111\u00fang.<\/li>\n<\/ul>\n<p><strong>V\u00ed d\u1ee5: X\u00e9t tuy\u1ec3n khi \u0111\u1ea1t c\u1ea3 To\u00e1n v\u00e0 L\u00fd tr\u00ean 7.0<\/strong><br \/>\n\u0110i\u1ec1u ki\u1ec7n tr\u00fang tuy\u1ec3n l\u00e0 \u0111i\u1ec3m To\u00e1n (c\u1ed9t B) V\u00c0 \u0111i\u1ec3m L\u00fd (c\u1ed9t C) \u0111\u1ec1u ph\u1ea3i l\u1edbn h\u01a1n 7.<br \/>\nC\u00f4ng th\u1ee9c t\u1ea1i \u00f4 D2:<br \/>\n=IF(AND(B2&gt;7, C2&gt;7), &#8220;Tr\u00fang tuy\u1ec3n&#8221;, &#8220;Tr\u01b0\u1ee3t&#8221;)<\/p>\n<h2><strong>Gi\u1ea3i ph\u00e1p thay th\u1ebf th\u00f4ng minh cho h\u00e0m IF l\u1ed3ng nhau<\/strong><\/h2>\n<p><strong>1. H\u00e0m IFS (D\u00e0nh cho Excel 2019, Microsoft 365 tr\u1edf l\u00ean)<\/strong><br \/>\nH\u00e0m IFS cho ph\u00e9p b\u1ea1n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n l\u1ed3ng v\u00e0o nhau.<br \/>\nC\u00fa ph\u00e1p:\u00a0=IFS(\u0111i\u1ec1u_ki\u1ec7n1, gi\u00e1_tr\u1ecb1, \u0111i\u1ec1u_ki\u1ec7n2, gi\u00e1_tr\u1ecb2, &#8230;)<br \/>\n\u00c1p d\u1ee5ng l\u1ea1i v\u00ed d\u1ee5 x\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c:<br \/>\n=IFS(B2&gt;=8, &#8220;Gi\u1ecfi&#8221;, B2&gt;=6.5, &#8220;Kh\u00e1&#8221;, B2&lt;6.5, &#8220;Trung B\u00ecnh&#8221;)<br \/>\nC\u00f4ng th\u1ee9c n\u00e0y r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n nhi\u1ec1u!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280544 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-5.jpg\" alt=\"ham-if-trong-excel-5\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-5-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-5-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><br \/>\n<strong>2. H\u00e0m VLOOKUP<\/strong><br \/>\nKhi b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng tham chi\u1ebfu (v\u00ed d\u1ee5 b\u1ea3ng quy \u0111\u1ed5i \u0111i\u1ec3m sang x\u1ebfp lo\u1ea1i), VLOOKUP l\u00e0 l\u1ef1a ch\u1ecdn tuy\u1ec7t v\u1eddi. B\u1ea1n ch\u1ec9 c\u1ea7n t\u1ea1o m\u1ed9t b\u1ea3ng nh\u1ecf quy \u0111\u1ecbnh c\u00e1c m\u1ee9c \u0111i\u1ec3m v\u00e0 x\u1ebfp lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng, sau \u0111\u00f3 d\u00f9ng VLOOKUP \u0111\u1ec3 tra c\u1ee9u. C\u00e1ch n\u00e0y c\u1ef1c k\u1ef3 linh ho\u1ea1t khi c\u1ea7n c\u1eadp nh\u1eadt c\u00e1c m\u1ee9c \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<h2>L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u00ecn chung, c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c trong Excel \u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p v\u00e0 s\u1eed d\u1ee5ng trong b\u00e0i t\u1eadp ph\u00f9 h\u1ee3p. N\u1ebfu ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai d\u1ea5u nh\u00e1y ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m kh\u00f4ng \u0111\u00fang th\u00ec s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF hi\u1ec7u qu\u1ea3.\u00a0<\/span><\/p>\n<p><strong>1. L\u1ed7i\u00a0<code>#NAME?<\/code><\/strong><br \/>\n\u0110\u00e2y l\u00e0 l\u1ed7i sai t\u00ean. Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0:<\/p>\n<ul>\n<li>G\u00f5 sai t\u00ean h\u00e0m: V\u00ed d\u1ee5, g\u00f5\u00a0=OF(&#8230;)\u00a0thay v\u00ec\u00a0=IF(&#8230;).<\/li>\n<li>Gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5:\u00a0=IF(A1&gt;10, \u0110\u1ea1t, Tr\u01b0\u1ee3t). C\u00f4ng th\u1ee9c \u0111\u00fang ph\u1ea3i l\u00e0\u00a0=IF(A1&gt;10, &#8220;\u0110\u1ea1t&#8221;, &#8220;Tr\u01b0\u1ee3t&#8221;).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280551 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-13.jpg\" alt=\"ham-if-trong-excel-13\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-13-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-13-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong>\u00a0Ki\u1ec3m tra l\u1ea1i ch\u00ednh t\u1ea3 c\u1ee7a t\u00ean h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ec1u n\u1eb1m trong d\u1ea5u\u00a0&#8220;&#8221;.<\/p>\n<p><strong>2. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 0 (s\u1ed1 kh\u00f4ng)<\/strong><br \/>\nL\u1ed7i n\u00e0y x\u1ea3y ra khi b\u1ea1n b\u1ecf tr\u1ed1ng \u0111\u1ed1i s\u1ed1\u00a0value_if_true. Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh tr\u1ea3 v\u1ec1 0 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<br \/>\n<strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong>\u00a0N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb g\u00ec, h\u00e3y d\u00f9ng c\u1eb7p d\u1ea5u ngo\u1eb7c k\u00e9p\u00a0&#8220;&#8221;. V\u00ed d\u1ee5:\u00a0=IF(A1&gt;10, &#8220;&#8221;, &#8220;Gi\u00e1 tr\u1ecb sai&#8221;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-280550 aligncenter\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-12.jpg\" alt=\"ham-if-trong-excel-12\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-12-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel-12-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>Tips s\u1eed d\u1ee5ng h\u00e0m IF trong Excel hi\u1ec7u qu\u1ea3<\/h2>\n<p><span style=\"font-weight: 400;\">Trong c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n Excel th\u00ec h\u00e0m IF c\u00f3 c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u. Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n bi\u1ebft c\u00fa ph\u00e1p h\u00e0m IF \u0111\u1ec3 t\u00ecm \u0111i\u1ec1u ki\u1ec7n tho\u1ea3 m\u00e3n, ho\u1eb7c kh\u00f4ng tho\u1ea3 m\u00e3n. B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 t\u00ecm ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1edb ch\u00ednh x\u00e1c c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF, khi nh\u1eadp h\u00e0m c\u1ea7n ch\u00ednh x\u00e1c t\u1eebng d\u1ea5u \u201c\u201d, d\u1ea5u hai ch\u1ea5m.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn gi\u00e1 tr\u1ecb c\u1ee7a t\u1eebng \u00f4 tham chi\u1ebfu, \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu ph\u00f9 h\u1ee3p kh\u00f4ng?\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu th\u1ea5y l\u1ed7i #NAME c\u1ea7n x\u00e1c \u0111\u1ecbnh nguy\u00ean d\u00e2n do \u0111\u00e2u \u0111\u1ec3 t\u00ecm c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 ch\u00fang t\u00f4i \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi l\u1ed3ng <\/span><b>h\u00e0m IF trong Excel <\/b><span style=\"font-weight: 400;\">v\u1edbi c\u00e1c h\u00e0m kh\u00e1c c\u1ea7n \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c, khoa h\u1ecdc. Ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng th\u1ec3 l\u1ed3ng h\u00e0m IF v\u1edbi h\u00e0m kh\u00f4ng ph\u00f9 h\u1ee3p s\u1ebd d\u1eabn t\u1edbi k\u1ebft qu\u1ea3 sai l\u1ec7ch.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, kh\u00f4ng ch\u1ec9 h\u00e0m IF m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n th\u00e0nh th\u1ea1o c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n, thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh Excel. Ng\u01b0\u1eddi d\u00f9ng h\u00e3y kh\u00f4ng ng\u1eebng h\u1ecdc h\u1ecfi, tham gia kho\u00e1 h\u1ecdc tin h\u1ecdc v\u0103n ph\u00f2ng \u0111\u1ed3ng th\u1eddi th\u1ef1c h\u00e0nh nhi\u1ec1u h\u01a1n. Nh\u01b0 v\u1eady, ki\u1ebfn th\u1ee9c s\u1eed d\u1ee5ng h\u00e0m c\u00f4ng th\u1ee9c Excel \u0111\u01b0\u1ee3c n\u00e2ng cao gi\u00fap \u00edch nhi\u1ec1u trong c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea3n.\u00a0<\/span><\/li>\n<\/ul>\n<h2>T\u1ea1m K\u1ebft<\/h2>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft tr\u00ean, ch\u00fang t\u00f4i \u0111\u00e3 gi\u1ea3i th\u00edch <\/span><b>h\u00e0m IF trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 g\u00ec? C\u00e1ch d\u00f9ng h\u00e0m IF nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ed3ng th\u1eddi l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3. Mong r\u1eb1ng nh\u1eefng th\u00f4ng tin tr\u00ean gi\u00fap \u00edch cho b\u1ea1n trong vi\u1ec7c s\u1eed d\u1ee5ng Excel ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c. Khi s\u1eed d\u1ee5ng h\u00e0m IF b\u1ea1n c\u1ea7n l\u01b0u \u00fd nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p t\u1eebng d\u1ea5u \u201c\u201d hay d\u1ea5u hai ch\u1ea5m. B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ea3m b\u1ea3o v\u1ecb tr\u00ed \u00f4 tham chi\u1ebfu ch\u1ee9a gi\u00e1 tr\u1ecb v\u00e0 \u0111i\u1ec1u ki\u1ec7n tham chi\u1ebfu ph\u00f9 h\u1ee3p. Ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u1eafm m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 t\u00ecm c\u00e1ch kh\u1eafc ph\u1ee5c. H\u00e3y b\u1ea5m follow fanpage <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> v\u00e0 k\u00eanh Youtube <\/span><b>Ho\u00e0ng H\u00e0 Channel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin h\u1eefu \u00edch nh\u00e9!\u00a0<\/span><\/p>\n<p><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\">C\u00e1ch d\u00f9ng h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m AND trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-or\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\">#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m IF trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n n\u1ebfu \u0111\u00e1p \u1ee9ng s\u1ebd tr\u1ea3 gi\u00e1 tr\u1ecb v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. \u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch d\u00f9ng c\u1ee7a h\u00e0m IF ch\u00fang t\u00f4i s\u1ebd chia s\u1ebb chi ti\u1ebft trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. \u0110\u1ed3ng th\u1eddi, ch\u00fang t\u00f4i s\u1ebd \u0111\u01b0a ra nh\u1eefng v\u00ed d\u1ee5 [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":280540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-280538","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>H\u00e0m IF trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eeb A-Z (C\u01a1 b\u1ea3n, l\u1ed3ng nhau, k\u1ebft h\u1ee3p AND\/OR &amp; V\u00ed d\u1ee5)<\/title>\n<meta name=\"description\" content=\"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.\" \/>\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-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao\" \/>\n<meta property=\"og:description\" content=\"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/\" \/>\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=\"2023-11-04T03:52:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-18T08:50:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.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=\"H\u1ed3ng Th\u01a1\" \/>\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=\"H\u1ed3ng Th\u01a1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 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-trong-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/4566733ad8597588f8cc8f453ff5913c\"},\"headline\":\"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao\",\"datePublished\":\"2023-11-04T03:52:27+00:00\",\"dateModified\":\"2025-10-18T08:50:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/\"},\"wordCount\":2687,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-if-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/\",\"name\":\"H\u00e0m IF trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eeb A-Z (C\u01a1 b\u1ea3n, l\u1ed3ng nhau, k\u1ebft h\u1ee3p AND\\\/OR & V\u00ed d\u1ee5)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-if-trong-excel.jpg\",\"datePublished\":\"2023-11-04T03:52:27+00:00\",\"dateModified\":\"2025-10-18T08:50:46+00:00\",\"description\":\"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\\\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-if-trong-excel.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/ham-if-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-if-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-if-trong-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao\"}]},{\"@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\\\/4566733ad8597588f8cc8f453ff5913c\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/hong-tho\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m IF trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eeb A-Z (C\u01a1 b\u1ea3n, l\u1ed3ng nhau, k\u1ebft h\u1ee3p AND\/OR & V\u00ed d\u1ee5)","description":"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.","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-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao","og_description":"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-04T03:52:27+00:00","article_modified_time":"2025-10-18T08:50:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"13 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/4566733ad8597588f8cc8f453ff5913c"},"headline":"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao","datePublished":"2023-11-04T03:52:27+00:00","dateModified":"2025-10-18T08:50:46+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/"},"wordCount":2687,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/","name":"H\u00e0m IF trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eeb A-Z (C\u01a1 b\u1ea3n, l\u1ed3ng nhau, k\u1ebft h\u1ee3p AND\/OR & V\u00ed d\u1ee5)","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.jpg","datePublished":"2023-11-04T03:52:27+00:00","dateModified":"2025-10-18T08:50:46+00:00","description":"N\u1eafm v\u1eefng c\u00e1ch d\u00f9ng h\u00e0m IF trong Excel qua h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t 2024. T\u00ecm hi\u1ec3u t\u1eeb c\u00fa ph\u00e1p c\u01a1 b\u1ea3n, l\u1ed3ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, k\u1ebft h\u1ee3p h\u00e0m AND\/OR, \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-trong-excel.jpg","width":1200,"height":628,"caption":"ham-if-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch D\u00f9ng H\u00e0m IF trong Excel: To\u00e0n t\u1eadp v\u00ed d\u1ee5 t\u1eeb C\u01a1 b\u1ea3n \u0111\u1ebfn N\u00e2ng cao"}]},{"@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\/4566733ad8597588f8cc8f453ff5913c","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/341a9928cf519382cd17655b5972243f557cc88efa3a31f0e8a8553d2d88b30b?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280538","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\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=280538"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/280538\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/280540"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=280538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=280538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=280538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}