{"id":3240,"date":"2024-12-03T01:31:35","date_gmt":"2024-12-03T01:31:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-thay-the-nhung-loi-cong-thuc-bang-so-0-khoang-trang-hoac-mot-van-ban-cu-the-trong-excel\/"},"modified":"2024-12-03T01:31:35","modified_gmt":"2024-12-03T01:31:35","slug":"cach-thay-the-nhung-loi-cong-thuc-bang-so-0-khoang-trang-hoac-mot-van-ban-cu-the-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-thay-the-nhung-loi-cong-thuc-bang-so-0-khoang-trang-hoac-mot-van-ban-cu-the-trong-excel\/","title":{"rendered":"C\u00e1ch thay th\u1ebf nh\u1eefng l\u1ed7i c\u00f4ng th\u1ee9c b\u1eb1ng s\u1ed1 0, kho\u1ea3ng tr\u1eafng ho\u1eb7c m\u1ed9t v\u0103n b\u1ea3n c\u1ee5 th\u1ec3 trong Excel"},"content":{"rendered":"
\n

B\u1ea1n th\u01b0\u1eddng c\u00f3 th\u1ec3 g\u1eb7p m\u1ed9t s\u1ed1 l\u1ed7i c\u00f4ng th\u1ee9c trong khi l\u00e0m vi\u1ec7c, ch\u1eb3ng h\u1ea1n nh\u01b0 # DIV \/ 0, #Value !, #REF, # N \/ A, #NUM !, #NAME ?, #NULL. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u m\u1ed9t s\u1ed1 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf nh\u1eefng l\u1ed7i n\u00e0y b\u1eb1ng s\u1ed1 kh\u00f4ng ho\u1eb7c \u00f4 tr\u1ed1ng. V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta s\u1ebd t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf l\u1ed7i c\u00f4ng th\u1ee9c trong b\u1ea3ng sau:<\/p>\n

<\/p>\n

T\u00ecm v\u00e0 thay th\u1ebf c\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c th\u00e0nh s\u1ed1 c\u1ee5 th\u1ec3<\/strong><\/p>\n

Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m\u00a0ERROR.TYPE<\/strong> \u0111\u1ec3 chuy\u1ec3n b\u1ea5t c\u1ee9 lo\u1ea1i l\u1ed7i c\u00f4ng th\u1ee9c n\u00e0o th\u00e0nh s\u1ed1 c\u1ee5 th\u1ec3.<\/p>\n

Trong v\u00ed d\u1ee5 tr\u00ean, nh\u1eadp = ERROR.TYPE(A3)<\/strong> v\u00e0o \u00f4 tr\u1ed1ng, v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn l\u1ea1i s\u1ed1 2 trong \u00f4. Lo\u1ea1i l\u1ed7i kh\u00e1c nhau th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 kh\u00e1c nhau.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
STT<\/strong><\/td>\nLo\u1ea1i l\u1ed7i
\n<\/strong><\/td>\n		C\u00f4ng th\u1ee9c
\n<\/strong><\/td>\n		S\u1ed1 chuy\u1ec3n \u0111\u1ed5i
\n<\/strong><\/td>\n<\/tr>\n
\n

1<\/p>\n<\/td>\n

#NULL!<\/td>\n=ERROR.TYPE(#NULL!)<\/td>\n\n

1<\/p>\n<\/td>\n<\/tr>\n

\n

2<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n<\/td>\n
#DIV\/0!<\/td>\n=ERROR.TYPE(#DIV\/0!)<\/td>\n\n

2<\/p>\n<\/td>\n<\/tr>\n

\n

3<\/p>\n<\/td>\n

#VALUE!<\/td>\n=ERROR.TYPE(#VALUE!)<\/td>\n\n

3<\/p>\n<\/td>\n<\/tr>\n

\n

4<\/p>\n<\/td>\n

#REF!<\/td>\n=ERROR.TYPE(#REF!)<\/td>\n\n

4<\/p>\n<\/td>\n<\/tr>\n

\n

5<\/p>\n<\/td>\n

#NAME?<\/td>\n=ERROR.TYPE(#NAME?)<\/td>\n\n

5<\/p>\n<\/td>\n<\/tr>\n

\n

6<\/p>\n<\/td>\n

#NUM!<\/td>\n=ERROR.TYPE(#NUM!)<\/td>\n\n

6<\/p>\n<\/td>\n<\/tr>\n

\n

7<\/p>\n<\/td>\n

#N\/A<\/td>\n=ERROR.TYPE(#N\/A)<\/td>\n\n

7<\/p>\n<\/td>\n<\/tr>\n

\n

8<\/p>\n<\/td>\n

#GETTING_DATA<\/td>\n=ERROR.TYPE(#GETTING_DATA)<\/td>\n\n

8<\/p>\n<\/td>\n<\/tr>\n

\n

9<\/p>\n<\/td>\n

Lo\u1ea1i kh\u00e1c<\/td>\n=ERROR.TYPE(1)<\/td>\n\n

#N\/A<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u0110\u01b0\u01a1ng nhi\u00ean b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c ph\u1ee7 h\u00e0m l\u00ean t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 l\u1ed7i \u0111\u1ec3 chuy\u1ec3n t\u1ea5t c\u1ea3 th\u00e0nh s\u1ed1.<\/p>\n

T\u00ecm v\u00e0 thay th\u1ebf l\u1ed7i c\u00f4ng th\u1ee9c b\u1eb1ng s\u1ed1 0 ho\u1eb7c \u00f4 tr\u1ed1ng v\u1edbi Go to<\/strong><\/p>\n

C\u00e1ch n\u00e0y c\u00f3 th\u1ec3 chuy\u1ec3n t\u1ea5t c\u1ea3 c\u00e1c l\u1ed7i c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c ch\u1ecdn th\u00e0nh s\u1ed1 0, \u00f4 tr\u1ed1ng ho\u1eb7c m\u1ed9t gi\u00e1 tr\u1ecb b\u1ea5t k\u00ec.<\/p>\n

B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u00e0m vi\u1ec7c<\/p>\n

B\u01b0\u1edbc 2<\/strong>: Nh\u1ea5n F5<\/strong> \u0111\u1ec3 \u0111\u1ebfn h\u1ed9p tho\u1ea1i Go To.<\/strong><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n n\u00fat Special<\/strong>, \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Go to Special<\/strong>.<\/p>\n

B\u01b0\u1edbc 4<\/strong>: Trong h\u1ed9p tho\u1ea1i Go to Special<\/strong>, ch\u1ec9 ch\u1ecdn Formula<\/strong> v\u00e0 Errors<\/strong>, nh\u01b0 h\u00ecnh:<\/p>\n

\"doc-remove-formula-errors-2\"<\/p>\n

B\u01b0\u1edbc 5<\/strong>: Nh\u1ea5n OK, t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn<\/p>\n

\"doc-remove-formula-errors-3\"<\/p>\n

B\u01b0\u1edbc 6: <\/strong>B\u00e2y gi\u1edd nh\u1eadp s\u1ed1 0 hay b\u1ea5t k\u00ec gi\u00e1 tr\u1ecb n\u00e0o \u0111\u1ec3 thay th\u1ebf l\u1ed7i, nh\u1ea5n Ctrl+Enter <\/strong><\/p>\n

\"doc-remove-formula-errors-4\"<\/p>\n

\u0110\u01b0\u01a1ng nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 \u00f4 c\u00f3 h\u00e0m l\u1ed7i b\u1eb1ng ph\u00edm Delete, \u0111\u1ec3 l\u1ea1i nh\u1eefng \u00f4 tr\u1ed1ng.<\/p>\n

R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3241,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3240"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3241"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}