{"id":20431,"date":"2021-05-04T10:16:14","date_gmt":"2021-05-04T10:16:14","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=20431"},"modified":"2024-07-03T11:33:40","modified_gmt":"2024-07-03T04:33:40","slug":"cach-khac-phuc-loi-excel-khong-nhay-cong-thuc","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=20431","title":{"rendered":"C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c"},"content":{"rendered":"

B\u1ea1n s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n? Th\u1ebf nh\u01b0ng sau khi nh\u1eadp h\u00e0m v\u00e0 nh\u1ea5n Enter th\u00ec k\u1ebft qu\u1ea3 kh\u00f4ng hi\u1ec7n ra? Ho\u1eb7c khi b\u1ea1n k\u00e9o chu\u1ed9t \u0111\u1ec3 l\u1eb7p l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u00f3 cho c\u00e1c h\u00e0ng ti\u1ebfp theo th\u00ec k\u1ebft qu\u1ea3 kh\u00f4ng hi\u1ec7n? V\u1eady c\u00f3 c\u00e1ch n\u00e0o kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c<\/strong> hay kh\u00f4ng?<\/span><\/p>\n

\"C\u00e1ch
C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c<\/span><\/figcaption><\/figure>\n

Th\u1eadt ra c\u00e1ch th\u1ee9c kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n. B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c thao t\u00e1c b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n

Xem th\u00eam:\u00a0H\u01b0\u1edbng d\u1eabn t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c tr\u00ean Excel<\/a><\/span><\/p><\/blockquote>\n

Nguy\u00ean nh\u00e2n l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c<\/strong><\/span><\/h2>\n

M\u00e1y t\u00ednh c\u1ee7a b\u1ea1n b\u1ecb l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 do nh\u1eefng nguy\u00ean nh\u00e2n sau \u0111\u00e2y g\u00e2y n\u00ean:<\/span><\/p>\n

– Do \u00f4 \u0111\u00f3 \u0111ang \u1edf \u0111\u1ecbnh d\u1ea1ng Text.<\/span><\/p>\n

– Do Excel \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c.<\/span><\/p>\n

– Do Excel \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng (manual).<\/span><\/p>\n

– Do c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111ang b\u1ecb v\u00f2ng l\u1eb7p.<\/span><\/p>\n

 <\/p>\n

H\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c<\/strong><\/span><\/h2>\n

 <\/p>\n

C\u00e1ch 1: S\u1eed d\u1ee5ng ph\u00edm t\u1eaft<\/span><\/h3>\n

Ngo\u00e0i c\u00e1c ph\u01b0\u01a1ng ph\u00e1p tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm F9<\/strong> sau m\u1ed7i l\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb cho \u00f4 \u0111\u00f3. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng \u00e1n t\u1ea1m th\u1eddi khi b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c nhanh l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng c\u1ea7n x\u00e1c \u0111\u1ecbnh nguy\u00ean nh\u00e2n l\u1ed7i.<\/span><\/p>\n

 <\/p>\n

C\u00e1ch 2: Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng Text<\/span><\/h3>\n

\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c do \u00f4 \u0111\u00f3 \u0111ang \u1edf \u0111\u1ecbnh d\u1ea1ng Text th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n chuy\u1ec3n n\u00f3 v\u1ec1 m\u1ed9t \u0111\u1ecbnh d\u1ea1ng kh\u00e1c (B\u1ea5t c\u1ee9 d\u1ea1ng n\u00e0o kh\u00e1c Text) \u1edf tab Home > Number<\/strong> r\u1ed3i nh\u1eadp l\u1ea1i c\u00f4ng th\u1ee9c l\u00e0 xong.<\/span><\/p>\n

\"Thay
Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng Text<\/span><\/figcaption><\/figure>\n

C\u00e1ch 3: T\u1eaft ch\u1ebf \u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/span><\/h3>\n

\u0110\u1ec3 t\u1eaft ch\u1ebf \u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c, b\u1ea1n truy c\u1eadp l\u1ea7n l\u01b0\u1ee3t nh\u01b0 sau: D\u1ea5u m\u0169i t\u00ean tr\u00ean c\u00f9ng > More Commands\u2026 > Advanced ><\/strong> B\u1ecf ch\u1ecdn Show formulas in cells instead of their calculated results.<\/strong><\/span><\/p>\n

\"T\u1eaft
T\u1eaft ch\u1ebf \u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/span><\/figcaption><\/figure>\n

C\u00e1ch 4: Chuy\u1ec3n v\u1ec1 ch\u1ebf \u0111\u1ed9 t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n<\/span><\/h3>\n

C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

B\u01b0\u1edbc 1:<\/strong> B\u1ea1n nh\u1ea5n v\u00e0o d\u1ea5u m\u0169i t\u00ean tr\u00ean c\u00f9ng v\u00e0 ch\u1ecdn More Commands\u2026\u00a0<\/strong><\/span><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Formulas<\/strong> \u1edf c\u1ed9t b\u00ean tr\u00e1i r\u1ed3i chuy\u1ec3n v\u1ec1 ch\u1ebf \u0111\u1ed9 Automatic<\/strong> trong Workbook Calculation<\/strong>.<\/span><\/p>\n

\"Chuy\u1ec3n
Chuy\u1ec3n v\u1ec1 ch\u1ebf \u0111\u1ed9 t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n<\/span><\/figcaption><\/figure>\n

B\u01b0\u1edbc 3:<\/strong> Cu\u1ed1i c\u00f9ng nh\u1ea5n OK<\/strong> l\u00e0 xong.<\/span><\/p>\n

 <\/p>\n

C\u00e1ch 5: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p c\u00f4ng th\u1ee9c (N\u1ebfu c\u00f3)<\/span><\/h3>\n

Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a \u0111o\u1ea1n m\u00e3 b\u1eb1ng 0 th\u00ec c\u00f3 kh\u1ea3 n\u0103ng l\u00e0 Excel c\u1ee7a b\u1ea1n \u0111ang b\u1ecb l\u1eb7p c\u00f4ng th\u1ee9c. Do v\u1eady, b\u1ea1n c\u1ea7n lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p c\u00f4ng th\u1ee9c n\u00e0y \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

B\u01b0\u1edbc 1:<\/strong> Tr\u00ean c\u1eeda s\u1ed5 Excel, b\u1ea1n chuy\u1ec3n sang tab Formulas<\/strong>.<\/span><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n v\u00e0o Error Checking<\/strong> v\u00e0 ch\u1ecdn Circular References<\/strong>.<\/span><\/p>\n

\"Lo\u1ea1i
Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p c\u00f4ng th\u1ee9c<\/span><\/figcaption><\/figure>\n

B\u01b0\u1edbc 3:<\/strong> T\u1ea1i \u0111\u00e2y, b\u1ea1n s\u1ebd th\u1ea5y nh\u1eefng \u00f4 \u0111ang b\u1ecb l\u1eb7p c\u00f4ng th\u1ee9c. Ti\u1ebfp theo, b\u1ea1n ti\u1ebfn h\u00e0nh \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c nh\u1eadp l\u1ea1i gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 b\u1ecb l\u1eb7p \u0111\u1ec3 s\u1eeda l\u1ed7i.<\/span><\/p>\n

Xem th\u00eam:\u00a0L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eeda l\u1ed7i Word, Excel, PowerPoint kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file tr\u1ef1c ti\u1ebfp<\/a><\/span><\/p><\/blockquote>\n

Tr\u00ean \u0111\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a H\u1ecdc vi\u1ec7n iT.vn v\u1ec1 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c. Hy v\u1ecdng nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 gi\u00fap \u00edch cho b\u1ea1n trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c. N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o th\u00ec h\u00e3y \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn ngay d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y ho\u1eb7c inbox tr\u1ef1c ti\u1ebfp cho HOCVIENiT.vn \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p t\u1ed1t nh\u1ea5t. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n

M\u1ecdi chi ti\u1ebft xin vui l\u00f2ng li\u00ean h\u1ec7:
\n<\/i>C\u00d4NG TY C\u1ed4 PH\u1ea6N H\u1eccC VI\u1ec6N IT
\n<\/strong>MST: 0108733789
\n<\/strong>T\u1ed5ng \u0111\u00e0i h\u1ed7 tr\u1ee3: 024 3566 8686 \u2013 Hotline: 0981 223 001
\n<\/strong>Facebook:<\/strong>\u00a0www.fb.com\/hocvienit<\/a>
\n\u0110\u0103ng k\u00fd k\u00eanh Youtube \u0111\u1ec3 theo d\u00f5i c\u00e1c b\u00e0i h\u1ecdc c\u1ee7a Hu\u1ea5n luy\u1ec7n vi\u00ean t\u1ed1t nh\u1ea5t:<\/strong>\u00a0http:\/\/bit.ly\/Youtube_HOCVIENiT<\/a>
\nH\u1ec7 th\u1ed1ng c\u01a1 s\u1edf \u0111\u00e0o t\u1ea1o:\u00a0<\/b>https:\/\/hocvienit.vn\/lien-he\/<\/a>
\nH\u1ecdc vi\u1ec7n IT.vn \u2013 Truy\u1ec1n ngh\u1ec1 th\u1ef1c t\u1ebf c\u00f9ng b\u1ea1n \u0111\u1ebfn th\u00e0nh c\u00f4ng!\u00a0<\/i><\/strong><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

B\u1ea1n s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n? Th\u1ebf nh\u01b0ng sau khi nh\u1eadp h\u00e0m v\u00e0 nh\u1ea5n Enter th\u00ec k\u1ebft qu\u1ea3 kh\u00f4ng hi\u1ec7n ra? Ho\u1eb7c khi b\u1ea1n k\u00e9o chu\u1ed9t \u0111\u1ec3 l\u1eb7p l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u00f3 cho c\u00e1c h\u00e0ng ti\u1ebfp theo th\u00ec k\u1ebft qu\u1ea3 kh\u00f4ng hi\u1ec7n? V\u1eady c\u00f3 c\u00e1ch n\u00e0o kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng Excel kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c hay kh\u00f4ng?<\/p>\n","protected":false},"author":95,"featured_media":20432,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96,94],"tags":[482],"_links":{"self":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/20431"}],"collection":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20431"}],"version-history":[{"count":0,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/20431\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/media\/20432"}],"wp:attachment":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}