{"id":12265,"date":"2025-01-15T07:49:27","date_gmt":"2025-01-15T07:49:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-db-trong-excel-va-cach-su-dung-ham-db-de-tinh-khau-hao-tai-san\/"},"modified":"2025-01-15T07:49:27","modified_gmt":"2025-01-15T07:49:27","slug":"ham-db-trong-excel-va-cach-su-dung-ham-db-de-tinh-khau-hao-tai-san","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-db-trong-excel-va-cach-su-dung-ham-db-de-tinh-khau-hao-tai-san\/","title":{"rendered":"H\u00e0m DB trong excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DB \u0111\u1ec3 t\u00ednh kh\u1ea5u hao t\u00e0i s\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft t\u00e0i s\u1ea3n c\u1ee7a m\u00ecnh kh\u1ea5u hao qua m\u1ed7i n\u0103m l\u00e0 bao nhi\u00eau,\u00a0h\u00e3y s\u1eed d\u1ee5ng h\u00e0m DB trong Excel nh\u00e9. H\u00e0m DB s\u1ebd gi\u00fap b\u1ea1n\u00a0nh\u1eadn th\u1ea5y gi\u00e1 tr\u1ecb kh\u1ea5u hao t\u00e0i s\u1ea3n gi\u1ea3m d\u1ea7n qua c\u00e1c n\u0103m, t\u1eeb \u0111\u00f3 s\u1ebd gi\u00fap c\u00e1c b\u1ea1n c\u00f3 k\u1ebf ho\u1ea1ch s\u1eed d\u1ee5ng t\u00e0i s\u1ea3n m\u1ed9t c\u00e1ch h\u1ee3p l\u00fd.<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m DB: \u00a0<strong>DB(cost, salvage, life, period, month)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li style=\"text-align: justify\"><strong>Cost:<\/strong>\u00a0Gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a t\u00e0i s\u1ea3n.<\/li>\n<li style=\"text-align: justify\"><strong>Salvage: <\/strong>Gi\u00e1 tr\u1ecb\u00a0c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n t\u1ea1i th\u1eddi \u0111i\u1ec3m cu\u1ed1i c\u1ee7a \u0111\u1eddi h\u1eefu d\u1ee5ng<\/li>\n<li style=\"text-align: justify\"><strong>Life:<\/strong>\u00a0l\u00e0 s\u1ed1 chu k\u1ef3 s\u1eed d\u1ee5ng c\u1ee7a t\u00e0i s\u1ea3n (\u0111\u00f4i khi c\u00f2n g\u1ecdi l\u00e0 \u0111\u1eddi h\u1eefu d\u1ee5ng c\u1ee7a t\u00e0i s\u1ea3n).<\/li>\n<li style=\"text-align: justify\"><strong>Period: \u00a0<\/strong>l\u00e0 chu k\u1ef3 t\u00ednh kh\u1ea5u hao ( ph\u1ea3i c\u00f3 c\u00f9ng \u0111\u01a1n v\u1ecb v\u1edbi Life).<\/li>\n<li style=\"text-align: justify\"><strong>Month:<\/strong>\u00a0l\u00e0 s\u1ed1 th\u00e1ng s\u1eed d\u1ee5ng t\u00e0i s\u1ea3n trong n\u0103m \u0111\u1ea7u ti\u00ean, n\u1ebfu kh\u00f4ng c\u00f3 th\u00ec Excel ch\u1ea5p nh\u1eadn l\u00e0 t\u00ednh t\u1eeb th\u00e1ng m\u1ed9t (month l\u00e0 12).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ch\u1ee9c n\u0103ng: H\u00e0m DB t\u00ednh kh\u1ea5u hao c\u1ee7a m\u1ed9t t\u00e0i s\u1ea3n cho m\u1ed9t chu k\u1ef3 ch\u1ec9 \u0111\u1ecbnh b\u1eb1ng ph\u01b0\u01a1ng ph\u00e1p k\u1ebft s\u1ed1 gi\u1ea3m \u0111\u1ec1u c\u1ed1 \u0111\u1ecbnh.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u00ecm hi\u1ec3u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">C\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5:<\/strong> Cu\u1ed1i th\u00e1ng 7 n\u0103m 2016 anh Thanh mua m\u1ed9t m\u00e1y h\u00e0n v\u1edbi gi\u00e1 12.000.000 VN\u0110. Sau 6 n\u0103m s\u1eed d\u1ee5ng b\u00e1n l\u1ea1i \u0111\u01b0\u1ee3c 3.000.000 VN\u0110. S\u1eed d\u1ee5ng h\u00e0m DB t\u00ednh kh\u1ea5u hao m\u00e1y h\u00e0n \u0111\u00f3 cho c\u00e1c n\u0103m s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1<\/strong>: Thi\u1ebft l\u1eadp b\u1ea3ng t\u00ednh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3624 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/db1.gif\" width=\"388\" height=\"320\" title=\"db1\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1i \u00f4 B4 g\u00f5 h\u00e0m DB:\u00a0<strong>=DB(12000000,3000000,6,A4,5).\u00a0<\/strong>Sau \u0111\u00f3, c\u00e1c b\u1ea1n sao ch\u00e9p h\u00e0m t\u1eeb \u00f4 B4 \u0111\u1ebfn B10.<\/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-375.gif\" title=\"ex101_92019-nho-375\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3628 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/db2.gif\" width=\"400\" height=\"320\" title=\"db2\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 3<\/strong>: T\u00ednh t\u1ef7 l\u1ec7 kh\u1ea5u hao b\u1eb1ng c\u00e1ch l\u1ea5y kh\u1ea5u hao n\u0103m sau chia cho kh\u1ea5u hao n\u0103m tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3629 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/db3-e1490891760554.gif\" width=\"406\" height=\"320\" title=\"db3-e1490891760554\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/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-375.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12265","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\/12265","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=12265"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12266"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}