{"id":314751,"date":"2024-02-06T20:49:36","date_gmt":"2024-02-06T13:49:36","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=314751"},"modified":"2024-02-06T20:49:36","modified_gmt":"2024-02-06T13:49:36","slug":"ham-iferror","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/","title":{"rendered":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<p>Trong Excel, khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p, l\u1ed7i l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00e1ng ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u, vi\u1ec7c b\u1eaft l\u1ed7i v\u00e0 x\u1eed l\u00fd ch\u00fang l\u00e0 r\u1ea5t quan tr\u1ecdng. \u0110\u00f3 l\u00e0 l\u00fac <strong>h\u00e0m IFERROR<\/strong> trong Excel tr\u1edf n\u00ean v\u00f4 c\u00f9ng h\u1eefu \u00edch. V\u1edbi kh\u1ea3 n\u0103ng x\u1eed l\u00fd linh ho\u1ea1t, h\u00e0m n\u00e0y trong Excel cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u00e0 x\u1eed l\u00fd nh\u1eefng l\u1ed7i m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<h2>H\u00e0m IFERROR trong Excel l\u00e0 g\u00ec?<\/h2>\n<p>H\u00e0m IFERROR trong Excel l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i trong c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n. Khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh trong Excel, c\u00f3 th\u1ec3 x\u1ea3y ra c\u00e1c l\u1ed7i nh\u01b0 l\u1ed7i chia cho 0, l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, ho\u1eb7c l\u1ed7i kh\u00e1c. H\u00e0m n\u00e0y gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u00e0 x\u1eed l\u00fd nh\u1eefng l\u1ed7i n\u00e0y m\u1ed9t c\u00e1ch linh ho\u1ea1t v\u00e0 ti\u1ec7n l\u1ee3i. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 sau: <strong>IFERROR(value, value_if_error)<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>Value l\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra l\u1ed7i.<\/li>\n<li>Value_if_error l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra.<\/li>\n<\/ul>\n<p>Khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m IFERROR, Excel s\u1ebd ki\u1ec3m tra gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c cho. N\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i, gi\u00e1 tr\u1ecb \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong value_if_error s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-314931 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-11.jpg\" alt=\"ham-iferror-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>V\u00ed d\u1ee5, gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c A1\/B1 \u0111\u1ec3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m. Tuy nhi\u00ean, n\u1ebfu B1 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0, c\u00f4ng th\u1ee9c s\u1ebd g\u00e2y ra l\u1ed7i chia cho 0. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng IFERROR nh\u01b0 sau: <strong>=IFERROR(A1\/B1, &#8220;Error: Divided by zero&#8221;). <\/strong>N\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i x\u1ea3y ra, k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh A1\/B1 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. Tuy nhi\u00ean, n\u1ebfu c\u00f3 l\u1ed7i chia cho 0, thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i, chu\u1ed7i &#8220;Error: Divided by zero&#8221; s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb thay th\u1ebf.<\/p>\n<h2>C\u00f4ng th\u1ee9c h\u00e0m IFERROR trong Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i n\u00e0o?<\/h2>\n<p>H\u00e0m IFERROR trong Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd nhi\u1ec1u lo\u1ea1i l\u1ed7i kh\u00e1c nhau trong c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n. S\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1ch x\u1eed l\u00fd l\u1ed7i v\u00e0 quy\u1ebft \u0111\u1ecbnh gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn m\u00e0 IFERROR c\u00f3 th\u1ec3 x\u1eed l\u00fd:<\/p>\n<ul>\n<li><strong>L\u1ed7i chia cho 0 (Divide by Zero Error):<\/strong> Khi b\u1ea1n chia m\u1ed9t s\u1ed1 cho 0 trong m\u1ed9t c\u00f4ng th\u1ee9c, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i &#8220;#DIV\/0!&#8221;. H\u00e0m IFERROR c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd l\u1ed7i n\u00e0y b\u1eb1ng c\u00e1ch tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/li>\n<li><strong>L\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb (Value Not Found Error):<\/strong> Khi b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t t\u00ecm ki\u1ebfm trong m\u1ed9t ph\u1ea1m vi nh\u01b0 h\u00e0m VLOOKUP ho\u1eb7c INDEX-MATCH v\u00e0 kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb kh\u1edbp, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i &#8220;#N\/A&#8221;. H\u00e0m IFERROR c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd l\u1ed7i n\u00e0y b\u1eb1ng c\u00e1ch tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/li>\n<li><strong>L\u1ed7i tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 (Invalid Reference Error):<\/strong> Khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 trong c\u00f4ng th\u1ee9c, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i &#8220;#REF!&#8221;. IFERROR c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd l\u1ed7i n\u00e0y b\u1eb1ng c\u00e1ch tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/li>\n<li><strong>L\u1ed7i gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7 (Invalid Value Error):<\/strong> Khi b\u1ea1n cung c\u1ea5p m\u1ed9t gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7 cho m\u1ed9t h\u00e0m ho\u1eb7c c\u00f4ng th\u1ee9c, Excel c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb l\u1ed7i ph\u00f9 h\u1ee3p nh\u01b0 &#8220;#VALUE!&#8221; ho\u1eb7c &#8220;#NUM!&#8221;. IFERROR c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c l\u1ed7i gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7 n\u00e0y b\u1eb1ng c\u00e1ch tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-314930 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-10.jpg\" alt=\"ham-iferror-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng c\u1ee7a IFERROR trong Excel<\/h2>\n<p>V\u1edbi c\u00fa ph\u00e1p \u0111\u01a1n gi\u1ea3n IFERROR(value, value_if_error), b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u t\u00e1c v\u1ee5 kh\u00e1c nhau. B\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd l\u1ed7i chia cho 0, l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, l\u1ed7i tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 nhi\u1ec1u l\u1ed7i kh\u00e1c n\u1eefa. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh gi\u00e1 tr\u1ecb_if_error \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o ho\u1eb7c gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u ki\u1ec3m tra t\u00ednh to\u00e1n c\u1ee7a m\u00ecnh.<\/p>\n<h3>C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IFERROR v\u1edbi h\u00e0m VLOOKUP<\/h3>\n<p>Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m IFERROR v\u00e0 VLOOKUP gi\u00fap b\u1ea1n t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u v\u00e0 x\u1eed l\u00fd m\u1ed9t c\u00e1ch linh ho\u1ea1t khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb mong mu\u1ed1n.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 gi\u00e1 c\u1ee7a ch\u00fang nh\u01b0 sau:<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-314932 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-2.jpg\" alt=\"ham-iferror-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u1ea1n d\u00f9ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm gi\u00e1 c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3 v\u00e0 n\u1ebfu s\u1ea3n ph\u1ea9m kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng d\u1eef li\u1ec7u, h\u00e0m VLOOKUP s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i &#8220;#N\/A&#8221;. B\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o thay v\u00ec &#8220;#N\/A&#8221;, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1.<\/strong> \u0110\u1ea7u ti\u00ean, h\u00e3y x\u00e1c \u0111\u1ecbnh \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n nh\u1eadp t\u00ean s\u1ea3n ph\u1ea9m m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1. V\u00ed d\u1ee5, \u0111\u1eb7t t\u00ean \u00f4 n\u00e0y l\u00e0 &#8220;T\u00ean s\u1ea3n ph\u1ea9m&#8221; trong \u00f4 C2.<\/p>\n<p><strong>B\u01b0\u1edbc 2.<\/strong> Sau \u0111\u00f3, trong \u00f4 D2, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: <strong>=IFERROR(VLOOKUP(C2, A2:B4, 2, FALSE), &#8220;Kh\u00f4ng t\u00ecm th\u1ea5y s\u1ea3n ph\u1ea9m&#8221;)<\/strong><\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li>C2 l\u00e0 \u00f4 ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1.<\/li>\n<li>A2:B4 l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm. \u00d4 A2 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t &#8220;S\u1ea3n ph\u1ea9m&#8221;, v\u00e0 \u00f4 B4 l\u00e0 \u00f4 cu\u1ed1i c\u00f9ng trong c\u1ed9t &#8220;Gi\u00e1&#8221;.<\/li>\n<li>2 l\u00e0 s\u1ed1 c\u1ed9t trong ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1. V\u00ec gi\u00e1 n\u1eb1m \u1edf c\u1ed9t th\u1ee9 2 (c\u1ed9t B), n\u00ean b\u1ea1n s\u1eed d\u1ee5ng s\u1ed1 2.<\/li>\n<li>FALSE l\u00e0 \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh r\u1eb1ng b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c theo t\u00ean s\u1ea3n ph\u1ea9m.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<ul>\n<li>N\u1ebfu t\u00ean s\u1ea3n ph\u1ea9m c\u00f3 trong b\u1ea3ng d\u1eef li\u1ec7u, gi\u00e1 c\u1ee7a s\u1ea3n ph\u1ea9m \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/li>\n<li>N\u1ebfu t\u00ean s\u1ea3n ph\u1ea9m kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng d\u1eef li\u1ec7u, chu\u1ed7i &#8220;Kh\u00f4ng t\u00ecm th\u1ea5y s\u1ea3n ph\u1ea9m&#8221; s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb thay v\u00ec l\u1ed7i &#8220;#N\/A&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314933 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-3.jpg\" alt=\"ham-iferror-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch d\u00f9ng h\u00e0m IFERROR k\u1ebft h\u1ee3p h\u00e0m IF<\/h3>\n<p>K\u1ebft h\u1ee3p hai h\u00e0m IF v\u00e0 IFERROR trong Excel cho ph\u00e9p b\u1ea1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch linh ho\u1ea1t. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p so s\u00e1nh, ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng \u0111\u1eb7c bi\u1ec7t trong c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n c\u1ee7a m\u00ecnh.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a ch\u00fang nh\u01b0 sau:<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314934 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-4.jpg\" alt=\"ham-iferror-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u1ea1n mu\u1ed1n ki\u1ec3m tra xem s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m c\u00f3 l\u1edbn h\u01a1n 0 hay kh\u00f4ng. N\u1ebfu t\u1ed3n kho l\u1edbn h\u01a1n 0, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o &#8220;C\u00f2n h\u00e0ng&#8221; v\u00e0 n\u1ebfu kh\u00f4ng, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o &#8220;H\u1ebft h\u00e0ng&#8221;.<\/p>\n<p>Trong \u00f4 C2 (th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi \u00f4 C3, C4 \u0111\u1ec3 ki\u1ec3m tra t\u1ed3n kho s\u1ea3n ph\u1ea9m B v\u00e0 C), b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau: =IFERROR(IF(B2&gt;0, &#8220;C\u00f2n h\u00e0ng&#8221;, &#8220;H\u1ebft h\u00e0ng&#8221;), &#8220;Kh\u00f4ng c\u00f3 th\u00f4ng tin&#8221;)<\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li>B2 l\u00e0 \u00f4 ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a s\u1ea3n ph\u1ea9m.<\/li>\n<li>N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn h\u01a1n 0 (B2&gt;0), h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i &#8220;C\u00f2n h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho kh\u00f4ng l\u1edbn h\u01a1n 0, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i &#8220;H\u1ebft h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu \u00f4 B2 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f3 l\u1ed7i, h\u00e0m IFERROR s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i &#8220;Kh\u00f4ng c\u00f3 th\u00f4ng tin&#8221; thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<ul>\n<li>N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn h\u01a1n 0, \u00f4 B2 s\u1ebd hi\u1ec3n th\u1ecb &#8220;C\u00f2n h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho l\u00e0 0, \u00f4 B2 s\u1ebd hi\u1ec3n th\u1ecb &#8220;H\u1ebft h\u00e0ng&#8221;.<\/li>\n<li>N\u1ebfu \u00f4 B2 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f3 l\u1ed7i, \u00f4 B2 s\u1ebd hi\u1ec3n th\u1ecb &#8220;Kh\u00f4ng c\u00f3 th\u00f4ng tin&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314936 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-6.jpg\" alt=\"ham-iferror-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch d\u00f9ng h\u00e0m IFERROR k\u1ebft h\u1ee3p h\u00e0m CONCATENATE<\/h3>\n<p>H\u00e0m CONCATENATE trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t. Khi k\u1ebft h\u1ee3p v\u1edbi IFERROR, b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u1ed7i v\u00e0 k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n theo y\u00eau c\u1ea7u.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p hai chu\u1ed7i v\u0103n b\u1ea3n trong hai \u00f4 A1 v\u00e0 B1 th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t trong \u00f4 C1. Tuy nhi\u00ean, n\u1ebfu m\u1ed9t trong hai \u00f4 A1 ho\u1eb7c B1 r\u1ed7ng, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb m\u1ed9t chu\u1ed7i th\u00f4ng b\u00e1o thay v\u00ec k\u1ebft qu\u1ea3 r\u1ed7ng.<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314928 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-8.jpg\" alt=\"ham-iferror-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau trong \u00f4 C1: =IFERROR(CONCATENATE(A1, B1), &#8220;Chu\u1ed7i r\u1ed7ng&#8221;)<\/p>\n<p>Trong c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<ul>\n<li>A1 v\u00e0 B1 l\u00e0 c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p.<\/li>\n<li>H\u00e0m CONCATENATE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 k\u1ebft h\u1ee3p hai chu\u1ed7i A1 v\u00e0 B1 th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t.<\/li>\n<li>N\u1ebfu qu\u00e1 tr\u00ecnh k\u1ebft h\u1ee3p th\u00e0nh c\u00f4ng, k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 C1.<\/li>\n<li>N\u1ebfu \u00f4 A1 ho\u1eb7c B1 r\u1ed7ng ho\u1eb7c c\u00f3 l\u1ed7i x\u1ea3y ra trong qu\u00e1 tr\u00ecnh k\u1ebft h\u1ee3p, h\u00e0m IFERROR s\u1ebd tr\u1ea3 v\u1ec1 chu\u1ed7i &#8220;Chu\u1ed7i r\u1ed7ng&#8221; thay v\u00ec hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 r\u1ed7ng.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<ul>\n<li>N\u1ebfu c\u1ea3 hai \u00f4 A1 v\u00e0 B1 \u0111\u1ec1u ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n, k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c k\u1ebft h\u1ee3p s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 C1.<\/li>\n<li>N\u1ebfu m\u1ed9t trong hai \u00f4 A1 ho\u1eb7c B1 r\u1ed7ng, \u00f4 C1 s\u1ebd hi\u1ec3n th\u1ecb chu\u1ed7i th\u00f4ng b\u00e1o &#8220;Chu\u1ed7i r\u1ed7ng&#8221;.<\/li>\n<li>N\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra trong qu\u00e1 tr\u00ecnh k\u1ebft h\u1ee3p, \u00f4 C1 c\u0169ng s\u1ebd hi\u1ec3n th\u1ecb chu\u1ed7i th\u00f4ng b\u00e1o &#8220;Chu\u1ed7i r\u1ed7ng&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314929 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-9.jpg\" alt=\"ham-iferror-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 id=\"1112678681973\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a IFERROR trong Excel<\/h2>\n<p>H\u00e0m IFERROR trong Excel c\u00f3 nhi\u1ec1u \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf h\u1eefu \u00edch.<\/p>\n<ul>\n<li><strong>X\u1eed l\u00fd l\u1ed7i trong c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n:<\/strong> Khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m k\u1ebft h\u1ee3p, c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i nh\u01b0 chia cho 0, tham chi\u1ebfu \u00f4 kh\u00f4ng t\u1ed3n t\u1ea1i,.. vi\u1ec7c s\u1eed d\u1ee5ng IFERROR gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c l\u1ed7i n\u00e0y v\u00e0 hi\u1ec3n th\u1ecb m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c th\u00f4ng b\u00e1o thay v\u00ec l\u1ed7i.<\/li>\n<li><strong>X\u1eed l\u00fd l\u1ed7i trong t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u:<\/strong> Khi b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm nh\u01b0 VLOOKUP ho\u1eb7c INDEX\/MATCH \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u, c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i khi gi\u00e1 tr\u1ecb kh\u00f4ng t\u1ed3n t\u1ea1i. IFERROR cho ph\u00e9p b\u1ea1n x\u1eed l\u00fd l\u1ed7i n\u00e0y v\u00e0 hi\u1ec3n th\u1ecb m\u1ed9t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh ho\u1eb7c th\u00f4ng b\u00e1o thay v\u00ec l\u1ed7i.<\/li>\n<li><strong>X\u1eed l\u00fd l\u1ed7i trong c\u00f4ng th\u1ee9c SUM ho\u1eb7c AVERAGE:<\/strong> Khi b\u1ea1n t\u00ednh t\u1ed5ng ho\u1eb7c trung b\u00ecnh c\u1ee7a m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u, c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i n\u1ebfu c\u00f3 \u00f4 trong ph\u1ea1m vi kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1. IFERROR cho ph\u00e9p b\u1ea1n x\u1eed l\u00fd l\u1ed7i n\u00e0y v\u00e0 t\u00ednh to\u00e1n t\u1ed5ng ho\u1eb7c trung b\u00ecnh c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 trong ph\u1ea1m vi.<\/li>\n<li><strong>X\u1eed l\u00fd l\u1ed7i trong c\u00f4ng th\u1ee9c h\u1ed7n h\u1ee3p:<\/strong> Khi b\u1ea1n k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m v\u00e0 c\u00e1c ph\u00e9p to\u00e1n trong m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i. IFERROR gi\u00fap x\u1eed l\u00fd c\u00e1c l\u1ed7i n\u00e0y v\u00e0 hi\u1ec3n th\u1ecb m\u1ed9t gi\u00e1 tr\u1ecb ho\u1eb7c th\u00f4ng b\u00e1o ph\u00f9 h\u1ee3p.<\/li>\n<li><strong>Hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i t\u00f9y ch\u1ec9nh:<\/strong> B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng IFERROR \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i t\u00f9y ch\u1ec9nh cho ng\u01b0\u1eddi d\u00f9ng. Thay v\u00ec hi\u1ec3n th\u1ecb l\u1ed7i m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o th\u00f4ng b\u00e1o l\u1ed7i ri\u00eang \u0111\u1ec3 gi\u1ea3i th\u00edch v\u1ea5n \u0111\u1ec1 ho\u1eb7c cung c\u1ea5p h\u01b0\u1edbng d\u1eabn cho ng\u01b0\u1eddi d\u00f9ng.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314941 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-15.jpg\" alt=\"ham-iferror-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>H\u00e0m IFERROR h\u1ed7 tr\u1ee3 d\u00f9ng cho phi\u00ean b\u1ea3n n\u00e0o trong Excel<\/h2>\n<p>H\u00e0m IFERROR \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 trong c\u00e1c phi\u00ean b\u1ea3n Excel t\u1eeb Excel 2007 tr\u1edf \u0111i. Do \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y trong c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n tr\u00ean Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 v\u00e0 phi\u00ean b\u1ea3n m\u1edbi h\u01a1n bao g\u1ed3m c\u1ea3 Office 365. C\u00fa ph\u00e1p c\u1ee7a IFERROR kh\u00f4ng c\u00f3 s\u1ef1 thay \u0111\u1ed5i qu\u00e1 kh\u00e1c bi\u1ec7t qua c\u00e1c phi\u00ean b\u1ea3n Excel, v\u00ec v\u1eady b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f9ng m\u1ed9t c\u00fa ph\u00e1p c\u01a1 b\u1ea3n trong b\u00e0i vi\u1ebft n\u00e0y cho c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau c\u1ee7a Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111ang s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/02\/ham-iferror-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-314940 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-14.jpg\" alt=\"ham-iferror-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd r\u1eb1ng IFERROR kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 trong c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n nh\u01b0 Excel 2003 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3. N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng m\u1ed9t phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ISERROR k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 ho\u1eb7c t\u1ea3i v\u1ec1 Excel phi\u00ean b\u1ea3n h\u1ed7 tr\u1ee3.<\/p>\n<h2>T\u1ea1m k\u1ebft<\/h2>\n<p>Qua b\u00e0i vi\u1ebft t\u1ed5ng h\u1ee3p n\u00e0y, <a href=\"https:\/\/hoanghamobile.com\/\">Ho\u00e0ng H\u00e0 Mobile<\/a> hy v\u1ecdng b\u1ea1n \u0111\u00e3 c\u00f3 \u0111\u1ee7 th\u00f4ng tin \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o. IFERROR gi\u00fap b\u1ea1n ki\u1ec3m tra c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 gi\u00e1 tr\u1ecb trong Excel, v\u00e0 n\u1ebfu c\u00f3 l\u1ed7i x\u1ea3y ra, b\u1ea1n c\u00f3 th\u1ec3 quy\u1ebft \u0111\u1ecbnh gi\u00e1 tr\u1ecb n\u00e0o s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb thay v\u00ec l\u1ed7i. Do \u0111\u00f3, v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 t\u0103ng t\u00ednh \u1ed5n \u0111\u1ecbnh v\u00e0 \u0111\u00e1ng tin c\u1eady cho c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n trong Excel. B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.<\/p>\n<p>XEM TH\u00caM:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\">H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/hlookup\/\">H\u00e0m HLOOKUP trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 s\u1eed d\u1ee5ng d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong Excel, khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p, l\u1ed7i l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00e1ng ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u, vi\u1ec7c b\u1eaft l\u1ed7i v\u00e0 x\u1eed l\u00fd ch\u00fang l\u00e0 r\u1ea5t quan tr\u1ecdng. \u0110\u00f3 l\u00e0 l\u00fac h\u00e0m IFERROR trong Excel tr\u1edf n\u00ean v\u00f4 c\u00f9ng h\u1eefu [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":314939,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-314751","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>H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.\" \/>\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-iferror\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\" \/>\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=\"2024-02-06T13:49:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.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=\"14 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-iferror\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\"},\"headline\":\"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3\",\"datePublished\":\"2024-02-06T13:49:36+00:00\",\"dateModified\":\"2024-02-06T13:49:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\"},\"wordCount\":3274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.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-iferror\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\",\"name\":\"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg\",\"datePublished\":\"2024-02-06T13:49:36+00:00\",\"dateModified\":\"2024-02-06T13:49:36+00:00\",\"description\":\"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-iferror-trong-excel-13\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3\"}]},{\"@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":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3","description":"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.","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-iferror\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3","og_description":"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-02-06T13:49:36+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.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":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0"},"headline":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3","datePublished":"2024-02-06T13:49:36+00:00","dateModified":"2024-02-06T13:49:36+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/"},"wordCount":3274,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.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-iferror\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/","name":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg","datePublished":"2024-02-06T13:49:36+00:00","dateModified":"2024-02-06T13:49:36+00:00","description":"H\u00e0m IFERROR gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t v\u00e0 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, t\u1eeb \u0111\u00f3 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u00fang \u0111\u1eafn h\u01a1n.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/02\/ham-iferror-13.jpg","width":1200,"height":628,"caption":"ham-iferror-trong-excel-13"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-iferror\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u00e0m IFERROR trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 b\u1eaft l\u1ed7i hi\u1ec7u qu\u1ea3"}]},{"@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\/314751","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=314751"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/314751\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/314939"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=314751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=314751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=314751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}