{"id":12257,"date":"2025-01-15T07:47:35","date_gmt":"2025-01-15T07:47:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-salvage-de-tinh-gia-tri-con-lai-cua-tai-san-trong-excel\/"},"modified":"2025-01-15T07:47:35","modified_gmt":"2025-01-15T07:47:35","slug":"huong-dan-su-dung-ham-salvage-de-tinh-gia-tri-con-lai-cua-tai-san-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-salvage-de-tinh-gia-tri-con-lai-cua-tai-san-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Salvage \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><strong>H\u00f4m nay m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng\u00a0h\u00e0m Salvage \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n khi bi\u1ebft gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a t\u00e0i s\u1ea3n, ty l\u1ec7 kh\u1ea5u hao h\u1eb1ng n\u0103m v\u00e0 s\u1ed1 n\u0103m t\u00ednh kh\u1ea5u hao. Bi\u1ebft r\u1eb1ng gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a n\u0103m sau d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n trong n\u0103m tr\u01b0\u1edbc \u0111\u00f3.<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m Salvage v\u1edbi c\u00fa ph\u00e1p h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>Salvage = Cost*(1-Rate)^Life<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\"><strong>Salvage:<\/strong> l\u00e0 gi\u00e1 tr\u1ecb c\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>Cost:<\/strong> l\u00e0 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u c\u1ee7a t\u00e0i s\u1ea3n.<\/li>\n<li style=\"text-align: justify\"><strong>Life:<\/strong> l\u00e0 t\u1ed5ng 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>Rate:<\/strong> l\u00e0 t\u1ef7 l\u1ec7 kh\u1ea5u hao m\u1ed7i k\u1ef3.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ch\u1ee9c n\u0103ng<\/strong>: T\u00ednh gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n khi bi\u1ebft gi\u00e1 tr\u1ecb ban \u0111\u1ea7u, t\u1ef7 l\u1ec7 kh\u1ea5u hao m\u1ed7i k\u1ef3, t\u1ed5ng s\u1ed1 chu k\u1ef3 s\u1eed d\u1ee5ng t\u00e0i s\u1ea3n.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem ngay: T\u1ed5ng h\u1ee3p c\u00e1c\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">h\u00e0m trong excel<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p style=\"text-align: justify\">T\u00ednh gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a\u00a0t\u00e0i s\u1ea3n v\u1edbi c\u00e1c s\u1ed1 li\u1ec7u sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3664\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gtcl.gif\" width=\"600\" height=\"289\" title=\"gtcl\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-374.gif\" title=\"ex101_92019-nho-374\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-74.gif\" title=\"vba101_92019-nho-74\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-374.gif\" title=\"ex101_92019-nho-374\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">T\u1ea1i \u00f4<strong> F2<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c: <strong>=C2*(1-E2)^D2\u00a0\u2192\u00a0<\/strong>Ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i c\u1ee7a t\u00e0i s\u1ea3n. Sau \u0111\u00f3, sao ch\u00e9p c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3665\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gtcl2-e1491130860723.gif\" width=\"600\" height=\"304\" title=\"gtcl2-e1491130860723\"><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-374.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12258,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12257","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\/12257","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=12257"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12257\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12258"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}