{"id":36101,"date":"2022-04-12T18:43:29","date_gmt":"2022-04-12T11:43:29","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=36101"},"modified":"2022-04-12T18:43:29","modified_gmt":"2022-04-12T11:43:29","slug":"ly-giai-loi-name-va-huong-dan-sua-loi-name-trong-excel","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/ly-giai-loi-name-va-huong-dan-sua-loi-name-trong-excel\/","title":{"rendered":"L\u00fd gi\u1ea3i l\u1ed7i #NAME v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i Name trong Excel"},"content":{"rendered":"
\n

Trong khi d\u00f9ng Excel, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng c\u00f3 sai s\u00f3t g\u00ec khi thao t\u00e1c, h\u1ec7 th\u1ed1ng Excel s\u1ebd ngay l\u1eadp t\u1ee9c hi\u1ec3n th\u1ecb l\u1ed7i # c\u00f9ng t\u00ean l\u1ed7i \u0111\u1ec3 c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng xem l\u1ea1i. V\u1eady l\u1ed7i NAME trong Excel l\u00e0 do \u0111\u00e2u? V\u00e0 c\u00e1ch \u0111\u1ec3 ch\u00fang ta ki\u1ec3m tra \u0111\u1ec3 s\u1eeda l\u1ea1i s\u1ebd nh\u01b0 th\u1ebf n\u00e0o? C\u00f9ng tham kh\u1ea3o ngay b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi.<\/strong><\/p>\n

C\u00f3 r\u1ea5t nhi\u1ec1u l\u1ed7i c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi ta d\u00f9ng Excel, v\u00ed d\u1ee5 nh\u01b0 #NAME, #N\/A, #REF, v.v. Trong b\u00e0i vi\u1ebft n\u00e0y, Divine Shop s\u1ebd gi\u1ea3i th\u00edch l\u1ed7i Name trong Excel v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i NAME trong Excel nh\u00e9!<\/p>\n

\"L\u1ed7i<\/p>\n

\n

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

N\u00f3i \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u nh\u1ea5t th\u00ec l\u1ed7i #NAME xu\u1ea5t hi\u1ec7n khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0ng b\u1ecb sai t\u00ean h\u00e0m, sai \u0111\u1ecbnh danh khi m\u00e0 Excel kh\u00f4ng truy so\u00e1t \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u. Do v\u1eady, t\u00f9y v\u00e0o m\u1ed7i tr\u01b0\u1eddng h\u1ee3p b\u1ecb sai \u1edf \u0111\u00e2u m\u00e0 b\u1ea1n s\u1ebd c\u00f3 c\u00e1ch kh\u1eafc ph\u1ee5c kh\u00e1c nhau.<\/p>\n

\"L\u00fd<\/p>\n

<\/span><\/span>C\u00e1ch<\/strong> s\u1eeda l\u1ed7i #NAME trong Excel<\/strong><\/span><\/span><\/h2>\n

<\/span><\/span>Nh\u1eadp sai t\u00ean h\u00e0m, thi\u1ebfu ho\u1eb7c d\u01b0 k\u00fd t\u1ef1<\/strong><\/span><\/span><\/h3>\n

Khi s\u1eed d\u1ee5ng Excel, t\u1ea5t nhi\u00ean b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c, h\u00e0m v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Nh\u01b0ng n\u1ebfu b\u1ea1n nh\u1eadp th\u1eeba ho\u1eb7c thi\u1ebfu, l\u00e0m sai l\u1ec7ch t\u00ean h\u00e0m th\u00ec Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #NAME<\/strong>.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> ki\u1ec3m tra v\u00e0 ch\u1ec9nh l\u1ea1i sao cho \u0111\u00fang t\u00ean h\u00e0m l\u00e0 \u0111\u01b0\u1ee3c nh\u00e9!<\/p>\n

\"Nh\u1eadp<\/p>\n

<\/span><\/span>Gi\u00e1 tr\u1ecb tham chi\u1ebfu, v\u1ecb tr\u00ed b\u1ecb sai<\/strong><\/span><\/span><\/h3>\n

B\u00ean c\u1ea1nh vi\u1ec7c sai t\u00ean h\u00e0m th\u00ec sai s\u00f3t khi nh\u1eadp c\u00e1c \u00f4 d\u1eef li\u1ec7u tham chi\u1ebfu c\u0169ng r\u1ea5t th\u01b0\u1eddng g\u1eb7p. C\u00f3 th\u1ec3 khi nh\u1eadp, b\u1ea1n \u0111\u00e3 nh\u1eadp ch\u01b0a \u0111\u00fang \u0111\u1ecba ch\u1ec9 \u00f4, ho\u1eb7c b\u1ecb thi\u1ebfu d\u1ea5u :<\/strong> ng\u0103n c\u00e1ch gi\u1eefa \u0111\u1ecba ch\u1ec9 v\u00f9ng trong Excel.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> ki\u1ec3m tra l\u1ea1i \u0111\u1ecba ch\u1ec9 c\u00e1c \u00f4 v\u00e0 d\u1ea5u 2 ch\u1ea5m : gi\u1eefa ch\u00fang.<\/p>\n

\"Gi\u00e1<\/p>\n

<\/span><\/span>Thi\u1ebfu d\u1ea5u ho\u1eb7c d\u00f9ng d\u1ea5u kh\u00f4ng \u0111\u00fang<\/strong><\/span><\/span><\/h3>\n

\u0110\u1ed1i v\u1edbi c\u00e1c h\u00e0m s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 \u1edf d\u1ea1ng d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp, b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ea3m b\u1ea3o nh\u1eadp th\u00eam d\u1ea5u ngo\u1eb7c k\u00e9p \u1edf hai b\u00ean \u0111\u1ec3 Excel c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c. N\u1ebfu kh\u00f4ng, l\u1ed7i #NAME s\u1ebd xu\u1ea5t hi\u1ec7n.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> D\u00f9ng \u0111\u00fang d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u2026\u201d<\/strong> cho c\u00e1c d\u1eef li\u1ec7u ki\u1ec3u ch\u1eef.<\/p>\n

\"Thi\u1ebfu<\/p>\n

<\/span><\/span>T\u1ea1m k\u1ebft<\/strong><\/span><\/span><\/h2>\n

L\u1ed7i #NAME trong Excel kh\u00f4ng ph\u1ea3i l\u00e0 1 l\u1ed7i kh\u00f3 gi\u1ea3i quy\u1ebft. B\u1ea1n ch\u1ec9 c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c h\u00e0m m\u00e0 m\u00ecnh nh\u1eadp v\u00e0o \u0111\u1ec3 xem l\u1ed7i ph\u00e1t sinh t\u1eeb nh\u1eefng l\u00ed do n\u00e0o b\u00ean tr\u00ean. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/p>\n

\u00a0<\/strong><\/em><\/p>\n

\u00a0<\/p>\n<\/div>\n<\/div>\n\n\n

\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n\n\n\n\n
<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Trong khi d\u00f9ng Excel, n\u1ebfu ng\u01b0\u1eddi d\u00f9ng c\u00f3 sai s\u00f3t g\u00ec khi thao t\u00e1c, h\u1ec7 th\u1ed1ng Excel s\u1ebd ngay l\u1eadp t\u1ee9c hi\u1ec3n th\u1ecb l\u1ed7i # c\u00f9ng t\u00ean l\u1ed7i \u0111\u1ec3 c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng xem l\u1ea1i. V\u1eady l\u1ed7i NAME trong Excel l\u00e0 do \u0111\u00e2u? V\u00e0 c\u00e1ch \u0111\u1ec3 ch\u00fang ta ki\u1ec3m tra \u0111\u1ec3 s\u1eeda l\u1ea1i s\u1ebd nh\u01b0 […]<\/p>\n","protected":false},"author":12,"featured_media":36102,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[190],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\t\n\t\n\t\n