{"id":4430,"date":"2025-11-11T19:59:45","date_gmt":"2025-11-11T12:59:45","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-iserr-de-do-loi-trong-excel-cuc-don-gian\/"},"modified":"2025-11-11T19:59:45","modified_gmt":"2025-11-11T12:59:45","slug":"cach-su-dung-ham-iserr-de-do-loi-trong-excel-cuc-don-gian","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-iserr-de-do-loi-trong-excel-cuc-don-gian\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ISERR \u0111\u1ec3 d\u00f2 l\u1ed7i trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m ISERR trong Excel gi\u00fap b\u1ea1n nh\u1eadn di\u1ec7n nhanh c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong c\u00f4ng th\u1ee9c, ngo\u1ea1i tr\u1eeb l\u1ed7i #N\/A. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi c\u1ea7n ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u ho\u1eb7c x\u1eed l\u00fd b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng ISERR, gi\u1ea3i th\u00edch c\u00fa ph\u00e1p v\u00e0 \u0111\u01b0a ra v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m ISERR \u0111\u1ec3 d\u00f2 l\u1ed7i trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n

\n

1. Gi\u1edbi thi\u1ec7u v\u1ec1 h\u00e0m ISERR trong Excel<\/h2>\n<\/div>\n
\n

1.1. H\u00e0m ISERR l\u00e0 g\u00ec?<\/h3>\n<\/div>\n

ISERR l\u00e0 h\u00e0m Excel d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra xem m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 ph\u00e1t sinh l\u1ed7i hay kh\u00f4ng, tr\u1eeb tr\u01b0\u1eddng h\u1ee3p l\u1ed7i #N\/A.<\/p>\n

N\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u00e9t l\u00e0 m\u1ed9t l\u1ed7i b\u1ea5t k\u1ef3 ngo\u00e0i #N\/A, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 TRUE. Ng\u01b0\u1ee3c l\u1ea1i, khi gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 ho\u1eb7c r\u01a1i v\u00e0o l\u1ed7i #N\/A, k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 FALSE.<\/p>\n

\"Gi\u1edbiNh\u1eadn di\u1ec7n l\u1ed7i b\u1eb1ng h\u00e0m ISERR trong Excel<\/em><\/p>\n

\n

1.2. H\u00e0m ISERR c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n nh\u1eefng l\u1ed7i n\u00e0o?<\/h3>\n<\/div>\n

