{"id":380031,"date":"2024-08-29T22:18:01","date_gmt":"2024-08-29T15:18:01","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=380031"},"modified":"2024-08-29T22:18:01","modified_gmt":"2024-08-29T15:18:01","slug":"loi-name-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-name-trong-excel\/","title":{"rendered":"L\u1ed7i NAME trong Excel l\u00e0 g\u00ec? Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c"},"content":{"rendered":"

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 t\u1eebng g\u1eb7p ph\u1ea3i l\u1ed7i NAME trong Excel, nh\u01b0ng kh\u00f4ng bi\u1ebft r\u00f5 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c. V\u1eady NAME l\u00e0 l\u1ed7i g\u00ec trong Excel v\u00e0 l\u00e0m sao \u0111\u1ec3 x\u1eed l\u00fd khi g\u1eb7p ph\u1ea3i? B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 v\u1ea5n \u0111\u1ec1 n\u00e0y, t\u1eeb l\u00fd do d\u1eabn \u0111\u1ebfn l\u1ed7i \u0111\u1ebfn c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u1eafc ph\u1ee5c hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 chi ti\u1ebft NAME l\u00e0 l\u1ed7i g\u00ec v\u00e0 c\u00e1ch x\u1eed l\u00fd \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng.<\/p>\n

L\u1ed7i #NAME trong Excel l\u00e0 g\u00ec?<\/h2>\n

L\u1ed7i NAME trong Excel l\u00e0 m\u1ed9t th\u00f4ng b\u00e1o cho bi\u1ebft r\u1eb1ng Excel kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c t\u00ean h\u00e0m, ph\u1ea1m vi, ho\u1eb7c k\u00fd t\u1ef1 v\u0103n b\u1ea3n trong c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp<\/strong>. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn v\u00e0 th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai t\u00ean h\u00e0m, qu\u00ean \u0111\u1eb7t d\u1ea5u ngo\u1eb7c k\u00e9p cho v\u0103n b\u1ea3n ho\u1eb7c g\u1ecdi nh\u1ea7m t\u00ean ph\u1ea1m vi ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh. V\u1eady NAME l\u00e0 l\u1ed7i g\u00ec v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c?<\/p>\n

L\u1ed7i #NAME trong Excel c\u00f3 th\u1ec3 x\u1ea3y ra trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau, v\u00e0 vi\u1ec7c hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng x\u1eed l\u00fd v\u00e0 ng\u0103n ch\u1eb7n l\u1ed7i n\u00e0y trong t\u01b0\u01a1ng lai. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp sai t\u00ean h\u00e0m, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u00e0 hi\u1ec3n th\u1ecb l\u1ed7i #NAME. T\u01b0\u01a1ng t\u1ef1, n\u1ebfu b\u1ea1n qu\u00ean \u0111\u1eb7t d\u1ea5u ngo\u1eb7c k\u00e9p cho chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c s\u1eed d\u1ee5ng t\u00ean ph\u1ea1m vi ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i NAME trong Excel<\/h2>\n

L\u1ed7i NAME th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi Excel kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c m\u1ed9t th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp. V\u1eady NAME l\u00e0 l\u1ed7i g\u00ec v\u00e0 t\u1ea1i sao l\u1ea1i x\u1ea3y ra? Sau \u0111\u00e2y l\u00e0 nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn d\u1eabn \u0111\u1ebfn l\u1ed7i n\u00e0y.<\/p>\n

Nh\u1eadp sai t\u00ean h\u00e0m<\/h3>\n

Nh\u1eadp sai t\u00ean h\u00e0m l\u00e0 m\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ch\u00ednh d\u1eabn \u0111\u1ebfn l\u1ed7i NAME. Khi b\u1ea1n nh\u1eadp t\u00ean h\u00e0m kh\u00f4ng ch\u00ednh x\u00e1c ho\u1eb7c vi\u1ebft sai ch\u00ednh t\u1ea3, Excel s\u1ebd kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c h\u00e0m \u0111\u00f3 v\u00e0 s\u1ebd b\u00e1o l\u1ed7i #NAME. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1eadp “SUME” thay v\u00ec “SUM,” Excel kh\u00f4ng hi\u1ec3u b\u1ea1n \u0111ang y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i #NAME s\u1ebd xu\u1ea5t hi\u1ec7n.<\/p>\n

\u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng ch\u00fa \u00fd \u0111\u1ebfn ch\u00ednh t\u1ea3 ho\u1eb7c v\u00f4 t\u00ecnh nh\u1eadp sai t\u00ean h\u00e0m. \u0110\u1eb7c bi\u1ec7t, khi s\u1eed d\u1ee5ng Excel trong ng\u00f4n ng\u1eef kh\u00e1c v\u1edbi ti\u1ebfng Anh, t\u00ean h\u00e0m c\u00f3 th\u1ec3 kh\u00e1c bi\u1ec7t, v\u00e0 vi\u1ec7c nh\u1eadp sai t\u00ean h\u00e0m s\u1ebd c\u00e0ng d\u1ec5 x\u1ea3y ra. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i ch\u00ednh t\u1ea3 v\u00e0 c\u00fa ph\u00e1p c\u1ee7a t\u00ean h\u00e0m trong c\u00f4ng th\u1ee9c. \u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u00fang t\u00ean h\u00e0m v\u00e0 nh\u1eadp ch\u00ednh x\u00e1c c\u00e1c k\u00fd t\u1ef1, bao g\u1ed3m c\u1ea3 c\u00e1c d\u1ea5u ngo\u1eb7c n\u1ebfu c\u1ea7n.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng t\u00ednh n\u0103ng AutoComplete c\u1ee7a Excel. Khi b\u1eaft \u0111\u1ea7u g\u00f5 t\u00ean h\u00e0m, Excel s\u1ebd g\u1ee3i \u00fd c\u00e1c t\u00ean h\u00e0m c\u00f3 s\u1eb5n \u0111\u1ec3 b\u1ea1n ch\u1ecdn. \u0110i\u1ec1u n\u00e0y gi\u00fap gi\u1ea3m thi\u1ec3u nguy c\u01a1 nh\u1eadp sai v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c nh\u1eadp ch\u00ednh x\u00e1c.<\/p>\n

Thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho chu\u1ed7i v\u0103n b\u1ea3n<\/h3>\n

Thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho chu\u1ed7i v\u0103n b\u1ea3n l\u00e0 m\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn g\u00e2y ra l\u1ed7i NAME trong excel<\/span>. Khi b\u1ea1n s\u1eed d\u1ee5ng chu\u1ed7i v\u0103n b\u1ea3n trong c\u00f4ng th\u1ee9c, chu\u1ed7i \u0111\u00f3 b\u1eaft bu\u1ed9c ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p \u0111\u1ec3 Excel c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u00fang \u0111\u00f3 l\u00e0 v\u0103n b\u1ea3n. N\u1ebfu b\u1ea1n qu\u00ean \u0111\u1eb7t d\u1ea5u ngo\u1eb7c k\u00e9p, Excel s\u1ebd kh\u00f4ng hi\u1ec3u chu\u1ed7i \u0111\u00f3 l\u00e0 v\u0103n b\u1ea3n v\u00e0 s\u1ebd c\u1ed1 g\u1eafng t\u00ecm ki\u1ebfm m\u1ed9t t\u00ean h\u00e0m ho\u1eb7c ph\u1ea1m vi t\u01b0\u01a1ng \u1ee9ng. Khi Excel kh\u00f4ng t\u00ecm th\u1ea5y h\u00e0m ho\u1eb7c ph\u1ea1m vi n\u00e0o ph\u00f9 h\u1ee3p, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 l\u1ed7i #NAME.<\/p>\n

Ch\u1eb3ng h\u1ea1n, thay v\u00ec nh\u1eadp c\u00f4ng th\u1ee9c =”Hello” & A1 \u0111\u1ec3 k\u1ebft h\u1ee3p ch\u1eef “Hello” v\u1edbi n\u1ed9i dung trong \u00f4 A1. n\u1ebfu b\u1ea1n nh\u1eadp =Hello & A1, Excel s\u1ebd kh\u00f4ng hi\u1ec3u “Hello” l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 s\u1ebd c\u1ed1 g\u1eafng t\u00ecm ki\u1ebfm t\u00ean h\u00e0m ho\u1eb7c t\u00ean ph\u1ea1m vi “Hello”. Khi kh\u00f4ng t\u00ecm th\u1ea5y, l\u1ed7i #NAME trong Excel s\u1ebd xu\u1ea5t hi\u1ec7n, khi\u1ebfn c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

T\u00ean ph\u1ea1m vi ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh<\/h3>\n

M\u1ed9t nguy\u00ean nh\u00e2n kh\u00e1c g\u00e2y ra l\u1ed7i NAME trong Excel l\u00e0 khi b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t t\u00ean ph\u1ea1m vi ho\u1eb7c t\u00ean bi\u1ebfn ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh trong b\u1ea3ng t\u00ednh. Khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c m\u00e0 c\u00f3 ch\u1ee9a t\u00ean ph\u1ea1m vi nh\u01b0 “DoanhThu,” nh\u01b0ng ph\u1ea1m vi n\u00e0y ch\u01b0a \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp tr\u01b0\u1edbc \u0111\u00f3, Excel s\u1ebd kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n v\u00e0 s\u1ebd b\u00e1o l\u1ed7i #NAME. V\u1eady, NAME l\u00e0 l\u1ed7i g\u00ec trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y?<\/p>\n

Excel d\u1ef1a v\u00e0o t\u00ean ph\u1ea1m vi \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n ho\u1eb7c thao t\u00e1c c\u1ee5 th\u1ec3. Khi t\u00ean ph\u1ea1m vi ho\u1eb7c bi\u1ebfn ch\u01b0a \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u01b0\u1edbc, Excel kh\u00f4ng bi\u1ebft c\u1ea7n ph\u1ea3i x\u1eed l\u00fd d\u1eef li\u1ec7u n\u00e0o, d\u1eabn \u0111\u1ebfn vi\u1ec7c c\u00f4ng th\u1ee9c kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 b\u00e1o l\u1ed7i #NAME trong Excel. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n t\u1ea1o c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u00e0 qu\u00ean x\u00e1c \u0111\u1ecbnh c\u00e1c ph\u1ea1m vi c\u1ea7n thi\u1ebft, ho\u1eb7c khi b\u1ea1n nh\u1eadp nh\u1ea7m t\u00ean ph\u1ea1m vi.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

S\u1eed d\u1ee5ng h\u00e0m t\u1eeb m\u1ed9t add-in ch\u01b0a \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t<\/h3>\n

M\u1ed9t nguy\u00ean nh\u00e2n kh\u00e1c d\u1eabn \u0111\u1ebfn l\u1ed7i NAME trong Excel l\u00e0 khi b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u1eeb m\u1ed9t add-in ho\u1eb7c th\u01b0 vi\u1ec7n ngo\u00e0i m\u00e0 ch\u01b0a \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t ho\u1eb7c c\u00e0i \u0111\u1eb7t \u0111\u00fang c\u00e1ch. Khi \u0111i\u1ec1u n\u00e0y x\u1ea3y ra, Excel s\u1ebd kh\u00f4ng th\u1ec3 nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c h\u00e0m \u0111\u00f3 v\u00e0 s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #NAME.<\/p>\n

C\u00e1c add-in trong Excel th\u01b0\u1eddng cung c\u1ea5p c\u00e1c h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 m\u1edf r\u1ed9ng, gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c ph\u1ee9c t\u1ea1p m\u00e0 c\u00e1c h\u00e0m t\u00edch h\u1ee3p s\u1eb5n kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m t\u1eeb add-in m\u00e0 add-in \u0111\u00f3 ch\u01b0a \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, Excel s\u1ebd kh\u00f4ng hi\u1ec3u b\u1ea1n \u0111ang y\u00eau c\u1ea7u th\u1ef1c hi\u1ec7n \u0111i\u1ec1u g\u00ec v\u00e0 b\u00e1o l\u1ed7i #NAME. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c m\u00e1y t\u00ednh m\u00e0 kh\u00f4ng ki\u1ec3m tra xem c\u00e1c add-in c\u1ea7n thi\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t hay ch\u01b0a.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Nh\u1eadp thi\u1ebfu tham s\u1ed1 trong c\u00f4ng th\u1ee9c<\/h3>\n

M\u1ed9t nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn kh\u00e1c d\u1eabn \u0111\u1ebfn l\u1ed7i NAME trong Excel l\u00e0 vi\u1ec7c nh\u1eadp thi\u1ebfu tham s\u1ed1 trong c\u00f4ng th\u1ee9c. Nhi\u1ec1u h\u00e0m trong Excel y\u00eau c\u1ea7u c\u00e1c tham s\u1ed1 b\u1eaft bu\u1ed9c \u0111\u1ec3 c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c. N\u1ebfu b\u1ea1n qu\u00ean cung c\u1ea5p m\u1ed9t ho\u1eb7c nhi\u1ec1u tham s\u1ed1 n\u00e0y, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh v\u00e0 s\u1ebd b\u00e1o l\u1ed7i #NAME.<\/p>\n

Khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 VLOOKUP, INDEX, ho\u1eb7c MATCH, n\u1ebfu b\u1ea1n kh\u00f4ng cung c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ea7n thi\u1ebft, Excel s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau c\u1ee7a c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 s\u1ebd xu\u1ea5t hi\u1ec7n l\u1ed7i #NAME trong Excel. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n v\u00f4 t\u00ecnh b\u1ecf qua m\u1ed9t tham s\u1ed1 ho\u1eb7c kh\u00f4ng bi\u1ebft r\u00f5 v\u1ec1 c\u00fa ph\u00e1p h\u00e0m.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t h\u00e0m ho\u1eb7c ph\u1ea1m vi trong ng\u00f4n ng\u1eef kh\u00e1c<\/h3>\n

Khi s\u1eed d\u1ee5ng Excel b\u1eb1ng m\u1ed9t ng\u00f4n ng\u1eef kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u1ed7i NAME n\u1ebfu nh\u1eadp t\u00ean h\u00e0m ho\u1eb7c t\u00ean ph\u1ea1m vi b\u1eb1ng ti\u1ebfng Anh ho\u1eb7c m\u1ed9t ng\u00f4n ng\u1eef kh\u00f4ng t\u01b0\u01a1ng th\u00edch. N\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n ch\u1ee9a c\u00e1c h\u00e0m ho\u1eb7c ph\u1ea1m vi m\u00e0 Excel kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c v\u00ec s\u1ef1 kh\u00e1c bi\u1ec7t ng\u00f4n ng\u1eef, Excel s\u1ebd kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u00e0 s\u1ebd b\u00e1o l\u1ed7i #NAME.<\/p>\n

Excel h\u1ed7 tr\u1ee3 nhi\u1ec1u ng\u00f4n ng\u1eef, v\u00e0 m\u1ed7i ng\u00f4n ng\u1eef c\u00f3 th\u1ec3 c\u00f3 c\u00e1c t\u00ean h\u00e0m v\u00e0 c\u00e1ch vi\u1ebft ph\u1ea1m vi kh\u00e1c nhau. V\u00ed d\u1ee5, h\u00e0m SUM trong Excel ti\u1ebfng Anh c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 SOMME trong Excel ti\u1ebfng Ph\u00e1p. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m ti\u1ebfng Anh trong phi\u00ean b\u1ea3n Excel kh\u00f4ng ph\u1ea3i ti\u1ebfng Anh, Excel s\u1ebd kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c h\u00e0m v\u00e0 s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #NAME.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i NAME trong Excel<\/h2>\n

Vi\u1ec7c bi\u1ebft c\u00e1ch kh\u1eafc ph\u1ee5c nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 c\u00f3 th\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c c\u1ee7a b\u1ea1n. Trong ph\u1ea7n n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 s\u1eeda ch\u1eefa c\u00e1c v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p v\u00e0 gi\u00fap c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c tr\u1edf l\u1ea1i.<\/p>\n

Kh\u1eafc ph\u1ee5c l\u1ed7i NAME trong Excel nh\u1eadp sai t\u00ean h\u00e0m<\/h3>\n

Ki\u1ec3m tra ch\u00ednh t\u1ea3<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u00fang t\u00ean h\u00e0m v\u00e0 kh\u00f4ng c\u00f3 l\u1ed7i ch\u00ednh t\u1ea3. V\u00ed d\u1ee5, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp “SUM” thay v\u00ec “SUME”.<\/p>\n

S\u1eed d\u1ee5ng t\u00ednh n\u0103ng AutoComplete<\/strong>: Khi nh\u1eadp t\u00ean h\u00e0m, h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng AutoComplete c\u1ee7a Excel \u0111\u1ec3 ch\u1ecdn t\u00ean h\u00e0m t\u1eeb danh s\u00e1ch g\u1ee3i \u00fd, gi\u00fap tr\u00e1nh l\u1ed7i ch\u00ednh t\u1ea3.<\/p>\n

Tham kh\u1ea3o t\u00e0i li\u1ec7u<\/strong>: N\u1ebfu kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 t\u00ean h\u00e0m, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o t\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn c\u1ee7a Excel ho\u1eb7c t\u00ecm ki\u1ebfm tr\u00ean internet \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111ang s\u1eed d\u1ee5ng \u0111\u00fang h\u00e0m.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Kh\u1eafc ph\u1ee5c l\u1ed7i NAME trong Excel thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p<\/h3>\n

Ki\u1ec3m tra d\u1ea5u ngo\u1eb7c k\u00e9p<\/strong>: M\u1ed7i khi s\u1eed d\u1ee5ng chu\u1ed7i v\u0103n b\u1ea3n trong c\u00f4ng th\u1ee9c, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n \u0111\u00e3 \u0111\u1eb7t ch\u00fang trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5, thay v\u00ec =Hello & A1, h\u00e3y nh\u1eadp =”Hello” & A1.<\/p>\n

Ki\u1ec3m tra c\u00f4ng th\u1ee9c:<\/strong> Tr\u01b0\u1edbc khi x\u00e1c nh\u1eadn c\u00f4ng th\u1ee9c, h\u00e3y ki\u1ec3m tra l\u1ea1i \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ec1u c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p.<\/p>\n

S\u1eed d\u1ee5ng t\u00ednh n\u0103ng ki\u1ec3m tra l\u1ed7i c\u1ee7a Excel<\/strong>: Excel c\u00f3 t\u00ednh n\u0103ng ki\u1ec3m tra l\u1ed7i gi\u00fap b\u1ea1n nh\u1eadn di\u1ec7n v\u00e0 kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, k\u1ec3 c\u1ea3 l\u1ed7i thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho chu\u1ed7i v\u0103n b\u1ea3n.<\/p>\n

Vi\u1ec7c nh\u1eadn bi\u1ebft v\u00e0 s\u1eeda ch\u1eefa l\u1ed7i l\u1ed7i NAME li\u00ean quan \u0111\u1ebfn d\u1ea5u ngo\u1eb7c k\u00e9p s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh g\u1eb7p ph\u1ea3i nh\u1eefng s\u1ef1 c\u1ed1 kh\u00f4ng mong mu\u1ed1n v\u00e0 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng m\u1ed9t c\u00e1ch \u0111\u00fang nh\u1ea5t.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Kh\u1eafc ph\u1ee5c l\u1ed7i NAME trong Excel do t\u00ean ph\u1ea1m vi ch\u01b0a x\u00e1c \u0111\u1ecbnh<\/h3>\n

X\u00e1c \u0111\u1ecbnh ph\u1ea1m vi ho\u1eb7c bi\u1ebfn tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng<\/strong>: Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng t\u00ean ph\u1ea1m vi ho\u1eb7c bi\u1ebfn trong c\u00f4ng th\u1ee9c, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh ch\u00fang trong Excel. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y b\u1eb1ng c\u00e1ch ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u v\u00e0 \u0111\u1eb7t t\u00ean cho n\u00f3 trong h\u1ed9p Name Box (h\u1ed9p t\u00ean) n\u1eb1m b\u00ean tr\u00e1i thanh c\u00f4ng th\u1ee9c.<\/p>\n

Ki\u1ec3m tra l\u1ea1i t\u00ean ph\u1ea1m vi<\/strong>: N\u1ebfu b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi nh\u01b0ng v\u1eabn g\u1eb7p ph\u1ea3i l\u1ed7i NAME, h\u00e3y ki\u1ec3m tra l\u1ea1i t\u00ean ph\u1ea1m vi trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n. T\u00ean ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c vi\u1ebft \u0111\u00fang ch\u00ednh t\u1ea3 v\u00e0 kh\u1edbp v\u1edbi t\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh trong Excel.<\/p>\n

S\u1eed d\u1ee5ng Name Manager (Tr\u00ecnh qu\u1ea3n l\u00fd t\u00ean)<\/strong>: Excel cung c\u1ea5p c\u00f4ng c\u1ee5 Name Manager gi\u00fap b\u1ea1n qu\u1ea3n l\u00fd v\u00e0 ki\u1ec3m tra c\u00e1c t\u00ean ph\u1ea1m vi. H\u00e3y s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c t\u00ean ph\u1ea1m vi \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp \u0111\u00fang c\u00e1ch v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c khi add-in ch\u01b0a \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t<\/h3>\n

K\u00edch ho\u1ea1t add-in c\u1ea7n thi\u1ebft:<\/strong> \u0110\u1ec3 tr\u00e1nh l\u1ed7i NAME trong Excel, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng m\u1ecdi add-in c\u1ea7n thi\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t. B\u1ea1n c\u00f3 th\u1ec3 k\u00edch ho\u1ea1t add-in b\u1eb1ng c\u00e1ch v\u00e0o menu File > Options > Add-ins, sau \u0111\u00f3 ch\u1ecdn Excel Add-ins trong danh s\u00e1ch Manage v\u00e0 nh\u1ea5p v\u00e0o Go. T\u1eeb \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn v\u00e0 k\u00edch ho\u1ea1t c\u00e1c add-in c\u1ea7n thi\u1ebft.<\/p>\n

C\u00e0i \u0111\u1eb7t l\u1ea1i add-in:<\/strong> N\u1ebfu add-in kh\u00f4ng xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch ho\u1eb7c kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang c\u00e1ch, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i c\u00e0i \u0111\u1eb7t l\u1ea1i n\u00f3. \u0110\u1ea3m b\u1ea3o r\u1eb1ng add-in \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t t\u1eeb ngu\u1ed3n tin c\u1eady v\u00e0 t\u01b0\u01a1ng th\u00edch v\u1edbi phi\u00ean b\u1ea3n Excel b\u1ea1n \u0111ang s\u1eed d\u1ee5ng.<\/p>\n

Ki\u1ec3m tra c\u00e1c h\u00e0m trong c\u00f4ng th\u1ee9c:<\/strong> N\u1ebfu b\u1ea1n th\u1ea5y l\u1ed7i #NAME trong Excel khi s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m t\u1eeb add-in, h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng h\u00e0m \u0111\u00f3 l\u00e0 t\u1eeb add-in m\u00e0 b\u1ea1n \u0111\u00e3 k\u00edch ho\u1ea1t. N\u1ebfu kh\u00f4ng, h\u00e3y xem x\u00e9t thay th\u1ebf h\u00e0m \u0111\u00f3 b\u1eb1ng m\u1ed9t h\u00e0m t\u01b0\u01a1ng t\u1ef1 t\u1eeb b\u1ed9 h\u00e0m t\u00edch h\u1ee3p s\u1eb5n c\u1ee7a Excel.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

Kh\u1eafc ph\u1ee5c l\u1ed7i NAME trong Excel nh\u1eadp thi\u1ebfu s\u1ed1<\/h3>\n

Ki\u1ec3m tra c\u00fa ph\u00e1p h\u00e0m:<\/strong> \u0110\u1ec3 tr\u00e1nh l\u1ed7i NAME, b\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p c\u1ee7a h\u00e0m m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng. Excel th\u01b0\u1eddng cung c\u1ea5p g\u1ee3i \u00fd v\u1ec1 c\u00e1c tham s\u1ed1 c\u1ea7n thi\u1ebft khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c. H\u00e3y ch\u00fa \u00fd \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn n\u00e0y \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 cung c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 c\u00e1c tham s\u1ed1.<\/p>\n

\u0110i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 c\u00e1c tham s\u1ed1 b\u1eaft bu\u1ed9c<\/strong>: \u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp t\u1ea5t c\u1ea3 c\u00e1c tham s\u1ed1 b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, th\u00ec b\u1ea1n c\u1ea7n cung c\u1ea5p c\u1ea3 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm, b\u1ea3ng d\u1eef li\u1ec7u, ch\u1ec9 s\u1ed1 c\u1ed9t, v\u00e0 ki\u1ec3u t\u00ecm ki\u1ebfm.<\/p>\n

S\u1eed d\u1ee5ng tr\u1ee3 gi\u00fap c\u1ee7a Excel:<\/strong> N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m c\u1ee5 th\u1ec3, h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng tr\u1ee3 gi\u00fap c\u1ee7a Excel. B\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o ph\u1ea7n Help ho\u1eb7c tra c\u1ee9u tr\u00ean internet \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1c tham s\u1ed1 c\u1ea7n thi\u1ebft c\u1ee7a h\u00e0m.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t h\u00e0m<\/h3>\n

S\u1eed d\u1ee5ng t\u00ean h\u00e0m ph\u00f9 h\u1ee3p v\u1edbi ng\u00f4n ng\u1eef: \u0110\u1ec3 tr\u00e1nh l\u1ed7i NAME trong Excel, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n s\u1eed d\u1ee5ng t\u00ean h\u00e0m v\u00e0 t\u00ean ph\u1ea1m vi ph\u00f9 h\u1ee3p v\u1edbi ng\u00f4n ng\u1eef c\u1ee7a phi\u00ean b\u1ea3n Excel b\u1ea1n \u0111ang s\u1eed d\u1ee5ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng Excel ti\u1ebfng Ph\u00e1p, h\u00e3y s\u1eed d\u1ee5ng “SOMME” thay v\u00ec “SUM.”<\/p>\n

Thay \u0111\u1ed5i ng\u00f4n ng\u1eef c\u1ee7a Excel: N\u1ebfu c\u00f3 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ng\u00f4n ng\u1eef c\u1ee7a Excel sang ti\u1ebfng Anh ho\u1eb7c ng\u00f4n ng\u1eef m\u00e0 b\u1ea1n quen thu\u1ed9c \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 h\u00f3a c\u00e1c t\u00ean h\u00e0m v\u00e0 ph\u1ea1m vi. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 tr\u00e1nh l\u1ed7i #NAME.<\/p>\n

\"loi-name-trong-excel\"<\/picture><\/p>\n

T\u00ecm hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng c\u00e1c t\u00ean h\u00e0m b\u1ea3n \u0111\u1ecba: Xem t\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn ho\u1eb7c b\u1ea3ng tra c\u1ee9u \u0111\u1ec3 bi\u1ebft t\u00ean h\u00e0m v\u00e0 ph\u1ea1m vi trong ng\u00f4n ng\u1eef m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng. Excel cung c\u1ea5p t\u00e0i li\u1ec7u v\u00e0 h\u01b0\u1edbng d\u1eabn cho c\u00e1c phi\u00ean b\u1ea3n ng\u00f4n ng\u1eef kh\u00e1c nhau, gi\u00fap b\u1ea1n t\u00ecm ra t\u00ean h\u00e0m \u0111\u00fang v\u00e0 ph\u00f9 h\u1ee3p.<\/p>\n

L\u1eddi k\u1ebft<\/h2>\n

Vi\u1ec7c g\u1eb7p ph\u1ea3i l\u1ed7i #NAME l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi, nh\u01b0ng hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. B\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 cung c\u1ea5p c\u00e1i nh\u00ecn s\u00e2u s\u1eafc v\u1ec1 l\u1ed7i NAME trong Excel, t\u1eeb vi\u1ec7c nh\u1eadn di\u1ec7n c\u00e1c nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u01b0 nh\u1eadp sai t\u00ean h\u00e0m, thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho chu\u1ed7i v\u0103n b\u1ea3n, \u0111\u1ebfn c\u00e1c v\u1ea5n \u0111\u1ec1 v\u1ec1 t\u00ean ph\u1ea1m vi, add-in ch\u01b0a k\u00edch ho\u1ea1t, v\u00e0 tham chi\u1ebfu ng\u00f4n ng\u1eef kh\u00e1c.<\/p>\n

B\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u1eafc ph\u1ee5c m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 chia s\u1ebb, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng x\u1eed l\u00fd l\u1ed7i #NAME v\u00e0 c\u1ea3i thi\u1ec7n kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. \u0110\u1eebng qu\u00ean ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng c\u00e1c c\u00f4ng th\u1ee9c, x\u00e1c nh\u1eadn t\u00ean h\u00e0m v\u00e0 ph\u1ea1m vi, c\u0169ng nh\u01b0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n s\u1eed d\u1ee5ng \u0111\u00fang ng\u00f4n ng\u1eef ph\u00f9 h\u1ee3p v\u1edbi phi\u00ean b\u1ea3n Excel c\u1ee7a m\u00ecnh.<\/p>\n

Xem th\u00eam:\u00a0<\/strong><\/p>\n