{"id":283238,"date":"2023-11-10T22:45:44","date_gmt":"2023-11-10T15:45:44","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=283238"},"modified":"2023-11-10T22:45:44","modified_gmt":"2023-11-10T15:45:44","slug":"loi-div","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/loi-div\/","title":{"rendered":"L\u1ed7i #DIV\/0 nguy\u00ean nh\u00e2n do \u0111\u00e2u v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c"},"content":{"rendered":"

#DIV\/0<\/b> l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Excel. Ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n nh\u1eadp sai ph\u00e9p t\u00ednh, sai h\u00e0m chia cho s\u1ed1 0 s\u1ebd xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o n\u00e0y v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. V\u1eady l\u1ed7i ph\u00e9p t\u00ednh khi chia cho s\u1ed1 0 c\u00f3 c\u00e1ch s\u1eeda nh\u01b0 th\u1ebf n\u00e0o? M\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 bi\u1ebft th\u00f4ng tin chi ti\u1ebft nh\u00e9!\u00a0<\/span><\/p>\n

#DIV\/0 l\u00e0 l\u1ed7i g\u00ec?\u00a0<\/span><\/h2>\n

N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng Excel s\u1ebd kh\u00f4ng \u00edt l\u1ea7n b\u1eaft g\u1eb7p l\u1ed7i<\/span> #DIV\/0<\/b>. L\u1ed7i n\u00e0y x\u1ea3y ra khi b\u1ea1n nh\u1eadp h\u00e0m c\u00f4ng th\u1ee9c chia cho s\u1ed1 0 b\u1ecb sai. Theo nguy\u00ean t\u1eafc trong to\u00e1n h\u1ecdc, ph\u00e9p chia c\u00f3 m\u1eabu s\u1ed1 b\u1eb1ng 0 th\u00ec kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c n\u00ean h\u1ec7 th\u1ed1ng b\u00e1o l\u1ed7i. Ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng m\u1eafc l\u1ed7i ph\u00e9p t\u00ednh khi chia cho 0 \u1edf m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 Mode, Quotient, If,…<\/span><\/p>\n

\"#DIV0-2\"<\/p>\n

L\u1ed7i #DIV\/0 do \u0111\u00e2u v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/span><\/h2>\n

Khi l\u00e0m vi\u1ec7c tr\u00ean b\u1ea3ng t\u00ednh Excel, c\u00f3 hai nguy\u00ean nh\u00e2n d\u1eabn t\u1edbi l\u1ed7i<\/span> #DIV\/0 <\/b>\u0111\u00f3 l\u00e0 do m\u1eabu s\u1ed1 b\u1eb1ng 0 ho\u1eb7c kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb. \u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi kh\u1eafc ph\u1ee5c l\u1ed7i ph\u00e9p t\u00ednh khi chia cho 0, ch\u00fang t\u00f4i s\u1ebd gi\u1ea3i th\u00edch r\u00f5 h\u01a1n trong ph\u1ea7n d\u01b0\u1edbi \u0111\u00e2y:\u00a0<\/span><\/p>\n

L\u1ed7i do m\u1eabu s\u1ed1 b\u1eb1ng 0 ho\u1eb7c kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb\u00a0<\/span><\/h3>\n

\u0110\u00f4i khi ng\u01b0\u1eddi d\u00f9ng Excel qu\u00ean r\u1eb1ng kh\u00f4ng t\u00ednh \u0111\u01b0\u1ee3c ph\u00e9p chia c\u00f3 m\u1eabu s\u1ed1 b\u1eb1ng 0. Ch\u1eb3ng h\u1ea1n nh\u01b0 trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =B3\/C3 t\u1ee9c l\u00e0 100\/0. Nh\u01b0 v\u1eady, \u00f4 k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb<\/span> #DIV\/0 n<\/b>h\u01b0 trong h\u00ecnh.\u00a0<\/span><\/p>\n

\"#DIV0-3\"<\/p>\n

\"#DIV0-4\"<\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ki\u1ec3m tra m\u1eabu s\u1ed1 c\u1ee7a ph\u00e9p chia kh\u00f4ng ch\u1ee9a s\u1ed1 0 l\u00e0 \u0111\u01b0\u1ee3c.\u00a0<\/span><\/p>\n

\"#DIV0-5\"<\/p>\n

S\u1eed d\u1ee5ng IFERROR<\/span><\/h3>\n

H\u00e0m IFERROR c\u00f3 ch\u1ee9c n\u0103ng ng\u0103n ch\u1eb7n c\u00e1c l\u1ed7i xu\u1ea5t hi\u1ec7n khi s\u1eed d\u1ee5ng Excel trong \u0111\u00f3 c\u00f3 <\/span>#DIV\/0<\/b>. Do \u0111\u00f3, \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i ph\u00e9p t\u00ednh khi chia cho s\u1ed1 0, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m IFERROR. C\u00e1c b\u01b0\u1edbc s\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: Th\u1ef1c hi\u1ec7n l\u1ed3ng h\u00e0m IFERROR v\u00e0o c\u00f4ng th\u1ee9c ph\u00e9p chia th\u00f4ng th\u01b0\u1eddng = IFERROR(B3\/C3,0).\u00a0<\/span><\/p>\n

\"#DIV0-6\"<\/p>\n

B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n h\u00e3y b\u1ea5m Enter, t\u1ea1i \u00f4 k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng c\u00f2n l\u1ed7i ph\u00e9p t\u00ednh khi chia cho 0. Thay v\u00e0o \u0111\u00f3, \u00f4 k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb d\u1ea5u – ho\u1eb7c s\u1ed1 0.\u00a0<\/span><\/p>\n

\"#DIV0-7\"<\/p>\n

M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p kh\u00e1c trong Excel\u00a0<\/span><\/h2>\n

Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 \u0111\u1eafc l\u1ef1c \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u, qu\u1ea3n l\u00fd th\u00f4ng tin, d\u1eef li\u1ec7u,… Khi s\u1eed d\u1ee5ng Excel, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ea3m b\u1ea3o nh\u1eadp \u0111\u00fang c\u00f4ng th\u1ee9c, \u0111\u00fang \u00f4 tham chi\u1ebfu, \u0111\u1ea3m b\u1ea3o kh\u00f4ng th\u1eeba hay thi\u1ebfu d\u1ea5u , d\u1ea5u ngo\u1eb7c. B\u00ean c\u1ea1nh l\u1ed7i\u00a0 <\/span>#DIV\/0<\/b>, trong Excel c\u00f2n xu\u1ea5t hi\u1ec7n l\u1ed7i ###, l\u1ed7i #VALUE, l\u1ed7i #N\/A,… V\u1eady nh\u1eefng l\u1ed7i n\u00e0y c\u00f3 nguy\u00ean nh\u00e2n do \u0111\u00e2u v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u01b0 th\u1ebf n\u00e0o?\u00a0<\/span><\/p>\n

L\u1ed7i ### trong Excel\u00a0<\/span><\/h3>\n

L\u1ed7i th\u01b0\u1eddng g\u1eb7p \u0111\u1ea7u ti\u00ean trong Excel ch\u00ednh l\u00e0 l\u1ed7i \u0111\u1ed9 r\u1ed9ng ###. T\u1ee9c l\u00e0 khi \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t trong b\u1ea3ng t\u00ednh kh\u00f4ng \u0111\u1ee7 kho\u1ea3ng tr\u1ed1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb n\u1ed9i dung s\u1ebd d\u1eabn t\u1edbi l\u1ed7i n\u00e0y. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i ###, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m \u0111\u00fap chu\u1ed9t tr\u00e1i v\u00e0o c\u1ea1nh ph\u1ea3i c\u1ee7a ti\u00eau \u0111\u1ec1 sau \u0111\u00f3 k\u00e9o sang ph\u00eda b\u00ean ph\u1ea3i \u0111\u1ec3 m\u1edf r\u1ed9ng.\u00a0<\/span><\/p>\n

\"#DIV0-8\"<\/p>\n

Ho\u1eb7c ng\u01b0\u1eddi d\u00f9ng b\u1ea5m chu\u1ed9t ph\u1ea3i t\u1ea1i c\u1ed9t c\u1ea7n m\u1edf r\u1ed9ng -> m\u1edf h\u1ed9p tho\u1ea1i Format cells -> ch\u1ecdn tab Alignment \u0111\u1ec3 c\u0103n ch\u1ec9nh. T\u1ea1i m\u1ee5c Textcontrol, b\u1ea1n h\u00e3y t\u00edch ch\u1ecdn Shrink to fit.\u00a0<\/span><\/p>\n

\"#DIV0-9\"<\/p>\n

L\u1ed7i #VALUE!\u00a0<\/span><\/h3>\n

Ti\u1ebfp theo, m\u1ed9t trong nh\u1eefng l\u1ed7i kh\u00e1 ph\u1ed5 bi\u1ebfn trong Excel \u0111\u00f3 l\u00e0 #VALUE!. L\u1ed7i n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n khi ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng h\u00e0m d\u1ea1ng s\u1ed1 nh\u01b0ng khi nh\u1eadp l\u1ea1i c\u00f3 kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00fd t\u1ef1, v\u0103n b\u1ea3n. \u0110\u1ec3 s\u1eeda l\u1ed7i #VALUE! tr\u01b0\u1edbc ti\u00ean b\u1ea1n h\u00e3y ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a kho\u1ea3ng tr\u1eafng, k\u00fd hi\u1ec7u, v\u0103n b\u1ea3n kh\u00f4ng. Ti\u1ebfp theo, ti\u1ebfn h\u00e0nh ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng v\u1ec1 d\u1ea1ng s\u1ed1 -> t\u1ea1i thanh c\u00f4ng c\u1ee5 Ribbon -> ch\u1ecdn Number.\u00a0<\/span><\/p>\n

\"#DIV0-10\"<\/p>\n

Sau khi th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, b\u1ea1n \u0111\u00e3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c l\u1ed7i sai s\u1ed1. \u0110\u1ec3 ki\u1ec3m tra trong c\u00f4ng th\u1ee9c c\u00f3 kho\u1ea3ng tr\u1eafng kh\u00f4ng th\u00ec b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u -> nh\u1ea5n t\u1ed5 h\u1ee3p Ctrl + G -> ch\u1ecdn tab Replace. Trong h\u1ed9p tho\u1ea1i Find and Replace, t\u1ea1i m\u1ee5c Find what nh\u1ea5n Space \u0111\u1ec3 t\u1ea1o kho\u1ea3ng tr\u1eafng. Cu\u1ed1i c\u00f9ng, b\u1ea1n th\u1ef1c hi\u1ec7n nh\u1ea5n Replace All \u0111\u1ec3 xo\u00e1 b\u1ecf kho\u1ea3ng tr\u1eafng trong c\u00f4ng th\u1ee9c.\u00a0<\/span><\/p>\n

\"#DIV0-11\"<\/p>\n

L\u1ed7i\u00a0 #NAME?\u00a0<\/span><\/h3>\n

Ngo\u00e0i l\u1ed7i<\/span> #DIV\/0<\/b> trong Excel th\u00ec l\u1ed7i #NAME? c\u0169ng kh\u00e1 ph\u1ed5 bi\u1ebfn, nhi\u1ec1u ng\u01b0\u1eddi t\u1eebng g\u1eb7p ph\u1ea3i. Nguy\u00ean nh\u00e2n c\u1ee7a l\u1ed7i n\u00e0y do h\u1ec7 th\u1ed1ng \u0111ang kh\u00f4ng hi\u1ec3u c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n l\u00e0 g\u00ec. C\u00f3 th\u1ec3 do ng\u01b0\u1eddi d\u00f9ng nh\u1eadp h\u00e0m SUM th\u00e0nh SU hay c\u00f4ng th\u1ee9c COUNTIF b\u1ecb th\u1eeba ch\u1eef.\u00a0<\/span><\/p>\n

\"#DIV0-12\"<\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng nh\u1edb ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c th\u00ec ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t v\u00e0i k\u00fd t\u1ef1 \u0111\u1ea7u. Sau \u0111\u00f3, b\u1ea3ng t\u00ednh Excel s\u1ebd g\u1ee3i \u00fd c\u00f4ng th\u1ee9c \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn l\u1ef1a. B\u00ean c\u1ea1nh \u0111\u00f3, khi nh\u1eadp h\u00e0m c\u00f4ng th\u1ee9c, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng ch\u1eef in th\u01b0\u1eddng b\u1edfi n\u1ebfu c\u00f4ng th\u1ee9c \u0111\u00fang th\u00ec h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 chuy\u1ec3n th\u00e0nh ch\u1eef in hoa.\u00a0<\/span><\/p>\n

\"#DIV0-13\"<\/p>\n

L\u1ed7i #REF!\u00a0<\/span><\/h3>\n

C\u00f3 th\u1ec3 n\u00f3i, #REF! l\u00e0 l\u1ed7i ph\u1ee9c t\u1ea1p nh\u1ea5t trong Excel khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng c\u1ea3m th\u1ea5y n\u1ea3n khi t\u00ecm nguy\u00ean nh\u00e2n. L\u1ed7i #REF! s\u1ebd x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn \u00f4 tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7. Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n xo\u00e1 m\u1ed9t \u00f4, c\u1ed9t ho\u1eb7c h\u00e0ng nh\u01b0ng ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u00e3 t\u1ea1o. Nh\u01b0 v\u1eady, t\u1ea1i \u00f4 \u0111\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n #REF! b\u00e1o l\u1ed7i cho ng\u01b0\u1eddi d\u00f9ng bi\u1ebft t\u1edbi.\u00a0<\/span><\/p>\n

\"#DIV0-14\"<\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #REF!, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd khi thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh. Khi xo\u00e1 b\u1ea5t c\u1ee9 \u00f4, c\u1ed9t hay h\u00e0ng n\u00e0o c\u1ea7n \u0111\u1ea3m b\u1ea3o kh\u00f4ng \u1ea3nh h\u01b0\u1edfng t\u1edbi c\u00f4ng th\u1ee9c \u0111\u00e3 t\u1ea1o. Trong tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng xo\u00e1 d\u1eef li\u1ec7u li\u00ean quan t\u1edbi c\u00f4ng th\u1ee9c th\u00ec h\u00e3y nh\u1ea5n Ctrl + Z \u0111\u1ec3 kh\u00f4i ph\u1ee5c nh\u00e9!\u00a0<\/span><\/p>\n

L\u1ed7i #NULL!<\/span>\u00a0<\/span><\/h3>\n

M\u1ed9t trong nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh Excel b\u00ean c\u1ea1nh l\u1ed7i <\/span>#DIV\/0 <\/b>\u0111\u00f3 l\u00e0 #NULL!. L\u1ed7i d\u1eef li\u1ec7u r\u1ed7ng x\u1ea3y ra khi kh\u00f4ng c\u00f3 ch\u1ec9 \u0111\u1ecbnh k\u1ebft n\u1ed1i d\u1eef li\u1ec7u. Ch\u1eb3ng h\u1ea1n =SUM(A1 A3), trong h\u00e0m n\u00e0y, ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh nh\u1eadp thi\u1ebfu d\u1ea5u \u0111\u1ec3 li\u00ean k\u1ebft gi\u1eefa hai \u00f4 d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n

\"#DIV0-15\"<\/p>\n

V\u00ec v\u1eady, khi s\u1eed d\u1ee5ng b\u1ea5t c\u1ee9 h\u00e0m c\u00f4ng th\u1ee9c n\u00e0o, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn d\u1ea5u ch\u1ec9 \u0111\u1ecbnh k\u1ebft n\u1ed1i. C\u00f3 th\u1ec3 d\u00f9ng d\u1ea5u hai ch\u1ea5m, d\u1ea5u ph\u1ea9y \u0111\u1ec3 t\u00e1ch bi\u1ec7t hai \u00f4 d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n

\"#DIV0-16\"<\/p>\n

L\u1ed7i #N\/A\u00a0<\/span><\/h3>\n

L\u1ed7i #N\/A x\u1ea3y ra khi h\u1ec7 th\u1ed1ng kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp trong c\u00f4ng th\u1ee9c. C\u00f3 th\u1ec3 do b\u1ea1n \u0111\u00e3 v\u00f4 t\u00ecnh xo\u00e1 d\u1eef li\u1ec7u d\u00f9ng trong c\u00f4ng th\u1ee9c nh\u1ea5t l\u00e0 \u1edf h\u00e0m VLOOKUP, h\u00e0m t\u01b0\u01a1ng t\u1ef1.<\/span><\/p>\n

\"#DIV0-17\"<\/p>\n

\u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A, \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n ki\u1ec3m tra d\u1eef li\u1ec7u tham chi\u1ebfu trong c\u00f4ng th\u1ee9c c\u00f3 b\u1ecb xo\u00e1 ho\u1eb7c thi\u1ebfu, sai \u0111\u1ecba ch\u1ec9 kh\u00f4ng. Tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong c\u00f3 trong v\u00f9ng tham chi\u1ebfu th\u00ec s\u1eed d\u1ee5ng IFERROR \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i.\u00a0<\/span><\/p>\n

L\u1ed7i #NUM!\u00a0<\/span><\/h3>\n

Cu\u1ed1i c\u00f9ng, m\u1ed9t l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Excel \u0111\u00f3 l\u00e0 #NUM!. L\u1ed7i n\u00e0y x\u1ea3y ra khi d\u1eef li\u1ec7u trong c\u00f4ng th\u1ee9c d\u1ea1ng s\u1ed1 kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c do gi\u00e1 tr\u1ecb s\u1ed1 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng qu\u00e1 nh\u1ecf ho\u1eb7c qu\u00e1 l\u1edbn. Do \u0111\u00f3, \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i #NUM!, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n ki\u1ec3m tra s\u1ed1 trong c\u00f4ng th\u1ee9c c\u00f3 \u0111\u00fang kh\u00f4ng v\u00e0 n\u1eb1m trong kho\u1ea3ng x\u00e1c \u0111\u1ecbnh t\u1eeb -1^10307 \u0111\u1ebfn 1^10307 kh\u00f4ng?\u00a0<\/span><\/p>\n

\"#DIV0-18\"<\/p>\n

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m chia trong Excel kh\u00f4ng m\u1eafc l\u1ed7i\u00a0<\/span><\/h2>\n

Trong Excel, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c l\u00e0 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. L\u1ed7i ph\u00e9p t\u00ednh chia cho 0 <\/span>#DIV\/0<\/b> do ng\u01b0\u1eddi d\u00f9ng nh\u1ea7m l\u1eabn trong nguy\u00ean t\u1eafc to\u00e1n h\u1ecdc. H\u00e0m chia trong Excel g\u1ed3m hai lo\u1ea1i l\u00e0 chia l\u1ea5y ph\u1ea7n d\u01b0 ho\u1eb7c chia l\u1ea5y ph\u1ea7n nguy\u00ean. \u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng h\u00e0m chia trong Excel d\u1ec5 d\u00e0ng, tr\u00e1nh x\u1ea3y ra l\u1ed7i, ch\u00fang t\u00f4i \u0111\u01b0a ra h\u01b0\u1edbng d\u1eabn nh\u01b0 sau:\u00a0<\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng Mod (chia l\u1ea5y ph\u1ea7n d\u01b0)\u00a0<\/span><\/h3>\n

Tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n l\u1ea5y k\u1ebft qu\u1ea3 s\u1ed1 d\u01b0 th\u00ec s\u1eed d\u1ee5ng h\u00e0m MOD. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m MOD l\u00e0 =MOD(s\u1ed1 b\u1ecb chia; s\u1ed1 chia). L\u01b0u \u00fd, gi\u00e1 tr\u1ecb trong c\u00f4ng th\u1ee9c c\u1ea7n b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 v\u00e0 trong tr\u01b0\u1eddng h\u1ee3p m\u1eabu s\u1ed1 l\u00e0 0 th\u00ec s\u1ebd b\u00e1o l\u1ed7i <\/span>#DIV\/0<\/b>. N\u1ebfu gi\u00e1 tr\u1ecb tham chi\u1ebfu l\u00e0 s\u1ed1 (-1, -2, -3 th\u00ec c\u1ea7n c\u00f3 d\u1ea5u ngo\u1eb7c \u0111\u01a1n (-1), (-2),…). B\u00ean c\u1ea1nh \u0111\u00f3, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m MOD s\u1ebd c\u00f3 d\u1ea5u c\u00f9ng v\u1edbi s\u1ed1 chia trong c\u00f4ng th\u1ee9c.\u00a0<\/span><\/p>\n

\u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch t\u00ednh c\u1ee7a h\u00e0m MOD, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =MOD(A3;B3) t\u1ea1i \u00f4 k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n

\"#DIV0-19\"<\/p>\n

B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n h\u00e3y nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 10 : 3 = 3 d\u01b0 1. B\u1edfi ch\u00fang ta ch\u1ec9 l\u1ea5y gi\u00e1 tr\u1ecb ph\u1ea7n d\u01b0 n\u00ean k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 1. Trong tr\u01b0\u1eddng h\u1ee3p s\u1ed1 d\u01b0 l\u1ebb th\u00ec h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed3ng l\u00e0m tr\u00f2n theo quy t\u1eafc.\u00a0<\/span><\/p>\n

\"#DIV0-20\"<\/p>\n

B\u01b0\u1edbc 3: \u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m MOD cho nh\u1eefng \u00f4 d\u1eef li\u1ec7u ti\u1ebfp theo, b\u1ea1n ch\u1ec9 c\u1ea7n gi\u1eef \u00f4 vu\u00f4ng \u1edf g\u00f3c ph\u1ea3i sau \u0111\u00f3 k\u00e9o xu\u1ed1ng ph\u00eda d\u01b0\u1edbi. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 \u00e1p d\u1ee5ng h\u00e0m MOD \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb s\u1ed1 d\u01b0 ch\u00ednh x\u00e1c, ti\u1ebft ki\u1ec7m th\u1eddi gian. N\u1ebfu tr\u01b0\u1eddng h\u1ee3p l\u1ed7i <\/span>#DIV\/0<\/b> th\u00ec do m\u1eabu s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 vi ph\u1ea1m nguy\u00ean t\u1eafc trong to\u00e1n h\u1ecdc.\u00a0<\/span><\/p>\n

\"#DIV0-21\"<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m QUOTIENT (chia l\u1ea5y ph\u1ea7n nguy\u00ean)\u00a0<\/span><\/h3>\n

Ngo\u00e0i c\u00e1ch chia l\u1ea5y ph\u1ea7n d\u01b0, ng\u01b0\u1eddi d\u00f9ng Excel ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3 ph\u00e9p chia ph\u1ea7n nguy\u00ean. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m QUOTIENT l\u00e0 =QUOTIENT(s\u1ed1 b\u1ecb chia, s\u1ed1 chia). L\u01b0u \u00fd, trong c\u00f4ng th\u1ee9c kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 th\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m QUOTIENT s\u1ebd b\u00e1o l\u1ed7i #VALUE!\u00a0<\/span><\/p>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi d\u1ec5 h\u00ecnh dung h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m QUOTIENT (l\u1ea5y k\u1ebft qu\u1ea3 ph\u1ea7n nguy\u00ean) ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n

B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y nh\u1eadp ch\u00ednh x\u00e1c c\u00fa ph\u00e1p =QUOTIENT(A3;B3).\u00a0<\/span><\/p>\n

\"#DIV0-22\"<\/p>\n

B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 10 : 3 = 3 d\u01b0 1. \u1ede \u0111\u00e2y k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 3 t\u1ee9c l\u00e0 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a k\u1ebft qu\u1ea3. L\u01b0u \u00fd, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y ho\u1eb7c d\u1ea5u ch\u1ea5m ph\u1ea9y \u0111\u1ec3 ng\u0103n c\u00e1ch gi\u1eefa hai gi\u00e1 tr\u1ecb.\u00a0<\/span><\/p>\n

\"#DIV0-23\"<\/p>\n

B\u01b0\u1edbc 3: B\u1ea1n h\u00e3y ch\u1ecdn v\u00e0 gi\u1eef \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c ph\u1ea3i sau \u0111\u00f3 k\u00e9o xu\u1ed1ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c h\u00e0ng ti\u1ebfp theo. Tr\u01b0\u1eddng h\u1ee3p t\u1eed s\u1ed1 v\u00e0 m\u1eabu s\u1ed1 l\u00e0 d\u01b0\u01a1ng th\u00ec k\u1ebft qu\u1ea3 l\u00e0 d\u01b0\u01a1ng; m\u1eabu s\u1ed1 v\u00e0 t\u1eed s\u1ed1 l\u00e0 s\u1ed1 \u00e2m th\u00ec k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 \u00e2m; tr\u01b0\u1eddng h\u1ee3p m\u1eabu s\u1ed1 l\u00e0 0 th\u00ec hi\u1ec3n th\u1ecb l\u1ed7i <\/span>#DIV\/0<\/b>!<\/span><\/p>\n

\"#DIV0-24\"<\/p>\n

T\u1ea1m K\u1ebft\u00a0<\/span><\/h2>\n

B\u00e0i vi\u1ebft tr\u00ean, ch\u00fang t\u00f4i \u0111\u00e3 gi\u1ea3i \u0111\u00e1p l\u1ed7i <\/span>#DIV\/0<\/b> l\u00e0 g\u00ec v\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c. Hy v\u1ecdng nh\u1eefng th\u00f4ng tin tr\u00ean gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c l\u1ed7i ph\u00e9p t\u00ednh khi chia cho 0. B\u00ean c\u1ea1nh \u0111\u00f3, ch\u00fang t\u00f4i \u0111\u00e3 ch\u1ec9 ra m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c chi ti\u1ebft. <\/span><\/p>\n

Khi s\u1eed d\u1ee5ng ph\u00e9p t\u00ednh chia trong Excel, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1eabu s\u1ed1 b\u1eb1ng 0 s\u1ebd vi ph\u1ea1m nguy\u00ean t\u1eafc. \u0110\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p chia l\u1ea5y ph\u1ea7n nguy\u00ean ho\u1eb7c l\u1ea5y ph\u1ea7n d\u01b0, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m Mod c\u00f2n chia l\u1ea5y ph\u1ea7n nguy\u00ean th\u00ec s\u1eed d\u1ee5ng h\u00e0m Quotient. H\u00e3y theo d\u00f5i fanpage<\/span> Ho\u00e0ng H\u00e0 Mobile<\/b> v\u00e0 k\u00eanh Youtube <\/span>Ho\u00e0ng H\u00e0 Channel<\/b> \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u th\u00f4ng tin th\u00fa v\u1ecb nh\u00e9!<\/span><\/p>\n

XEM TH\u00caM:\u00a0<\/strong><\/p>\n