{"id":8532,"date":"2024-12-22T14:48:36","date_gmt":"2024-12-22T14:48:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/phat-hien-va-xu-ly-loi-cong-thuc-trong-excel\/"},"modified":"2024-12-22T14:48:36","modified_gmt":"2024-12-22T14:48:36","slug":"phat-hien-va-xu-ly-loi-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/phat-hien-va-xu-ly-loi-cong-thuc-trong-excel\/","title":{"rendered":"Ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"
\n

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel c\u1ee7a m\u00ecnh, ch\u1eafc ch\u1eafn c\u00e1c b\u1ea1n \u0111\u00e3 g\u1eb7p c\u00e1c l\u1ed7i nh\u01b0 sau:<\/p>\n

\"Ph\u00e1t<\/a>
Ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c trong Excel<\/figcaption><\/figure>\n
    \n
  1. #DIV\/0!<\/strong> \u2013 l\u1ed7i chia cho s\u1ed1 0. VD: =1\/0<\/li>\n
  2. #NAME?<\/strong> \u2013 l\u1ed7i kh\u00f4ng t\u1ed3n t\u1ea1i name range, r\u1ea5t hay g\u1eb7p khi c\u00e1c b\u1ea1n g\u00f5 sai m\u1ed9t c\u00f4ng th\u1ee9c. VD: =SUMM(1,2) thay v\u00ec =SUM(1,2) ch\u1eb3ng h\u1ea1n<\/li>\n
  3. #N\/A<\/strong> \u2013 Th\u01b0\u1eddng x\u1ea3y ra khi c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm<\/li>\n
  4. #REF!<\/strong> \u2013 \u0110\u1ec3 t\u1ea1o ra l\u1ed7i n\u00e0y, b\u1ea1n nh\u1eadp th\u1eed l\u00e0m nh\u01b0 sau: nh\u1eadp v\u00e0o A1=1, B1=2, C1=A1+B1. Sau \u0111\u00f3 xo\u00e1 c\u1ed9t B \u0111i<\/li>\n
  5. #NUM!<\/strong> \u2013 Th\u1eed c\u00f4ng th\u1ee9c sau \u0111\u00e2y trong \u00f4 b\u1ea5t k\u00ec \u0111\u1ec3 t\u1ea1o ra l\u1ed7i n\u00e0y: =SQRT(-2)<\/li>\n
  6. #VALUE!<\/strong> \u2013 Th\u1eed c\u00f4ng th\u1ee9c sau \u0111\u00e2y \u0111\u1ec3 t\u1ea1o ra l\u1ed7i n\u00e0y =3+\u201dhi\u201d<\/li>\n
  7. #NULL!<\/strong> \u2013 C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o ra l\u1ed7i n\u00e0y l\u00e0 =A1:B1 D1:E1 (gi\u1eefa A1:B1 v\u00e0 D1:E1 l\u00e0 1 d\u1ea5u c\u00e1ch)<\/li>\n<\/ol>\n

    B\u00ecnh th\u01b0\u1eddng, khi s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 ph\u00e1t sinh l\u1ed7i, ch\u00fang ta ch\u1ec9 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c chung chung l\u00e0 IFERROR<\/strong> \u0111\u1ed1i v\u1edbi b\u1ea3n Excel t\u1eeb 2007 tr\u1edf l\u00ean v\u00e0 k\u1ebft h\u1ee3p IF(ISERROR)<\/strong> v\u1edbi Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc. C\u00e1ch l\u00e0m n\u00e0y kh\u00f4ng \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u1eafc ch\u1eafn trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p v\u00e0 c\u00f3 th\u1ec3 x\u1ea3y ra sai s\u00f3t. V\u1eady Excel c\u00f2n h\u1ed7 tr\u1ee3 nh\u1eefng c\u00e1ch n\u00e0o \u0111\u1ec3 ki\u1ec3m tra v\u00e0 b\u1eaby l\u1ed7i n\u1eefa?<\/p>\n

    \"Ph\u00e1t<\/a>
    Ph\u00e1t hi\u1ec7n v\u00e0 x\u1eed l\u00fd l\u1ed7i c\u00f4ng th\u1ee9c trong Excel<\/figcaption><\/figure>\n
    \n

    Xem nhanh<\/p>\n