{"id":474325,"date":"2025-07-18T21:20:41","date_gmt":"2025-07-18T14:20:41","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=474325"},"modified":"2025-07-18T21:20:41","modified_gmt":"2025-07-18T14:20:41","slug":"trong-excel-co-nghia-la-gi","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/trong-excel-co-nghia-la-gi\/","title":{"rendered":"#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec? C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"

#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/b> T\u1ea1i sao b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n b\u1ed7ng d\u01b0ng xu\u1ea5t hi\u1ec7n to\u00e0n d\u1ea5u th\u0103ng m\u00e0 kh\u00f4ng ph\u1ea3i con s\u1ed1 hay ng\u00e0y th\u00e1ng? B\u1ea1n \u0111\u1eebng lo, \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u1ed7i nghi\u00eam tr\u1ecdng! Ch\u1ec9 c\u1ea7n b\u1ea1n xem qua b\u00e0i chia s\u1ebb th\u1ee7 thu\u1eadt c\u1ee7a Ho\u00e0ng H\u00e0 Mobile c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i c\u1ef1c \u0111\u01a1n gi\u1ea3n nh\u00e9.<\/span><\/p>\n

#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/b><\/h2>\n

C\u00e2u h\u1ecfi t\u01b0\u1edfng ch\u1eebng \u0111\u01a1n gi\u1ea3n nh\u01b0ng l\u1ea1i khi\u1ebfn kh\u00f4ng \u00edt ng\u01b0\u1eddi d\u00f9ng Excel c\u1ea3m th\u1ea5y b\u1ed1i r\u1ed1i. Th\u1ef1c t\u1ebf, k\u00fd hi\u1ec7u \u201c####\u201d kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i h\u1ec7 th\u1ed1ng hay sai s\u00f3t nghi\u00eam tr\u1ecdng, m\u00e0 l\u00e0 c\u00e1ch Excel th\u00f4ng b\u00e1o r\u1eb1ng n\u1ed9i dung trong \u00f4 \u0111ang b\u1ecb che khu\u1ea5t ho\u1eb7c kh\u00f4ng \u0111\u1ee7 ch\u1ed7 hi\u1ec3n th\u1ecb. Th\u01b0\u1eddng g\u1eb7p nh\u1ea5t l\u00e0 khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng ho\u1eb7c s\u1ed1 li\u1ec7u l\u1edbn, v\u00e0 chi\u1ec1u r\u1ed9ng c\u1ed9t kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u1ee7 \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-1\"<\/picture><\/p>\n

Khi \u0111\u00f3, thay v\u00ec hi\u1ec7n n\u1ed9i dung c\u1ee5 th\u1ec3, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng thay th\u1ebf b\u1eb1ng chu\u1ed7i d\u1ea5u th\u0103ng nh\u1eb1m c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh giao di\u1ec7n. \u0110i\u1ec1u n\u00e0y kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn gi\u00e1 tr\u1ecb th\u1ef1c b\u00ean trong \u00f4, nh\u01b0ng c\u00f3 th\u1ec3 g\u00e2y nh\u1ea7m l\u1eabn n\u1ebfu b\u1ea1n kh\u00f4ng hi\u1ec3u nguy\u00ean nh\u00e2n. \u0110\u1ec3 x\u1eed l\u00fd nhanh g\u1ecdn, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o gi\u00e3n c\u1ed9t r\u1ed9ng ra ho\u1eb7c thay \u0111\u1ed5i ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p.<\/span><\/p>\n

Ngo\u00e0i ra, l\u1ed7i n\u00e0y c\u0169ng c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi gi\u00e1 tr\u1ecb \u00e2m \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo ki\u1ec3u ng\u00e0y th\u00e1ng \u2013 \u0111i\u1ec1u m\u00e0 Excel kh\u00f4ng th\u1ec3 di\u1ec5n gi\u1ea3i, d\u1eabn \u0111\u1ebfn vi\u1ec7c hi\u1ec3n th\u1ecb ####. Do \u0111\u00f3, hi\u1ec3u r\u00f5 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng, d\u1ea5u v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong Excel s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c t\u00ecnh tr\u1ea1ng n\u00e0y m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #### trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/b><\/h2>\n

G\u1eb7p l\u1ed7i hi\u1ec3n th\u1ecb<\/span> #### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec<\/b> m\u00e0 khi\u1ebfn b\u1ea1n hoang mang? \u0110\u1eebng lo, \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ed7i ph\u1ed5 bi\u1ebfn v\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 x\u1eed l\u00fd ch\u1ec9 trong v\u00e0i gi\u00e2y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #### trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c, k\u1ec3 c\u1ea3 khi b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u l\u00e0m quen v\u1edbi b\u1ea3ng t\u00ednh.<\/span><\/p>\n

L\u1ed7i hi\u1ec3n th\u1ecb #### \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u qu\u00e1 d\u00e0i<\/b><\/h3>\n

Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, kh\u00f4ng \u00edt ng\u01b0\u1eddi g\u1eb7p t\u00ecnh hu\u1ed1ng c\u00e1c \u00f4 t\u00ednh hi\u1ec3n th\u1ecb chu\u1ed7i d\u1ea5u #### thay v\u00ec n\u1ed9i dung ban \u0111\u1ea7u. \u0110\u00e2y l\u00e0 l\u1ed7i hi\u1ec3n th\u1ecb kh\u00e1 ph\u1ed5 bi\u1ebfn, th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n nh\u1eadp n\u1ed9i dung qu\u00e1 d\u00e0i ho\u1eb7c sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb file hay Sheet kh\u00e1c. L\u00fac n\u00e0y, k\u00edch th\u01b0\u1edbc c\u1ed9t kh\u00f4ng \u0111\u1ee7 \u0111\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 d\u1eef li\u1ec7u, khi\u1ebfn Excel “thay th\u1ebf” n\u1ed9i dung b\u1eb1ng c\u00e1c d\u1ea5u #### \u0111\u1ec3 b\u00e1o hi\u1ec7u c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh giao di\u1ec7n.<\/span><\/p>\n

V\u00ed d\u1ee5: Khi b\u1ea1n copy m\u1ed9t b\u1ea3ng t\u1eeb Sheet kh\u00e1c sang, c\u00e1c \u00f4 ch\u1ee9a s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c chu\u1ed7i k\u00fd t\u1ef1 d\u00e0i d\u1ec5 g\u1eb7p l\u1ed7i n\u00e0y n\u1ebfu c\u1ed9t b\u1ecb thu h\u1eb9p.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-2\"<\/picture><\/p>\n

C\u00e1ch 1: B\u1ea1n ch\u1ec9 c\u1ea7n di chu\u1ed9t \u0111\u1ebfn \u0111\u01b0\u1eddng vi\u1ec1n b\u00ean ph\u1ea3i c\u1ee7a ti\u00eau \u0111\u1ec1 c\u1ed9t b\u1ecb l\u1ed7i (v\u00ed d\u1ee5, c\u1ed9t B), nh\u1ea5n gi\u1eef chu\u1ed9t tr\u00e1i r\u1ed3i k\u00e9o sang ph\u1ea3i cho \u0111\u1ebfn khi n\u1ed9i dung trong \u00f4 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay l\u1eadp t\u1ee9c.<\/span><\/p>\n

C\u00e1ch 2: \u0110\u01b0a chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed ng\u0103n c\u00e1ch gi\u1eefa hai c\u1ed9t (v\u00ed d\u1ee5 gi\u1eefa c\u1ed9t A v\u00e0 B), sau \u0111\u00f3 nh\u1ea5p \u0111\u00fap chu\u1ed9t tr\u00e1i. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng c\u1ed9t \u0111\u00f3 \u0111\u1ebfn \u0111\u1ed9 r\u1ed9ng ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi n\u1ed9i dung d\u00e0i nh\u1ea5t trong c\u1ed9t, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 kh\u00f4ng c\u1ea7n c\u0103n ch\u1ec9nh th\u1ee7 c\u00f4ng.<\/span><\/p>\n

\u0110\u00e3 m\u1edf r\u1ed9ng \u00f4 nh\u01b0ng v\u1eabn c\u00f2n l\u1ed7i ####<\/b><\/h3>\n

Tr\u01b0\u1eddng h\u1ee3p hi\u1ebfm g\u1eb7p h\u01a1n c\u1ee7a l\u1ed7i <\/span>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/b> \u0110\u00f3 l\u00e0 khi b\u1ea1n \u0111\u00e3 m\u1edf r\u1ed9ng c\u1ed9t nh\u01b0ng k\u00fd hi\u1ec7u #### v\u1eabn xu\u1ea5t hi\u1ec7n. Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t trong t\u00ecnh hu\u1ed1ng n\u00e0y l\u00e0 do \u00f4 \u0111ang ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi gi\u00e1 tr\u1ecb \u00e2m, \u0111i\u1ec1u m\u00e0 Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c trong \u0111\u1ecbnh d\u1ea1ng ng\u00e0y m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n

V\u00ed d\u1ee5: B\u1ea1n th\u1ea5y \u00f4 t\u00ednh hi\u1ec3n th\u1ecb ####, nh\u01b0ng khi nh\u1ea5p v\u00e0o \u00f4 \u0111\u00f3, n\u1ed9i dung b\u00ean trong l\u1ea1i l\u00e0 c\u00f4ng th\u1ee9c nh\u01b0 =-3\/1\/2012. \u0110\u00e2y ch\u00ednh l\u00e0 l\u00fac Excel kh\u00f4ng hi\u1ec3u \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng \u00e2m v\u00e0 hi\u1ec3n th\u1ecb chu\u1ed7i d\u1ea5u #### \u0111\u1ec3 b\u00e1o l\u1ed7i.\u00a0<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-3\"<\/picture><\/p>\n

C\u00e1ch 1: Trong tr\u01b0\u1eddng h\u1ee3p \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb ki\u1ec3u =-3\/1\/2012, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o \u00f4 l\u1ed7i, sau \u0111\u00f3 x\u00f3a d\u1ea5u \u201c=\u201d v\u00e0 d\u1ea5u \u201c-\u201d \u1edf \u0111\u1ea7u c\u00f4ng th\u1ee9c. Sau khi x\u00f3a, h\u00e3y th\u00eam l\u1ea1i d\u1ea5u \u201c-\u201d \u1edf ph\u00eda tr\u01b0\u1edbc ng\u00e0y th\u00e1ng theo \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb, v\u00ed d\u1ee5: -3\/1\/2012 thay v\u00ec =-3\/1\/2012. Thao t\u00e1c n\u00e0y gi\u00fap Excel hi\u1ec3u \u0111\u00e2y l\u00e0 m\u1ed9t chu\u1ed7i ng\u00e0y th\u00e1ng th\u00f4ng th\u01b0\u1eddng c\u00f3 gi\u00e1 tr\u1ecb \u00e2m m\u00e0 kh\u00f4ng th\u00f4ng qua t\u00ednh to\u00e1n c\u00f4ng th\u1ee9c, t\u1eeb \u0111\u00f3 tr\u00e1nh b\u1ecb l\u1ed7i hi\u1ec3n th\u1ecb.<\/span><\/p>\n

C\u00e1ch 2: N\u1ebfu mu\u1ed1n gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb \u00e2m trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u1eeb Date sang General. Th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4, ch\u1ecdn \u201cFormat Cells\u201d, sau \u0111\u00f3 ch\u1ecdn m\u1ee5c \u201cGeneral\u201d. Khi \u0111\u00f3, Excel s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng s\u1ed1 thay v\u00ec c\u1ed1 g\u1eafng di\u1ec5n gi\u1ea3i m\u1ed9t ng\u00e0y \u00e2m \u2014 \u0111i\u1ec1u n\u00f3 v\u1ed1n kh\u00f4ng th\u1ec3 l\u00e0m. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c ph\u00e9p t\u00ednh c\u00f3 th\u1ec3 cho k\u1ebft qu\u1ea3 \u00e2m.<\/span><\/p>\n

M\u1ed9t s\u1ed1 l\u1ed7i hi\u1ec3n th\u1ecb kh\u00e1c trong Excel<\/b><\/h2>\n

Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft v\u1ec1 l\u1ed7i <\/span>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec<\/b>? Ngo\u00e0i l\u1ed7i #### quen thu\u1ed9c, Excel c\u00f2n c\u00f3 nhi\u1ec1u l\u1ed7i hi\u1ec3n th\u1ecb kh\u00e1c khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng b\u1ed1i r\u1ed1i n\u1ebfu kh\u00f4ng hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n. Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch nh\u1eadn di\u1ec7n nhanh ch\u00f3ng \u0111\u1ec3 x\u1eed l\u00fd hi\u1ec7u qu\u1ea3 trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh.<\/span><\/p>\n

L\u1ed7i #NAME?<\/b><\/h3>\n

L\u1ed7i #NAME? trong Excel l\u00e0 m\u1ed9t d\u1ea1ng c\u1ea3nh b\u00e1o ph\u1ed5 bi\u1ebfn khi ph\u1ea7n m\u1ec1m kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c b\u1ea1n \u0111ang s\u1eed d\u1ee5ng. Nguy\u00ean nh\u00e2n ch\u00ednh th\u01b0\u1eddng do g\u00f5 sai t\u00ean h\u00e0m, thi\u1ebfu d\u1ea5u ngo\u1eb7c, qu\u00ean d\u1ea5u nh\u00e1y k\u00e9p khi d\u00f9ng chu\u1ed7i v\u0103n b\u1ea3n, ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn t\u00ean v\u00f9ng ch\u01b0a \u0111\u01b0\u1ee3c khai b\u00e1o. Khi g\u1eb7p l\u1ed7i n\u00e0y, Excel hi\u1ec3u r\u1eb1ng b\u1ea1n \u0111ang y\u00eau c\u1ea7u th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p t\u00ednh, nh\u01b0ng c\u00fa ph\u00e1p b\u1ea1n nh\u1eadp v\u00e0o l\u1ea1i kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng t\u1ed3n t\u1ea1i trong h\u1ec7 th\u1ed1ng h\u00e0m m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n

V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n g\u00f5 \u201c=sume(A1:A5)\u201d thay v\u00ec \u201c=SUM(A1:A5)\u201d, Excel s\u1ebd b\u00e1o l\u1ed7i #NAME? v\u00ec \u201csu\u201d kh\u00f4ng ph\u1ea3i l\u00e0 h\u00e0m h\u1ee3p l\u1ec7. \u0110\u00e2y l\u00e0 l\u1ed7i d\u1ec5 m\u1eafc, \u0111\u1eb7c bi\u1ec7t v\u1edbi ng\u01b0\u1eddi m\u1edbi h\u1ecdc Excel ho\u1eb7c khi s\u1eed d\u1ee5ng h\u00e0m \u00edt g\u1eb7p.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-4\"<\/picture><\/p>\n

\u0110\u1ec3 tr\u00e1nh l\u1ed7i, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u nh\u1eadp v\u00e0i k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00f4ng th\u1ee9c \u2014 Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch g\u1ee3i \u00fd c\u00e1c h\u00e0m c\u00f3 s\u1eb5n. Khi th\u1ea5y \u0111\u00fang h\u00e0m, h\u00e3y nh\u1ea5n Tab \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ho\u00e0n t\u1ea5t t\u00ean h\u00e0m v\u00e0 \u0111\u1ea3m b\u1ea3o ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i. C\u00e1ch n\u00e0y gi\u00fap gi\u1ea3m r\u1ee7i ro sai s\u00f3t th\u1ee7 c\u00f4ng trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u.<\/span><\/p>\n

M\u1ed9t m\u1eb9o nh\u1ecf kh\u00e1c l\u00e0 lu\u00f4n g\u00f5 h\u00e0m \u1edf d\u1ea1ng ch\u1eef th\u01b0\u1eddng. N\u1ebfu h\u00e0m h\u1ee3p l\u1ec7, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n sang ch\u1eef in hoa, \u0111\u00e2y l\u00e0 d\u1ea5u hi\u1ec7u nh\u1eadn bi\u1ebft r\u00f5 r\u00e0ng r\u1eb1ng b\u1ea1n \u0111\u00e3 vi\u1ebft \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu b\u1ea1n g\u00f5 sai v\u00e0 c\u00f4ng th\u1ee9c v\u1eabn hi\u1ec3n th\u1ecb \u1edf d\u1ea1ng ch\u1eef th\u01b0\u1eddng, h\u00e3y ki\u1ec3m tra l\u1ea1i ngay \u0111\u1ec3 k\u1ecbp th\u1eddi s\u1eeda l\u1ed7i, tr\u00e1nh \u1ea3nh h\u01b0\u1edfng k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n.<\/span><\/p>\n

L\u1ed7i #DIV\/0!<\/b><\/h3>\n

Ngay sau khi bi\u1ebft \u0111\u01b0\u1ee3c l\u1ed7i hi\u1ec3n th\u1ecb <\/span>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/b> B\u1ea1n c\u0169ng n\u00ean bi\u1ebft \u0111\u1ebfn l\u1ed7i #DIV\/0! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i hi\u1ec3n th\u1ecb th\u01b0\u1eddng g\u1eb7p nh\u1ea5t, \u0111\u1eb7c bi\u1ec7t khi th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p chia. L\u1ed7i n\u00e0y x\u1ea3y ra khi c\u00f4ng th\u1ee9c c\u1ed1 g\u1eafng chia cho m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1eb1ng 0 ho\u1eb7c \u00f4 tr\u1ed1ng. B\u1edfi v\u00ec, theo quy t\u1eafc to\u00e1n h\u1ecdc c\u01a1 b\u1ea3n, ph\u00e9p chia cho s\u1ed1 0 l\u00e0 v\u00f4 ngh\u0129a v\u00e0 kh\u00f4ng x\u00e1c \u0111\u1ecbnh. Excel c\u0169ng tu\u00e2n theo nguy\u00ean t\u1eafc \u0111\u00f3 v\u00e0 b\u00e1o l\u1ed7i khi g\u1eb7p tr\u01b0\u1eddng h\u1ee3p t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n

V\u00ed d\u1ee5: Khi b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =A1\/B1, n\u1ebfu \u00f4 B1 r\u1ed7ng ho\u1eb7c c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0, Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 #DIV\/0! \u0111\u1ec3 c\u1ea3nh b\u00e1o r\u1eb1ng ph\u00e9p chia kh\u00f4ng h\u1ee3p l\u1ec7. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea3ng t\u00ednh b\u1ecb gi\u00e1n \u0111o\u1ea1n ho\u1eb7c g\u00e2y hi\u1ec3u l\u1ea7m n\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng nh\u1eadn ra nguy\u00ean nh\u00e2n th\u1ef1c s\u1ef1.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-5\"<\/picture><\/p>\n

C\u00e1ch x\u1eed l\u00fd l\u1ed7i n\u00e0y kh\u00f4ng ph\u1ee9c t\u1ea1p. N\u1ebfu \u00f4 b\u1ecb l\u1ed7i do kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t s\u1ed1 kh\u00e1c 0 \u0111\u1ec3 ho\u00e0n th\u00e0nh ph\u00e9p t\u00ednh. Trong tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e0 0 (ch\u1eb3ng h\u1ea1n do k\u1ebft qu\u1ea3 t\u1eeb m\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c), b\u1ea1n n\u00ean s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u1eed l\u00fd linh ho\u1ea1t h\u01a1n.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-6\"<\/picture><\/p>\n

M\u1ed9t ph\u01b0\u01a1ng ph\u00e1p r\u1ea5t hi\u1ec7u qu\u1ea3 l\u00e0 s\u1eed d\u1ee5ng h\u00e0m IFERROR. C\u00fa ph\u00e1p: =IFERROR(ph\u00e9p_t\u00ednh, gi\u00e1_tr\u1ecb_khi_l\u1ed7i). V\u00ed d\u1ee5: =IFERROR(A1\/B1, “Kh\u00f4ng th\u1ec3 chia”). C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap Excel tr\u1ea3 v\u1ec1 n\u1ed9i dung t\u00f9y ch\u1ecdn (v\u00ed d\u1ee5: d\u00f2ng ch\u1eef \u201cKh\u00f4ng th\u1ec3 chia\u201d) thay v\u00ec l\u1ed7i #DIV\/0!, gi\u00fap b\u1ea3ng t\u00ednh s\u1ea1ch s\u1ebd, d\u1ec5 theo d\u00f5i, chuy\u00ean nghi\u1ec7p h\u01a1n. Ngo\u00e0i IFERROR, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng IF \u0111\u1ec3 ki\u1ec3m tra tr\u01b0\u1edbc \u0111i\u1ec1u ki\u1ec7n, v\u00ed d\u1ee5: =IF(B1=0, “”, A1\/B1).<\/span><\/p>\n

L\u1ed7i #REF!<\/b><\/h3>\n

B\u00ean c\u1ea1nh vi\u1ec7c bi\u1ebft l\u1ed7i <\/span>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec<\/b>, b\u1ea1n c\u0169ng n\u00ean t\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #REF! c\u0169ng th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi m\u1ed9t c\u00f4ng th\u1ee9c c\u1ed1 g\u1eafng tham chi\u1ebfu \u0111\u1ebfn \u00f4, h\u00e0ng, c\u1ed9t ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 b\u1ecb x\u00f3a ho\u1eb7c kh\u00f4ng c\u00f2n t\u1ed3n t\u1ea1i. Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u1ecba ch\u1ec9 tham chi\u1ebfu ban \u0111\u1ea7u, v\u00ec v\u1eady thay v\u00ec tr\u1ea3 k\u1ebft qu\u1ea3, n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #REF! \u0111\u1ec3 c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng.\u00a0<\/span><\/p>\n

V\u00ed d\u1ee5: b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c =A1+B1, sau \u0111\u00f3 b\u1ea1n x\u00f3a c\u1ed9t B \u2013 Excel s\u1ebd kh\u00f4ng c\u00f2n nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c B1 v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd chuy\u1ec3n th\u00e0nh =A1+#REF!, k\u00e8m theo l\u1ed7i xu\u1ea5t hi\u1ec7n trong \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u00f3. T\u00ecnh hu\u1ed1ng n\u00e0y d\u1ec5 g\u1eb7p khi ng\u01b0\u1eddi d\u00f9ng xo\u00e1 d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng ki\u1ec3m tra tr\u01b0\u1edbc xem c\u00f3 c\u00f4ng th\u1ee9c n\u00e0o \u0111ang tham chi\u1ebfu \u0111\u1ebfn ph\u1ea7n \u0111\u00f3 hay kh\u00f4ng.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-7\"<\/picture><\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #REF!, \u0111i\u1ec1u quan tr\u1ecdng l\u00e0 b\u1ea1n c\u1ea7n th\u1eadn tr\u1ecdng trong qu\u00e1 tr\u00ecnh ch\u1ec9nh s\u1eeda b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t khi x\u00f3a h\u00e0ng lo\u1ea1t d\u1eef li\u1ec7u. Tr\u01b0\u1edbc khi x\u00f3a, n\u00ean r\u00e0 so\u00e1t xem c\u00f3 c\u00f4ng th\u1ee9c n\u00e0o li\u00ean quan \u0111\u1ebfn v\u00f9ng \u0111\u00f3 kh\u00f4ng. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh x\u00f3a m\u1ea5t v\u00f9ng \u0111ang \u0111\u01b0\u1ee3c tham chi\u1ebfu, c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Z \u0111\u1ec3 ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng v\u00e0 kh\u00f4i ph\u1ee5c l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 m\u1ea5t.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-8\"<\/picture><\/p>\n

M\u1ed9t gi\u1ea3i ph\u00e1p hi\u1ec7u qu\u1ea3 \u0111\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y l\u00e0 s\u1eed d\u1ee5ng t\u00ean v\u00f9ng \u0111\u1eb7t tr\u01b0\u1edbc ho\u1eb7c b\u1ea3ng (Table) trong Excel thay v\u00ec tham chi\u1ebfu tr\u1ef1c ti\u1ebfp theo \u00f4. Vi\u1ec7c n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n khi thay \u0111\u1ed5i c\u1ea5u tr\u00fac b\u1ea3ng m\u00e0 c\u00f2n gi\u1ea3m thi\u1ec3u r\u1ee7i ro x\u1ea3y ra l\u1ed7i khi ch\u1ec9nh s\u1eeda n\u1ed9i dung.<\/span><\/p>\n

L\u1ed7i #NULL!<\/b><\/h3>\n

Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a l\u1ed7i #NULL! l\u00e0 do b\u1ea1n s\u1eed d\u1ee5ng sai k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch v\u00f9ng. Trong Excel, \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t v\u00f9ng li\u00ean t\u1ee5c, b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng d\u1ea5u hai ch\u1ea5m (:) \u2014 k\u00fd hi\u1ec7u n\u00e0y cho bi\u1ebft ph\u1ea1m vi li\u1ec1n k\u1ec1 t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng. V\u00ed d\u1ee5: =SUM(A1:A3) s\u1ebd c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb \u00f4 A1 \u0111\u1ebfn A3. Trong khi \u0111\u00f3, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y (,) nh\u01b0 trong =SUM(A1,A3), Excel hi\u1ec3u r\u1eb1ng b\u1ea1n \u0111ang ch\u1ec9 \u0111\u1ecbnh hai \u00f4 ri\u00eang bi\u1ec7t kh\u00f4ng li\u1ec1n k\u1ec1 v\u00e0 v\u1eabn x\u1eed l\u00fd \u0111\u01b0\u1ee3c b\u00ecnh th\u01b0\u1eddng.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-9\"<\/picture><\/p>\n

Tuy nhi\u00ean, n\u1ebfu b\u1ea1n v\u00f4 t\u00ecnh s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch ( ) thay cho d\u1ea5u hai ch\u1ea5m ho\u1eb7c d\u1ea5u ph\u1ea9y, Excel s\u1ebd hi\u1ec3u b\u1ea1n \u0111ang t\u00ecm ph\u1ea7n giao nhau c\u1ee7a hai v\u00f9ng \u2014 \u0111i\u1ec1u n\u00e0y th\u01b0\u1eddng kh\u00f4ng t\u1ed3n t\u1ea1i v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i #NULL!. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c =SUM(A1 A3) s\u1ebd g\u00e2y ra l\u1ed7i v\u00ec Excel kh\u00f4ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c v\u00f9ng giao c\u1eaft gi\u1eefa hai \u00f4 \u0111\u00f3.<\/span><\/p>\n

\"####-trong-excel-co-nghia-la-gi-10\"<\/picture><\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u00e0 x\u00e1c minh r\u1eb1ng b\u1ea1n \u0111ang d\u00f9ng \u0111\u00fang k\u00fd hi\u1ec7u ph\u00e2n c\u00e1ch v\u00f9ng. Khi c\u1ea7n t\u00ednh t\u1ed5ng m\u1ed9t d\u1ea3i \u00f4 li\u1ec1n nhau, h\u00e3y d\u00f9ng d\u1ea5u hai ch\u1ea5m. Khi c\u1ea7n c\u1ed9ng c\u00e1c \u00f4 r\u1eddi r\u1ea1c, h\u00e3y d\u00f9ng d\u1ea5u ph\u1ea9y. Tr\u00e1nh s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch n\u1ebfu b\u1ea1n kh\u00f4ng th\u1ef1c s\u1ef1 mu\u1ed1n t\u00ecm v\u00f9ng giao nhau, v\u1ed1n l\u00e0 tr\u01b0\u1eddng h\u1ee3p r\u1ea5t \u00edt khi s\u1eed d\u1ee5ng trong th\u1ef1c t\u1ebf.<\/span><\/p>\n

K\u1ebft lu\u1eadn<\/b><\/h2>\n

Qua nh\u1eefng n\u1ed9i dung \u0111\u00e3 t\u00ecm hi\u1ec3u, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 <\/span>#### trong Excel c\u00f3 ngh\u0129a l\u00e0 g\u00ec <\/b>c\u0169ng nh\u01b0 c\u00e1c l\u1ed7i hi\u1ec3n th\u1ecb ph\u1ed5 bi\u1ebfn kh\u00e1c trong Excel. Vi\u1ec7c hi\u1ec3u v\u00e0 n\u1eafm v\u1eefng nguy\u00ean nh\u00e2n c\u00e1c l\u1ed7i s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh, thao t\u00e1c hi\u1ec7u qu\u1ea3 v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n khi s\u1eed d\u1ee5ng Excel trong h\u1ecdc t\u1eadp, c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n

Xem th\u00eam:<\/b><\/p>\n