{"id":29921,"date":"2025-05-06T09:21:59","date_gmt":"2025-05-06T02:21:59","guid":{"rendered":"https:\/\/qltshelp.misa.vn\/?post_type=ht_kb&#038;p=29921"},"modified":"2026-04-18T14:13:18","modified_gmt":"2026-04-18T07:13:18","slug":"khi-xuat-tep-ms-excel-bao-cao-cac-o-co-gia-tri-bang-0-duoc-hien-thi-de-nguoi-dung-de-dang-tinh-toan-va-so-sanh-so-lieu","status":"publish","type":"ht_kb","link":"\/tai-san\/knowledge-base\/khi-xuat-tep-ms-excel-bao-cao-cac-o-co-gia-tri-bang-0-duoc-hien-thi-de-nguoi-dung-de-dang-tinh-toan-va-so-sanh-so-lieu\/","title":{"rendered":"Khi xu\u1ea5t t\u1ec7p MS Excel b\u00e1o c\u00e1o, c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng t\u00ednh to\u00e1n v\u00e0 so s\u00e1nh s\u1ed1 li\u1ec7u"},"content":{"rendered":"<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p>B\u00e0i vi\u1ebft n\u00e0y gi\u00fap anh\/ch\u1ecb hi\u1ec3u v\u1ec1 t\u00ednh n\u0103ng xu\u1ea5t t\u1ec7p Excel (d\u1ea1ng d\u1eef li\u1ec7u) tr\u00ean IHOS T\u00e0i s\u1ea3n, trong \u0111\u00f3 c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 0, h\u1ed7 tr\u1ee3 thu\u1eadn ti\u1ec7n cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u t\u00e0i s\u1ea3n.<\/p>\n<h3><strong>2. Chi ti\u1ebft thay \u0111\u1ed5i<\/strong><\/h3>\n<p>Khi anh\/ch\u1ecb c\u1ea7n \u0111\u1ed1i chi\u1ebfu, tra so\u00e1t th\u00f4ng tin t\u00e0i s\u1ea3n s\u1ebd d\u00f9ng t\u00ednh n\u0103ng xu\u1ea5t t\u1ec7p Excel (d\u1ea1ng d\u1eef li\u1ec7u), sau \u0111\u00f3 s\u1ebd d\u00f9ng c\u00f4ng th\u1ee9c c\u1ed9ng tr\u1eeb \u0111\u1ec3 t\u00ednh v\u00e0 \u0111\u1ed1i chi\u1ebfu.<\/p>\n<p><strong>\u2013 Tr\u01b0\u1edbc phi\u00ean b\u1ea3n R56:<\/strong><\/p>\n<p>Ph\u1ea7n m\u1ec1m cho ph\u00e9p xu\u1ea5t d\u1ea1ng d\u1eef li\u1ec7u \u0111\u1ed1i v\u1edbi m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o, v\u1edbi c\u00e1c b\u00e1o c\u00e1o c\u00f3 s\u1ed1 li\u1ec7u gi\u00e1 tr\u1ecb l\u00e0 0 s\u1ebd hi\u1ec3n th\u1ecb \u00f4 tr\u1ed1ng. Khi\u1ebfn cho anh\/ch\u1ecb d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu c\u00e1c h\u00e0ng, c\u1ed9t th\u00ec b\u1ecb b\u00e1o l\u1ed7i.<\/p>\n<p><strong>\u2013 K\u1ec3 t\u1eeb phi\u00ean b\u1ea3n R56:<\/strong><\/p>\n<p>Ph\u1ea7n m\u1ec1m c\u00f3 th\u1ec3 xu\u1ea5t c\u00e1c b\u00e1o c\u00e1o d\u1ea1ng d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 \u0111\u1ec3 c\u00f3 th\u1ec3 thu\u1eadn ti\u1ec7n trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u.\u00a0<\/p>\n<p><em>V\u00ed d\u1ee5: Khi in m\u1eabu s\u1ed1 <strong>S24-H: S\u1ed5 t\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh<\/strong>, b\u00e1o c\u00e1o n\u00e0y c\u00f3 th\u1ec3 xu\u1ea5t t\u1ec7p MS Excel (d\u1ea1ng d\u1eef li\u1ec7u).<\/em><img decoding=\"async\" class=\"alignnone wp-image-29925 size-full\" src=\"\/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45.jpg\" alt=\"\" width=\"1917\" height=\"938\" srcset=\"\/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45.jpg 1917w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-300x147.jpg 300w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-1024x501.jpg 1024w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-768x376.jpg 768w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-50x24.jpg 50w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-1536x752.jpg 1536w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-60x29.jpg 60w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-15-45-100x49.jpg 100w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><em>V\u1edbi c\u00e1c gi\u00e1 tr\u1ecb b\u1eb1ng 0 th\u00ec s\u1ebd hi\u1ec3n th\u1ecb b\u1eb1ng 0.<\/em><img decoding=\"async\" class=\"alignnone wp-image-29927 size-full\" src=\"\/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19.jpg\" alt=\"\" width=\"1922\" height=\"1007\" srcset=\"\/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19.jpg 1922w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-300x157.jpg 300w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-1024x537.jpg 1024w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-768x402.jpg 768w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-50x26.jpg 50w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-1536x805.jpg 1536w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-60x31.jpg 60w, \/tai-san\/wp-content\/uploads\/2025\/05\/2025-05-06_9-21-19-100x52.jpg 100w\" sizes=\"(max-width: 1922px) 100vw, 1922px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y gi\u00fap anh\/ch\u1ecb hi\u1ec3u v\u1ec1 t\u00ednh n\u0103ng xu\u1ea5t t\u1ec7p Excel (d\u1ea1ng d\u1eef li\u1ec7u) tr\u00ean IHOS T\u00e0i s\u1ea3n, trong \u0111\u00f3 c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 0, h\u1ed7 tr\u1ee3 thu\u1eadn ti\u1ec7n cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u t\u00e0i&#8230;<\/p>\n","protected":false},"author":112,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[227],"ht-kb-tag":[],"class_list":["post-29921","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r56"],"_links":{"self":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/29921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tai-san\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/users\/112"}],"version-history":[{"count":3,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/29921\/revisions"}],"predecessor-version":[{"id":46909,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/29921\/revisions\/46909"}],"wp:attachment":[{"href":"\/tai-san\/wp-json\/wp\/v2\/media?parent=29921"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-category?post=29921"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-tag?post=29921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}