{"id":4464,"date":"2025-11-12T18:40:22","date_gmt":"2025-11-12T11:40:22","guid":{"rendered":"https:\/\/autofillform.com\/blog\/tong-hop-9-thong-bao-ma-loi-trong-excel-va-cach-sua-loi\/"},"modified":"2025-11-12T18:40:22","modified_gmt":"2025-11-12T11:40:22","slug":"tong-hop-9-thong-bao-ma-loi-trong-excel-va-cach-sua-loi","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/tong-hop-9-thong-bao-ma-loi-trong-excel-va-cach-sua-loi\/","title":{"rendered":"T\u1ed5ng h\u1ee3p 9 Th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i trong Excel v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, c\u00e1c l\u1ed7i nh\u01b0 #VALUE!, #NAME?, ####, #REF! hay #DIV\/0! th\u01b0\u1eddng khi\u1ebfn b\u1ea1n m\u1ea5t th\u1eddi gian x\u1eed l\u00fd v\u00e0 d\u1ec5 gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c. B\u00e0i vi\u1ebft n\u00e0y t\u1ed5ng h\u1ee3p nh\u1eefng m\u00e3 l\u1ed7i ph\u1ed5 bi\u1ebfn k\u00e8m c\u00e1ch kh\u1eafc ph\u1ee5c nhanh \u0111\u1ec3 b\u1ea1n thao t\u00e1c b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n

\"Bi\u1ec3uC\u00e1c th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i ph\u1ed5 bi\u1ebfn trong Excel<\/em><\/p>\n

\n

1. L\u1ed7i gi\u00e1 tr\u1ecb: #VALUE!<\/h2>\n<\/div>\n

L\u1ed7i #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00ec c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u gi\u00e1 tr\u1ecb s\u1ed1, trong khi \u00f4 l\u1ea1i ch\u1ee9a k\u00fd t\u1ef1, ch\u1eef ho\u1eb7c kho\u1ea3ng tr\u1eafng.<\/p>\n

    \n
  • L\u1ed7i #VALUE! do k\u00fd t\u1ef1: <\/strong>N\u1ebfu \u00f4 A3 ch\u1ee9a v\u0103n b\u1ea3n nh\u01b0 “hi”, Excel s\u1ebd b\u00e1o l\u1ed7i v\u00ec kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u1edbi chu\u1ed7i ch\u1eef.<\/li>\n<\/ul>\n

    \"\u00d4V\u00ed d\u1ee5 l\u1ed7i #VALUE! do \u00f4 ch\u1ee9a v\u0103n b\u1ea3n<\/em><\/p>\n

      \n
    • L\u1ed7i #VALUE! do kho\u1ea3ng tr\u1eafng:<\/strong> Ngay c\u1ea3 m\u1ed9t d\u1ea5u c\u00e1ch ” ” trong \u00f4 A3 c\u0169ng \u0111\u1ee7 khi\u1ebfn c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 #VALUE! v\u00ec Excel hi\u1ec3u \u0111\u00e2y kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u s\u1ed1 h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n

      \"C\u00f4ngV\u00ed d\u1ee5 l\u1ed7i #VALUE! do \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1eafng<\/em><\/p>\n

      C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> B\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i to\u00e0n b\u1ed9 d\u1eef li\u1ec7u xem c\u00f3 ch\u1ee9a ch\u1eef, k\u00fd t\u1ef1 l\u1ea1 ho\u1eb7c kho\u1ea3ng tr\u1eafng hay kh\u00f4ng.<\/p>\n

        \n
      • \u0110\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng s\u1ed1: <\/strong>Ch\u1ecdn v\u00f9ng c\u1ea7n x\u1eed l\u00fd, v\u00e0o nh\u00f3m Number tr\u00ean thanh Ribbon v\u00e0 ch\u1ecdn Number \u0111\u1ec3 chuy\u1ec3n to\u00e0n b\u1ed9 v\u1ec1 ki\u1ec3u s\u1ed1.<\/li>\n<\/ul>\n

        \"\u0110\u1ecbnhChuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u1ec1 ki\u1ec3u Number \u0111\u1ec3 tr\u00e1nh l\u1ed7i #VALUE!<\/em><\/p>\n

          \n
        • Lo\u1ea1i b\u1ecf kho\u1ea3ng tr\u1eafng th\u1eeba<\/strong>\n
            \n
          • B\u00f4i \u0111en khu v\u1ef1c d\u1eef li\u1ec7u, nh\u1ea5n Ctrl + H ch\u1ecdn Replace.<\/li>\n
          • T\u1ea1i \u00f4 Find what, nh\u1eadp m\u1ed9t d\u1ea5u c\u00e1ch, sau \u0111\u00f3 ch\u1ecdn Replace All \u0111\u1ec3 Excel x\u00f3a to\u00e0n b\u1ed9 d\u1ea5u c\u00e1ch trong v\u00f9ng \u0111ang ch\u1ecdn.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            \"T\u00ecmX\u00f3a kho\u1ea3ng tr\u1eafng th\u1eeba b\u1eb1ng Find & Replace \u0111\u1ec3 s\u1eeda l\u1ed7i #VALUE!<\/em><\/p>\n

            \n

            2. L\u1ed7i sai t\u00ean c\u00f4ng th\u1ee9c: #NAME?<\/h2>\n<\/div>\n

            L\u1ed7i #NAME? th\u01b0\u1eddng x\u1ea3y ra khi Excel kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c b\u1ea1n nh\u1eadp. Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 \u0111\u00e1nh nh\u1ea7m t\u00ean h\u00e0m ho\u1eb7c g\u00f5 sai c\u00fa ph\u00e1p.<\/p>\n

            V\u00ed d\u1ee5: <\/strong>N\u1ebfu b\u1ea1n nh\u1eadp “su” thay v\u00ec “SUM”, Excel s\u1ebd kh\u00f4ng hi\u1ec3u v\u00e0 tr\u1ea3 v\u1ec1 #NAME?.<\/p>\n

            \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #NAME? khi g\u00f5 sai t\u00ean h\u00e0m<\/em><\/p>\n

            C\u00e1ch tr\u00e1nh l\u1ed7i #NAME?<\/strong><\/p>\n

            B\u1ea1n c\u00f3 th\u1ec3 g\u00f5 v\u00e0i k\u00fd t\u1ef1 \u0111\u1ea7u c\u1ee7a t\u00ean h\u00e0m, sau \u0111\u00f3 ch\u1ecdn h\u00e0m \u0111\u00fang trong danh s\u00e1ch g\u1ee3i \u00fd m\u00e0 Excel \u0111\u01b0a ra v\u00e0 nh\u1ea5n Tab \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e0n th\u00e0nh.<\/p>\n

            \"ExcelG\u1ee3i \u00fd t\u00ean h\u00e0m trong Excel gi\u00fap tr\u00e1nh l\u1ed7i #NAME? trong Excel<\/em><\/p>\n

            Ngo\u00e0i ra, khi b\u1ea1n vi\u1ebft h\u00e0m b\u1eb1ng ch\u1eef th\u01b0\u1eddng, Excel s\u1ebd t\u1ef1 \u0111\u1ed5i sang ch\u1eef in hoa n\u1ebfu t\u00ean h\u00e0m h\u1ee3p l\u1ec7. \u0110\u00e2y l\u00e0 d\u1ea5u hi\u1ec7u nhanh gi\u00fap b\u1ea1n nh\u1eadn bi\u1ebft c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u00fang hay ch\u01b0a.<\/p>\n

            \n

            3. L\u1ed7i \u0111\u1ed9 r\u1ed9ng: #####<\/h2>\n<\/div>\n

            Hi\u1ec7n t\u01b0\u1ee3ng \u00f4 t\u00ednh hi\u1ec3n th\u1ecb #### kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i t\u00ednh to\u00e1n, m\u00e0 l\u00e0 t\u00edn hi\u1ec7u cho th\u1ea5y Excel kh\u00f4ng \u0111\u1ee7 kh\u00f4ng gian \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u. B\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh nguy\u00ean nh\u00e2n th\u00f4ng qua hai tr\u01b0\u1eddng h\u1ee3p ph\u1ed5 bi\u1ebfn:<\/p>\n

              \n
            • C\u1ed9t qu\u00e1 h\u1eb9p so v\u1edbi d\u1eef li\u1ec7u: <\/strong>L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb d\u00e0i, v\u00ed d\u1ee5 nh\u01b0 s\u1ed1 th\u1eadp ph\u00e2n c\u00f3 r\u1ea5t nhi\u1ec1u ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y ho\u1eb7c nh\u1eefng con s\u1ed1 l\u1edbn v\u01b0\u1ee3t qu\u00e1 chi\u1ec1u r\u1ed9ng c\u1ed9t hi\u1ec7n t\u1ea1i.<\/li>\n
            • N\u1ed9i dung trong \u00f4 v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n hi\u1ec3n th\u1ecb: <\/strong>Khi b\u1ea1n nh\u1eadp m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 qu\u00e1 d\u00e0i, Excel s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb tr\u1ecdn v\u1eb9n trong k\u00edch th\u01b0\u1edbc \u00f4 hi\u1ec7n c\u00f3 v\u00e0 thay th\u1ebf b\u1eb1ng d\u00e3y ####.<\/li>\n<\/ul>\n

              \"\u00d4V\u00ed d\u1ee5 \u00f4 hi\u1ec3n th\u1ecb #### do c\u1ed9t qu\u00e1 h\u1eb9p<\/em><\/p>\n

              C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

                \n
              • C\u00e1ch 1: <\/strong>\u0110\u01b0a chu\u1ed9t v\u00e0o \u0111\u01b0\u1eddng ph\u00e2n c\u00e1ch gi\u1eefa hai c\u1ed9t, n\u01a1i c\u1ed9t b\u00ean tr\u00e1i l\u00e0 c\u1ed9t ch\u1ee9a \u00f4 b\u1ecb l\u1ed7i. Nh\u1ea5n \u0111\u00fap \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng c\u1ed9t theo \u0111\u1ed9 d\u00e0i l\u1edbn nh\u1ea5t c\u1ee7a d\u1eef li\u1ec7u.<\/li>\n
              • C\u00e1ch 2: <\/strong>C\u0169ng \u0111\u1eb7t chu\u1ed9t v\u00e0o \u0111\u01b0\u1eddng ph\u00e2n c\u00e1ch gi\u1eefa hai c\u1ed9t, sau \u0111\u00f3 k\u00e9o th\u1ea3 sang ph\u1ea3i \u0111\u1ec3 t\u0103ng \u0111\u1ed9 r\u1ed9ng c\u1ed9t \u0111\u1ebfn khi n\u1ed9i dung xu\u1ea5t hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7.<\/li>\n<\/ul>\n

                \"K\u00e9oM\u1edf r\u1ed9ng c\u1ed9t \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u<\/em><\/p>\n

                  \n
                • C\u00e1ch 3: <\/strong>\u0110\u1ed5i \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ec3 r\u00fat ng\u1eafn n\u1ed9i dung. Ch\u1ecdn \u00f4 \u0111ang b\u00e1o ####, nh\u1ea5n chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Cells, sau \u0111\u00f3 gi\u1ea3m s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ho\u1eb7c chuy\u1ec3n sang d\u1ea1ng General, Number, Date t\u00f9y ki\u1ec3u d\u1eef li\u1ec7u. Khi n\u1ed9i dung ng\u1eafn l\u1ea1i, Excel s\u1ebd hi\u1ec3n th\u1ecb b\u00ecnh th\u01b0\u1eddng m\u00e0 kh\u00f4ng c\u1ea7n m\u1edf r\u1ed9ng c\u1ed9t.<\/li>\n<\/ul>\n

                  \"H\u1ed9p\u0110\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111\u1ec3 r\u00fat ng\u1eafn d\u1eef li\u1ec7u v\u00e0 kh\u1eafc ph\u1ee5c l\u1ed7i ####<\/em><\/p>\n

                  \n

                  4. L\u1ed7i chia cho gi\u00e1 tr\u1ecb 0: #DIV\/0!<\/h2>\n<\/div>\n

                  L\u1ed7i #DIV\/0! xu\u1ea5t hi\u1ec7n khi Excel ph\u1ea3i th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p chia m\u00e0 m\u1eabu s\u1ed1 b\u1eb1ng 0 ho\u1eb7c \u00f4 \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m m\u1eabu s\u1ed1 \u0111ang \u0111\u1ec3 tr\u1ed1ng. V\u00ec ph\u00e9p chia cho 0 l\u00e0 \u0111i\u1ec1u kh\u00f4ng h\u1ee3p l\u1ec7 trong to\u00e1n h\u1ecdc, Excel s\u1ebd b\u00e1o l\u1ed7i thay v\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/p>\n

                  \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #DIV\/0! khi m\u1eabu s\u1ed1 b\u1eb1ng 0<\/em><\/p>\n

                  Th\u00f4ng b\u00e1o n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111ang r\u01a1i v\u00e0o t\u00ecnh hu\u1ed1ng “chia cho 0”.<\/p>\n

                  C\u00e1ch x\u1eed l\u00fd r\u1ea5t \u0111\u01a1n gi\u1ea3n: <\/strong>Thay \u0111\u1ed5i gi\u00e1 tr\u1ecb \u1edf \u00f4 l\u00e0m m\u1eabu s\u1ed1 sang m\u1ed9t s\u1ed1 kh\u00e1c 0 ho\u1eb7c nh\u1eadp d\u1eef li\u1ec7u n\u1ebfu \u00f4 \u0111\u00f3 \u0111ang b\u1ecf tr\u1ed1ng.<\/p>\n

                  N\u1ebfu b\u1ea1n mu\u1ed1n ph\u00e9p t\u00ednh v\u1eabn ho\u1ea1t \u0111\u1ed9ng m\u00e0 kh\u00f4ng b\u00e1o l\u1ed7i, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR theo m\u1eabu: =IFERROR(ph\u00e9p_t\u00ednh, gi\u00e1_tr\u1ecb_mu\u1ed1n_hi\u1ec3n_th\u1ecb_khi_l\u1ed7i)<\/p>\n

                  \"S\u1eedS\u1eeda l\u1ed7i #DIV\/0! b\u1eb1ng c\u00e1ch d\u00f9ng h\u00e0m IFERROR<\/em><\/p>\n

                  \n

                  5. L\u1ed7i sai v\u00f9ng tham chi\u1ebfu: #REF!<\/h2>\n<\/div>\n

                  L\u1ed7i #REF! l\u00e0 l\u1ed7i tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 th\u01b0\u1eddng khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng g\u1eb7p kh\u00f3 kh\u0103n v\u00ec kh\u00f3 x\u00e1c \u0111\u1ecbnh nguy\u00ean nh\u00e2n ngay l\u1eadp t\u1ee9c. L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c tr\u1ecf t\u1edbi m\u1ed9t \u00f4, h\u00e0ng ho\u1eb7c c\u1ed9t \u0111\u00e3 kh\u00f4ng c\u00f2n t\u1ed3n t\u1ea1i.<\/p>\n

                  Ch\u1eb3ng h\u1ea1n, \u00f4 A5 \u0111ang d\u00f9ng c\u00f4ng th\u1ee9c c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb \u1edf A1, A2, A3 v\u00e0 A4. N\u1ebfu b\u1ea1n x\u00f3a h\u00e0ng ch\u1ee9a A2, tham chi\u1ebfu \u0111\u00f3 b\u1ecb m\u1ea5t v\u00e0 c\u00f4ng th\u1ee9c l\u1eadp t\u1ee9c chuy\u1ec3n th\u00e0nh #REF!.<\/p>\n

                  \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #REF! khi tham chi\u1ebfu \u0111\u1ebfn \u00f4 \u0111\u00e3 b\u1ecb x\u00f3a<\/em><\/p>\n

                  \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n n\u00ean c\u1ea9n tr\u1ecdng khi x\u00f3a d\u1eef li\u1ec7u ho\u1eb7c ch\u1ec9nh s\u1eeda c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh. Tr\u01b0\u1eddng h\u1ee3p l\u1ee1 tay x\u00f3a m\u1ea5t v\u00f9ng \u0111ang \u0111\u01b0\u1ee3c tham chi\u1ebfu, ch\u1ec9 c\u1ea7n d\u00f9ng Ctrl + Z \u0111\u1ec3 ho\u00e0n t\u00e1c tr\u01b0\u1edbc khi l\u1ed7i lan sang c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c.<\/p>\n

                  Xem th\u00eam: <\/strong>5 C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/div>\n
                  \n

                  6. L\u1ed7i d\u1eef li\u1ec7u r\u1ed7ng: #NULL!<\/h2>\n<\/div>\n

                  M\u00e3 l\u1ed7i #NULL! xu\u1ea5t hi\u1ec7n khi Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ed1i li\u00ean k\u1ebft gi\u1eefa c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c. Nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p l\u00e0 b\u1ea1n d\u00f9ng sai k\u00fd t\u1ef1 \u0111\u1ec3 n\u1ed1i c\u00e1c ph\u1ea1m vi tham chi\u1ebfu, khi\u1ebfn Excel hi\u1ec3u r\u1eb1ng c\u00e1c v\u00f9ng \u0111\u00f3 kh\u00f4ng giao nhau.<\/p>\n

                  \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #NULL! do d\u00f9ng sai k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch ph\u1ea1m vi<\/em><\/p>\n

                  \u0110\u1ec3 x\u1eed l\u00fd l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch trong c\u00f4ng th\u1ee9c:<\/p>\n

                  D\u1ea5u hai ch\u1ea5m (:) d\u00f9ng \u0111\u1ec3 ch\u1ec9 m\u1ed9t v\u00f9ng li\u00ean t\u1ee5c, trong \u0111\u00f3 k\u00fd t\u1ef1 tr\u01b0\u1edbc l\u00e0 \u00f4 b\u1eaft \u0111\u1ea7u v\u00e0 k\u00fd t\u1ef1 sau l\u00e0 \u00f4 k\u1ebft th\u00fac.<\/p>\n

                  V\u00ed d\u1ee5: <\/strong>=AVERAGE(A1:A3)<\/p>\n

                  \"B\u1ed5S\u1eeda l\u1ed7i #NULL! b\u1eb1ng d\u1ea5u hai ch\u1ea5m (:) \u0111\u1ec3 ch\u1ec9 v\u00f9ng li\u00ean t\u1ee5c<\/em><\/p>\n

                  D\u1ea5u ph\u1ea9y (,) d\u00f9ng \u0111\u1ec3 ph\u00e2n t\u00e1ch c\u00e1c \u00f4 ho\u1eb7c c\u00e1c v\u00f9ng kh\u00f4ng li\u1ec1n k\u1ec1.<\/p>\n

                  V\u00ed d\u1ee5:<\/strong> =AVERAGE(A1, A3)<\/p>\n

                  \"Th\u00eamS\u1eeda l\u1ed7i #NULL! b\u1eb1ng d\u1ea5u ph\u1ea9y (,) cho c\u00e1c v\u00f9ng kh\u00f4ng li\u1ec1n k\u1ec1<\/em><\/p>\n

                  Vi\u1ec7c ch\u1ecdn \u0111\u00fang k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch s\u1ebd gi\u00fap Excel hi\u1ec3u ch\u00ednh x\u00e1c ph\u1ea1m vi b\u1ea1n mu\u1ed1n t\u00ednh v\u00e0 tr\u00e1nh l\u1ed7i #NULL!.<\/p>\n

                  \n

                  7. L\u1ed7i d\u1eef li\u1ec7u: #N\/A<\/h2>\n<\/div>\n

                  L\u1ed7i #N\/A l\u00e0 t\u00edn hi\u1ec7u cho bi\u1ebft Excel kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb m\u00e0 c\u00f4ng th\u1ee9c \u0111ang y\u00eau c\u1ea7u. T\u00ecnh hu\u1ed1ng n\u00e0y th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n trong c\u00e1c h\u00e0m d\u00f2 t\u00ecm nh\u01b0 VLOOKUP, HLOOKUP ho\u1eb7c XLOOKUP, \u0111\u1eb7c bi\u1ec7t khi v\u00f9ng d\u1eef li\u1ec7u b\u1ecb x\u00f3a, b\u1ecb thi\u1ebfu ho\u1eb7c khi gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng tham chi\u1ebfu.<\/p>\n

                  \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #N\/A trong h\u00e0m VLOOKUP khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb<\/em><\/p>\n

                  \u0110\u1ec3 s\u1eeda l\u1ed7i, b\u1ea1n c\u1ea7n xem l\u1ea1i to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u00e0 ki\u1ec3m tra xem ph\u1ea1m vi d\u00f2 t\u00ecm c\u00f3 c\u00f2n \u0111\u1ea7y \u0111\u1ee7 hay \u0111\u00e3 b\u1ecb ch\u1ec9nh s\u1eeda, x\u00f3a m\u1ea5t d\u00f2ng ho\u1eb7c c\u1ed9t quan tr\u1ecdng.<\/p>\n

                  Trong tr\u01b0\u1eddng h\u1ee3p v\u00f9ng tham chi\u1ebfu v\u1eabn ch\u00ednh x\u00e1c nh\u01b0ng gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm th\u1ef1c s\u1ef1 kh\u00f4ng c\u00f3 trong d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IFERROR \u0111\u1ec3 \u1ea9n th\u00f4ng b\u00e1o l\u1ed7i v\u00e0 thay b\u1eb1ng n\u1ed9i dung d\u1ec5 hi\u1ec3u h\u01a1n.<\/p>\n

                  \n

                  8. L\u1ed7i d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1: #NUM!<\/h2>\n<\/div>\n

                  L\u1ed7i #NUM! x\u1ea3y ra khi Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u s\u1ed1 trong c\u00f4ng th\u1ee9c. C\u00f3 3 nguy\u00ean nh\u00e2n ch\u00ednh:<\/p>\n

                    \n
                  • C\u00f4ng th\u1ee9c ch\u1ee9a \u0111\u1ed1i s\u1ed1 kh\u00f4ng h\u1ee3p l\u1ec7, v\u00ed d\u1ee5 s\u1ed1 \u00e2m \u1edf v\u1ecb tr\u00ed y\u00eau c\u1ea7u s\u1ed1 d\u01b0\u01a1ng.<\/li>\n
                  • H\u00e0m t\u00ednh l\u1eb7p kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3, \u0111i\u1ec3n h\u00ecnh nh\u01b0 IRR ho\u1eb7c RATE.<\/li>\n
                  • Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 nh\u1ecf v\u01b0\u1ee3t ngo\u00e0i ph\u1ea1m vi Excel h\u1ed7 tr\u1ee3.<\/li>\n<\/ul>\n

                    \"L\u1ed7iV\u00ed d\u1ee5 l\u1ed7i #NUM! khi c\u0103n b\u1eadc hai c\u1ee7a s\u1ed1 \u00e2m<\/em><\/p>\n

                    C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Ki\u1ec3m tra l\u1ea1i c\u00e1c tham s\u1ed1 s\u1ed1 h\u1ecdc, \u0111i\u1ec1u ch\u1ec9nh gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o c\u1ee7a h\u00e0m l\u1eb7p ho\u1eb7c r\u00fat g\u1ecdn gi\u00e1 tr\u1ecb \u0111\u1ec3 k\u1ebft qu\u1ea3 kh\u00f4ng v\u01b0\u1ee3t gi\u1edbi h\u1ea1n m\u00e0 Excel c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c.<\/p>\n

                    \"K\u1ebftK\u1ebft qu\u1ea3 h\u1ee3p l\u1ec7 sau khi s\u1eeda l\u1ed7i #NUM!<\/em><\/p>\n

                    \n

                    9. L\u1ed7i tr\u00e0n #SPILL!<\/h2>\n<\/div>\n

                    L\u1ed7i #SPILL! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ed9ng c\u1ea7n \u201ctr\u00e0n\u201d k\u1ebft qu\u1ea3 xu\u1ed1ng nhi\u1ec1u \u00f4, nh\u01b0ng khu v\u1ef1c nh\u1eadn k\u1ebft qu\u1ea3 l\u1ea1i kh\u00f4ng \u0111\u1ee7 kh\u00f4ng gian. C\u00e1c \u00f4 n\u1eb1m trong v\u00f9ng tr\u00e0n c\u00f3 th\u1ec3 \u0111ang ch\u1ee9a d\u1eef li\u1ec7u, c\u00f4ng th\u1ee9c, k\u00fd t\u1ef1 \u1ea9n ho\u1eb7c b\u1ecb kh\u00f3a, khi\u1ebfn Excel kh\u00f4ng th\u1ec3 \u0111\u1ed5 k\u1ebft qu\u1ea3 ra \u0111\u01b0\u1ee3c.<\/p>\n

                    \"L\u1ed7iL\u1ed7i #SPILL! do v\u00f9ng tr\u00e0n b\u1ecb \u00f4 kh\u00e1c ch\u1eb7n<\/em><\/p>\n

                    C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n

                      \n
                    • X\u00f3a d\u1eef li\u1ec7u ch\u1eafn v\u00f9ng tr\u00e0n:<\/strong> Ch\u1ecdn \u00f4 b\u00e1o l\u1ed7i \u0111\u1ec3 xem v\u00f9ng k\u1ebft qu\u1ea3, sau \u0111\u00f3 x\u00f3a c\u00e1c \u00f4 \u0111ang ch\u1ee9a n\u1ed9i dung trong v\u00f9ng \u0111\u00f3.<\/li>\n
                    • Tr\u00e1nh \u0111\u1eb7t c\u00f4ng th\u1ee9c trong Table:<\/strong> C\u00f4ng th\u1ee9c m\u1ea3ng kh\u00f4ng th\u1ec3 tr\u00e0n trong Table. H\u00e3y chuy\u1ec3n Table v\u1ec1 ph\u1ea1m vi th\u01b0\u1eddng (Convert to Range) ho\u1eb7c \u0111\u1eb7t c\u00f4ng th\u1ee9c b\u00ean ngo\u00e0i Table.<\/li>\n
                    • Gi\u1ea3m ph\u1ea1m vi tham chi\u1ebfu:<\/strong> Kh\u00f4ng tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t\/h\u00e0ng n\u1ebfu v\u00f9ng tr\u00e0n c\u00f3 nguy c\u01a1 v\u01b0\u1ee3t kh\u1ecfi gi\u1edbi h\u1ea1n trang t\u00ednh. Ch\u1ec9 ch\u1ecdn \u0111\u00fang ph\u1ea1m vi c\u1ea7n d\u00f9ng.<\/li>\n<\/ul>\n

                      \"K\u1ebftKh\u1eafc ph\u1ee5c l\u1ed7i #SPILL! b\u1eb1ng c\u00e1ch x\u00f3a \u00f4 ch\u1eafn \u0111\u1ec3 v\u00f9ng tr\u00e0n ho\u1ea1t \u0111\u1ed9ng<\/em><\/p>\n

                      N\u1eafm v\u1eefng c\u00e1c m\u00e3 l\u1ed7i Excel gi\u00fap b\u1ea1n x\u1eed l\u00fd b\u1ea3ng t\u00ednh nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. N\u1ebfu mu\u1ed1n c\u1eadp nh\u1eadt th\u00eam m\u1eb9o hay v\u00e0 h\u01b0\u1edbng d\u1eabn th\u1ef1c t\u1ebf cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 kh\u00f4ng b\u1ecf l\u1ee1 n\u1ed9i dung h\u1eefu \u00edch.<\/p>\n

                      N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ph\u1ee5 ki\u1ec7n vi t\u00ednh nh\u01b0 chu\u1ed9t, b\u00e0n ph\u00edm hay thi\u1ebft b\u1ecb h\u1ed7 tr\u1ee3 l\u00e0m vi\u1ec7c, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng, gi\u00e1 t\u1ed1t v\u00e0 ph\u00f9 h\u1ee3p cho nhu c\u1ea7u s\u1eed d\u1ee5ng m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                      \u00a0 Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, c\u00e1c l\u1ed7i nh\u01b0 #VALUE!, #NAME?, ####, #REF! hay #DIV\/0! th\u01b0\u1eddng khi\u1ebfn b\u1ea1n m\u1ea5t th\u1eddi gian x\u1eed l\u00fd v\u00e0 d\u1ec5 gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c. B\u00e0i vi\u1ebft n\u00e0y t\u1ed5ng h\u1ee3p nh\u1eefng m\u00e3 l\u1ed7i ph\u1ed5 bi\u1ebfn k\u00e8m c\u00e1ch kh\u1eafc ph\u1ee5c nhanh \u0111\u1ec3 b\u1ea1n thao t\u00e1c b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3 v\u00e0 […]<\/p>\n","protected":false},"author":1,"featured_media":4465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19271.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4464"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4465"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}