{"id":4213,"date":"2025-11-11T09:34:32","date_gmt":"2025-11-11T02:34:32","guid":{"rendered":"https:\/\/autofillform.com\/blog\/5-cach-sua-loi-ref-trong-excel-cuc-don-gian-ma-ban-nen-biet\/"},"modified":"2025-11-11T09:34:32","modified_gmt":"2025-11-11T02:34:32","slug":"5-cach-sua-loi-ref-trong-excel-cuc-don-gian-ma-ban-nen-biet","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/5-cach-sua-loi-ref-trong-excel-cuc-don-gian-ma-ban-nen-biet\/","title":{"rendered":"5 C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"
\n
\u00a0<\/div>\n

L\u1ed7i #REF! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i tham chi\u1ebfu ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel v\u00e0 th\u01b0\u1eddng khi\u1ebfn b\u1ea3ng t\u00ednh tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai ho\u1eb7c kh\u00f4ng th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u t\u1eebng nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i, c\u00e1ch nh\u1eadn bi\u1ebft v\u00e0 c\u00e1ch s\u1eeda theo t\u1eebng t\u00ecnh hu\u1ed1ng c\u1ee5 th\u1ec3 \u0111\u1ec3 thao t\u00e1c Excel ch\u00ednh x\u00e1c h\u01a1n.<\/p>\n

\"Bi\u1ec3uC\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n

\n

1. L\u1ed7i #REF! trong Excel l\u00e0 g\u00ec? Nh\u1eefng h\u00e0m th\u01b0\u1eddng g\u1eb7p l\u1ed7i #REF! trong Excel<\/h2>\n<\/div>\n
\n

1.1. L\u1ed7i #REF! trong Excel l\u00e0 g\u00ec?<\/h3>\n<\/div>\n

L\u1ed7i #REF! l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Reference, ngh\u0129a l\u00e0 l\u1ed7i tham chi\u1ebfu trong Excel. Khi th\u00f4ng b\u00e1o n\u00e0y xu\u1ea5t hi\u1ec7n, Excel \u0111ang b\u00e1o r\u1eb1ng c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u m\u00e0 n\u00f3 c\u1ea7n truy c\u1eadp.<\/p>\n

Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 b\u1ea1n \u0111\u00e3 x\u00f3a, c\u1eaft ho\u1eb7c d\u00e1n \u0111\u00e8 l\u00ean nh\u1eefng \u00f4 n\u1eb1m trong c\u00f4ng th\u1ee9c, khi\u1ebfn c\u00f4ng th\u1ee9c trong \u00f4 tham chi\u1ebfu kh\u00f4ng c\u00f2n h\u1ee3p l\u1ec7.<\/p>\n

\n

1.2. Nh\u1eefng h\u00e0m th\u01b0\u1eddng g\u1eb7p ph\u1ea3i l\u1ed7i #REF! trong Excel<\/h3>\n<\/div>\n

M\u1ed9t s\u1ed1 h\u00e0m d\u1ec5 xu\u1ea5t hi\u1ec7n l\u1ed7i #REF! khi v\u00f9ng tham chi\u1ebfu b\u1ecb x\u00f3a ho\u1eb7c thay \u0111\u1ed5i g\u1ed3m c\u00f3: SUM, AVERAGE, VLOOKUP, SUMPRODUCT, INDEX, IFERROR v\u00e0 nhi\u1ec1u h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ef1a tr\u00ean \u0111\u1ecba ch\u1ec9 \u00f4 kh\u00e1c.<\/p>\n

\n

2. Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel<\/h2>\n<\/div>\n
\n

2.1. L\u1ed7i #REF! xu\u1ea5t hi\u1ec7n do c\u1ed9t ho\u1eb7c v\u00f9ng tham chi\u1ebfu b\u1ecb x\u00f3a<\/h3>\n<\/div>\n

Khi b\u1ea1n l\u1ee1 x\u00f3a m\u1ed9t c\u1ed9t n\u1eb1m trong v\u00f9ng tham chi\u1ebfu c\u1ee7a c\u00f4ng th\u1ee9c, Excel s\u1ebd l\u1eadp t\u1ee9c b\u00e1o l\u1ed7i #REF! v\u00ec c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f2n t\u00ecm th\u1ea5y \u0111\u1ecba ch\u1ec9 \u00f4 c\u1ea7n thi\u1ebft.<\/p>\n

\"L\u1ed7iL\u1ed7i #REF! khi c\u00f4ng th\u1ee9c m\u1ea5t c\u1ed9t tham chi\u1ebfu<\/em><\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u00fang c\u00e1ch, b\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c \u0111ang d\u00f9ng, x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed tham chi\u1ebfu b\u1ecb m\u1ea5t, sau \u0111\u00f3 ch\u1ec9nh s\u1eeda ho\u1eb7c kh\u00f4i ph\u1ee5c l\u1ea1i d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

C\u00e1ch l\u00e0m g\u1ee3i \u00fd:<\/strong><\/p>\n

    \n
  • B\u01b0\u1edbc 1:<\/strong> Nh\u00ecn v\u00e0o \u00f4 b\u00e1o l\u1ed7i v\u00e0 m\u1edf c\u00f4ng th\u1ee9c \u0111\u1ec3 xem ph\u1ea7n tham chi\u1ebfu n\u00e0o \u0111ang hi\u1ec3n th\u1ecb #REF!.<\/li>\n
  • B\u01b0\u1edbc 2: <\/strong>\u0110\u1ed1i chi\u1ebfu v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u1ed9t ho\u1eb7c v\u00f9ng b\u1ecb x\u00f3a ho\u1eb7c thay \u0111\u1ed5i.<\/li>\n
  • B\u01b0\u1edbc 3: <\/strong>Th\u00eam l\u1ea1i c\u1ed9t c\u1ea7n thi\u1ebft (n\u1ebfu b\u1ecb x\u00f3a) ho\u1eb7c ch\u1ec9nh l\u1ea1i v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c sao cho kh\u1edbp v\u1edbi d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i.<\/li>\n
  • B\u01b0\u1edbc 4: <\/strong>N\u1ebfu thao t\u00e1c v\u1eeba th\u1ef1c hi\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng Ctrl + Z \u0111\u1ec3 ph\u1ee5c h\u1ed3i nhanh c\u1ed9t \u0111\u00e3 x\u00f3a.<\/li>\n<\/ul>\n

    \"B\u1ea3ngX\u00e1c \u0111\u1ecbnh c\u1ed9t ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u b\u1ecb x\u00f3a g\u00e2y l\u1ed7i #REF!<\/em><\/p>\n

    \n

    2.2. Tham chi\u1ebfu \u00f4 v\u01b0\u1ee3t qu\u00e1 ph\u1ea1m vi \u0111\u01b0\u1ee3c Excel cho ph\u00e9p<\/h3>\n<\/div>\n

    L\u1ed7i #REF! c\u0169ng c\u00f3 th\u1ec3 x\u1ea3y ra khi c\u00f4ng th\u1ee9c y\u00eau c\u1ea7u truy xu\u1ea5t \u0111\u1ebfn nhi\u1ec1u c\u1ed9t h\u01a1n so v\u1edbi ph\u1ea1m vi d\u1eef li\u1ec7u th\u1ef1c t\u1ebf. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng g\u1eb7p \u1edf c\u00e1c h\u00e0m nh\u01b0 VLOOKUP, n\u01a1i b\u1ea1n khai b\u00e1o ch\u1ec9 s\u1ed1 c\u1ed9t l\u1edbn h\u01a1n s\u1ed1 c\u1ed9t th\u1eadt s\u1ef1 c\u00f3 trong b\u1ea3ng.<\/p>\n

    V\u00ed d\u1ee5:<\/strong><\/p>\n

    B\u01b0\u1edbc 1: <\/strong>Trong b\u1ea3ng tr\u00ean, n\u1ebfu b\u1ea1n d\u00f9ng VLOOKUP v\u00e0 \u0111\u1eb7t ch\u1ec9 s\u1ed1 c\u1ed9t tr\u1ea3 v\u1ec1 l\u00e0 5, nh\u01b0ng v\u00f9ng d\u1eef li\u1ec7u ch\u1ec9 c\u00f3 4 c\u1ed9t, Excel s\u1ebd b\u00e1o l\u1ed7i #REF! v\u00ec kh\u00f4ng t\u00ecm th\u1ea5y c\u1ed9t th\u1ee9 5 \u0111\u1ec3 tr\u1ea3 k\u1ebft qu\u1ea3.<\/p>\n

    \"L\u1ed7iL\u1ed7i #REF! do VLOOKUP y\u00eau c\u1ea7u s\u1ed1 c\u1ed9t l\u1edbn h\u01a1n ph\u1ea1m vi b\u1ea3ng<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Ch\u1ec9nh l\u1ea1i ch\u1ec9 s\u1ed1 c\u1ed9t t\u1eeb 5 xu\u1ed1ng 4, t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 c\u1ed9t th\u1ef1c t\u1ebf trong b\u1ea3ng, c\u00f4ng th\u1ee9c s\u1ebd ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng.<\/p>\n

    \"K\u1ebft\u0110i\u1ec1u ch\u1ec9nh ch\u1ec9 s\u1ed1 c\u1ed9t ph\u00f9 h\u1ee3p \u0111\u1ec3 c\u00f4ng th\u1ee9c VLOOKUP ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang<\/em><\/p>\n

    \n

    2.3. H\u00e0m INDEX s\u1eed d\u1ee5ng h\u00e0ng ho\u1eb7c c\u1ed9t sai v\u1ecb tr\u00ed<\/h3>\n<\/div>\n

    Khi s\u1eed d\u1ee5ng h\u00e0m INDEX, n\u1ebfu b\u1ea1n y\u00eau c\u1ea7u h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t n\u1eb1m ngo\u00e0i ph\u1ea1m vi c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn, Excel s\u1ebd b\u00e1o l\u1ed7i #REF!.<\/p>\n

    V\u00ed d\u1ee5:<\/strong><\/p>\n

    B\u01b0\u1edbc 1<\/strong>: B\u1ea1n nh\u1eadp tham s\u1ed1 \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1ea1i h\u00e0ng 5 v\u00e0 c\u1ed9t 5, trong khi v\u00f9ng tham chi\u1ebfu ch\u1ec9 c\u00f3 4 h\u00e0ng v\u00e0 4 c\u1ed9t. Do v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n n\u00ean c\u00f4ng th\u1ee9c l\u1eadp t\u1ee9c tr\u1ea3 v\u1ec1 #REF!.<\/p>\n

    \"L\u1ed7iL\u1ed7i #REF! khi h\u00e0m INDEX g\u1ecdi t\u1edbi h\u00e0ng ho\u1eb7c c\u1ed9t v\u01b0\u1ee3t ph\u1ea1m vi d\u1eef li\u1ec7u<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> H\u00e3y ch\u1ec9nh l\u1ea1i ch\u1ec9 s\u1ed1 h\u00e0ng ho\u1eb7c c\u1ed9t sao cho ph\u00f9 h\u1ee3p v\u1edbi k\u00edch th\u01b0\u1edbc th\u1eadt c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u. Khi h\u00e0ng v\u00e0 c\u1ed9t n\u1eb1m trong ph\u1ea1m vi h\u1ee3p l\u1ec7, h\u00e0m s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 b\u00ecnh th\u01b0\u1eddng.<\/p>\n

    \"K\u1ebftCh\u1ec9nh l\u1ea1i ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t trong INDEX \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c<\/em><\/p>\n

    Xem th\u00eam: <\/strong>Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i file Excel b\u1ecb tr\u1eafng c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/div>\n
    \n

    2.4. Do tham chi\u1ebfu \u0111\u1ebfn h\u00e0m \u0111\u00f3ng INDIRECT<\/h3>\n<\/div>\n

    H\u00e0m INDIRECT trong Excel \u0111\u01b0\u1ee3c xem l\u00e0 h\u00e0m \u201c\u0111\u00f3ng\u201d, ngh\u0129a l\u00e0 c\u00e1c h\u00e0m kh\u00e1c kh\u00f4ng th\u1ec3 truy xu\u1ea5t tr\u1ef1c ti\u1ebfp v\u00e0o v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi INDIRECT. V\u00ec v\u1eady, khi b\u1ea1n c\u1ed1 g\u1eafng tham chi\u1ebfu \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m n\u00e0y, Excel c\u00f3 th\u1ec3 b\u00e1o l\u1ed7i #REF! n\u1ebfu ph\u1ea1m vi kh\u00f4ng \u0111\u01b0\u1ee3c m\u1edf ho\u1eb7c x\u00e1c \u0111\u1ecbnh l\u1ea1i \u0111\u00fang c\u00e1ch.<\/p>\n

    B\u01b0\u1edbc 1: <\/strong>Thi\u1ebft l\u1eadp b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 s\u1eed d\u1ee5ng INDIRECT \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u1ea7n thi\u1ebft nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda.<\/p>\n

    \"B\u1ea3ngL\u1ed7i #REF! khi c\u00f4ng th\u1ee9c kh\u00e1c truy c\u1eadp v\u00f9ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi INDIRECT<\/em><\/p>\n

    B\u01b0\u1edbc 2: <\/strong>N\u1ebfu c\u00f4ng th\u1ee9c kh\u00e1c c\u1ed1 truy c\u1eadp v\u00e0o v\u00f9ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi INDIRECT, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #REF!. Khi \u0111\u00f3, b\u1ea1n c\u1ea7n m\u1edf l\u1ea1i h\u00e0m INDIRECT v\u00e0 ch\u1ec9 \u0111\u1ecbnh l\u1ea1i tham chi\u1ebfu sao cho ph\u00f9 h\u1ee3p th\u00ec c\u00f4ng th\u1ee9c m\u1edbi ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng.<\/p>\n

    \"C\u00f4ngC\u00e1ch \u0111i\u1ec1u ch\u1ec9nh h\u00e0m INDIRECT \u0111\u1ec3 kh\u00f4i ph\u1ee5c tham chi\u1ebfu h\u1ee3p l\u1ec7<\/em><\/p>\n

    \n

    2.5. L\u1ed7i ph\u00e1t sinh khi sao ch\u00e9p d\u1eef li\u1ec7u gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c nhau<\/h3>\n<\/div>\n

    Vi\u1ec7c copy m\u1ed9t b\u1ea3ng t\u00ednh t\u1eeb file n\u00e0y sang file kh\u00e1c \u0111\u00f4i khi khi\u1ebfn c\u00f4ng th\u1ee9c m\u1ea5t tham chi\u1ebfu, d\u1eabn \u0111\u1ebfn l\u1ed7i #REF!. Nguy\u00ean nh\u00e2n l\u00e0 do c\u1ea5u tr\u00fac d\u1eef li\u1ec7u ho\u1eb7c v\u1ecb tr\u00ed \u00f4 \u1edf file m\u1edbi kh\u00f4ng gi\u1ed1ng v\u1edbi file ban \u0111\u1ea7u.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> Sao ch\u00e9p b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb file g\u1ed1c sang m\u1ed9t file Excel kh\u00e1c.<\/p>\n

    \"L\u1ed7iL\u1ed7i #REF! xu\u1ea5t hi\u1ec7n khi sao ch\u00e9p b\u1ea3ng sang file m\u1edbi khi\u1ebfn m\u1ea5t tham chi\u1ebfu<\/em><\/p>\n

    B\u01b0\u1edbc 2: <\/strong>Khi xu\u1ea5t hi\u1ec7n l\u1ed7i #REF!, h\u00e3y \u0111\u1ed1i chi\u1ebfu hai file \u0111\u1ec3 xem c\u00f4ng th\u1ee9c \u0111ang thi\u1ebfu ho\u1eb7c sai tham chi\u1ebfu \u1edf v\u1ecb tr\u00ed n\u00e0o. Sau khi ch\u1ec9nh l\u1ea1i cho ph\u00f9 h\u1ee3p v\u1edbi c\u1ea5u tr\u00fac m\u1edbi, b\u1ea3ng s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/p>\n

    \"B\u1ea3ng\u0110\u1ed1i chi\u1ebfu hai file v\u00e0 ch\u1ec9nh l\u1ea1i tham chi\u1ebfu \u0111\u1ec3 b\u1ea3ng tr\u1ea3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c<\/em><\/p>\n

    \n

    3. M\u1ed9t s\u1ed1 l\u1ed7i c\u00fa ph\u00e1p th\u01b0\u1eddng g\u1eb7p trong Excel<\/h2>\n<\/div>\n

    B\u00ean c\u1ea1nh l\u1ed7i #REF!, Excel c\u00f2n xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ed7i c\u00fa ph\u00e1p m\u00e0 ng\u01b0\u1eddi d\u00f9ng n\u00ean bi\u1ebft, bao g\u1ed3m:<\/p>\n

      \n
    • #N\/A: <\/strong>Xu\u1ea5t hi\u1ec7n khi h\u00e0m kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p ho\u1eb7c d\u1eef li\u1ec7u tra c\u1ee9u kh\u00f4ng t\u1ed3n t\u1ea1i.<\/li>\n
    • #VALUE!: <\/strong>B\u00e1o l\u1ed7i khi ki\u1ec3u d\u1eef li\u1ec7u kh\u00f4ng \u0111\u00fang v\u1edbi y\u00eau c\u1ea7u c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n
    • #NAME?: <\/strong>Th\u01b0\u1eddng x\u1ea3y ra khi nh\u1eadp sai t\u00ean h\u00e0m, sai ph\u1ea1m vi ho\u1eb7c thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p trong v\u0103n b\u1ea3n.<\/li>\n
    • #NUM!: <\/strong>L\u1ed7i do gi\u00e1 tr\u1ecb s\u1ed1 kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c c\u00f4ng th\u1ee9c t\u1ea1o ra k\u1ebft qu\u1ea3 v\u01b0\u1ee3t gi\u1edbi h\u1ea1n.<\/li>\n
    • #DIV\/0!: <\/strong>Th\u00f4ng b\u00e1o xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c th\u1ef1c hi\u1ec7n ph\u00e9p chia cho 0 ho\u1eb7c cho \u00f4 tr\u1ed1ng.<\/li>\n<\/ul>\n

      Hi\u1ec3u r\u00f5 l\u1ed7i #REF! c\u00f9ng c\u00e1c l\u1ed7i c\u00fa ph\u00e1p ph\u1ed5 bi\u1ebfn trong Excel gi\u00fap b\u1ea1n x\u1eed l\u00fd b\u1ea3ng d\u1eef li\u1ec7u m\u01b0\u1ee3t h\u01a1n v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t. N\u1ebfu mu\u1ed1n h\u1ecdc th\u00eam nhi\u1ec1u m\u1eb9o thao t\u00e1c Excel v\u00e0 kinh nghi\u1ec7m c\u00f4ng ngh\u1ec7 h\u1eefu \u00edch, 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.<\/p>\n

      N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ecdn m\u1ed9t chi\u1ebfc laptop ph\u00f9 h\u1ee3p cho c\u00f4ng vi\u1ec7c ho\u1eb7c c\u1ea7n th\u00eam ph\u1ee5 ki\u1ec7n vi t\u00ednh nh\u01b0 chu\u1ed9t hay b\u00e0n ph\u00edm, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. C\u00e1c d\u00f2ng m\u00e1y ch\u00ednh h\u00e3ng c\u00f9ng ph\u1ee5 ki\u1ec7n \u0111\u1ed3ng b\u1ed9 s\u1ebd gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      \u00a0 L\u1ed7i #REF! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i tham chi\u1ebfu ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel v\u00e0 th\u01b0\u1eddng khi\u1ebfn b\u1ea3ng t\u00ednh tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai ho\u1eb7c kh\u00f4ng th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u t\u1eebng nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i, c\u00e1ch nh\u1eadn bi\u1ebft v\u00e0 c\u00e1ch s\u1eeda theo t\u1eebng t\u00ecnh hu\u1ed1ng c\u1ee5 […]<\/p>\n","protected":false},"author":1,"featured_media":4214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4213","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\/19222.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4213","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=4213"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4213\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4214"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}