{"id":9464,"date":"2025-01-02T07:30:03","date_gmt":"2025-01-02T07:30:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan\/"},"modified":"2025-01-02T07:30:03","modified_gmt":"2025-01-02T07:30:03","slug":"huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n, ch\u00fang ta th\u01b0\u1eddng xuy\u00ean ph\u1ea3i th\u1ef1c hi\u1ec7n vi\u1ec7c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef. Ti\u00eau bi\u1ec3u nh\u01b0 c\u00e1c m\u1eabu b\u1ea3ng b\u00e1o gi\u00e1, h\u00f3a\u00a0\u0111\u01a1n VAT, h\u1ee3p\u00a0\u0111\u1ed3ng kinh t\u1ebf, Phi\u1ebfu thu, Phi\u1ebfu chi, \u1ee6y nhi\u1ec7m chi, l\u1ec7nh r\u00fat ti\u1ec1n\u2026\u00a0\u0111\u1ec1u quy\u00a0\u0111\u1ecbnh c\u1ea7n ghi r\u00f5 s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef, m\u1ee5c\u00a0\u0111\u00edch l\u00e0\u00a0\u0111\u1ec3 tr\u00e1nh s\u1ef1 hi\u1ec3u nh\u1ea7m gi\u1eefa c\u00e1c con s\u1ed1 v\u00e0 c\u00e1ch vi\u1ebft. V\u00e0 trong blog c\u1ee7a H\u1ecdc\u00a0Excel Online\u00a0\u0111\u00e3 c\u00f3 1 b\u00e0i vi\u1ebft r\u1ea5t hay v\u1ec1 vi\u1ec7c t\u1ef1 t\u1ea1o c\u00f4ng th\u1ee9c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef tr\u00ean\u00a0Excel. V\u1eady ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch\u00a0s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n nh\u00e9.<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft v\u1ec1 <strong>C\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef tr\u00ean\u00a0Excel<\/strong>:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html\">Ph\u1ea7n 1<\/a>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html\">Ph\u1ea7n 2<\/a><\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2Upapa1\">http:\/\/bit.ly\/2Upapa1<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6776407adc192\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan.html#Cach_su_dung_cong_thuc_viet_so_tien_bang_chu_trong_ke_toan\" title=\"C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n\">C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan.html#Uu_diem\" title=\"\u01afu\u00a0\u0111i\u1ec3m:\">\u01afu\u00a0\u0111i\u1ec3m:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan.html#Nhuoc_diem\" title=\"Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m:\">Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_cong_thuc_viet_so_tien_bang_chu_trong_ke_toan\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c vi\u1ebft s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong k\u1ebf to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 m\u1eabu phi\u1ebfu thu nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24351\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mau-phieu-thu-excel.png\" width=\"800\" height=\"411\" title=\"mau-phieu-thu-excel\"><\/p>\n<p>\u00a0<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-58.gif\" title=\"ex101_92019-nho-58\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea1i m\u1eabu n\u00e0y, ch\u00fang ta c\u00f3 m\u1ee5c\u00a0\u00f4 s\u1ed1 ti\u1ec1n l\u00e0\u00a0\u00f4 C9 v\u00e0\u00a0\u00f4\u00a0\u0111\u1ecdc ti\u1ec1n b\u1eb1ng ch\u1eef l\u00e0\u00a0\u00f4 C10.<\/p>\n<p><strong>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/strong><\/p>\n<ul>\n<li>T\u1ea1o th\u00eam 1 sheet (goi l\u00e0 sheet TienBangChu). T\u1ea1i n\u00e0y\u00a0b\u1ea1n copy nguy\u00ean c\u00f4ng th\u1ee9c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n th\u00e0nh ch\u1eef t\u1eeb file m\u1eabu\u00a0\u1edf tr\u00ean.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24352\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/copy-cong-thuc-doc-so-tien-thanh-chu.png\" width=\"1217\" height=\"191\" title=\"copy-cong-thuc-doc-so-tien-thanh-chu\"><\/p>\n<ul>\n<li>T\u1ea1i\u00a0\u00f4 C1 c\u1ee7a sheet TienBangChu, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi\u00a0\u00f4 C9 c\u1ee7a sheet PhieuThu l\u00e0\u00a0=PhieuThu!C9<\/li>\n<li>T\u1ea1i sheet PhieuThu,\u00a0\u00f4 C10 s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c tham chi\u1ebfu t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef, l\u00e0\u00a0\u00f4 B7 c\u1ee7a sheet\u00a0TienBangChu<\/li>\n<\/ul>\n<p>B\u00e2y gi\u1edd nh\u1eadp 1 s\u00f4\u1ed1 ti\u1ec1n b\u1ea5t k\u1ef3\u00a0\u1edf \u00f4 S\u1ed1 ti\u1ec1n (\u00f4 C9) c\u1ee7a Phi\u1ebfu thu, ch\u00fang ta s\u1ebd c\u00f3 ngay k\u1ebft qu\u1ea3 ti\u1ec1n b\u1eb1ng ch\u1eef<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24353\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-so-tien-bang-chu-phieu-thu.gif\" width=\"800\" height=\"447\" title=\"doc-so-tien-bang-chu-phieu-thu\"><\/p>\n<p>R\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o. Tuy nhi\u00ean khi\u00a0\u00e1p d\u1ee5ng c\u00e1ch l\u00e0m n\u00e0y c\u00e1c b\u1ea1n ch\u00fa\u00a0\u00fd m\u1ed9t s\u1ed1 v\u1ea5n\u00a0\u0111\u1ec1 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Uu_diem\"><\/span>\u01afu\u00a0\u0111i\u1ec3m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>D\u1ec5 s\u1eed d\u1ee5ng, kh\u00f4ng c\u1ea7n l\u00e0m l\u1ea1i c\u00f4ng th\u1ee9c, ch\u1ec9 c\u1ea7n copy v\u00e0 s\u1eed d\u1ee5ng ngay<\/li>\n<li>C\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i c\u00e1ch\u00a0\u0111\u1ecdc theo\u00a0\u00fd mu\u1ed1n (nh\u01b0\u00a0\u0111\u00e3 ph\u00e2n t\u00edch trong b\u00e0i vi\u1ebft c\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c)<\/li>\n<li>Kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng VBA hay c\u00e0i\u00a0\u0111\u1eb7t Add-In, ch\u1ec9\u00a0\u0111\u01a1n thu\u1ea7n l\u00e0 c\u00f4ng th\u1ee9c trong\u00a0excel<\/li>\n<li>Hi\u1ec3u r\u00f5 c\u00e1ch\u00a0\u0111\u1ecdc, ki\u1ec3m tra\u00a0\u0111\u01b0\u1ee3c c\u00e1ch\u00a0\u0111\u1ecdc theo\u00a0\u00fd mu\u1ed1n.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nhuoc_diem\"><\/span>Nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>C\u00f4ng th\u1ee9c hi\u1ec7n ch\u1ec9\u00a0\u00e1p d\u1ee5ng t\u1edbi h\u00e0ng tr\u0103m t\u1ef7, s\u1ed1 l\u1edbn h\u01a1n (h\u00e0ng ngh\u00ecn t\u1ef7) th\u00ec kh\u00f4ng\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c. B\u1ea1n s\u1ebd c\u1ea7n l\u00e0m l\u1ea1i c\u00f4ng th\u1ee9c.<\/li>\n<li>M\u1ed7i 1 s\u1ed1 c\u1ea7n\u00a0\u0111\u1ecdc s\u1ebd c\u1ea7n 1 b\u1ed9 c\u00f4ng th\u1ee9c. Do v\u1eady h\u1ea1n ch\u1ebf\u00a0\u0111\u1ecdc nhi\u1ec1u s\u1ed1.<\/li>\n<\/ul>\n<p>M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c v\u1ec1 vi\u1ec7c\u00a0\u00e1p d\u1ee5ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1\u00a0th\u00e0nh ch\u1eef cho\u00a0\u1ee6y nhi\u1ec7m chi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22735\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ung-dung-doc-so-tien-thanh-chu.png\" width=\"1287\" height=\"757\" title=\"ung-dung-doc-so-tien-thanh-chu\"><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/addin-doc-thanh-chu-tu-hoc-excel-online.html\">Addin \u0111\u1ecdc s\u1ed1 th\u00e0nh ch\u1eef t\u1eeb H\u1ecdc Excel Online<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-doc-so-tien-thanh-chu-trong-excel-2007-2010-2013-2016.html\">C\u00e1ch \u0111\u1ecdc s\u1ed1 ti\u1ec1n th\u00e0nh ch\u1eef trong Excel 2007 2010 2013 2016 v\u1edbi addins<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-58.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9465,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9464"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9465"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}