{"id":5295,"date":"2025-11-25T11:07:32","date_gmt":"2025-11-25T04:07:32","guid":{"rendered":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-value-trong-excel-cuc-de-hieu\/"},"modified":"2025-11-25T11:07:32","modified_gmt":"2025-11-25T04:07:32","slug":"nguyen-nhan-va-cach-sua-loi-value-trong-excel-cuc-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-value-trong-excel-cuc-de-hieu\/","title":{"rendered":"Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #Value! trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, l\u1ed7i #VALUE! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i g\u00e2y kh\u00f3 hi\u1ec3u v\u00e0 d\u1ec5 l\u00e0m gi\u00e1n \u0111o\u1ea1n t\u00ednh to\u00e1n nh\u1ea5t. L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng khi\u1ebfn Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd ph\u00e9p t\u00ednh. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y tr\u00ecnh b\u00e0y r\u00f5 t\u1eebng tr\u01b0\u1eddng h\u1ee3p l\u1ed7i v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c ph\u00f9 h\u1ee3p.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i #VALUE! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n

\n

1. L\u1ed7i #VALUE! trong Excel<\/h2>\n<\/div>\n

L\u1ed7i #VALUE! xu\u1ea5t hi\u1ec7n khi Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng. \u0110\u00e2y l\u00e0 d\u1ea1ng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0o kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng, v\u00ed d\u1ee5 nh\u01b0 nh\u1eadp k\u00fd t\u1ef1 Text v\u00e0o v\u1ecb tr\u00ed c\u1ea7n s\u1ed1, tham chi\u1ebfu b\u1ecb sai ho\u1eb7c d\u1eef li\u1ec7u ch\u1ee9a k\u00fd t\u1ef1 \u1ea9n g\u00e2y c\u1ea3n tr\u1edf qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n.<\/p>\n

\n

2. Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i #VALUE! v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/h2>\n<\/div>\n
\n

2.1 L\u1ed7i #VALUE! do \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1eafng \u1ea9n<\/h3>\n<\/div>\n

Khi \u00f4 d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1eafng \u1ea9n d\u00f9 nh\u00ecn gi\u1ed1ng nh\u01b0 \u00f4 tr\u1ed1ng, Excel s\u1ebd kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u00fang gi\u00e1 tr\u1ecb c\u1ea7n x\u1eed l\u00fd. Nh\u1eefng k\u00fd t\u1ef1 \u201cv\u00f4 h\u00ecnh\u201d n\u00e0y khi\u1ebfn c\u00f4ng th\u1ee9c kh\u00f4ng \u0111\u1ecdc \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u v\u00e0 th\u00f4ng b\u00e1o l\u1ed7i #VALUE!.<\/p>\n

C\u00e1ch 1. X\u00f3a kho\u1ea3ng tr\u1eafng b\u1eb1ng Find & Replace<\/strong><\/h4>\n

B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 nghi ng\u1edd ch\u1ee9a kho\u1ea3ng tr\u1eafng \u1ea9n \u2192 B\u00f4i \u0111en v\u00f9ng tham chi\u1ebfu \u2192 Nh\u1ea5n Ctrl + H<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Find and Replace<\/strong>.<\/p>\n

B\u01b0\u1edbc 2: <\/strong>Ti\u1ebfn h\u00e0nh nh\u1eadp m\u1ed9t d\u1ea5u c\u00e1ch v\u00e0o \u00f4 Find what<\/strong>, \u0111\u1ec3 tr\u1ed1ng \u00f4 Replace with<\/strong>, sau \u0111\u00f3 nh\u1ea5n Replace All<\/strong> \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng \u1ea9n trong v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n

C\u00e1ch 2. D\u00f9ng b\u1ed9 l\u1ecdc (Filter) \u0111\u1ec3 ph\u00e1t hi\u1ec7n v\u00e0 l\u00e0m s\u1ea1ch<\/strong><\/h4>\n

B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u \u0111ang ph\u00e1t sinh l\u1ed7i \u2192 V\u00e0o Data<\/strong> \u2192 Ch\u1ecdn Filter<\/strong>.<\/p>\n

\"L\u1ecdcB\u1eadt Filter \u0111\u1ec3 l\u1ecdc c\u00e1c \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1eafng g\u00e2y l\u1ed7i #VALUE!<\/em><\/p>\n

B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean l\u1ecdc t\u1ea1i c\u1ed9t c\u1ea7n ki\u1ec3m tra \u2192 B\u1ecf ch\u1ecdn Blanks<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c \u00f4 \u0111ang ch\u1ee9a k\u00fd t\u1ef1 (bao g\u1ed3m kho\u1ea3ng tr\u1eafng \u1ea9n).<\/p>\n

\"Ch\u1ecdnL\u1ecdc b\u1ecf \u00f4 tr\u1ed1ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 ch\u1ee9a k\u00fd t\u1ef1 g\u00e2y l\u1ed7i #VALUE!<\/em><\/p>\n

B\u01b0\u1edbc 3: <\/strong>Khi \u0111\u00e3 l\u1ecdc xong, b\u1ea1n ti\u1ebfn h\u00e0nh lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng trong nh\u1eefng \u00f4 n\u00e0y r\u1ed3i ch\u1ea1y l\u1ea1i c\u00f4ng th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3.<\/p>\n

\"V\u00edD\u1eef li\u1ec7u sau khi lo\u1ea1i l\u1ed7i hi\u1ec3n th\u1ecb \u0111\u00fang, c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f2n b\u00e1o #VALUE!<\/em><\/p>\n

\n

2.2 L\u1ed7i #VALUE! xu\u1ea5t ph\u00e1t t\u1eeb k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/h3>\n<\/div>\n

L\u1ed7i #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi trong danh s\u00e1ch c\u00f3 \u00f4 ch\u1ee9a ch\u1eef, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ho\u1eb7c n\u1ed9i dung kh\u00f4ng ph\u1ea3i s\u1ed1. Khi c\u00f4ng th\u1ee9c g\u1eb7p nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y, Excel kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 l\u1ed7i.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #VALUE! khi d\u1eef li\u1ec7u ch\u1ee9a v\u0103n b\u1ea3n ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/p>\n

B\u01b0\u1edbc 1: <\/strong>T\u1ea1o th\u00eam m\u1ed9t c\u1ed9t TEST<\/strong> n\u1eb1m c\u1ea1nh c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n v\u00e0 nh\u1eadp h\u00e0m ISTEXT<\/strong> \u0111\u1ec3 ki\u1ec3m tra xem \u00f4 \u0111\u00f3 c\u00f3 ph\u1ea3i d\u1ea1ng v\u0103n b\u1ea3n hay kh\u00f4ng.<\/p>\n

\"Ki\u1ec3mH\u00e0m ISTEXT gi\u00fap nh\u1eadn bi\u1ebft \u00f4 ch\u1ee9a v\u0103n b\u1ea3n g\u00e2y ra l\u1ed7i #VALUE!<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>, sau \u0111\u00f3 k\u00e9o xu\u1ed1ng c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3 ki\u1ec3m tra cho to\u00e0n b\u1ed9 danh s\u00e1ch.<\/p>\n

B\u01b0\u1edbc 3: <\/strong>D\u1ef1a v\u00e0o k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, b\u1ea1n ti\u1ebfn h\u00e0nh r\u00e0 so\u00e1t nh\u1eefng \u00f4 hi\u1ec3n th\u1ecb TRUE<\/strong>, ch\u1ec9nh s\u1eeda ho\u1eb7c x\u00f3a k\u00fd t\u1ef1 kh\u00f4ng h\u1ee3p l\u1ec7. Sau khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u00e0m s\u1ea1ch, c\u00f4ng th\u1ee9c s\u1ebd ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng.<\/p>\n

\"K\u1ebftK\u1ebft qu\u1ea3 TRUE th\u1ec3 hi\u1ec7n \u00f4 ch\u1ee9a k\u00fd t\u1ef1, c\u1ea7n x\u1eed l\u00fd \u0111\u1ec3 tr\u00e1nh l\u1ed7i<\/em><\/p>\n

\n

2.3 L\u1ed7i #VALUE! khi d\u00f9ng to\u00e1n t\u1eed<\/h3>\n<\/div>\n

Khi th\u1ef1c hi\u1ec7n ph\u00e9p c\u1ed9ng ho\u1eb7c nh\u00e2n b\u1eb1ng d\u1ea5u +<\/strong> ho\u1eb7c *<\/strong> tr\u00ean m\u1ed9t danh s\u00e1ch c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 l\u1ea1, v\u0103n b\u1ea3n ho\u1eb7c kho\u1ea3ng tr\u1eafng \u1ea9n, Excel s\u1ebd kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00e0 l\u1eadp t\u1ee9c tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!. \u0110i\u1ec1u n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi b\u1ea1n c\u1ed9ng t\u1eebng \u00f4 theo c\u00e1ch th\u1ee7 c\u00f4ng, khi\u1ebfn ch\u1ec9 m\u1ed9t \u00f4 sai \u0111\u1ecbnh d\u1ea1ng c\u0169ng l\u00e0m to\u00e0n b\u1ed9 ph\u00e9p t\u00ednh b\u00e1o l\u1ed7i.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong>: \u0110\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y, b\u1ea1n n\u00ean d\u00f9ng h\u00e0m SUM<\/strong> thay v\u00ec nh\u1eadp to\u00e1n t\u1eed c\u1ed9ng ho\u1eb7c nh\u00e2n t\u1eebng \u00f4. H\u00e0m SUM c\u00f3 kh\u1ea3 n\u0103ng b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 t\u00ednh nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1.<\/p>\n

\"s\u1eedD\u00f9ng h\u00e0m SUM cho d\u1eef li\u1ec7u c\u00f3 k\u00fd t\u1ef1 nh\u1eb1m tr\u00e1nh l\u1ed7i #VALUE!<\/em><\/p>\n

Xem th\u00eam: <\/strong>7 C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/div>\n
\n

3. L\u1ed7i #VALUE! trong m\u1ed9t s\u1ed1 h\u00e0m Excel c\u1ee5 th\u1ec3<\/h2>\n<\/div>\n
\n

3.1 Nh\u1eefng h\u00e0m d\u1ec5 m\u1eafc ph\u1ea3i l\u1ed7i #VALUE! trong Excel<\/h3>\n<\/div>\n

C\u00e1c h\u00e0m trong Excel nh\u01b0 AVERAGE, SUM, TRANSPOSE, VLOOKUP, SUMPRODUCT, FIND, v\u00e0 SEARCH d\u1ec5 g\u1eb7p ph\u1ea3i l\u1ed7i #VALUE! khi d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o kh\u00f4ng \u0111\u00fang ki\u1ec3u, ch\u1eb3ng h\u1ea1n nh\u01b0 khi tham s\u1ed1 l\u00e0 v\u0103n b\u1ea3n thay v\u00ec s\u1ed1 ho\u1eb7c khi c\u00e1c m\u1ea3ng c\u00f3 k\u00edch th\u01b0\u1edbc kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t.<\/p>\n

\n

3.2 L\u1ed7i #VALUE! v\u1edbi h\u00e0m SUM, AVERAGE k\u1ebft h\u1ee3p h\u00e0m IF, ISERROR, IFERROR<\/h3>\n<\/div>\n

L\u1ed7i #VALUE! c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh t\u1ed5ng ho\u1eb7c t\u00ednh trung b\u00ecnh tr\u00ean m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb l\u1ed7i. Ch\u1ec9 c\u1ea7n m\u1ed9t \u00f4 trong ph\u1ea1m vi t\u00ednh to\u00e1n tr\u1ea3 v\u1ec1 l\u1ed7i, to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c SUM ho\u1eb7c AVERAGE s\u1ebd kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00e0 d\u1eabn \u0111\u1ebfn l\u1ed7i #VALUE!.<\/p>\n

\u0110\u1ec3 x\u1eed l\u00fd, b\u1ea1n c\u1ea7n y\u00eau c\u1ea7u Excel b\u1ecf qua nh\u1eefng \u00f4 ch\u1ee9a l\u1ed7i v\u00e0 ch\u1ec9 t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7. C\u00e1ch th\u1ef1c hi\u1ec7n l\u00e0 k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi ISERROR, ho\u1eb7c d\u00f9ng IFERROR trong nh\u1eefng phi\u00ean b\u1ea3n Excel h\u1ed7 tr\u1ee3.<\/p>\n

V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

=AVERAGE(IF(ISERROR(B2:D2),””,B2:D2))<\/p>\n

C\u00f4ng th\u1ee9c n\u00e0y gi\u00fap l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 trong v\u00f9ng B2:D2, b\u1ecf qua nh\u1eefng \u00f4 l\u1ed7i tr\u01b0\u1edbc khi t\u00ednh trung b\u00ecnh.<\/p>\n

L\u01b0u \u00fd: <\/strong>C\u00e1ch k\u1ebft h\u1ee3p n\u00e0y \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho Excel 2007 tr\u1edf l\u00ean.<\/p>\n

\"C\u00f4ngAVERAGE k\u1ebft h\u1ee3p ISERROR gi\u00fap b\u1ecf qua \u00f4 l\u1ed7i tr\u01b0\u1edbc khi t\u00ednh trung b\u00ecnh<\/em><\/p>\n

\n

3.3 L\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng SUMIF, SUMIFS, COUNTIF, COUNTIFS<\/h3>\n<\/div>\n

Khi c\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n nh\u01b0 SUMIF, SUMIFS, COUNTIF, COUNTIFS l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t file Excel kh\u00e1c, l\u1ed7i #VALUE! s\u1ebd xu\u1ea5t hi\u1ec7n n\u1ebfu file ch\u1ee9a d\u1eef li\u1ec7u b\u1ecb \u0111\u00f3ng. Trong tr\u01b0\u1eddng h\u1ee3p c\u1ea3 file ngu\u1ed3n v\u00e0 file t\u00ednh to\u00e1n c\u00f9ng m\u1edf, Excel c\u00f3 th\u1ec3 truy c\u1eadp \u0111\u1ea7y \u0111\u1ee7 n\u00ean c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng. Nh\u01b0ng ch\u1ec9 c\u1ea7n \u0111\u00f3ng file d\u1eef li\u1ec7u, m\u1ecdi c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn file \u0111\u00f3 s\u1ebd \u0111\u1ed3ng lo\u1ea1t b\u00e1o l\u1ed7i.<\/p>\n

C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong>: M\u1edf \u0111\u1ed3ng th\u1eddi c\u1ea3 hai file, sau \u0111\u00f3 nh\u1ea5n F9 \u0111\u1ec3 Excel c\u1eadp nh\u1eadt l\u1ea1i to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u00e0 lo\u1ea1i b\u1ecf l\u1ed7i #VALUE!.<\/p>\n

\"SUMIFSSUMIFS c\u1ea7n d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t, sai \u0111\u1ecbnh d\u1ea1ng d\u1ec5 g\u00e2y l\u1ed7i #VALUE!<\/em><\/p>\n

\n

3.4 L\u1ed7i #VALUE! khi d\u00f9ng h\u00e0m IF, ISERROR ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c format c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

L\u1ed7i #VALUE! c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c IF ho\u1eb7c ISERROR \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng ch\u01b0a \u0111\u1ea7y \u0111\u1ee7, thi\u1ebfu \u0111\u1ed1i s\u1ed1 ho\u1eb7c c\u00f3 kho\u1ea3ng tr\u1ed1ng trong ph\u00e9p t\u00ednh. \u0110\u1ec3 x\u1eed l\u00fd t\u00ecnh hu\u1ed1ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng hai c\u00e1ch hi\u1ec7u qu\u1ea3 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

C\u00e1ch 1: D\u00f9ng IF k\u1ebft h\u1ee3p ISERROR ho\u1eb7c IFERROR \u0111\u1ec3 lo\u1ea1i b\u1ecf l\u1ed7i<\/strong><\/h4>\n

N\u1ebfu trong c\u1ed9t d\u1eef li\u1ec7u c\u00f3 \u00f4 b\u1ecb l\u1ed7i, ch\u1eb3ng h\u1ea1n nh\u01b0 c\u1ed9t s\u1ed1 l\u01b0\u1ee3ng ch\u1ee9a k\u00fd t\u1ef1 thay v\u00ec s\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 y\u00eau c\u1ea7u Excel tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0 \u0111\u1ec3 tr\u00e1nh b\u00e1o c\u00e1o b\u1ecb r\u1ed1i.<\/p>\n

V\u00ed d\u1ee5: <\/strong>C\u00e1c m\u1eb7t h\u00e0ng \u0111\u1ec1u c\u00f3 \u0111\u01a1n gi\u00e1 200. Khi \u0111\u00f3, c\u00f4ng th\u1ee9c t\u00ednh doanh thu c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0:<\/p>\n

=IF(ISERROR(B2),0,B2*200) ho\u1eb7c s\u1eed d\u1ee5ng c\u00fa ph\u00e1p g\u1ecdn h\u01a1n: =IFERROR(B2*200,0)<\/p>\n

\"D\u00f9ngC\u00f4ng th\u1ee9c IF(ISERROR) gi\u00fap thay gi\u00e1 tr\u1ecb l\u1ed7i b\u1eb1ng n\u1ed9i dung mong mu\u1ed1n<\/em><\/p>\n

C\u00e1ch 2: D\u00f9ng Conditional Formatting \u0111\u1ec3 \u1ea9n l\u1ed7i tr\u00ean b\u1ea3ng t\u00ednh<\/strong><\/h4>\n

B\u1ea1n v\u1eabn c\u00f3 th\u1ec3 gi\u1eef c\u00f4ng th\u1ee9c t\u00ednh doanh thu \u1edf d\u1ea1ng chu\u1ea9n: Doanh thu = S\u1ed1 l\u01b0\u1ee3ng * \u0110\u01a1n gi\u00e1<\/p>\n

Sau \u0111\u00f3, \u00e1p d\u1ee5ng Conditional Formatting<\/strong> \u0111\u1ec3 \u1ea9n nh\u1eefng \u00f4 l\u1ed7i:<\/p>\n

    \n
  • B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u1ea9n l\u1ed7i \u2192 Ch\u1ecdn Conditional Formatting<\/strong> \u2192 New Rule<\/strong>.<\/li>\n
  • B\u01b0\u1edbc 2: <\/strong>T\u1ea1i ph\u1ea7n Use a formula to determine which cells to format<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c ki\u1ec3m tra l\u1ed7i: =ISERROR(B2)<\/li>\n
  • B\u01b0\u1edbc 3:<\/strong> Trong ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng, ch\u1ecdn m\u00e0u ch\u1eef tr\u1eafng ho\u1eb7c m\u00e0u tr\u00f9ng v\u1edbi n\u1ec1n \u0111\u1ec3 l\u00e0m l\u1ed7i \u201cbi\u1ebfn m\u1ea5t\u201d tr\u00ean giao di\u1ec7n b\u1ea3ng t\u00ednh.<\/li>\n<\/ul>\n

    S\u1eeda l\u1ed7i #VALUE! kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea3ng t\u00ednh ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o c\u00e1c k\u1ebft qu\u1ea3 ph\u00e2n t\u00edch lu\u00f4n \u0111\u00e1ng tin c\u1eady. Khi n\u1eafm r\u00f5 c\u00e1ch x\u1eed l\u00fd t\u1eebng t\u00ecnh hu\u1ed1ng, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng gi\u1eef cho file Excel g\u1ecdn g\u00e0ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n trong su\u1ed1t qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng.<\/p>\n

    \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u h\u01b0\u1edbng d\u1eabn h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n

    N\u1ebfu b\u1ea1n \u0111ang t\u00ecm m\u1ed9t thi\u1ebft b\u1ecb ti\u1ec7n l\u1ee3i \u0111\u1ec3 h\u1ecdc v\u00e0 thao t\u00e1c Excel m\u1ecdi l\u00fac m\u1ecdi n\u01a1i, h\u00e3y tham kh\u1ea3o c\u00e1c d\u00f2ng \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng \u0111ang \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \u00a0 Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, l\u1ed7i #VALUE! l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i g\u00e2y kh\u00f3 hi\u1ec3u v\u00e0 d\u1ec5 l\u00e0m gi\u00e1n \u0111o\u1ea1n t\u00ednh to\u00e1n nh\u1ea5t. L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng khi\u1ebfn Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd ph\u00e9p t\u00ednh. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y tr\u00ecnh b\u00e0y r\u00f5 […]<\/p>\n","protected":false},"author":1,"featured_media":5296,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19454.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5295"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5295\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5296"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}