{"id":225860,"date":"2023-07-03T20:39:58","date_gmt":"2023-07-03T13:39:58","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=225860"},"modified":"2023-07-03T20:39:58","modified_gmt":"2023-07-03T13:39:58","slug":"cac-cach-sua-loi-value-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/","title":{"rendered":"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp sai h\u00e0m ho\u1eb7c sai \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u. Khi \u0111\u00f3, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i Value thay v\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m. V\u1eady nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda <\/span><b>l\u1ed7i Value trong Excel <\/b><span style=\"font-weight: 400;\">nh\u01b0 th\u1ebf n\u00e0o, c\u00f3 kh\u00f3 kh\u00f4ng? H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u ngay b\u00e2y gi\u1edd nh\u00e9.<\/span><\/p>\n<h2><b>L\u1ed7i Value trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t m\u00e0 ng\u01b0\u1eddi d\u00f9ng Excel hay g\u1eb7p ph\u1ea3i, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi s\u1eed d\u1ee5ng h\u00e0m. D\u1ea5u hi\u1ec7u nh\u1eadn bi\u1ebft l\u1ed7i n\u00e0y l\u00e0 b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec3n th\u1ecb \u201c<\/span><b>#VALUE!<\/b><span style=\"font-weight: 400;\">\u201d sau khi nh\u1eadp h\u00e0m, thay v\u00ec m\u1ed9t gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-225863 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-1.jpg\" alt=\"loi-value-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>C\u00e1c nguy\u00ean nh\u00e2n ch\u00ednh g\u00e2y ra l\u1ed7i Value trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i #VALUE! trong Excel, v\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft h\u1ebft c\u00e1c nguy\u00ean nh\u00e2n n\u00e0y \u0111\u1ec3 t\u00ecm ra c\u00e1ch kh\u1eafc ph\u1ee5c ph\u00f9 h\u1ee3p. C\u1ee5 th\u1ec3:<\/span><\/p>\n<h3><b>L\u1ed7i Value do sai \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n c\u1ed1 g\u1eafng th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0m tr\u00ean c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng ph\u00f9 h\u1ee3p th\u00ec Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i Value. V\u00ed d\u1ee5: B\u1ea1n c\u00f3 c\u00e1c d\u1ea3i \u00f4 d\u1eef li\u1ec7u v\u1eeba ch\u1ee9a v\u0103n b\u1ea3n v\u1eeba ch\u1ee9a s\u1ed1, nh\u01b0ng l\u1ea1i th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia tr\u00ean d\u1ea3i \u00f4 \u0111\u00f3.<\/span><\/p>\n<figure id=\"attachment_225864\" aria-describedby=\"caption-attachment-225864\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-225864 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-2.jpg\" alt=\"loi-value-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225864\" class=\"wp-caption-text\"><em>Sai \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u g\u00e2y ra l\u1ed7i #VALUE! trong Excel<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">V\u1edbi nguy\u00ean nh\u00e2n n\u00e0y, sau \u0111\u00e2y l\u00e0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p hay g\u1eb7p ph\u1ea3i nh\u1ea5t:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong d\u1ea3i \u00f4 c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1ed1ng tr\u1eafng<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong d\u1ea3i \u00f4 c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t kh\u00f4ng ph\u1ea3i s\u1ed1<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">C\u00e1c tr\u01b0\u1eddng h\u1ee3p tr\u00ean \u0111\u00e2y \u0111\u1ec1u g\u00e2y ra l\u1ed7i Value trong Excel ngay t\u1ea1i \u00f4 nh\u1eadp h\u00e0m.<\/span><\/p>\n<h3><b>L\u1ed7i Value do sai h\u00e0m<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c nh\u1eadp sai h\u00e0m c\u0169ng g\u00e2y ra l\u1ed7i #VALUE! v\u00ec Excel kh\u00f4ng th\u1ec3 hi\u1ec3u \u00fd ngh\u0129a h\u00e0m \u0111\u00f3. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp =SUM(A1:A3 B1:B3) th\u00ec \u0111\u00e2y l\u00e0 c\u1ea5u tr\u00fac h\u00e0m sai v\u00ec thi\u1ebfu d\u1ea5u ph\u1ea9y (,) ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c tham s\u1ed1 c\u1ee7a h\u00e0m.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m \u0111\u00fang s\u1ebd l\u00e0: =SUM(A1:A3, B1:B3) ho\u1eb7c =SUM(A1:A3; B1:B3)<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-225865 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-3.jpg\" alt=\"loi-value-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, n\u1ebfu nh\u1eadp sai ch\u00ednh t\u1ea3 t\u00ean h\u00e0m th\u00ec Excel c\u0169ng s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i Value.<\/span><\/p>\n<p><b>Ch\u00fa \u00fd: <\/b><span style=\"font-weight: 400;\">Vi\u1ec7c d\u00f9ng d\u1ea5u (,) hay (;) \u0111\u1ec3 ng\u0103n c\u00e1ch c\u00e1ch c\u00e1c tham s\u1ed1 t\u00f9y thu\u1ed9c v\u00e0o c\u00e0i \u0111\u1eb7t c\u1ee7a b\u1ea1n nh\u00e9.<\/span><\/p>\n<h3><b>L\u1ed7i Value trong Excel do tham chi\u1ebfu<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t cell kh\u00f4ng t\u1ed3n t\u1ea1i ho\u1eb7c ch\u01b0a c\u00f3 d\u1eef li\u1ec7u, l\u1ed7i Value c\u0169ng c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p chia cho s\u1ed1 kh\u00f4ng, Excel c\u0169ng s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i Value.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =A1\/B1 trong m\u1ed9t \u00f4 nh\u01b0ng B1 l\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p chia cho s\u1ed1 0 v\u00e0 s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i Value.<\/span><\/p>\n<figure id=\"attachment_225866\" aria-describedby=\"caption-attachment-225866\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225866 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-4.jpg\" alt=\"loi-value-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225866\" class=\"wp-caption-text\"><em>Tham chi\u1ebfu \u0111\u1ebfn \u00f4 tr\u1ed1ng g\u00e2y ra l\u1ed7i Value khi th\u1ef1c hi\u1ec7n ph\u00e9p chia<\/em><\/figcaption><\/figure>\n<h3><b>L\u1ed7i Value li\u00ean quan \u0111\u1ebfn ph\u00e9p t\u00ednh<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng, \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia trong Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c d\u1ea5u + &#8211; * \/. Tuy nhi\u00ean, n\u1ebfu m\u1ed9t trong c\u00e1c tham s\u1ed1 c\u1ed9ng v\u00e0o kh\u00f4ng ph\u1ea3i s\u1ed1 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 l\u1ed7i #VALUE!.<\/span><\/p>\n<p style=\"text-align: center;\"><i><span style=\"font-weight: 400;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225867 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-5.jpg\" alt=\"loi-value-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/span><\/i><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eeda l\u1ed7i Value trong Excel nhanh ch\u00f3ng<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c nguy\u00ean nh\u00e2n, b\u1ea1n n\u00ean \u00e1p d\u1ee5ng c\u00e1c c\u00e1ch s\u1eeda l\u1ed7i ph\u00f9 h\u1ee3p. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch s\u1eeda l\u1ed7i Value m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/span><\/p>\n<h3><b>S\u1eeda l\u1ed7i Value trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 \u201cError Checking\u201d<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u201cError Checking\u201d l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch trong Excel, gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u00e0 kh\u1eafc ph\u1ee5c l\u1ed7i Value. \u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn v\u00e0o \u00f4 ch\u1ee9a l\u1ed7i, sau \u0111\u00f3 ch\u1ecdn \u201cFormulas\u201d &gt; \u201cError Checking\u201d. Excel s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ecbnh v\u1ecb l\u1ed7i v\u00e0 g\u1ee3i \u00fd c\u00e1ch kh\u1eafc ph\u1ee5c ph\u00f9 h\u1ee3p.<\/span><\/p>\n<figure id=\"attachment_225868\" aria-describedby=\"caption-attachment-225868\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225868 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-6.jpg\" alt=\"loi-value-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225868\" class=\"wp-caption-text\"><em>S\u1eed d\u1ee5ng \u201cError Checking\u201d \u0111\u1ec3 check v\u00e0 s\u1eeda l\u1ed7i #Value!<\/em><\/figcaption><\/figure>\n<h3><b>S\u1eeda l\u1ed7i Value trong Excel li\u00ean quan \u0111\u1ebfn \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 c\u1ed9ng nh\u1ea7m gi\u1eefa d\u1ea1ng d\u1eef li\u1ec7u s\u1ed1 v\u00e0 v\u0103n b\u1ea3n. Sau \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i Value trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y:<\/span><\/p>\n<p><b>1. L\u1ed7i Value khi c\u1ed9ng c\u00e1c \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1eafng<\/b><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225869 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-7.jpg\" alt=\"loi-value-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u \u0111ang l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n \u201cCtrl + H\u201d \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Find &amp; Replace v\u00e0 ti\u1ebfn h\u00e0nh 3 b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u1ede \u00f4 \u201cfind what\u201d: nh\u1eadp m\u1ed9t kho\u1ea3ng tr\u1eafng (d\u1ea5u c\u00e1ch)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u1ede \u00f4 \u201cReplace with\u201d: \u0111\u1ec3 tr\u1ed1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1ea5n Replace All \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c kho\u1ea3ng tr\u1eafng trong c\u00e1c \u00f4 thu\u1ed9c v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-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-225870 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-8.jpg\" alt=\"loi-value-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-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-225871 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-9.jpg\" alt=\"loi-value-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>2. L\u1ed7i Value trong Excel khi c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/b><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225872 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-10.jpg\" alt=\"loi-value-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1o m\u1ed9t c\u1ed9t \u201cTEST\u201d \u1edf b\u00ean ph\u1ea3i v\u00e0 s\u1eed d\u1ee5ng h\u00e0m \u201cISTEXT\u201d \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: K\u00e9o tr\u1ecf chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 \u00e1p d\u1ee5ng h\u00e0m cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong v\u00f9ng d\u1eef li\u1ec7u.<\/span><\/p>\n<figure id=\"attachment_225873\" aria-describedby=\"caption-attachment-225873\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225873 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-11.jpg\" alt=\"loi-value-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225873\" class=\"wp-caption-text\"><em>S\u1eed d\u1ee5ng ISTEXT \u0111\u1ec3 ki\u1ec3m tra c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u00d4 n\u00e0o hi\u1ec7n k\u1ebft qu\u1ea3 l\u00e0 \u201cTRUE\u201d th\u00ec \u00f4 \u0111\u00f3 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 v\u0103n b\u1ea3n. B\u1ea1n c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh c\u00e1c \u00f4 \u0111\u00f3 cho \u0111\u1ebfn khi to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb l\u00e0 \u201cFALSE\u201d &#8211; ngh\u0129a l\u00e0 kh\u00f4ng c\u00f2n \u00f4 n\u00e0o ch\u1ee9a v\u0103n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225874 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-12.jpg\" alt=\"loi-value-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>S\u1eeda l\u1ed7i Value trong Excel li\u00ean quan \u0111\u1ebfn tham chi\u1ebfu<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi l\u1ed7i tham chi\u1ebfu, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i xem c\u00e1c \u00f4 tham chi\u1ebfu \u0111\u1ebfn c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 hay ch\u01b0a. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n ph\u00e9p chia th\u00ec \u00f4 tham chi\u1ebfu m\u1eabu s\u1ed1 ph\u1ea3i kh\u00e1c 0. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp h\u00e0m sau \u0111\u00e2y \u0111\u1ec3 thay gi\u00e1 tr\u1ecb \u201c#VALUE!\u201d th\u00e0nh \u201cError\u201d (n\u1ebfu kh\u00f4ng chia \u0111\u01b0\u1ee3c).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=IF(A4=0, \u201cError\u201d, B4\/A4)<\/span><\/p>\n<figure id=\"attachment_225875\" aria-describedby=\"caption-attachment-225875\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225875 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-13.jpg\" alt=\"loi-value-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225875\" class=\"wp-caption-text\"><em>C\u00e1ch s\u1eeda l\u1ed7i Value trong Excel v\u1edbi ph\u00e9p chia kh\u00f4ng \u0111\u00fang<\/em><\/figcaption><\/figure>\n<h3><b>S\u1eeda l\u1ed7i Value trong Excel ph\u00e9p nh\u00e2n, chia, c\u1ed9ng, tr\u1eeb<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Thay v\u00ec s\u1eed d\u1ee5ng d\u1ea5u * hay + \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n v\u00e0 c\u1ed9ng, b\u1ea1n n\u00ean d\u00f9ng c\u00e1c h\u00e0m c\u00f3 s\u1eb5n trong Excel. C\u00e1c h\u00e0m n\u00e0y ch\u1ec9 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u1edbi c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p n\u00ean h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c l\u1ed7i Value.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m c\u1ed9ng: =SUM<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-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-225876 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-14.jpg\" alt=\"loi-value-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m nh\u00e2n: =PRODUCT<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-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-225877 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-15.jpg\" alt=\"loi-value-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>M\u1eb9o: <\/b><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi v\u00e0 mu\u1ed1n h\u1ecdc Excel c\u01a1 b\u1ea3n, h\u00e3y tham kh\u1ea3o <\/span><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/hoc-excel-co-ban-tu-a-z-cuc-chi-tiet-de-hieu-danh-cho-nguoi-moi\"><span style=\"font-weight: 400;\">h\u01b0\u1edbng d\u1eabn chi ti\u1ebft \u1edf \u0111\u00e2y<\/span><\/a><span style=\"font-weight: 400;\"> nh\u00e9!<\/span><\/p>\n<h2><b>C\u00e1ch s\u1eeda l\u1ed7i Value trong Excel khi d\u00f9ng v\u1edbi c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 SUM, AVERAGE, SUMIF, COUNTIF, ng\u01b0\u1eddi d\u00f9ngr\u1ea5t hay g\u1eb7p l\u1ed7i Value. V\u1eady l\u00e0m sao \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y v\u00e0 cho ra k\u1ebft qu\u1ea3 \u0111\u00fang? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.<\/span><\/p>\n<h3><b>L\u1ed7i Value trong Excel khi d\u00f9ng h\u00e0m SUM ho\u1eb7c AVERAGE<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu m\u1ed9t trong c\u00e1c \u00f4 m\u00e0 h\u00e0m SUM ho\u1eb7c AVERAGE tham thi\u1ebfu \u0111\u1ebfn c\u00f3 ch\u1ee9a #VALUE! th\u00ec k\u1ebft qu\u1ea3 s\u1ebd cho ra #VALUE!. \u0110\u1ec3 b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n x\u00e2y d\u1ef1ng m\u1ed9t h\u00e0m kh\u00e1c \u0111\u1ec3 ch\u1ec9 t\u00ednh c\u00e1c <\/span><b>gi\u00e1 tr\u1ecb s\u1ed1 <\/b><span style=\"font-weight: 400;\">trong v\u00f9ng tham chi\u1ebfu.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225878 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-16.jpg\" alt=\"loi-value-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i ph\u00e1p:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp h\u00e0m =AVERAGE(IF(ISERROR(B2:D2),&#8221;&#8221;,B2:D2)) t\u1ea1i \u00f4 E2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3 (v\u00ec \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng).<\/span><\/p>\n<figure id=\"attachment_225879\" aria-describedby=\"caption-attachment-225879\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225879 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-17.jpg\" alt=\"loi-value-trong-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225879\" class=\"wp-caption-text\"><em>C\u00e1ch s\u1eeda l\u1ed7i Value khi d\u00f9ng h\u00e0m AVERAGE trong Excel<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng 2 b\u01b0\u1edbc tr\u00ean cho h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u00f9ng tham chi\u1ebfu c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb l\u1ed7i Value.<\/span><\/p>\n<h3><b>L\u1ed7i Value trong Excel khi d\u00f9ng h\u00e0m SUMIF, SUMIFS, COUNTIF ho\u1eb7c COUNTIFS<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m SUMIF hay COUNTIFS, l\u1ed7i Value c\u00f3 th\u1ec3 x\u1ea3y ra n\u1ebfu b\u1ea1n d\u00f9ng h\u00e0m kh\u00f4ng \u0111\u00fang c\u00e1ch. C\u1ee5 th\u1ec3:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 1: Nh\u1eadp h\u00e0m tr\u00ean m\u1ed9t file nh\u01b0ng tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 trong m\u1ed9t file kh\u00e1c. Khi \u0111\u00f3, b\u1ea1n c\u1ea7n m\u1edf c\u1ea3 2 file l\u00ean v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 s\u1eeda l\u1ed7i Value trong Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 2: D\u1ea3i \u00f4 tham chi\u1ebfu v\u00e0 d\u1ea3i \u00f4 t\u00ednh t\u1ed5ng kh\u00f4ng c\u00f9ng s\u1ed1 l\u01b0\u1ee3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i ph\u00e1p: B\u1ea1n c\u1ea7n s\u1eeda l\u1ea1i h\u00e0m l\u00e0 =SUMIFS(C2:C12,A2:A12,A14,B2:B12,B14) th\u00ec m\u1edbi h\u1ebft b\u1ecb l\u1ed7i Value.<\/span><\/p>\n<p style=\"text-align: center;\"><i><span style=\"font-weight: 400;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225880 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-18.jpg\" alt=\"loi-value-trong-excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/span><\/i><\/p>\n<h3><b>L\u1ed7i Value trong Excel khi d\u00f9ng h\u00e0m DAYS<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi, do s\u1ef1 kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t gi\u1eefa ng\u00e0y gi\u1edd tr\u00ean m\u00e1y t\u00ednh v\u1edbi \u0111\u1ecbnh d\u1ea1ng tr\u00ean Excel n\u00ean h\u00e0m DAYS cho ra l\u1ed7i Value.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i ph\u00e1p:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: V\u00e0o Control Panel &gt; ch\u1ecdn v\u00e0o m\u1ee5c \u201cClock and Region\u201d \u0111\u1ec3 b\u1eaft \u0111\u1ea7u s\u1eeda ng\u00e0y th\u00e1ng tr\u00ean m\u00e1y t\u00ednh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225881 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-19.jpg\" alt=\"loi-value-trong-excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn m\u1ee5c \u201cDate and Time\u201d.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225882 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-20.jpg\" alt=\"loi-value-trong-excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5p v\u00e0o \u201cChange date and time\u201d v\u00e0 \u0111i\u1ec1u ch\u1ec9nh ng\u00e0y gi\u1edd theo \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p. Sau \u0111\u00f3 tr\u1edf l\u1ea1i Excel v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 refresh trang t\u00ednh v\u00e0 xem c\u00f2n l\u1ed7i Value hay kh\u00f4ng.<\/span><\/p>\n<figure id=\"attachment_225883\" aria-describedby=\"caption-attachment-225883\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225883 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-21.jpg\" alt=\"loi-value-trong-excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225883\" class=\"wp-caption-text\"><em>Thay \u0111\u1ed5i ng\u00e0y gi\u1edd tr\u00ean m\u00e1y t\u00ednh \u0111\u1ec3 s\u1eeda l\u1ed7i #VALUE!<\/em><\/figcaption><\/figure>\n<h3><b>L\u1ed7i Value trong Excel khi d\u00f9ng h\u00e0m SEARCH ho\u1eb7c FIND<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">SEARCH v\u00e0 FIND \u0111\u1ec1u l\u00e0 2 l\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n trong Excel. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong v\u00f9ng tham chi\u1ebfu th\u00ec c\u1ea3 2 h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i Value.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-225884 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-22.jpg\" alt=\"loi-value-trong-excel-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ec v\u1eady, \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang, b\u1ea1n c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c nguy\u00ean t\u1eafc tham chi\u1ebfu c\u1ee7a 2 h\u00e0m n\u00e0y, c\u1ee5 th\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SEARCH: Kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng hay ch\u1eef hoa khi t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FIND: C\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef th\u01b0\u1eddng v\u00e0 ch\u1eef hoa khi t\u00ecm ki\u1ebfm.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=FIND(&#8220;gloves&#8221;;&#8221;Gloves (Youth)&#8221;;1) =&gt; k\u1ebft qu\u1ea3 l\u00e0 #VALUE!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=SEARCH(&#8220;gloves&#8221;;&#8221;Gloves (Youth)&#8221;;1) =&gt; k\u1ebft qu\u1ea3 l\u00e0 1<\/span><\/p>\n<h3><b>L\u1ed7i Value trong Excel khi d\u00f9ng h\u00e0m VLOOKUP ho\u1eb7c HLOOKUP<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi d\u00f9ng h\u00e0m VLOOKUP ho\u1eb7c HLOOKUP, ng\u01b0\u1eddi d\u00f9ng r\u1ea5t hay m\u1eafc ph\u1ea3i l\u1ed7i Value. C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n cho vi\u1ec7c n\u00e0y, nh\u01b0ng l\u00fd do ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 do nh\u1eadp ch\u1ec9 s\u1ed1 c\u1ed9t sai.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<figure id=\"attachment_225885\" aria-describedby=\"caption-attachment-225885\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225885 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-23.jpg\" alt=\"loi-value-trong-excel-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225885\" class=\"wp-caption-text\"><em>L\u1ed7i Value do nh\u1eadp ch\u1ec9 s\u1ed1 sai khi d\u00f9ng c\u00e1c h\u00e0m VLOOKUP, HLOOKUP<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Tham s\u1ed1 (0) trong h\u00e0m tr\u00ean l\u00e0 ch\u1ec9 cho th\u1ee9 t\u1ef1 c\u1ed9t c\u1ee7a v\u00f9ng tham chi\u1ebfu (A2:B9). V\u00ec v\u1eady, kh\u00f4ng c\u00f3 c\u1ed9t th\u1ee9 0 n\u00e0o c\u1ea3 n\u00ean h\u00e0m tr\u1ea3 v\u1ec1 l\u1ed7i Value. \u0110\u1ec3 s\u1eeda l\u1ea1i cho \u0111\u00fang, b\u1ea1n ch\u1ec9 c\u1ea7n thay s\u1ed1 0 b\u1eb1ng s\u1ed1 1 l\u00e0 xong. \u00dd ngh\u0129a l\u00e0 h\u00e0m n\u00e0y l\u00e0 t\u00ecm gi\u00e1 tr\u1ecb D2 trong c\u1ed9t th\u1ee9 nh\u1ea5t c\u1ee7a v\u00f9ng A2:B9.<\/span><\/p>\n<h2><b>M\u1ed9t s\u1ed1 m\u1eb9o c\u1ea7n bi\u1ebft \u0111\u1ec3 tr\u00e1nh l\u1ed7i Value khi l\u00e0m vi\u1ec7c v\u1edbi Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1eady khi l\u00e0m vi\u1ec7c v\u1edbi Excel, ng\u01b0\u1eddi d\u00f9ng r\u1ea5t hay g\u1eb7p ph\u1ea3i l\u1ed7i Value do nhi\u1ec1u sai s\u00f3t. B\u00ean c\u1ea1nh c\u00e1c gi\u1ea3i ph\u00e1p \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c m\u1eb9o nh\u1ecf sau \u0111\u00e2y \u0111\u1ec3 h\u1ea1n ch\u1ebf ho\u1eb7c kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y:<\/span><\/p>\n<p><b>Ki\u1ec3m tra c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00f4ng th\u1ee9c: <\/b><span style=\"font-weight: 400;\">\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 b\u1ea1n \u0111\u01b0a v\u00e0o c\u00f4ng th\u1ee9c \u0111\u1ec1u \u0111\u00fang v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi lo\u1ea1i d\u1eef li\u1ec7u m\u00e0 c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u.<\/span><\/p>\n<p><b>S\u1eed d\u1ee5ng c\u00e1c h\u00e0m l\u1ed7i:<\/b><span style=\"font-weight: 400;\"> Excel cung c\u1ea5p c\u00e1c h\u00e0m nh\u01b0 IFERROR v\u00e0 ISERROR \u0111\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c l\u1ed7i m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n. H\u00e0m IFERROR s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb b\u1ea1n ch\u1ec9 \u0111\u1ecbnh n\u1ebfu c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i, trong khi ISERROR s\u1ebd tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00f3 l\u1ed7i v\u00e0 FALSE n\u1ebfu kh\u00f4ng l\u1ed7i.<\/span><\/p>\n<figure id=\"attachment_225886\" aria-describedby=\"caption-attachment-225886\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/loi-value-trong-excel-24-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-225886 webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-24.jpg\" alt=\"loi-value-trong-excel-24\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-225886\" class=\"wp-caption-text\"><em>M\u1ed9t s\u1ed1 m\u1eb9o n\u00ean bi\u1ebft \u0111\u1ec3 h\u1ea1n ch\u1ebf l\u1ed7i VALUE xu\u1ea5t hi\u1ec7n trong Excel<\/em><\/figcaption><\/figure>\n<p><b>Ki\u1ec3m tra d\u1ea5u ph\u1ea9y: <\/b><span style=\"font-weight: 400;\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, l\u1ed7i Value trong Excel c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n do vi\u1ec7c s\u1eed d\u1ee5ng d\u1ea5u (,) thay v\u00ec d\u1ea5u (;) \u0111\u1ec3 t\u00e1ch c\u00e1c \u0111\u1ed1i s\u1ed1 trong m\u1ed9t h\u00e0m. T\u00f9y thu\u1ed9c v\u00e0o c\u00e0i \u0111\u1eb7t ng\u00f4n ng\u1eef c\u1ee7a b\u1ea1n, Excel c\u00f3 th\u1ec3 y\u00eau c\u1ea7u b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y ho\u1eb7c d\u1ea5u ch\u1ea5m ph\u1ea9y.<\/span><\/p>\n<p><b>Ki\u1ec3m tra c\u00e1c cell tr\u1ed1ng ho\u1eb7c ch\u01b0a \u0111\u01b0\u1ee3c \u0111i\u1ec1n:<\/b><span style=\"font-weight: 400;\"> \u0110\u00f4i khi, c\u00e1c \u0111\u1ed1i s\u1ed1 trong h\u00e0m c\u00f3 th\u1ec3 bao g\u1ed3m m\u1ed9t \u00f4 tr\u1ed1ng ho\u1eb7c m\u1ed9t \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c \u0111i\u1ec1n, d\u1eabn \u0111\u1ebfn l\u1ed7i #VALUE!.<\/span><\/p>\n<p><b>C\u1ea9n th\u1eadn v\u1edbi c\u00e1c h\u00e0m v\u00e0 to\u00e1n t\u1eed m\u1ea3ng: <\/b><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 SUMPRODUCT ho\u1ea1t \u0111\u1ed9ng tr\u00ean m\u1ea3ng. N\u1ebfu c\u00e1c m\u1ea3ng kh\u00f4ng c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p l\u1ed7i #VALUE!.<\/span><\/p>\n<h2><b>T\u1ed5ng k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">T\u00f3m l\u1ea1i, tr\u00ean \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eeda <\/span><b>l\u1ed7i Value trong Excel <\/b><span style=\"font-weight: 400;\">chi ti\u1ebft nh\u1ea5t. H\u00e3y \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u1ebfu b\u1ea1n c\u00f3 th\u1eafc m\u1eafc n\u00e0o kh\u00e1c li\u00ean quan \u0111\u1ebfn l\u1ed7i n\u00e0y \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p s\u1edbm nh\u1ea5t. \u0110\u1eebng qu\u00ean chia s\u1ebb b\u00e0i vi\u1ebft \u0111\u1ebfn b\u1ea1n b\u00e8 v\u00e0 xem th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt Excel kh\u00e1c t\u1ea1i <\/span><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\"><span style=\"font-weight: 400;\">trang Tin Nhanh<\/span><\/a><span style=\"font-weight: 400;\"> nh\u00e9.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp sai h\u00e0m ho\u1eb7c sai \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u. Khi \u0111\u00f3, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i Value thay v\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m. V\u1eady nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i Value trong Excel nh\u01b0 th\u1ebf n\u00e0o, c\u00f3 kh\u00f3 kh\u00f4ng? H\u00e3y c\u00f9ng Ho\u00e0ng [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":225862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-225860","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\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i Value trong Excel chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.\" \/>\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\/cac-cach-sua-loi-value-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel\" \/>\n<meta property=\"og:description\" content=\"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-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-07-03T13:39:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-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=\"Do Tuyet Nhi\" \/>\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=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 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\/cac-cach-sua-loi-value-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\"},\"headline\":\"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel\",\"datePublished\":\"2023-07-03T13:39:58+00:00\",\"dateModified\":\"2023-07-03T13:39:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/\"},\"wordCount\":3075,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.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\/cac-cach-sua-loi-value-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i Value trong Excel chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg\",\"datePublished\":\"2023-07-03T13:39:58+00:00\",\"dateModified\":\"2023-07-03T13:39:58+00:00\",\"description\":\"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"loi-value-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#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\":\"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel\"}]},{\"@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\/bba0f0fb7a9ee063d98abf6557ccdaee\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/757297e37ac8b79c5e571984e68b85a1.jpg?ver=1775469912\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/757297e37ac8b79c5e571984e68b85a1.jpg?ver=1775469912\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i Value trong Excel chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t","description":"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.","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\/cac-cach-sua-loi-value-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel","og_description":"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-07-03T13:39:58+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"17 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee"},"headline":"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel","datePublished":"2023-07-03T13:39:58+00:00","dateModified":"2023-07-03T13:39:58+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/"},"wordCount":3075,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.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\/cac-cach-sua-loi-value-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i Value trong Excel chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg","datePublished":"2023-07-03T13:39:58+00:00","dateModified":"2023-07-03T13:39:58+00:00","description":"L\u1ed7i Value trong Excel l\u00e0 do \u0111\u00e2u v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c? N\u1ebfu g\u1eb7p l\u1ed7i Value khi d\u00f9ng c\u00e1c h\u00e0m SUM, AVERAGE, SUMIF, ... th\u00ec sao? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/loi-value-trong-excel.jpg","width":1200,"height":628,"caption":"loi-value-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\/#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":"C\u00e1c c\u00e1ch s\u1eeda l\u1ed7i value trong Excel"}]},{"@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\/bba0f0fb7a9ee063d98abf6557ccdaee","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/757297e37ac8b79c5e571984e68b85a1.jpg?ver=1775469912","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/757297e37ac8b79c5e571984e68b85a1.jpg?ver=1775469912","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/225860","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\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=225860"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/225860\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/225862"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=225860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=225860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=225860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}