{"id":15721,"date":"2022-06-08T11:08:40","date_gmt":"2022-06-08T04:08:40","guid":{"rendered":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=15721"},"modified":"2026-01-03T16:47:31","modified_gmt":"2026-01-03T09:47:31","slug":"mot-so-canh-bao-loi-pho-bien-trong-o-tinh-vd-div-0-name-va-cach-xu-ly","status":"publish","type":"ht_kb","link":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/mot-so-canh-bao-loi-pho-bien-trong-o-tinh-vd-div-0-name-va-cach-xu-ly\/","title":{"rendered":"M\u1ed9t s\u1ed1 c\u1ea3nh b\u00e1o l\u1ed7i ph\u1ed5 bi\u1ebfn trong \u00f4 t\u00ednh (VD: #DIV\/0!, #NAME?) v\u00e0 c\u00e1ch x\u1eed l\u00fd"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd c\u00e1c l\u1ed7i t\u00ednh to\u00e1n th\u01b0\u1eddng g\u1eb7p tr\u00ean b\u1ea3ng t\u00ednh l\u01b0\u01a1ng trong ph\u1ea7n m\u1ec1m.<br \/>\n<b>N\u1ed9i dung:<\/b><br \/>\n&#8211; L\u1ed7i #DIV\/0!<br \/>\n&#8211; L\u1ed7i #NAME?<br \/>\n&#8211; L\u1ed7i #VALUE!<br \/>\n&#8211; C\u00e1ch \u1ea9n l\u1ed7i b\u1eb1ng gi\u00e1 tr\u1ecb 0<br \/>\n<b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> Nh\u00e2n s\u1ef1, k\u1ebf to\u00e1n, Qu\u1ea3n l\u00fd s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m t\u00ednh l\u01b0\u01a1ng.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-15724 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/06\/Loi-DIV.png\" alt=\"\" width=\"1285\" height=\"595\" \/><\/p>\n<p style=\"text-align: center;\">H\u00ecnh \u1ea3nh minh h\u1ecda<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. H\u01b0\u1edbng d\u1eabn chi ti\u1ebft<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<table>\n<tbody>\n<tr>\n<td><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><b>2.1 L\u1ed7i #DIV\/0!<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<strong>Bi\u1ec3u hi\u1ec7n:<\/strong> Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb l\u1ed7i #DIV\/0! khi s\u1ed1 chia b\u1eb1ng kh\u00f4ng (0).<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> \u0110i\u1ec1u n\u00e0y x\u1ea3y ra khi nh\u1eadp c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n gi\u1ed1ng nh\u01b0 =5\/0 ho\u1eb7c khi c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 b\u1eb1ng 0 nh\u01b0 LUONG_NGAY_CONG = TONG_CONG_HUONG_LUONG*LUONG_CO_BAN\/SO_CONG_CHUAN, trong \u0111\u00f3 SO_CONG_CHUAN l\u1ea1i b\u1eb1ng 0.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/06\/Loi-DIV0.png\" alt=\"\" width=\"467\" height=\"112\" \/><br \/>\n<strong>C\u00e1ch x\u1eed l\u00fd:<\/strong><\/p>\n<p>B\u01b0\u1edbc 1: Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng g\u1eb7p l\u1ed7i \u0111\u1ec3 bi\u1ebft s\u1ed1 chia b\u1eb1ng 0 trong c\u00f4ng th\u1ee9c \u0111ang l\u00e0 th\u00e0nh ph\u1ea7n n\u00e0o<br \/>\nB\u01b0\u1edbc 2: T\u00ecm ki\u1ebfm ti\u1ebfp th\u00e0nh ph\u1ea7n \u0111\u00f3 tr\u00ean b\u1ea3ng t\u00ednh \u0111\u1ec3 s\u1eeda l\u1ea1i th\u00e0nh gi\u00e1 tr\u1ecb kh\u00e1c 0 ho\u1eb7c n\u1ebfu th\u00e0nh ph\u1ea7n n\u00e0y \u0111\u01b0\u1ee3c tham chi\u1ebfu t\u1eeb m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u kh\u00e1c (nh\u01b0 B\u1ea3ng ch\u1ea5m c\u00f4ng, B\u1ea3ng doanh s\u1ed1,&#8230;) th\u00ec truy c\u1eadp v\u00e0o \u0111\u00fang b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c \u0111\u1ec3 s\u1eeda gi\u00e1 tr\u1ecb r\u1ed3i c\u1eadp nh\u1eadt l\u1ea1i b\u1ea3ng l\u01b0\u01a1ng.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><b>2.2 L\u1ed7i #NAME?<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<strong>Bi\u1ec3u hi\u1ec7n:<\/strong> Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb l\u1ed7i #NAME?<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p sau:<br \/>\n&#8211; C\u00f4ng th\u1ee9c ch\u1ee9a l\u1ed7i \u0111\u00e1nh m\u00e1y khi\u1ebfn cho c\u00fa ph\u00e1p c\u1ee7a c\u00f4ng th\u1ee9c kh\u00f4ng ch\u00ednh x\u00e1c<br \/>\n&#8211; C\u00f4ng th\u1ee9c thi\u1ebfu d\u1ea5u ngo\u1eb7c k\u00e9p cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n: khi c\u00f3 tham chi\u1ebfu v\u0103n b\u1ea3n trong c\u00f4ng th\u1ee9c th\u00ec c\u1ea7n nh\u1eadp v\u0103n b\u1ea3n trong d\u1ea5u ngo\u1eb7c k\u00e9p, ngay c\u1ea3 khi ch\u1ec9 s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch. VD: IF(TY_LE_HOAN_THANH_DOANH_SO &lt; 100, &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;,&#8221;\u0110\u1ea1t&#8221;)<br \/>\n<img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/06\/Loi-NAME.png\" alt=\"\" width=\"567\" height=\"113\" \/><\/p>\n<p><strong>C\u00e1ch x\u1eed l\u00fd:<\/strong><\/p>\n<p>B\u01b0\u1edbc 1: Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng g\u1eb7p l\u1ed7i \u0111\u1ec3 bi\u1ebft n\u00f3 \u0111ang tham chi\u1ebfu \u0111\u1ebfn nh\u1eefng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng n\u00e0o kh\u00e1c v\u00e0 \u0111ang s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n, h\u00e0m n\u00e0o<br \/>\nB\u01b0\u1edbc 2: Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh xem c\u00f3 g\u1eb7p l\u1ed7i c\u00fa ph\u00e1p \u1edf \u0111\u00e2u kh\u00f4ng<br \/>\nB\u01b0\u1edbc 3: V\u00e0o Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u1ec3 s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c cho ch\u00ednh x\u00e1c; ho\u1eb7c n\u1ebfu g\u1eb7p l\u1ed7i tr\u00ean b\u1ea3ng l\u01b0\u01a1ng th\u00ec c\u1ea7n v\u00e0o c\u1ea3 M\u1eabu b\u1ea3ng l\u01b0\u01a1ng v\u00e0 L\u1ecbch s\u1eed l\u01b0\u01a1ng c\u1ee7a nh\u00e2n vi\u00ean \u0111\u1ec3 s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><b>2.3 L\u1ed7i #VALUE!<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<strong>Bi\u1ec3u hi\u1ec7n:<\/strong> Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb l\u1ed7i #VALUE!<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong>L\u1ed7i n\u00e0y ch\u1ee7 y\u1ebfu l\u00e0 trong tr\u01b0\u1eddng h\u1ee3p nh\u1eadp gi\u00e1 tr\u1ecb kh\u00f4ng c\u00f9ng ki\u1ec3u d\u1eef li\u1ec7u (VD: H\u00e0m s\u1eed d\u1ee5ng s\u1ed1 nh\u01b0ng l\u1ea1i nh\u1eadp chu\u1ed7i v\u0103n b\u1ea3n). L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i l\u1ea1i t\u00ednh ch\u1ea5t, ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng sau khi \u0111\u00e3 c\u00f3 ph\u00e1t sinh tr\u00ean b\u1ea3ng t\u00ednh.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/06\/Loi-VALUE.png\" alt=\"\" width=\"498\" height=\"113\" \/><\/p>\n<p><strong>C\u00e1ch x\u1eed l\u00fd:<\/strong><\/p>\n<p>B\u01b0\u1edbc 1: Ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c t\u00ednh c\u1ee7a th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng g\u1eb7p l\u1ed7i \u0111\u1ec3 bi\u1ebft n\u00f3 \u0111ang tham chi\u1ebfu \u0111\u1ebfn nh\u1eefng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng n\u00e0o kh\u00e1c v\u00e0 \u0111ang s\u1eed d\u1ee5ng ph\u00e9p to\u00e1n, h\u00e0m n\u00e0o<br \/>\nB\u01b0\u1edbc 2: Ki\u1ec3m tra l\u1ea1i t\u1eebng th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng tham chi\u1ebfu \u0111\u1ec3 xem ki\u1ec3u d\u1eef li\u1ec7u \u0111\u00e3 ch\u00ednh x\u00e1c hay ch\u01b0a<br \/>\nB\u01b0\u1edbc 3: N\u1ebfu sai ki\u1ec3u d\u1eef li\u1ec7u th\u00ec v\u00e0o th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng \u0111\u00f3 \u0111\u1ec3 s\u1eeda l\u1ea1i cho ch\u00ednh x\u00e1c v\u00e0 quay l\u1ea1i b\u1ea3ng t\u00ednh \u0111\u1ec3 c\u1eadp nh\u1eadt<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><b>2.4 \u1ea8n l\u1ed7i b\u1eb1ng c\u00e1ch c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb v\u1ec1 0<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\nNgo\u00e0i ra, trong tr\u01b0\u1eddng h\u1ee3p \u00f4 t\u00ednh g\u1eb7p l\u1ed7i nh\u01b0ng anh\/ch\u1ecb kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb m\u00e3 l\u1ed7i t\u1ea1i \u00f4 \u0111\u00f3 th\u00ec c\u00f3 th\u1ec3 ch\u1ecdn ch\u1ee9c n\u0103ng &#8220;<strong>C\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb v\u1ec1 0<\/strong>&#8221; \u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb tr\u00ean \u00f4 t\u00ednh b\u1ecb l\u1ed7i n\u00e0y th\u00e0nh 0.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2022\/06\/Cap-nhat-gia-tri-loi-ve-0.png\" alt=\"\" width=\"605\" height=\"295\" \/><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":109,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[151],"ht-kb-tag":[],"class_list":["post-15721","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap"],"_links":{"self":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/109"}],"replies":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=15721"}],"version-history":[{"count":4,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15721\/revisions"}],"predecessor-version":[{"id":18847,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/15721\/revisions\/18847"}],"wp:attachment":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=15721"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=15721"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=15721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}