ISERR c\u00f3 kh\u1ea3 n\u0103ng ph\u00e1t hi\u1ec7n h\u1ea7u h\u1ebft c\u00e1c l\u1ed7i trong Excel, ngo\u1ea1i tr\u1eeb #N\/A. Nh\u1eefng l\u1ed7i m\u00e0 h\u00e0m c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n g\u1ed3m:<\/p>\n

    \n
  • #DIV\/0!: <\/strong>Ph\u00e9p chia cho s\u1ed1 0<\/li>\n
  • #VALUE!: <\/strong>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u00fang ki\u1ec3u<\/li>\n
  • #REF!:<\/strong> Tham chi\u1ebfu \u0111\u1ebfn \u00f4 kh\u00f4ng c\u00f2n t\u1ed3n t\u1ea1i<\/li>\n
  • #NAME?: <\/strong>D\u00f9ng sai t\u00ean h\u00e0m ho\u1eb7c t\u00ean ph\u1ea1m vi<\/li>\n
  • #NUM!: <\/strong>L\u1ed7i li\u00ean quan \u0111\u1ebfn gi\u00e1 tr\u1ecb s\u1ed1<\/li>\n
  • #NULL!: <\/strong>D\u00f9ng to\u00e1n t\u1eed giao gi\u1eefa hai v\u00f9ng nh\u01b0ng kh\u00f4ng h\u1ee3p l\u1ec7<\/li>\n<\/ul>\n

    \"B\u1ea3ngV\u00ed d\u1ee5 c\u00e1c l\u1ed7i Excel \u0111\u01b0\u1ee3c h\u00e0m ISERR x\u00e1c \u0111\u1ecbnh<\/em><\/p>\n

    \n

    1.3. \u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m ISERR<\/h3>\n<\/div>\n
      \n
    • Ki\u1ec3m tra l\u1ed7i trong c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3:<\/strong> ISERR gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n nhanh c\u00e1c l\u1ed7i trong bi\u1ec3u th\u1ee9c ho\u1eb7c c\u00f4ng th\u1ee9c, ngo\u1ea1i tr\u1eeb l\u1ed7i #N\/A, t\u1eeb \u0111\u00f3 d\u1ec5 d\u00e0ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed sai v\u00e0 x\u1eed l\u00fd k\u1ecbp th\u1eddi.<\/li>\n
    • T\u0103ng t\u00ednh chuy\u00ean nghi\u1ec7p khi thao t\u00e1c Excel: <\/strong>Nh\u1edd kh\u1ea3 n\u0103ng ki\u1ec3m tra l\u1ed7i t\u1ef1 \u0111\u1ed9ng, h\u00e0m n\u00e0y gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c g\u1ecdn g\u00e0ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi x\u1eed l\u00fd c\u00e1c c\u00f4ng th\u1ee9c nhi\u1ec1u t\u1ea7ng ho\u1eb7c b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/li>\n
    • D\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c:<\/strong> ISERR th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng chung v\u1edbi c\u00e1c h\u00e0m nh\u01b0 IF, VLOOKUP, INDEX, MATCH\u2026 \u0111\u1ec3 ki\u1ec3m so\u00e1t l\u1ed7i linh ho\u1ea1t, \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c kh\u00f4ng b\u1ecb gi\u00e1n \u0111o\u1ea1n khi d\u1eef li\u1ec7u g\u1eb7p v\u1ea5n \u0111\u1ec1.<\/li>\n<\/ul>\n
      Xem th\u00eam: <\/strong>5 C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/div>\n
      \n

      2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ISERR \u0111\u1ec3 d\u00f2 l\u1ed7i trong Excel<\/h2>\n<\/div>\n
      \n

      2.1. C\u00fa ph\u00e1p h\u00e0m ISERR<\/h3>\n<\/div>\n

      C\u00f4ng th\u1ee9c:<\/strong> =ISERR(value)<\/p>\n

      Trong \u0111\u00f3 value l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n ki\u1ec3m tra. \u0110\u1ed1i s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c, ph\u00e9p to\u00e1n, h\u00e0m Excel ho\u1eb7c m\u1ed9t \u00f4 b\u1ea5t k\u1ef3. \u0110\u00e2y l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c \u0111\u1ec3 ISERR x\u00e1c \u0111\u1ecbnh xem gi\u00e1 tr\u1ecb \u0111\u00f3 c\u00f3 \u0111ang g\u1eb7p l\u1ed7i hay kh\u00f4ng.<\/p>\n

      Ghi ch\u00fa:<\/strong> ISERR thu\u1ed9c nh\u00f3m h\u00e0m IS, chuy\u00ean d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra tr\u1ea1ng th\u00e1i c\u1ee7a d\u1eef li\u1ec7u. H\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi IF \u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c c\u00f4ng th\u1ee9c x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch ch\u1ee7 \u0111\u1ed9ng v\u00e0 an to\u00e0n h\u01a1n.<\/p>\n

      \"V\u00edC\u00fa ph\u00e1p v\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m ISERR<\/em><\/p>\n

      \n

      2.2. V\u00ed d\u1ee5 s\u1eed d\u1ee5ng v\u1ec1 h\u00e0m ISERR<\/h3>\n<\/div>\n

      B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra l\u1ed7i trong Excel b\u1eb1ng ISERR qua hai b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n:<\/p>\n

      B\u01b0\u1edbc 1<\/strong>: M\u1edf file Excel c\u1ea7n x\u1eed l\u00fd v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c: =ISERR(value)<\/p>\n

      H\u00e0m s\u1ebd \u0111\u00e1nh gi\u00e1 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o v\u00e0 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u0111\u00f3 l\u00e0 l\u1ed7i (tr\u1eeb l\u1ed7i #N\/A) v\u00e0 FALSE n\u1ebfu gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 ho\u1eb7c thu\u1ed9c l\u1ed7i #N\/A.<\/p>\n

      B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ki\u1ec3m tra.<\/p>\n

      \"K\u1ebftC\u00e1ch ISERR ki\u1ec3m tra l\u1ed7i trong c\u00f4ng th\u1ee9c<\/em><\/p>\n

      H\u00ecnh minh h\u1ecda cho th\u1ea5y c\u00e1ch ISERR ph\u1ea3n h\u1ed3i v\u1edbi t\u1eebng lo\u1ea1i gi\u00e1 tr\u1ecb:.<\/p>\n

        \n
      • V\u00ed d\u1ee5 1: <\/strong>Chu\u1ed7i v\u0103n b\u1ea3n “Cat and Dog” c\u0169ng l\u00e0 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 n\u00ean k\u1ebft qu\u1ea3 l\u00e0 FALSE.<\/li>\n
      • V\u00ed d\u1ee5 2:<\/strong> Ph\u00e9p t\u00ednh 0\/1 h\u1ee3p l\u1ec7 n\u00ean h\u00e0m tr\u1ea3 v\u1ec1 FALSE.<\/li>\n
      • V\u00ed d\u1ee5 3: <\/strong>Ph\u00e9p t\u00ednh 1\/0 t\u1ea1o ra l\u1ed7i chia cho 0, ISERR s\u1ebd tr\u1ea3 v\u1ec1 TRUE.<\/li>\n<\/ul>\n

        ISERR l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 nh\u1eadn bi\u1ebft v\u00e0 x\u1eed l\u00fd l\u1ed7i trong nh\u1eefng c\u00f4ng th\u1ee9c d\u1ec5 ph\u00e1t sinh sai s\u00f3t. \u00c1p d\u1ee5ng \u0111\u00fang s\u1ebd gi\u00fap b\u1ea3ng t\u00ednh r\u00f5 r\u00e0ng v\u00e0 \u00edt gi\u00e1n \u0111o\u1ea1n h\u01a1n. \u0110\u1ec3 xem th\u00eam nhi\u1ec1u h\u01b0\u1edbng d\u1eabn Excel th\u1ef1c t\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 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.<\/p>\n

        L\u00e0m vi\u1ec7c v\u1edbi Excel s\u1ebd thu\u1eadn ti\u1ec7n h\u01a1n khi b\u1ea1n trang b\u1ecb chu\u1ed9t, b\u00e0n ph\u00edm ho\u1eb7c thi\u1ebft b\u1ecb l\u01b0u tr\u1eef ph\u00f9 h\u1ee3p. B\u1ea1n c\u00f3 th\u1ec3 gh\u00e9 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn nh\u1eefng ph\u1ee5 ki\u1ec7n vi t\u00ednh ch\u1ea5t l\u01b0\u1ee3ng, \u0111\u1ed3ng b\u1ed9 v\u00e0 b\u1ec1n b\u1ec9 cho nhu c\u1ea7u s\u1eed d\u1ee5ng h\u1eb1ng ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        \u00a0 H\u00e0m ISERR trong Excel gi\u00fap b\u1ea1n nh\u1eadn di\u1ec7n nhanh c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong c\u00f4ng th\u1ee9c, ngo\u1ea1i tr\u1eeb l\u1ed7i #N\/A. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch khi c\u1ea7n ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u ho\u1eb7c x\u1eed l\u00fd b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng ISERR, […]<\/p>\n","protected":false},"author":1,"featured_media":4431,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4430","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\/19256.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4430","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=4430"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4430\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4431"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}