{"id":36589,"date":"2022-08-09T13:11:19","date_gmt":"2022-08-09T06:11:19","guid":{"rendered":"https:\/\/jobsgo.vn\/blog\/?p=36589"},"modified":"2025-01-10T15:14:00","modified_gmt":"2025-01-10T08:14:00","slug":"cach-sua-loi-value-trong-excel","status":"publish","type":"post","link":"https:\/\/jobsgo.vn\/blog\/cach-sua-loi-value-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eefa l\u1ed7i #value trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 c\u1ef1c nhanh ch\u00f3ng"},"content":{"rendered":"\n
L\u1ed7i value trong excel<\/i><\/strong><\/a> l\u00e0 v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng xuy\u00ean g\u1eb7p khi b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n. \u0110i\u1ec1u n\u00e0y khi\u1ebfn cho b\u1ea1n m\u1ea5t th\u1eddi gian, c\u00f4ng s\u1ee9c \u0111\u1ec3 d\u1eebng l\u1ea1i x\u1eed l\u00fd, \u0111\u00f4i khi c\u00f2n l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c. \u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n c\u0169ng nh\u01b0 c\u00e1ch kh\u1eafc ph\u1ee5c <\/i>l\u1ed7i #value trong excel<\/i><\/strong> th\u00ec b\u1ea1n h\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft sau c\u1ee7a JobsGO.<\/i><\/p>\n M\u1ee5c l\u1ee5c<\/p> L\u1ed7i value \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 l\u1ed7i hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 sai trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n tr\u00ean m\u00e1y t\u00ednh. Tr\u00ean th\u1ef1c t\u1ebf, l\u1ed7i #value trong excel<\/strong> x\u1ea3y ra do nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. Th\u1ebf nh\u01b0ng ph\u1ea7n l\u1edbn l\u00e0 v\u00ec ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai c\u00f4ng th\u1ee9c ho\u1eb7c \u00f4 tham chi\u1ebfu \u0111ang c\u00f3 v\u1ea5n \u0111\u1ec1.<\/p><\/blockquote>\n Nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn s\u1ef1 c\u1ed1<\/strong> n\u00e0y l\u00e0 do v\u00f9ng t\u00ednh t\u1ed5ng ho\u1eb7c trung b\u00ecnh c\u00f3 l\u1ed7i value trong excel<\/strong>.<\/p>\n C\u00e1ch x\u1eed l\u00fd nh\u01b0 sau<\/strong>: B\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p gi\u1eefa hai h\u00e0m l\u00e0 \u201cif\u201d v\u00e0 \u201ciserror\u201d ho\u1eb7c \u201ciferror\u201d.<\/p>\n V\u00ed d\u1ee5: ={AVERAGE(IF(ISERROR(B2:D2,\u201d\u201d,B2:D2))}<\/p>\n Tuy nhi\u00ean, trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c b\u1ea1n ph\u1ea3i ch\u00fa \u00fd n\u00f3 ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c cho excel 2007 tr\u1edf l\u00ean th\u00f4i nh\u00e9.<\/p>\n Nguy\u00ean nh\u00e2n x\u1ea3y ra s\u1ef1 c\u1ed1<\/strong>: \u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi t\u00ednh h\u00e0m t\u1ed5ng, h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean c\u00f9ng file kh\u00e1c. N\u1ebfu c\u1ea3 file t\u00ednh v\u00e0 file ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ec1u m\u1edf \u0111\u01b0\u1ee3c th\u00ec l\u1ed7i value trong excel<\/strong> kh\u00f4ng xu\u1ea5t hi\u1ec7n.<\/p>\n Th\u1ebf nh\u01b0ng khi b\u1ea1n t\u1eaft file \u0111i v\u00e0 ch\u1ec9 m\u1edf m\u1ed9t file t\u00ednh th\u00ec l\u1ed7i #value ngay l\u1eadp t\u1ee9c xu\u1ea5t hi\u1ec7n \u1edf c\u00e1c \u00f4 li\u00ean quan \u0111\u1ebfn h\u00e0m SUMIF, SUMIFS, COUNTIF, COUNTIFS.<\/p>\n1. L\u1ed7i #value trong excel l\u00e0 g\u00ec?<\/strong><\/span><\/h2>\n
L\u1ed7i value trong excel l\u00e0 g\u00ec?<\/em><\/center><\/figcaption><\/figure>\n2. M\u1ed9t s\u1ed1 h\u00e0m d\u1ec5 m\u1eafc l\u1ed7i #value<\/strong><\/span><\/h2>\n
2.1 K\u1ebft h\u1ee3p h\u00e0m SUM, AVERAGE v\u1edbi h\u00e0m d\u1eef li\u1ec7u ISERROR, IF ho\u1eb7c IFERROR<\/strong><\/span><\/h3>\n
<\/p>\n
2.2 H\u00e0m SUMIF, SUMIFS, COUNTIF, COUNTIFS<\/strong><\/span><\/h3>\n