Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay m\u00e0 b\u1ea5t c\u1ee9 c\u00f4ng ty n\u00e0o c\u0169ng s\u1eed d\u1ee5ng. Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel, ch\u1eafc ch\u1eafn kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi nh\u1eefng l\u1ed7i ph\u00e1t sinh ra khi thao c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n, c\u00e1c thao t\u00e1c kh\u00e1c tr\u00ean b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n
V\u00ec th\u1ebf vi\u1ec7c n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n ph\u00e1t sinh c\u00e1c l\u1ed7i n\u00e0y l\u00e0 r\u1ea5t c\u1ea7n thi\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n\n\n\n
D\u01b0\u1edbi \u0111\u00e2y m\u00ecnh li\u1ec7t k\u00ea nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c, n\u1ebfu b\u1ea1n g\u1eb7p l\u1ed7i m\u00e0 kh\u00f4ng t\u00ecm th\u1ea5y trong \u0111\u00e2y th\u00ec h\u00e3y \u0111\u1ec3 l\u1ea1i comment ho\u0103c email cho m\u00ecnh (email cu\u1ed1i trang web), m\u00ecnh s\u1ebd t\u00ecm c\u00e1ch x\u1eed l\u00fd cho b\u1ea1n<\/p>\n\n\n\n
1. L\u1ed7i kh\u00f4ng th\u1ea5y t\u00ean d\u00f2ng, c\u1ed9t:<\/strong><\/p>\n\n\n\n B\u1ea1n m\u1edf b\u1ea3ng t\u00ednh ra nh\u01b0ng kh\u00f4ng th\u1ea5y t\u00ean c\u00e1c c\u1ed9t (A, B, C, D…) v\u00e0 t\u00ean c\u00e1c d\u00f2ng (1, 2, 3, 4…) \u0111\u00e2u c\u1ea3. Kh\u1eafc ph\u1ee5c: v\u00e0o menu Tools\/ Options\/ View v\u00e0 \u0111\u00e1nh d\u1ea5u ch\u1ecdn m\u1ee5c Row & column headers trong Windows Options r\u1ed3i nh\u1ea5n OK<\/p>\n\n\n\n 2. L\u1ed7i b\u1ecb m\u1ea5t \u0111\u01b0\u1eddng k\u1ebb:<\/strong><\/p>\n\n\n\n Khi b\u1ea3ng t\u00ednh Excel kh\u00f4ng hi\u1ec3n th\u1ecb c\u00e1c \u0111\u01b0\u1eddng k\u1ebb d\u1ecdc, ngang bao quanh c\u00e1c \u00f4 th\u00ec b\u1ea1n h\u00e3y v\u00e0o menu Tools\/ Options\/ View, trong m\u1ee5c Window Options b\u1ea1n \u0111\u00e1nh d\u1ea5u v\u00e0o \u00f4 Gridlines. Trong Gridlines color, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u00e0u cho nh\u1eefng \u0111\u01b0\u1eddng l\u01b0\u1edbi m\u00e0 b\u1ea1n th\u00edch r\u1ed3i nh\u1ea5n OK.<\/p>\n\n\n\n 3. L\u1ed7i m\u1ea5t sheet tab<\/strong><\/p>\n\n\n\n Trong b\u1ea3ng t\u00ednh c\u00f3 r\u1ea5t nhi\u1ec1u sheet nh\u01b0ng kh\u00f4ng th\u1ea5y sheet tab \u0111\u00e2u c\u1ea3 l\u00e0m cho b\u1ea1n kh\u00f4ng th\u1ec3 m\u1edf \u0111\u01b0\u1ee3c c\u00e1c sheet kh\u00e1c. Kh\u1eafc ph\u1ee5c: v\u00e0o menu Tools\/ Options\/ View v\u00e0 trong v\u00f9ng Window Options, b\u1ea1n h\u00e3y \u0111\u00e1nh d\u1ea5u ch\u1ecdn trong m\u1ee5c sheet tab r\u1ed3i nh\u1ea5n OK. V\u1edbi Excel t\u1eeb 2007 tr\u1edf v\u1ec1 sau th\u00ec v\u00e0o Excel Options\\Advanced\\Show sheet tabs4. C\u1ed9t hi\u1ec3n th\u1ecb s\u1ed1 1,2,3… thay v\u00ec A,B,C…<\/strong><\/p>\n\n\n\n Khi m\u1edf b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng th\u1ea5y t\u00ean c\u1ee7a c\u00e1c c\u1ed9t hi\u1ec3n th\u1ecb b\u1edfi c\u00e1c ch\u1eef c\u00e1i A, B, C… m\u00e0 thay v\u00e0o \u0111\u00f3 l\u00e0 nh\u1eefng ch\u1eef s\u1ed1 1, 2, 3… th\u00ec b\u1ea1n v\u00e0o menu Tools\/ Options, ch\u1ecdn th\u1ebb General trong \u00f4 Settings, h\u1ee7y d\u1ea5u ch\u1ecdn m\u1ee5c R1C1 Reference style\/ OK.<\/p>\n\n\n\n 5. Hi\u1ec7n th\u1ecb c\u00f4ng th\u1ee9c thay v\u00ec k\u1ebft qu\u1ea3<\/strong><\/p>\n\n\n\n C\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh r\u1ea5t r\u1ed9ng v\u00e0 trong c\u00e1c \u00f4 l\u1ea1i hi\u1ec7n c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng hi\u1ec7n k\u1ebft qu\u1ea3. Kh\u1eafc ph\u1ee5c: v\u00e0o menu Tools\/ Options\/ View, trong v\u00f9ng Window options h\u1ee7y d\u1ea5u ch\u1ecdn trong m\u1ee5c Formulas. V\u1edbi Excel t\u1eeb 2007 tr\u1edf v\u1ec1 sau th\u00ec v\u00e0o Formulas v\u00e0 ch\u1ecdn Show Formulas<\/p>\n\n\n\n 6. Nh\u1ea5n Enter con tr\u1ecf nh\u1ea3y l\u00ean<\/strong><\/p>\n\n\n\n Khi nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 k\u1ebft th\u00fac nh\u1eadp li\u1ec7u th\u00ec con tr\u1ecf l\u1ea1i nh\u1ea3y l\u00ean \u00f4 b\u00ean tr\u00ean, \u00f4 b\u00ean ph\u1ea3i hay \u00f4 b\u00ean tr\u00e1i m\u00e0 kh\u00f4ng nh\u1ea3y xu\u1ed1ng \u00f4 b\u00ean d\u01b0\u1edbi. Kh\u1eafc ph\u1ee5c: v\u00e0o menu Tools\/ Options\/ Edit, trong m\u1ee5c Direction b\u1ea1n ch\u1ecdn Down v\u00e0 nh\u1ea5n OK. V\u1edbi Excel t\u1eeb 2007 tr\u1edf v\u1ec1 sau th\u00ec v\u00e0o Excel Options\\Advanced, trong m\u1ee5c Direction b\u1ea1n ch\u1ecdn Down v\u00e0 nh\u1ea5n OK.<\/p>\n\n\n\n 7. L\u1ed7i ph\u00edm m\u0169i t\u00ean<\/strong><\/p>\n\n\n\n Khi nh\u1ea5n c\u00e1c ph\u00edm m\u0169i t\u00ean tr\u00ean b\u00e0n ph\u00edm th\u00ec l\u1ea1i cu\u1ed9n m\u00e0n h\u00ecnh ch\u1ee9 kh\u00f4ng nh\u1ea3y sang \u00f4 b\u00ean tr\u00ean, d\u01b0\u1edbi, tr\u00e1i, ph\u1ea3i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n h\u00e3y xem \u0111\u00e8n c\u1ee7a ph\u00edm Scroll Lock c\u00f3 s\u00e1ng kh\u00f4ng, n\u1ebfu c\u00f3 th\u00ec b\u1ea1n nh\u1ea5n ph\u00edm Scroll Lock \u0111\u1ec3 t\u1eaft n\u00f3 \u0111i.<\/p>\n\n\n\n 8. #NULL! L\u1ed7i d\u1eef li\u1ec7u r\u1ed7ng<\/strong><\/p>\n\n\n\n D\u00f9ng m\u1ed9t d\u00e3y to\u00e1n t\u1eed kh\u00f4ng ph\u00f9 h\u1ee3p<\/p>\n\n\n\n D\u00f9ng m\u1ed9t m\u1ea3ng kh\u00f4ng c\u00f3 ph\u00e2n c\u00e1ch.<\/p>\n\n\n\n (L\u1ed7i n\u00e0y x\u1ea3y ra khi s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p to\u00e1n t\u1eed nh\u01b0 =SUM(A1:A5 B1:B5), gi\u1eefa hai h\u00e0m n\u00e0y kh\u00f4ng c\u00f3 \u0111i\u1ec3m giao nhau, \u0111\u1ec3 kh\u1eafc ph\u1ee5c b\u1ea1n ph\u1ea3i x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c \u0111i\u1ec3m giao nhau gi\u1eefa hai h\u00e0m.)<\/p>\n\n\n\n 9. ##### L\u1ed7i \u0111\u1ed9 r\u1ed9ng<\/strong><\/p>\n\n\n\n Khi c\u1ed9t thi\u1ebfu \u0111\u1ed9 r\u1ed9ng. D\u00f9ng chu\u1ed9t k\u00e9o \u0111\u1ed9 r\u1ed9ng c\u1ed9t ra cho ph\u00f9 h\u1ee3p<\/p>\n\n\n\n Khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng ho\u1eb7c th\u1eddi gian l\u00e0 s\u1ed1 \u00e2m.<\/p>\n\n\n\n 10. #VALUE! L\u1ed7i gi\u00e1 tr\u1ecb<\/strong><\/p>\n\n\n\n B\u1ea1n nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c m\u1ed9t chu\u1ed7i trong khi h\u00e0m y\u00eau c\u1ea7u m\u1ed9t s\u1ed1 ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb logic. 11. #DIV\/0! L\u1ed7i chia cho 0<\/strong><\/p>\n\n\n\n Nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c s\u1ed1 chia l\u00e0 0. V\u00ed d\u1ee5 = MOD(10,0). 12. #NAME! Sai t\u00ean<\/strong><\/p>\n\n\n\n B\u1ea1n d\u00f9ng nh\u1eefng h\u00e0m kh\u00f4ng th\u01b0\u1eddng tr\u1ef1c trong Excel nh\u01b0 EDATE, EOMONTH, NETWORKDAYS, WORKDAYS,\u2026 Khi \u0111\u00f3 c\u1ea7n ph\u1ea3i v\u00e0o menu Tools \u2013 Add-in. \u0110\u00e1nh d\u1ea5u v\u00e0o ti\u1ec7n \u00edch Analysis ToolPak. (Excel kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c t\u00ean trong c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m =SM(BBB), \u1edf h\u00e0m n\u00e0y sai c\u1ea3 t\u00ean c\u00f4ng th\u1ee9c v\u00e0 t\u00ean m\u1ea3ng tham chi\u1ebfu t\u1edbi. Mu\u1ed1n kh\u1eafc ph\u1ee5c b\u1ea1n ph\u1ea3i s\u1eeda l\u1ea1i t\u00ean h\u00e0m cho \u0111\u00fang ho\u1eb7c nh\u1eadp \u0111\u00fang m\u1ea3ng c\u1ea7n tham chi\u1ebfu.)<\/p>\n\n\n\n 13. #N\/A L\u1ed7i d\u1eef li\u1ec7u<\/strong><\/p>\n\n\n\n Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 kh\u00f4ng t\u01b0\u01a1ng th\u00edch t\u1eeb [color=] [\/color]c\u00e1c h\u00e0m d\u00f2 t\u00ecm nh\u01b0 VLOOKUP, HLOOKUP, LOOKUP ho\u1eb7c MATCH.<\/p>\n\n\n\n D\u00f9ng h\u00e0m HLOOKUP, VLOOKUP, MATCH \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb trong b\u1ea3ng ch\u01b0a \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp.<\/p>\n\n\n\n Kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t d\u1eef li\u1ec7u khi b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ecba ch\u1ec9 m\u1ea3ng trong Excel.<\/p>\n\n\n\n Qu\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111\u1ed1i s\u1ed1 trong c\u00e1c h\u00e0m t\u1ef1 t\u1ea1o.<\/p>\n\n\n\n D\u00f9ng m\u1ed9t h\u00e0m t\u1ef1 t\u1ea1o kh\u00f4ng h\u1ee3p l\u00fd.<\/p>\n\n\n\n (X\u1ea3y ra khi c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 trong m\u1ea3ng nh\u01b0ng \u00f4 \u0111\u00f3 l\u1ea1i kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb. L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra v\u1edbi c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm nh\u01b0 VLOOKUP, HLOOKUP\u2026 B\u1ea1n ch\u1ec9 c\u1ea7n xem k\u1ef9 l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 ch\u1ec9nh s\u1eeda \u00f4 m\u00e0 h\u00e0m tham chi\u1ebfu t\u1edbi.)<\/p>\n\n\n\n 14. #REF! Sai v\u00f9ng tham chi\u1ebfu<\/strong><\/p>\n\n\n\n X\u00f3a nh\u1eefng \u00f4 \u0111ang \u0111\u01b0\u1ee3c tham chi\u1ebfu b\u1edfi c\u00f4ng th\u1ee9c. Ho\u1eb7c d\u00e1n nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb c\u00f4ng th\u1ee9c l\u00ean ch\u00ednh v\u00f9ng tham chi\u1ebfu c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u00f3.<\/p>\n\n\n\n (\u0110\u00e2y l\u00e0 l\u1ed7i tham chi\u1ebfu \u00f4, ch\u1eb3ng h\u1ea1n b\u1ea1n x\u00f3a d\u00f2ng hay c\u1ed9t m\u00e0 d\u00f2ng c\u1ed9t \u0111\u00f3 \u0111\u01b0\u1ee3c d\u00f9ng trong c\u00f4ng th\u1ee9c, khi \u0111\u00f3 s\u1ebd b\u1ecb b\u00e1o l\u1ed7i #REF!)<\/p>\n\n\n\n Li\u00ean k\u1ebft ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u1ee9ng d\u1ee5ng kh\u00f4ng th\u1ec3 ch\u1ea1y \u0111\u01b0\u1ee3c.<\/p>\n\n\n\n 15. #NUM! L\u1ed7i d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1<\/strong><\/p>\n\n\n\n D\u00f9ng m\u1ed9t \u0111\u1ed1i s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p trong c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng \u0111\u1ed1i s\u1ed1 l\u00e0 d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1. V\u00ed d\u1ee5 b\u1ea1n \u0111\u01b0a v\u00e0o c\u00f4ng th\u1ee9c s\u1ed1 \u00e2m trong khi n\u00f3 ch\u1ec9 t\u00ednh s\u1ed1 d\u01b0\u01a1ng.<\/p>\n\n\n\n D\u00f9ng h\u00e0m l\u1eb7p \u0111i l\u1eb7p l\u1ea1i d\u1eabn \u0111\u1ebfn h\u00e0m kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1.<\/p>\n\n\n\n D\u00f9ng m\u1ed9t h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 nh\u1ecf so v\u1edbi kh\u1ea3 n\u0103ng t\u00ednh to\u00e1n c\u1ee7a Excel.<\/p>\n\n\n\n (Gi\u00e1 tr\u1ecb s\u1ed1 trong c\u00f4ng th\u1ee9c kh\u00f4ng h\u1ee3p l\u1ec7, s\u1ed1 qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 b\u00e9. Ch\u1eb3ng h\u1ea1n nh\u01b0 ph\u00e9p t\u00ednh =99^999 s\u1ebd b\u1ecb b\u00e1o l\u1ed7i #NUM!, b\u1ea1n ch\u1ec9 c\u1ea7n gi\u1ea3m b\u1edbt gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n l\u1ea1i.)<\/p>\n","protected":false},"excerpt":{"rendered":" Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 t\u00ednh to\u00e1n ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay m\u00e0 b\u1ea5t c\u1ee9 c\u00f4ng ty n\u00e0o […]<\/p>\n","protected":false},"author":6,"featured_media":9327,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-6004","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-van-phong"],"views":539,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/6004","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/comments?post=6004"}],"version-history":[{"count":1,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/6004\/revisions"}],"predecessor-version":[{"id":9326,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/6004\/revisions\/9326"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media\/9327"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=6004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=6004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=6004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\u0110ang nh\u1eadp m\u1ed9t ho\u1eb7c ch\u1ec9nh s\u1eeda c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c m\u00e0 nh\u1ea5n Enter.
Nh\u1eadp qu\u00e1 nhi\u1ec1u tham s\u1ed1 cho m\u1ed9t to\u00e1n t\u1eed ho\u1eb7c m\u1ed9t h\u00e0m trong khi ch\u00fang ch\u1ec9 d\u00f9ng m\u1ed9t tham s\u1ed1. V\u00ed d\u1ee5 =LEFT(A2:A5)
Thi h\u00e0nh m\u1ed9t marco (l\u1ec7nh t\u1ef1 \u0111\u1ed9ng) li\u00ean quan \u0111\u1ebfn m\u1ed9t h\u00e0m m\u00e0 h\u00e0m \u0111\u00f3 tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!
(Xu\u1ea5t hi\u1ec7n khi trong c\u00f4ng th\u1ee9c c\u00f3 c\u00e1c ph\u00e9p to\u00e1n kh\u00f4ng c\u00f9ng m\u1ed9t ki\u1ec3u d\u1eef li\u1ec7u. Ch\u1eb3ng h\u1ea1n c\u00f4ng th\u1ee9c =A1+A2, trong \u0111\u00f3 A1 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 1, A2 l\u00e0 T\u00e2y Ninh.V\u00ec 1 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 s\u1ed1 h\u1ecdc, c\u00f2n T\u00e2y Ninh l\u1ea1i l\u00e0 m\u1ed9t chu\u1ed7i m\u1eabu t\u1ef1 n\u00ean kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n ph\u1ea3i ch\u1ec9nh s\u1eeda cho gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c ph\u00e9p to\u00e1n c\u00f3 c\u00f9ng m\u1ed9t ki\u1ec3u d\u1eef li\u1ec7u l\u00e0 k\u00fd t\u1ef1 s\u1ed1 h\u1ecdc ho\u1eb7c chu\u1ed7i m\u1eabu t\u1ef1.)<\/p>\n\n\n\n
S\u1ed1 chia trong c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn \u00f4 tr\u1ed1ng.<\/p>\n\n\n\n
Nh\u1eadp sai t\u00ean m\u1ed9t h\u00e0m s\u1ed1. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y x\u1ea3y tra khi b\u1ea1n d\u00f9ng b\u1ed9 g\u00f5 ti\u1ebfng Vi\u1ec7t \u1edf ch\u1ebf \u0111\u1ed9 Telex v\u00f4 t\u00ecnh l\u00e0m sai t\u00ean h\u00e0m nh\u01b0 IF th\u00e0nh \u00cc, VLOOKUP th\u00e0nh VL\u00d4KUP.
D\u00f9ng nh\u1eefng k\u00fd t\u1ef1 kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p trong c\u00f4ng th\u1ee9c.
Nh\u1eadp m\u1ed9t chu\u1ed7i trong c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng c\u00f3 \u0111\u00f3ng v\u00e0 m\u1edf d\u1ea5u nh\u00e1y \u0111\u00f4i.\u201d\u201d
Kh\u00f4ng c\u00f3 d\u1ea5u 2 ch\u1ea5m : trong d\u00e3y \u0111\u1ecba ch\u1ec9 \u00f4 trong c\u00f4ng th\u1ee9c.<\/p>\n\n\n\n