{"id":5016,"date":"2025-11-20T18:02:45","date_gmt":"2025-11-20T11:02:45","guid":{"rendered":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-khong-nhay-cong-thuc-trong-excel\/"},"modified":"2025-11-20T18:02:45","modified_gmt":"2025-11-20T11:02:45","slug":"nguyen-nhan-va-cach-sua-loi-khong-nhay-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-khong-nhay-cong-thuc-trong-excel\/","title":{"rendered":"Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"
\n

Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p tr\u01b0\u1eddng h\u1ee3p Excel hi\u1ec3n th\u1ecb nguy\u00ean c\u00f4ng th\u1ee9c thay v\u00ec k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n. T\u00ecnh hu\u1ed1ng n\u00e0y l\u00e0m gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c v\u00e0 khi\u1ebfn b\u1ea3ng t\u00ednh d\u1ec5 sai l\u1ec7ch. Nguy\u00ean nh\u00e2n th\u01b0\u1eddng \u0111\u1ebfn t\u1eeb \u0111\u1ecbnh d\u1ea1ng \u00f4, ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n ho\u1eb7c l\u1ed7i tham chi\u1ebfu. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nhanh ch\u00f3ng.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c nhanh ch\u00f3ng, d\u1ec5 hi\u1ec3u<\/em><\/p>\n

\n

1. L\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel<\/h2>\n<\/div>\n

L\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c kh\u00e1 ph\u1ed5 bi\u1ebfn. D\u1ea5u hi\u1ec7u th\u01b0\u1eddng g\u1eb7p l\u00e0 \u00f4 ch\u1ec9 hi\u1ec7n c\u00f4ng th\u1ee9c thay v\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u00f9 b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u00fang. M\u1ed9t d\u1ea5u hi\u1ec7u kh\u00e1c l\u00e0 c\u00f4ng th\u1ee9c t\u00ednh ch\u00ednh x\u00e1c \u1edf \u00f4 \u0111\u1ea7u ti\u00ean nh\u01b0ng khi k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi, gi\u00e1 tr\u1ecb l\u1ea1i kh\u00f4ng c\u1eadp nh\u1eadt theo d\u1eef li\u1ec7u m\u1edbi.<\/p>\n

\n

2. Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel<\/h2>\n<\/div>\n

L\u1ed7i c\u00f4ng th\u1ee9c kh\u00f4ng c\u1eadp nh\u1eadt trong Excel th\u01b0\u1eddng xu\u1ea5t ph\u00e1t t\u1eeb m\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n sau:<\/p>\n

    \n
  • \u00d4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111ang \u1edf \u0111\u1ecbnh d\u1ea1ng Text, khi\u1ebfn Excel kh\u00f4ng nh\u1eadn di\u1ec7n v\u00e0 kh\u00f4ng t\u00ednh to\u00e1n (l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t).<\/li>\n
  • Ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c \u0111ang b\u1eadt, n\u00ean Excel ch\u1ec9 hi\u1ec7n n\u1ed9i dung c\u00f4ng th\u1ee9c thay v\u00ec gi\u00e1 tr\u1ecb.<\/li>\n
  • Excel \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng (Manual Calculation), khi\u1ebfn c\u00f4ng th\u1ee9c kh\u00f4ng t\u1ef1 c\u1eadp nh\u1eadt khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/li>\n
  • C\u00f4ng th\u1ee9c r\u01a1i v\u00e0o tr\u01b0\u1eddng h\u1ee3p Circular References, t\u1ee9c c\u00f4ng th\u1ee9c \u0111ang t\u1ef1 tham chi\u1ebfu l\u1ea1i ch\u00ednh n\u00f3 khi\u1ebfn Excel kh\u00f4ng th\u1ec3 t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n

    \"T\u00ecmNh\u1eefng nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel<\/em><\/p>\n

    Xem th\u00eam: <\/strong>6 C\u00e1ch th\u00eam d\u00f2ng trong Excel c\u1ef1c nhanh v\u00e0 d\u1ec5<\/div>\n
    \n

    3. C\u00e1ch s\u1eeda l\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel<\/h2>\n<\/div>\n
    \n

    3.1 S\u1eeda \u0111\u1ecbnh d\u1ea1ng \u00f4 nh\u1eadp c\u00f4ng th\u1ee9c<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111ang \u1edf \u0111\u1ecbnh d\u1ea1ng Text, sau \u0111\u00f3 truy c\u1eadp tab Home<\/strong>.<\/p>\n

    \"\u00d4Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u1ecbnh d\u1ea1ng Text \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ch\u1ec9nh s\u1eeda<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Trong nh\u00f3m Number<\/strong>, nh\u1ea5p v\u00e0o m\u1ee5c Text<\/strong> v\u00e0 \u0111\u1ed5i sang \u0111\u1ecbnh d\u1ea1ng General<\/strong>.<\/p>\n

    \"\u0110\u1ed5iChuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u1eeb Text sang General trong m\u1ee5c Number<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p \u0111\u00fap v\u00e0o \u00f4 v\u1eeba ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng r\u1ed3i nh\u1ea5n Enter<\/strong> \u0111\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c t\u00ednh l\u1ea1i.<\/p>\n

    \"K\u1ebftNh\u1ea5p \u0111\u00fap r\u1ed3i nh\u1ea5n Enter \u0111\u1ec3 Excel t\u00ednh l\u1ea1i c\u00f4ng th\u1ee9c<\/em><\/p>\n

    \n

    3.2 S\u1eeda \u0111\u1ecbnh d\u1ea1ng t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> M\u1edf tab File<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5, sau \u0111\u00f3 truy c\u1eadp m\u1ee5c Options<\/strong>.<\/p>\n

    \"GiaoV\u00e0o m\u1ee5c More trong File \u0111\u1ec3 m\u1edf ph\u1ea7n Options<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Khi h\u1ed9p tho\u1ea1i Excel Options<\/strong> xu\u1ea5t hi\u1ec7n, chuy\u1ec3n sang ph\u1ea7n Formulas<\/strong>. T\u1ea1i m\u1ee5c t\u00ednh to\u00e1n, ch\u1ecdn Automatic<\/strong> \u0111\u1ec3 thay th\u1ebf ch\u1ebf \u0111\u1ed9 Manual<\/strong>, r\u1ed3i nh\u1ea5n OK<\/strong> \u0111\u1ec3 l\u01b0u thi\u1ebft l\u1eadp. \u0110i\u1ec1u n\u00e0y gi\u00fap c\u00f4ng th\u1ee9c t\u1ef1 c\u1eadp nh\u1eadt khi sao ch\u00e9p ho\u1eb7c k\u00e9o sang c\u00e1c \u00f4 kh\u00e1c.<\/p>\n

    \"B\u1eadtCh\u1ecdn ch\u1ebf \u0111\u1ed9 Automatic \u0111\u1ec3 b\u1eadt t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng trong Excel<\/em><\/p>\n

    \n

    3.3 T\u1eaft ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> V\u00e0o tab File<\/strong>, ch\u1ecdn More\u2026<\/strong>, sau \u0111\u00f3 nh\u1ea5p Options<\/strong> \u0111\u1ec3 m\u1edf b\u1ea3ng t\u00f9y ch\u1ec9nh Excel.<\/p>\n

    \"GiaoM\u1edf File, ch\u1ecdn More r\u1ed3i truy c\u1eadp Excel Options<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> T\u1ea1i h\u1ed9p tho\u1ea1i Excel Options<\/strong>, ch\u1ecdn Advanced<\/strong>, k\u00e9o \u0111\u1ebfn m\u1ee5c Display options for this worksheet<\/strong>, b\u1ecf d\u1ea5u t\u00edch \u1edf Show formulas in cells instead of their calculated results<\/strong>, r\u1ed3i nh\u1ea5n OK<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/p>\n

    \"T\u1eaftT\u1eaft hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c v\u00e0 \u00e1p d\u1ee5ng b\u1eb1ng c\u00e1ch nh\u1ea5n OK<\/em><\/p>\n

    \n

    3.4 L\u1ed7i c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i v\u00f2ng l\u1eb7p<\/h3>\n<\/div>\n

    B\u01b0\u1edbc 1:<\/strong> M\u1edf tab Formulas<\/strong>, sau \u0111\u00f3 trong nh\u00f3m Formula Auditing b\u1ea5m Error Checking<\/strong> \u0111\u1ec3 xem danh s\u00e1ch l\u1ed7i.<\/p>\n

    \"Ki\u1ec3mTruy c\u1eadp Error Checking trong nh\u00f3m Formula Auditing<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Circular References<\/strong>. Excel s\u1ebd hi\u1ec3n th\u1ecb \u00f4 \u0111ang g\u1eb7p l\u1ed7i (v\u00ed d\u1ee5: F3). Nh\u1ea5p v\u00e0o \u00f4 \u0111\u00f3 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed ch\u1ee9a c\u00f4ng th\u1ee9c v\u00f2ng l\u1eb7p.<\/p>\n

    \"X\u00e1cDanh s\u00e1ch Circular References hi\u1ec3n th\u1ecb \u00f4 \u0111ang b\u1ecb l\u1ed7i v\u00f2ng l\u1eb7p<\/em><\/p>\n

    B\u01b0\u1edbc 3:<\/strong> S\u1eeda c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 b\u1ecb l\u1ed7i: \u0110i\u1ec1u ch\u1ec9nh tham chi\u1ebfu, thay \u0111\u1ed5i c\u00e1ch t\u00ednh ho\u1eb7c x\u00f3a c\u00f4ng th\u1ee9c g\u00e2y v\u00f2ng l\u1eb7p. Sau khi ch\u1ec9nh s\u1eeda, l\u1ed7i s\u1ebd \u0111\u01b0\u1ee3c kh\u1eafc ph\u1ee5c.<\/p>\n

    \"\u00d4\u00d4 F3 \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eeda c\u00f4ng th\u1ee9c v\u00e0 kh\u00f4ng c\u00f2n l\u1ed7i v\u00f2ng l\u1eb7p<\/em><\/p>\n

    Vi\u1ec7c kh\u00f4i ph\u1ee5c kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n c\u1ee7a c\u00f4ng th\u1ee9c gi\u00fap b\u1ea3ng d\u1eef li\u1ec7u v\u1eadn h\u00e0nh \u1ed5n \u0111\u1ecbnh v\u00e0 d\u1ec5 ki\u1ec3m so\u00e1t h\u01a1n. Khi \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch x\u1eed l\u00fd, b\u1ea1n c\u00f3 th\u1ec3 tr\u00e1nh gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c v\u00e0 duy tr\u00ec \u0111\u1ed9 ch\u00ednh x\u00e1c cho to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh. \u0110\u1eebng qu\u00ean 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 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o h\u1eefu \u00edch.<\/p>\n

    N\u1ebfu b\u1ea1n c\u1ea7n thi\u1ebft b\u1ecb m\u1ea1nh m\u1ebd h\u01a1n \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi Excel v\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng v\u0103n ph\u00f2ng, h\u00e3y gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn mua m\u00e1y t\u00ednh b\u1ea3ng ho\u1eb7c \u0111i\u1ec7n tho\u1ea1i v\u1edbi nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn d\u00e0nh cho m\u00f9a n\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p tr\u01b0\u1eddng h\u1ee3p Excel hi\u1ec3n th\u1ecb nguy\u00ean c\u00f4ng th\u1ee9c thay v\u00ec k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n. T\u00ecnh hu\u1ed1ng n\u00e0y l\u00e0m gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c v\u00e0 khi\u1ebfn b\u1ea3ng t\u00ednh d\u1ec5 sai l\u1ec7ch. Nguy\u00ean nh\u00e2n th\u01b0\u1eddng \u0111\u1ebfn t\u1eeb \u0111\u1ecbnh d\u1ea1ng \u00f4, ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n ho\u1eb7c l\u1ed7i tham […]<\/p>\n","protected":false},"author":1,"featured_media":5017,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5016","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\/19399.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5016","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=5016"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5016\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5017"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}