{"id":273556,"date":"2023-10-19T19:27:29","date_gmt":"2023-10-19T12:27:29","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=273556"},"modified":"2023-10-19T19:27:29","modified_gmt":"2023-10-19T12:27:29","slug":"loi-co-ban-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/","title":{"rendered":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng Microsoft Excel, ng\u01b0\u1eddi d\u00f9ng s\u1ebd kh\u00f4ng tr\u00e1nh kh\u1ecfi nh\u1eefng m\u00e3 l\u1ed7i hi\u1ec3n th\u1ecb do nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. \u0110i\u1ec3n h\u00ecnh nh\u01b0 l\u1ed7i #### khi nh\u1eadp li\u1ec7u ho\u1eb7c d\u00f9ng h\u00e0m, ho\u1eb7c c\u00e1c l\u1ed7i gi\u00e1 tr\u1ecb kh\u00e1c. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft <\/span><b>#### trong Excel l\u00e0 l\u1ed7i g\u00ec<\/b><span style=\"font-weight: 400;\"> c\u0169ng nh\u01b0 c\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c m\u00e3 l\u1ed7i trong khi thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh. Nh\u1eefng l\u1ed7i n\u00e0y \u0111\u00f4i khi s\u1ebd khi\u1ebfn b\u1ea1n c\u1ea3m gi\u00e1c hoang mang, th\u1eadm ch\u00ed l\u00e0 t\u1ed1n th\u1eddi gian \u0111\u1ec3 nh\u1eadp li\u1ec7u l\u1ea1i t\u1eeb \u0111\u1ea7u n\u1ebfu kh\u00f4ng bi\u1ebft c\u00e1ch s\u1eeda \u0111\u00fang. V\u00ec v\u1eady, \u0111\u1ec3 b\u1ed5 sung th\u00eam m\u1ed9t k\u1ef9 n\u0103ng m\u1edbi v\u00e0o c\u1ea9m nang tin h\u1ecdc v\u0103n ph\u00f2ng, trong b\u00e0i vi\u1ebft h\u00f4m nay, <\/span><b>Ho\u00e0ng H\u00e0 Mobile <\/b><span style=\"font-weight: 400;\">s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda c\u1ef1c nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n khi b\u1eaft g\u1eb7p 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn nh\u1ea5t.<\/span><\/p>\n<h2>#### trong Excel l\u00e0 l\u1ed7i g\u00ec, b\u1eaft ngu\u1ed3n t\u1eeb \u0111\u00e2u?<\/h2>\n<p><span style=\"font-weight: 400;\">#### l\u00e0 m\u1ed9t d\u00e3y k\u00fd t\u1ef1 bi\u1ec3u hi\u1ec7n m\u00e3 l\u1ed7i ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng b\u1eaft g\u1eb7p trong Microsoft Excel. D\u00f2ng hi\u1ec3n th\u1ecb n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n ngay sau khi b\u1ea1n nh\u1eadp xong d\u1eef li\u1ec7u l\u1ed7i ho\u1eb7c h\u00e0m l\u1ed7i v\u00e0 nh\u1ea5n Enter. Th\u00f4ng th\u01b0\u1eddng, \u00f4 t\u00ednh d\u00ednh l\u1ed7i s\u1ebd hi\u1ec3n th\u1ecb nhi\u1ec1u d\u1ea5u # t\u00f9y thu\u1ed9c v\u00e0o \u0111\u1ed9 r\u1ed9ng c\u1ee7a \u00f4 ho\u1eb7c \u0111\u1ed9 d\u00e0i c\u1ee7a d\u1eef li\u1ec7u. N\u1ebfu b\u1eaft g\u1eb7p m\u00e3 l\u1ed7i n\u00e0y, b\u1ea1n c\u0169ng \u0111\u1eebng qu\u00e1 lo l\u1eafng v\u00ec hi\u1ec7n t\u01b0\u1ee3ng n\u00e0y b\u1eaft ngu\u1ed3n t\u1eeb nh\u1eefng nguy\u00ean nh\u00e2n r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 \u0111\u1ec3 kh\u1eafc ph\u1ee5c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-273562 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-1.jpg\" alt=\"####-trong-excel-la-loi-gi-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u1ee5 th\u1ec3, \u0111\u1ec3 bi\u1ec3u l\u1ed7i #### trong Excel l\u00e0 l\u1ed7i g\u00ec, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ki\u1ec3m tra d\u1ef1a v\u00e0o 3 ngu\u1ed3n nguy\u00ean nh\u00e2n sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">K\u00edch th\u01b0\u1edbc c\u1ee7a c\u1ed9t ch\u1ee9a \u00f4 t\u00ednh kh\u00f4ng \u0111\u1ee7 ch\u1ed7 \u0111\u1ec3 ch\u1ee9a h\u1ebft c\u00e1c d\u1eef li\u1ec7u d\u00e0i, \u0111i\u1ec3n h\u00ecnh nh\u01b0 s\u1ed1 th\u1eadp ph\u00e2n v\u00f4 h\u1ea1n v\u1edbi qu\u00e1 nhi\u1ec1u ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y m\u00e0 \u00f4 kh\u00f4ng th\u1ec3 ch\u1ee9a h\u1ebft.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N\u1ed9i dung \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 t\u00ednh ch\u1ee9a qu\u00e1 nhi\u1ec1u k\u00fd t\u1ef1, kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c h\u1ebft trong ph\u1ea1m vi cho ph\u00e9p c\u1ee7a \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111i\u1ec1n ng\u00e0y th\u00e1ng nh\u01b0ng \u00f4 t\u00ednh l\u1ea1i tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u00e2m, \u0111\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p kh\u00e1 hi\u1ebfm g\u1eb7p nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng c\u0169ng n\u00ean bi\u1ebft c\u00e1ch \u0111\u1ec3 kh\u1eafc ph\u1ee5c khi c\u1ea7n thi\u1ebft.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u00ecn chung, l\u1ed7i #### l\u00e0 m\u1ed9t trong 8 m\u00e3 l\u1ed7i c\u01a1 b\u1ea3n c\u1ee7a b\u1ea3ng t\u00ednh, s\u1ebd g\u00e2y b\u1ea5t ti\u1ec7n n\u1ebfu ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng bi\u1ebft c\u00e1ch kh\u1eafc ph\u1ee5c. Khi ph\u00e1t hi\u1ec7n l\u1ed7i, thay v\u00ec ph\u1ea3i t\u1ed1n th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c x\u00f3a \u0111i \u0111\u1ec3 nh\u1eadp l\u1ea1i d\u1eef li\u1ec7u, b\u1ea1n ch\u1ec9 c\u1ea7n bi\u1ebft s\u1eed d\u1ee5ng m\u1ed9t v\u00e0i c\u00f4ng c\u1ee5 c\u00f3 s\u1eb5n trong ph\u1ea7n m\u1ec1m l\u00e0 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng s\u1eeda l\u1ed7i hi\u1ec3n th\u1ecb n\u00e0y.<\/span><\/p>\n<h2>C\u00e1ch kh\u1eafc ph\u1ee5c \u0111\u01a1n gi\u1ea3n khi bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec<\/h2>\n<p><span style=\"font-weight: 400;\">L\u1ed7i hi\u1ec3n th\u1ecb #### d\u00f9 th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i nh\u01b0ng kh\u00f4ng ph\u1ea3i m\u1ed9t s\u1ef1 c\u1ed1 kh\u00f3 gi\u1ea3i quy\u1ebft trong Excel, ng\u01b0\u1ee3c l\u1ea1i, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng kh\u1eafc ph\u1ee5c trong m\u1ed9t v\u00e0i gi\u00e2y. Vi\u1ec7c \u0111\u1ea7u ti\u00ean, b\u1ea1n ph\u1ea3i x\u00e1c \u0111\u1ecbnh xem m\u00e3 l\u1ed7i #### xu\u1ea5t ph\u00e1t t\u1eeb nguy\u00ean nh\u00e2n n\u00e0o trong 3 th\u1ee9 \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp ph\u00e1i tr\u00ean: k\u00edch th\u01b0\u1edbc \u00f4 qu\u00e1 nh\u1ecf, k\u00fd t\u1ef1 qu\u00e1 d\u00e0i hay th\u1eddi gian b\u1ecb \u00e2m. \u0110\u1ed1i v\u1edbi 2 tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea7u ti\u00ean, c\u00e1ch x\u1eed l\u00fd s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n so v\u1edbi c\u00e1i c\u00f2n l\u1ea1i. Ti\u1ebfp theo, ng\u01b0\u1eddi d\u00f9ng s\u1ebd l\u00e0m theo c\u00e1c h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y \u0111\u1ec3 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 m\u1ed9t c\u00e1ch nhanh g\u1ecdn l\u1eb9 nh\u1ea5t.<\/span><\/p>\n<h3>S\u1eeda l\u1ed7i k\u00edch th\u01b0\u1edbc \u00f4 qu\u00e1 nh\u1ecf khi bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec<\/h3>\n<p><span style=\"font-weight: 400;\">M\u00e3 l\u1ed7i #### s\u1ebd xu\u1ea5t hi\u1ec7n ngay sau khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp li\u1ec7u xong, nh\u01b0ng k\u00edch th\u01b0\u1edbc c\u1ee7a \u00f4 t\u00ednh l\u1ea1i qu\u00e1 nh\u1ecf, kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi n\u1ed9i dung \u0111\u01b0\u1ee3c nh\u1eadp. M\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh l\u00e0 khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m t\u00ednh to\u00e1n, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ed1 th\u1eadp ph\u00e2n v\u00f4 h\u1ea1n v\u1edbi r\u1ea5t nhi\u1ec1u ch\u1eef s\u1ed1, \u00f4 t\u00ednh kh\u00f4ng th\u1ec3 ch\u1ee9a n\u1ed5i, v\u00e0 t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng \u00f4 v\u1ec1 ####. Tuy nhi\u00ean, khi click v\u00e0o \u00f4 t\u00ednh b\u1ecb l\u1ed7i \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng v\u1eabn c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u \u0111\u1ea7y \u0111\u1ee7 tr\u00ean thanh n\u1ed9i dung.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D\u00f9 kh\u00f4ng g\u00e2y \u1ea3nh h\u01b0\u1edfng g\u00ec qu\u00e1 nghi\u00eam tr\u1ecdng, nh\u01b0ng m\u00e3 l\u1ed7i n\u00e0y s\u1ebd khi\u1ebfn b\u1ea3ng t\u00ednh m\u1ea5t th\u1ea9m m\u1ef9 v\u00e0 g\u00e2y kh\u00f3 \u0111\u1ecdc, kh\u00f3 theo d\u00f5i d\u1eef li\u1ec7u. V\u1eady n\u00ean trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u00f4 t\u00ednh ho\u1eb7c c\u1ed9t ch\u1ee9a \u00f4 t\u00ednh sao cho v\u1eeba kh\u1edbp ho\u1eb7c d\u00e0i h\u01a1n v\u1edbi d\u1eef li\u1ec7u \u0111\u1ec3 n\u1ed9i dung \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb h\u1ebft m\u00e0 kh\u00f4ng d\u00ednh l\u1ed7i. C\u00f3 3 c\u00e1ch kh\u1eafc ph\u1ee5c v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n sau, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo 1 trong nh\u1eefng c\u00e1ch \u0111\u01b0\u1ee3c nh\u1eafc t\u1edbi sau \u0111\u00e2y:<\/span><\/p>\n<p><b>C\u00e1ch 1:<\/b><span style=\"font-weight: 400;\"> \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o v\u00e1ch ng\u0103n gi\u1eefa hai c\u1ed9t, trong \u0111\u00f3 c\u1ed9t b\u00ean tr\u00e1i ch\u1ee9a \u00f4 b\u1ecb l\u1ed7i. Nh\u1ea5n \u0111\u00fap chu\u1ed9t \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc cho ph\u00f9 h\u1ee3p v\u1edbi n\u1ed9i dung d\u00e0i nh\u1ea5t.<\/span><\/p>\n<p><b>C\u00e1ch 2: <\/b><span style=\"font-weight: 400;\">\u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o v\u00e1ch ng\u0103n gi\u1eefa hai c\u1ed9t, thao t\u00e1c k\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc c\u1ed9t \u0111\u1ebfn khi n\u1ed9i dung \u0111\u00e3 v\u1eeba v\u1edbi \u0111\u1ed9 r\u1ed9ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-273563 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-2.jpg\" alt=\"####-trong-excel-la-loi-gi-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch 3:<\/b><span style=\"font-weight: 400;\"> L\u1ef1a ch\u1ecdn c\u1ed9t ch\u1ee9a \u00f4 t\u00ednh b\u1ecb l\u1ed7i ####, click chu\u1ed9t ph\u1ea3i ch\u1ecdn <\/span><b>Column Width<\/b><span style=\"font-weight: 400;\">. Sau \u0111\u00f3 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc b\u1eb1ng c\u00e1ch nh\u1eadp s\u1ed1 mong mu\u1ed1n v\u00e0 ph\u00f9 h\u1ee3p, r\u1ed3i ch\u1ecdn<\/span><b> OK<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3>S\u1eeda l\u1ed7i s\u1ed1 th\u1eadp ph\u00e2n li\u00ean quan \u0111\u1ebfn v\u1ea5n \u0111\u1ec1 #### trong Excel l\u00e0 l\u1ed7i g\u00ec<\/h3>\n<p><span style=\"font-weight: 400;\">Nguy\u00ean nh\u00e2n th\u1ee9 hai b\u1eaft ngu\u1ed3n t\u1eeb vi\u1ec7c n\u1ed9i dung nh\u1eadp v\u00e0o Excel qu\u00e1 d\u00e0i, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng d\u1eef li\u1ec7u c\u00f3 li\u00ean quan \u0111\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n. Th\u00f4ng th\u01b0\u1eddng, \u0111\u1ed1i v\u1edbi nh\u1eefng s\u1ed1 ch\u1ee9a qu\u00e1 nhi\u1ec1u ch\u1eef s\u1ed1 ph\u00eda sau d\u1ea5u ph\u1ea9y, k\u00edch th\u01b0\u1edbc m\u1eb7c \u0111\u1ecbnh c\u1ee7a \u00f4 t\u00ednh s\u1ebd kh\u00f3 m\u00e0 hi\u1ec3n th\u1ecb \u0111\u1ee7, d\u1eabn \u0111\u1ebfn m\u00e3 l\u1ed7i ####. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, thay v\u00ec ph\u1ea3i x\u00f3a b\u1edbt c\u00e1c ch\u1eef s\u1ed1 theo c\u00e1ch th\u1ee7 c\u00f4ng, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng v\u00e0 r\u00fat g\u1ecdn s\u1ed1 b\u1eb1ng c\u00e1c ch\u1ee9c n\u0103ng \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec v\u00e0 xu\u1ea5t ph\u00e1t t\u1eeb n\u1ed9i dung qu\u00e1 kh\u1ed5, b\u1ea1n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00e1ch sau:<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">L\u1ef1a ch\u1ecdn \u00f4 t\u00ednh b\u1ecb l\u1ed7i d\u1eef li\u1ec7u.<\/span><\/p>\n<p><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400;\"> Click chu\u1ed9t ch\u1ecdn tab <\/span><b>Home<\/b><span style=\"font-weight: 400;\">, trong b\u1ea3ng c\u00f4ng c\u1ee5 <\/span><b>Number<\/b><span style=\"font-weight: 400;\">, l\u1ef1a ch\u1ecdn ch\u1ee9c n\u0103ng <\/span><b>Decrease Decimal<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-273564 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-3.jpg\" alt=\"####-trong-excel-la-loi-gi-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng c\u1ee5 n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng r\u00fat g\u1ecdn s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch l\u00e0m tr\u00f2n c\u00e1c ch\u1eef s\u1ed1 \u0111\u1eb1ng sau d\u1ea5u ph\u1ea9y, khi\u1ebfn s\u1ed1 trong \u00f4 t\u00ednh ng\u1eafn h\u01a1n v\u00e0 v\u1eeba v\u1eb7n h\u01a1n. Khi \u0111\u1ecbnh d\u1ea1ng xong, \u00f4 t\u00ednh ch\u1ee9a l\u1ed7i #### s\u1ebd t\u1ef1 \u0111\u1ed9ng kh\u1eafc ph\u1ee5c v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n cho b\u1ea1n. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng y\u00ean t\u00e2m v\u00ec h\u1ec7 th\u1ed1ng c\u1ee7a Excel v\u00f4 c\u00f9ng th\u00f4ng minh, c\u00f3 th\u1ec3 t\u1ef1 l\u00e0m tr\u00f2n v\u1edbi k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t.<\/span><\/p>\n<h3>S\u1eeda l\u1ed7i ng\u00e0y th\u00e1ng \u00e2m sau khi bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec v\u00e0 nguy\u00ean nh\u00e2n g\u00ec<\/h3>\n<p><span style=\"font-weight: 400;\">D\u00f9 l\u00e0 tr\u01b0\u1eddng h\u1ee3p kh\u00e1 hi\u1ebfm g\u1eb7p khi s\u1eed d\u1ee5ng Excel, nh\u01b0ng trong qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u hay s\u1eed d\u1ee5ng h\u00e0m, \u0111\u00f4i khi ng\u01b0\u1eddi d\u00f9ng s\u1ebd g\u1eb7p sai s\u00f3t v\u00e0 khi\u1ebfn k\u1ebft qu\u1ea3 ng\u00e0y th\u00e1ng tr\u1ea3 l\u1eddi d\u00ednh d\u1ea5u \u00e2m. Khi n\u00e0y, h\u1ec7 th\u1ed1ng Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ghi nh\u1eadn l\u1ed7i v\u00e0 th\u00f4ng b\u00e1o b\u1eb1ng c\u00e1ch hi\u1ec3n th\u1ecb ####. Click v\u00e0o thanh nh\u1eadp li\u1ec7u c\u1ee7a \u00f4 \u1edf ph\u00eda tr\u00ean, b\u1ea1n s\u1ebd th\u1ea5y trong m\u1ee5c ng\u00e0y th\u00e1ng d\u00ednh m\u1ea5t d\u1ea5u \u201c-\u201d \u1edf \u0111\u1ea7u, khi\u1ebfn m\u00e1y kh\u00f4ng th\u1ec3 nh\u1eadn d\u1ea1ng. Khi ph\u00e1t hi\u1ec7n ra s\u1ef1 c\u1ed1 n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c thao t\u00e1c sau \u0111\u00e2y \u0111\u1ec3 kh\u1eafc ph\u1ee5c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh nh\u1ea5t.<\/span><\/p>\n<p><b>C\u00e1ch 1: <\/b><span style=\"font-weight: 400;\">Ki\u1ec3m tra c\u00e1c h\u00e0m th\u1eddi gian \u0111ang s\u1eed d\u1ee5ng xem c\u00f3 nh\u1eadp nh\u1ea7m d\u1ea5u trong khi d\u00f9ng h\u00e0m kh\u00f4ng.<\/span><\/p>\n<p><b>C\u00e1ch 2: <\/b><span style=\"font-weight: 400;\">Click ch\u1ecdn \u00f4 ng\u00e0y th\u00e1ng b\u1ecb l\u1ed7i, thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng t\u1eeb <\/span><b>Date<\/b><span style=\"font-weight: 400;\"> v\u1ec1 <\/span><b>General<\/b><span style=\"font-weight: 400;\"> trong h\u1ed9p c\u00f4ng c\u1ee5 Number \u1edf tab Home.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273565 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-4.jpg\" alt=\"####-trong-excel-la-loi-gi-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch 3: <\/b><span style=\"font-weight: 400;\">Click \u0111\u00fap v\u00e0o \u00f4 t\u00ednh ho\u1eb7c s\u1eed d\u1ee5ng thanh nh\u1eadp li\u1ec7u \u0111\u1ec3 x\u00f3a d\u1ea5u \u201c=\u201d v\u00e0 d\u1ea5u \u201c-\u201d ngay tr\u01b0\u1edbc ch\u1eef s\u1ed1 hi\u1ec3n th\u1ecb ng\u00e0y \u0111\u1ec3 \u00f4 t\u00ednh nh\u1eadn d\u1ea1ng n\u1ed9i dung b\u00ecnh th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i hi\u1ec3n th\u1ecb #### theo t\u1eebng nguy\u00ean nh\u00e2n v\u00e0 tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau. \u0110\u00e2y ch\u1ec9 l\u00e0 1 trong 8 m\u00e3 l\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng chuy\u00ean s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh. \u0110\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng tin h\u1ecdc v\u0103n ph\u00f2ng c\u1ee7a m\u00ecnh, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c l\u1ed7i, t\u1eeb \u0111\u00f3 c\u00f3 c\u00e1ch x\u1eed l\u00fd k\u1ecbp th\u1eddi v\u00e0 hi\u1ec7u qu\u1ea3. B\u00ean c\u1ea1nh gi\u1ea3i \u0111\u00e1p th\u1eafc m\u1eafc \u201c#### trong Excel l\u00e0 l\u1ed7i g\u00ec?\u201d, ph\u1ea7n ti\u1ebfp theo \u0111\u00e2y s\u1ebd m\u00e1ch b\u1ea1n c\u00f3 m\u1eb9o kh\u1eafc ph\u1ee5c th\u00eam 7 l\u1ed7i c\u01a1 b\u1ea3n n\u1eefa trong Microsoft Excel.<\/span><\/p>\n<h2>C\u00e1ch kh\u1eafc ph\u1ee5c c\u00e1c m\u00e3 l\u1ed7i ph\u1ed5 bi\u1ebfn trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3<\/h2>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh l\u1ed7i \u0111\u1ed9 r\u1ed9ng ####, ng\u01b0\u1eddi d\u00f9ng r\u1ea5t c\u00f3 th\u1ec3 s\u1ebd b\u1eaft g\u1eb7p th\u00eam 7 m\u00e3 l\u1ed7i n\u1eefa c\u00f3 li\u00ean quan \u0111\u1ebfn Excel. \u0110\u00f3 l\u00e0 c\u00e1c l\u1ed7i c\u01a1 b\u1ea3n v\u1ec1 gi\u00e1 tr\u1ecb, c\u00e1ch chia, d\u1eef li\u1ec7u, v\u00f9ng tham chi\u1ebfu v\u00e0 l\u1ed7i t\u00ean. M\u1ed7i lo\u1ea1i l\u1ed7i s\u1ebd c\u00f3 m\u00e3 l\u1ed7i v\u1edbi c\u00e1c k\u00fd t\u1ef1 kh\u00e1c nhau. V\u1eady \u0111\u00e2u l\u00e0 nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn c\u00e1c s\u1ef1 c\u1ed1 n\u00e0y v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n thi\u1ebft? C\u00e1ch th\u00f4ng tin d\u01b0\u1edbi \u0111\u00e2y s\u1ebd cung c\u1ea5p cho b\u1ea1n t\u1ea5t t\u1eadn t\u1ea5t nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 7 l\u1ed7i c\u00f2n l\u1ea1i trong Excel v\u00e0 \u0111\u1ec1 xu\u1ea5t nh\u1eefng ph\u01b0\u01a1ng \u00e1n gi\u1ea3i quy\u1ebft nhanh, \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/span><\/p>\n<h3>#VALUE! &#8211; C\u00e1ch s\u1eeda l\u1ed7i gi\u00e1 tr\u1ecb trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #VALUE! l\u00e0 m\u1ed9t d\u1ea1ng m\u00e3 l\u1ed7i th\u00f4ng b\u00e1o t\u1edbi ng\u01b0\u1eddi d\u00f9ng v\u1ec1 s\u1ef1 c\u1ed1 g\u1eb7p ph\u1ea3i \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp, ho\u1eb7c c\u00e1c \u00f4 tham chi\u1ebfu \u0111ang g\u1eb7p v\u1ea5n \u0111\u1ec1. \u0110\u00e2y l\u00e0 m\u1ed9t ki\u1ec3u l\u1ed7i gi\u00e1 tr\u1ecb kh\u00e1 chung chung v\u00e0 c\u00f3 th\u1ec3 xu\u1ea5t ph\u00e1t t\u1eeb nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 do gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 tham chi\u1ebfu kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u c\u1ee7a h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng, khi\u1ebfn vi\u1ec7c t\u00ednh to\u00e1n c\u1ee7a ph\u1ea7n m\u1ec1m b\u1ecb l\u1ed7i (v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c ch\u1ec9 t\u00ednh \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u s\u1ed1, nh\u01b0ng v\u00f9ng tham chi\u1ebfu l\u1ea1i l\u00e0 ch\u1eef c\u00e1i, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c d\u00ednh kho\u1ea3ng tr\u1eafng). Ngo\u00e0i ra, ng\u01b0\u1eddi d\u00f9ng c\u00f2n g\u1eb7p ph\u1ea3i #VALUE! trong m\u1ed9t v\u00e0i tr\u01b0\u1eddng h\u1ee3p sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00e1c l\u1ed7i v\u1edbi ph\u00e9p tr\u1eeb do \u0111\u1ecbnh d\u1ea1ng D\u1ea5u t\u00e1ch danh s\u00e1ch ch\u01b0a ph\u00f9 h\u1ee3p.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00e1c l\u1ed7i v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c li\u00ean quan \u0111\u1ebfn th\u1eddi gian.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c ch\u01b0a \u0111\u01b0\u1ee3c ho\u00e0n thi\u1ec7n m\u00e0 v\u00f4 t\u00ednh nh\u1ea5n Enter.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273566 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-5.jpg\" alt=\"####-trong-excel-la-loi-gi-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p l\u1ed7i gi\u00e1 tr\u1ecb do \u0111\u1ecbnh d\u1ea1ng v\u00f9ng tham chi\u1ebfu ho\u1eb7c kho\u1ea3ng tr\u1eafng, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! nh\u01b0 sau:<\/span><\/p>\n<p><b>C\u00e1ch 1:<\/b><span style=\"font-weight: 400;\"> Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp xem \u0111\u00e3 \u0111\u1ea7y \u0111\u1ee7 v\u00e0 \u0111\u00fang y\u00eau c\u1ea7u ch\u01b0a.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273567 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-6.jpg\" alt=\"####-trong-excel-la-loi-gi-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch 2:<\/b>\u00a0Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng cho \u00f4 t\u00ednh \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng v\u1edbi c\u00f4ng th\u1ee9c b\u1eb1ng c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng\u00a0<b>Number<\/b>\u00a0trong tab\u00a0<b>Home<\/b>.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273568 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-7.jpg\" alt=\"####-trong-excel-la-loi-gi-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>C\u00e1ch 3: <\/b><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 <\/span><b>Replace (Ctrl + G)<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf c\u00e1c kho\u1ea3ng tr\u1eafng b\u1ecb \u1ea9n trong v\u00f9ng tham chi\u1ebfu.<\/span><\/p>\n<h3>#DIV\/0! &#8211; C\u00e1ch s\u1eeda l\u1ed7i chia cho 0 trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">M\u00e3 l\u1ed7i #DIV\/0! ch\u1ec9 xu\u1ea5t hi\u1ec7n trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c chia v\u1edbi s\u1ed1 chia mang gi\u00e1 tr\u1ecb 0. L\u1ed7i n\u00e0y th\u00f4ng b\u00e1o r\u1eb1ng ph\u00e9p chia cho 0 kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n hay c\u00f3 k\u1ebft qu\u1ea3 x\u00e1c \u0111\u1ecbnh. T\u1ed5ng h\u1ee3p l\u1ea1i, ng\u01b0\u1eddi d\u00f9ng s\u1ebd g\u1eb7p ph\u1ea3i m\u00e3 l\u1ed7i n\u00e0y v\u1edbi c\u00e1c nguy\u00ean nh\u00e2n sau \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1eadp c\u00f4ng th\u1ee9c chia \u0111\u01a1n gi\u1ea3n nh\u01b0ng s\u1ed1 chia l\u1ea1i c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 (VD nh\u01b0 1\/0).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c chia nh\u01b0ng v\u00f9ng tham chi\u1ebfu c\u00f3 ch\u1ee9a m\u1ed9t \u00f4 b\u1eb1ng 0.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273569 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-8.jpg\" alt=\"####-trong-excel-la-loi-gi-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c chia \u0111\u1ebfn v\u00f9ng tham chi\u1ebfu c\u00f3 m\u1ed9t \u00f4 tr\u1ed1ng d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273570 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-9.jpg\" alt=\"####-trong-excel-la-loi-gi-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">T\u00f9y thu\u1ed9c v\u00e0o t\u1eebng nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u01b0\u01a1ng \u00e1n sau \u0111\u1ec3 kh\u1eafc ph\u1ee5c m\u00e3 l\u1ed7i n\u00e0y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">H\u00e3y ch\u1eafc ch\u1eafn s\u1eed d\u1ee5ng h\u00e0m ho\u1eb7c c\u00f4ng th\u1ee9c chia kh\u00f4ng \u00e1p d\u1ee5ng v\u1edbi s\u1ed1 chia l\u00e0 \u00f4 c\u00f3 gi\u00e1 tr\u1ecb 0 ho\u1eb7c ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Thay \u0111\u1ed5i s\u1ed1 chia sang \u00f4 tham chi\u1ebfu kh\u00e1c m\u00e0 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb 0 ho\u1eb7c ch\u01b0a \u0111\u01b0\u1ee3c nh\u1eadp d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng k\u00fd t\u1ef1 #N\/A v\u00e0o \u00f4 tr\u1ed1ng \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ec3 bi\u1ec3u th\u1ecb r\u1eb1ng kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 chia.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p th\u1ee9 ba m\u00e0 ng\u01b0\u1eddi d\u00f9ng n\u00ean bi\u1ebft c\u00e1ch kh\u1eafc ph\u1ee5c sau khi bi\u1ebft #VALUE! hay #### trong Excel l\u00e0 l\u1ed7i g\u00ec. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 ng\u0103n ch\u1eb7n m\u00e3 l\u1ed7i chia cho 0. Khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, n\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u00fang th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u00ecnh th\u01b0\u1eddng, nh\u01b0ng n\u1ebfu c\u00f4ng th\u1ee9c sai s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0.<\/span><\/p>\n<h3>#NAME! &#8211; C\u00e1ch s\u1eeda l\u1ed7i t\u00ean c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">M\u00e3 l\u1ed7i #NAME! th\u01b0\u1eddng b\u1eaft ngu\u1ed3n t\u1eeb nguy\u00ean nh\u00e2n ch\u1ee7 quan c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng, th\u00f4ng b\u00e1o r\u1eb1ng Excel kh\u00f4ng th\u1ec3 \u0111\u1ecdc hi\u1ec3u hay x\u1eed l\u00fd h\u00e0m b\u1ea1n v\u1eeba nh\u1eadp. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng xu\u1ea5t ph\u00e1t t\u1eeb vi\u1ec7c ghi sai t\u00ean c\u00f4ng th\u1ee9c, ngo\u00e0i ra l\u1ed7i c\u0169ng xu\u1ea5t hi\u1ec7n khi b\u1ea1n thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p v\u0103n b\u1ea3n trong h\u00e0m ho\u1eb7c thi\u1ebfu d\u1ea5u hai ch\u1ea5m cho c\u00e1c d\u1ea3i \u00f4 tham chi\u1ebfu. Khi g\u1eb7p l\u1ed7i n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n click chu\u1ed9t v\u00e0o \u00f4 t\u00ednh ch\u1ee9a m\u00e3 l\u1ed7i v\u00e0 ki\u1ec3m tra l\u1ea1i h\u00e0m v\u1eeba nh\u1eadp tr\u00ean thanh d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng t\u00ednh. B\u1ea1n c\u1ea7n check l\u1ea1i xem li\u1ec7u m\u00ecnh \u0111\u00e3 vi\u1ebft \u0111\u00fang t\u00ean h\u00e0m, s\u1eed d\u1ee5ng \u0111\u00fang c\u00fa ph\u00e1p v\u00e0 d\u1ea5u c\u00e2u ch\u01b0a.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273571 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-10.jpg\" alt=\"####-trong-excel-la-loi-gi-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">M\u1ed9t g\u1ee3i \u00fd \u0111\u1ec3 h\u1ea1n ch\u1ebf t\u00ecnh tr\u1ea1ng #NAME! x\u1ea3y ra l\u00e0 ng\u01b0\u1eddi d\u00f9ng n\u00ean s\u1eed d\u1ee5ng Tr\u00ecnh h\u01b0\u1edbng d\u1eabn C\u00f4ng th\u1ee9c trong Excel &#8211; ph\u1ea7n b\u1ea3ng g\u1ee3i \u00fd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb m\u1ed7i khi b\u1eaft \u0111\u1ea7u nh\u1eadp h\u00e0m v\u00e0o \u00f4 t\u00ednh. C\u00f4ng c\u1ee5 \u0111\u00f3 s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch ghi t\u00ean \u0111\u00fang cho c\u00e1c h\u00e0m, \u0111\u1ed3ng th\u1eddi g\u1ee3i \u00fd chi ti\u1ebft v\u1ec1 c\u00fa ph\u00e1p \u0111\u00fang \u0111\u1ec3 h\u00e0m c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng.<\/span><\/p>\n<h3>#N\/A &#8211; C\u00e1ch s\u1eeda l\u1ed7i d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">M\u00e3 l\u1ed7i #N\/A! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u00e1o hi\u1ec7u cho ng\u01b0\u1eddi d\u00f9ng r\u1eb1ng Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd c\u00f4ng th\u1ee9c v\u1eeba nh\u1eadp do nh\u1eefng n\u1ed9i dung bao h\u00e0m trong c\u00f4ng th\u1ee9c \u0111\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong b\u1ea3ng t\u00ednh hay v\u00f9ng tham chi\u1ebfu. L\u1ed7i n\u00e0y ph\u1ed5 bi\u1ebfn nh\u1ea5t v\u1edbi c\u00e1c h\u00e0m VLOOKUP, HLOOKUP ho\u1eb7c MATCH khi h\u00e0m kh\u00f4ng th\u1ec3 t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb tham chi\u1ebfu do nh\u1eadp li\u1ec7u thi\u1ebfu ho\u1eb7c \u0111\u00e3 b\u1ecb x\u00f3a tr\u01b0\u1edbc khi ch\u1ea1y h\u00e0m.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273572 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-11.jpg\" alt=\"####-trong-excel-la-loi-gi-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 h\u1ea1n ch\u1ebf c\u0169ng nh\u01b0 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng v\u00f9ng tham chi\u1ebfu v\u1edbi c\u00f4ng th\u1ee9c ph\u1ea3i c\u00f3 \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u ho\u1eb7c gi\u00e1 tr\u1ecb. B\u1ea1n c\u0169ng c\u1ea7n ki\u1ec3m tra xem li\u1ec7u h\u00e0m \u0111\u00e3 tham chi\u1ebfu \u0111\u00fang khu v\u1ef1c ch\u01b0a, li\u1ec7u c\u00e1c n\u1ed9i dung c\u00f3 b\u1ecb x\u00f3a nh\u1ea7m tr\u01b0\u1edbc khi kh\u1edfi ch\u1ea1y h\u00e0m hay kh\u00f4ng. B\u00ean c\u1ea1nh \u0111\u00f3, s\u1eed d\u1ee5ng h\u00e0m IFERROR c\u0169ng gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ecm ra nguy\u00ean nh\u00e2n c\u1ee7a #N\/A! \u0111\u1ec3 c\u00f3 gi\u1ea3i ph\u00e1p x\u1eed l\u00fd ph\u00f9 h\u1ee3p.<\/span><\/p>\n<h3>#REF &#8211; C\u00e1ch s\u1eeda l\u1ed7i v\u00f9ng tham chi\u1ebfu trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">Khi nh\u1eadp m\u1ed9t h\u00e0m ho\u1eb7c c\u00f4ng th\u1ee9c \u0111\u1ec3 v\u00f9ng tham chi\u1ebfu ch\u1ee9a nh\u1eefng \u00f4 t\u00ednh kh\u00f4ng h\u1ee3p l\u1ec7, m\u00e3 l\u1ed7i #REF! s\u1ebd hi\u1ec3n th\u1ecb \u0111\u1ec3 th\u00f4ng b\u00e1o t\u1edbi b\u1ea1n \u0111i\u1ec1u n\u00e0y. \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng m\u00e3 l\u1ed7i t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f3 t\u00ecm ra nguy\u00ean nh\u00e2n nh\u1ea5t. #REF! c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi m\u1ed9t \u00f4 t\u00ednh \u0111\u00e3 b\u1ecb x\u00f3a, s\u1eed d\u1ee5ng sai v\u00f9ng tham chi\u1ebfu, di chuy\u1ec3n \u00f4 tham chi\u1ebfu d\u1eabn \u0111\u1ebfn l\u1ec7ch gi\u00e1 tr\u1ecb\u2026<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273573 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-12.jpg\" alt=\"####-trong-excel-la-loi-gi-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ki\u1ec3m tra c\u1ea9n th\u1eadn v\u00f9ng tham chi\u1ebfu c\u1ee7a c\u00f4ng th\u1ee9c xem g\u1eb7p s\u1ef1 c\u1ed1 g\u00ec kh\u00f4ng. N\u1ebfu v\u00f4 t\u00ecnh x\u00f3a nh\u1ea7m h\u00e0ng\/c\u1ed9t trong khu v\u1ef1c tham chi\u1ebfu, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn <\/span><b>Ho\u00e0n t\u00e1c<\/b><span style=\"font-weight: 400;\"> ho\u1eb7c <\/span><b>Ctrl Z <\/b><span style=\"font-weight: 400;\">\u0111\u1ec3 h\u1ec7 th\u1ed1ng kh\u00f4i ph\u1ee5c l\u1ea1i d\u1eef li\u1ec7u v\u1eeba x\u00f3a. Nh\u01b0 v\u1eady, b\u00e0i vi\u1ebft \u0111\u00e3 gi\u1edbi thi\u1ec7u \u0111\u01b0\u1ee3c th\u00eam m\u1ed9t m\u00e3 l\u1ed7i c\u01a1 b\u1ea3n n\u1eefa sau khi cung c\u1ea5p c\u00e1c th\u00f4ng tin v\u1ec1 #VALUE!, #DIV\/0!, #N\/A, #### trong Excel l\u00e0 l\u1ed7i g\u00ec. 2 l\u1ed7i sau \u0111\u00e2y \u0111\u1ec1u li\u00ean quan \u0111\u1ebfn s\u1ef1 c\u1ed1 d\u1eef li\u1ec7u, \u00edt g\u1eb7p h\u01a1n nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u1ea7n n\u1eafm r\u00f5 ph\u01b0\u01a1ng ph\u00e1p x\u1eed l\u00fd n\u1ebfu g\u1eb7p ph\u1ea3i.<\/span><\/p>\n<h3>#NUM &#8211; C\u00e1ch s\u1eeda l\u1ed7i d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1 trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu h\u00e0m hay c\u00f4ng th\u1ee9c b\u1ea1n s\u1eed d\u1ee5ng trong Excel ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 kh\u00f4ng ph\u00f9 h\u1ee3p, \u00f4 t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #NUM. L\u1ed7i n\u00e0y th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi b\u1ea1n nh\u1eadp gi\u00e1 tr\u1ecb s\u1ed1 d\u00f9ng ki\u1ec3u d\u1eef li\u1ec7u ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00f4ng \u0111\u01b0\u01a1\u0323c h\u1ed7 tr\u1ee3 trong ph\u1ea7n \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00f4ng th\u1ee9c. B\u00ean c\u1ea1nh \u0111\u00f3, \u0111\u00e2y c\u0169ng l\u00e0 m\u00e3 l\u1ed7i th\u00f4ng b\u00e1o r\u1eb1ng c\u00f4ng th\u1ee9c \u0111ang s\u1eed d\u1ee5ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb qu\u00e1 l\u1edbn ho\u1eb7c qu\u00e1 nh\u1ecf.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273574 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-13.jpg\" alt=\"####-trong-excel-la-loi-gi-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 li\u00ean quan \u0111\u1ebfn \u0111\u1ecbnh d\u1ea1ng n\u1ed9i dung ch\u1eef s\u1ed1 n\u00e0y trong b\u1ea3ng t\u00ednh, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ki\u1ec3m tra xem d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 t\u00ednh c\u00f3 ph\u00f9 h\u1ee3p v\u00e0 \u0111\u00fang v\u1edbi y\u00eau c\u1ea7u hay kh\u00f4ng. T\u1eeb \u0111\u00f3 c\u00f3 nh\u1eefng thay \u0111\u1ed5i ph\u00f9 h\u1ee3p trong c\u00e0i \u0111\u1eb7t v\u1ec1 ph\u1ea1m vi hi\u1ec3n th\u1ecb s\u1ed1 c\u0169ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 li\u00ean quan.<\/span><\/p>\n<h3>#NULL &#8211; C\u00e1ch s\u1eeda l\u1ed7i d\u1eef li\u1ec7u r\u1ed7ng trong b\u1ea3ng t\u00ednh Excel<\/h3>\n<p><span style=\"font-weight: 400;\">M\u00e3 l\u1ed7i #NULL hi\u1ec3n th\u1ecb \u0111\u1ec3 th\u00f4ng b\u00e1o v\u1edbi ng\u01b0\u1eddi d\u00f9ng Excel l\u00e0 c\u00e1c \u00f4 ho\u1eb7c v\u00f9ng tham chi\u1ebfu trong c\u00f4ng th\u1ee9c ch\u01b0a c\u00f3 s\u1ef1 li\u00ean k\u1ebft b\u1edfi k\u00fd t\u1ef1 c\u00f3 t\u00ean l\u00e0 to\u00e1n t\u1eed giao. Th\u00f4ng th\u01b0\u1eddng, c\u00e1c k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c l\u00e0 d\u1ea5u \u201c:\u201d v\u00e0 \u201c;\u201d.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/trong-excel-la-loi-gi-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-273575 webpexpress-processed\" src=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-14.jpg\" alt=\"####-trong-excel-la-loi-gi-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ch\u1eafc ch\u1eafn \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u00fang k\u00fd t\u1ef1 ph\u00e2n t\u00e1ch gi\u1eefa c\u00e1c ph\u1ea1m vi tham chi\u1ebfu. Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">D\u1ea5u hai ch\u1ea5m (:) \u0111\u1ec3 khoanh v\u00f9ng khu v\u1ef1c \u0111\u01b0\u1ee3c tham chi\u1ebfu, v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea7u \u0111\u1ec3 ch\u1ec9 \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 k\u00fd t\u1ef1 sau ch\u1ec9 \u00f4 cu\u1ed1i c\u00f9ng trong ph\u1ea1m vi \u00f4 li\u00ean t\u1ee5c. VD: = AVERAGE (A1:A5).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">D\u1ea5u ph\u1ea9y (,) d\u00f9ng \u0111\u1ec3 ph\u00e2n bi\u1ec7t hai \u00f4 tham chi\u1ebfu ho\u1eb7c ph\u1ea1m vi tham chi\u1ebfu kh\u00f4ng giao nhau. VD: = AVERAGE (A1, A5).<\/span><\/li>\n<\/ul>\n<h2>T\u1ea1m k\u1ebft ch\u1ee7 \u0111\u1ec1 #### trong Excel l\u00e0 g\u00ec l\u1ed7i g\u00ec v\u00e0 c\u00e1ch s\u1eeda 8 l\u1ed7i th\u01b0\u1eddng g\u1eb7p<\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, b\u00e0i vi\u1ebft \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n th\u00eam c\u00e1c k\u1ef9 n\u0103ng m\u1edbi cho cu\u1ed1n c\u1ea9m nang tin h\u1ecdc v\u0103n ph\u00f2ng, gi\u00fap b\u1ea1n c\u1ea3i thi\u1ec7n hi\u1ec7u qu\u1ea3 s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Microsoft Excel trong c\u00f4ng vi\u1ec7c. \u0110\u1eb7c bi\u1ec7t, v\u1edbi ph\u1ea7n gi\u1ea3i th\u00edch <\/span><b>#### trong Excel l\u00e0 l\u1ed7i g\u00ec<\/b><span style=\"font-weight: 400;\"> v\u00e0 h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c 8 m\u00e3 l\u1ed7i th\u01b0\u1eddng g\u1eb7p, ng\u01b0\u1eddi d\u00f9ng s\u1ebd d\u1ec5 d\u00e0ng x\u1eed l\u00fd c\u00e1c s\u1ef1 c\u1ed1 h\u01a1n trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh. \u0110\u1eebng qu\u00ean theo d\u00f5i <\/span><b>Ho\u00e0ng H\u00e0 Mobile <\/b><span style=\"font-weight: 400;\">\u0111\u1ec3 c\u1eadp nh\u1eadt tin t\u1ee9c c\u00f4ng ngh\u1ec7 m\u1edbi nh\u1ea5t v\u00e0 c\u00e1c th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh h\u1eefu \u00edch kh\u00e1c.<\/span><\/p>\n<p><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li aria-level=\"1\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\"><b>H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p<\/b><\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\\\/\\\/hoanghamobile.com\/tin-tuc\/cach-tach-ten-trong-excel\/\"><strong>C\u00e1ch t\u00e1ch c\u1ed9t h\u1ecd v\u00e0 t\u00ean trong Excel nhanh v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/strong><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Khi s\u1eed d\u1ee5ng Microsoft Excel, ng\u01b0\u1eddi d\u00f9ng s\u1ebd kh\u00f4ng tr\u00e1nh kh\u1ecfi nh\u1eefng m\u00e3 l\u1ed7i hi\u1ec3n th\u1ecb do nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. \u0110i\u1ec3n h\u00ecnh nh\u01b0 l\u1ed7i #### khi nh\u1eadp li\u1ec7u ho\u1eb7c d\u00f9ng h\u00e0m, ho\u1eb7c c\u00e1c l\u1ed7i gi\u00e1 tr\u1ecb kh\u00e1c. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec c\u0169ng nh\u01b0 c\u00e1ch [&hellip;]<\/p>\n","protected":false},"author":79,"featured_media":273561,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-273556","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-19T12:27:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Linh Kieu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Linh Kieu\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\"},\"author\":{\"name\":\"Linh Kieu\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/25972a42c5fe0b5ed1d6cc938986850d\"},\"headline\":\"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\",\"datePublished\":\"2023-10-19T12:27:29+00:00\",\"dateModified\":\"2023-10-19T12:27:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\"},\"wordCount\":4810,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\",\"name\":\"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg\",\"datePublished\":\"2023-10-19T12:27:29+00:00\",\"dateModified\":\"2023-10-19T12:27:29+00:00\",\"description\":\"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg\",\"width\":1200,\"height\":628,\"caption\":\"####-trong-excel-la-loi-gi\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/25972a42c5fe0b5ed1d6cc938986850d\",\"name\":\"Linh Kieu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/54765dbe1f46c0c7c466fdb1cc779f8c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/54765dbe1f46c0c7c466fdb1cc779f8c?s=96&d=mm&r=g\",\"caption\":\"Linh Kieu\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/linh-kieu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn","description":"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c","og_description":"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-19T12:27:29+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg","type":"image\/jpeg"}],"author":"Linh Kieu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Linh Kieu","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"21 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/"},"author":{"name":"Linh Kieu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/25972a42c5fe0b5ed1d6cc938986850d"},"headline":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c","datePublished":"2023-10-19T12:27:29+00:00","dateModified":"2023-10-19T12:27:29+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/"},"wordCount":4810,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/","name":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg","datePublished":"2023-10-19T12:27:29+00:00","dateModified":"2023-10-19T12:27:29+00:00","description":"S\u1eed d\u1ee5ng MS Excel, li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft #### trong Excel l\u00e0 l\u1ed7i g\u00ec? B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c l\u1ed7i #### v\u00e0 8 l\u1ed7i ph\u1ed5 bi\u1ebfn trong b\u1ea3ng t\u00ednh.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/trong-excel-la-loi-gi.jpg","width":1200,"height":628,"caption":"####-trong-excel-la-loi-gi"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-co-ban-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"#### trong Excel l\u00e0 l\u1ed7i g\u00ec? 8 th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i Excel ph\u1ed5 bi\u1ebfn v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/25972a42c5fe0b5ed1d6cc938986850d","name":"Linh Kieu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/54765dbe1f46c0c7c466fdb1cc779f8c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54765dbe1f46c0c7c466fdb1cc779f8c?s=96&d=mm&r=g","caption":"Linh Kieu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/linh-kieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/273556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=273556"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/273556\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/273561"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=273556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=273556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=273556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}