{"id":12073,"date":"2025-01-15T06:56:03","date_gmt":"2025-01-15T06:56:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rate-ham-tinh-lai-suat-trong-excel\/"},"modified":"2025-01-15T06:56:03","modified_gmt":"2025-01-15T06:56:03","slug":"ham-rate-ham-tinh-lai-suat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rate-ham-tinh-lai-suat-trong-excel\/","title":{"rendered":"H\u00e0m RATE, H\u00e0m t\u00ednh l\u00e3i su\u1ea5t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>S\u1eed d\u1ee5ng h\u00e0m RATE \u0111\u1ec3 t\u00ednh l\u00e3i su\u1ea5t theo chu k\u1ef3 c\u1ee7a m\u1ed9t kho\u1ea3n cho vay ho\u1eb7c \u0111\u1ea7u t\u01b0.<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p: =RATE(nper, pmt, pv, [fv], [type])<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>Nper:<\/strong> l\u00e0 t\u1ed5ng s\u1ed1 k\u1ef3 chi tr\u1ea3.<\/li>\n<li><strong>Pmt:<\/strong> l\u00e0 s\u1ed1 ti\u1ec1n chi tr\u1ea3 (hay thu v\u1ec1) trong m\u1ed7i k\u1ef3, c\u1ed1 \u0111\u1ecbnh trong su\u1ed1t giai \u0111o\u1ea1n.<\/li>\n<li><strong>Pv:<\/strong> l\u00e0 gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i .<\/li>\n<li><strong>Fv:<\/strong> l\u00e0 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng lai ho\u1eb7c c\u1ea7n b\u1eb1ng ti\u1ec1n m\u1eb7t m\u00e0 ta mu\u1ed1n t\u00ecm sau l\u1ea7n chi tr\u1ea3 cu\u1ed1i c\u00f9ng. N\u1ebfu Fv kh\u00f4ng c\u00f3 th\u00ec ph\u1ea3i cho c\u00f3 Pmt.<\/li>\n<li><strong>Type:<\/strong> b\u1eb1ng 1 n\u1ebfu s\u1ed1 ti\u1ec1n tr\u1ea3 \u0111\u1ea7u k\u1ef3, b\u1eb1ng 0 n\u1ebfu cu\u1ed1i k\u1ef3.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Kho\u0301a h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n<p>Cho d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4339 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/rate-1.gif\" width=\"600\" height=\"280\" title=\"rate-1\"><\/p>\n<p>H\u00e3y t\u00ednh l\u00e3i su\u1ea5t th\u00e1ng v\u00e0 n\u0103m m\u00e0 kh\u00e1ch h\u00e0ng ph\u1ea3i ch\u1ecbu.<\/p>\n<ul>\n<li>T\u00ednh l\u00e3i su\u1ea5t th\u00e1ng: T\u1ea1i \u00f4 G3 c\u00e1c b\u1ea1n nh\u1eadp: <strong>=Rate(D3*12,-F3,E3)<\/strong>\u00a0\u2192 Enter v\u00e0 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.\u00a0<em> L\u01b0u \u00fd:<\/em> Pmt ph\u1ea3i nh\u1eadp v\u1edbi d\u1ea5u \u00e2m do \u0111\u00e2y l\u00e0 s\u1ed1 ti\u1ec1n ph\u1ea3i b\u1ecf ra.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/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-347.gif\" title=\"ex101_92019-nho-347\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4340 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/rate-2.gif\" width=\"600\" height=\"351\" title=\"rate-2\"><\/p>\n<ul>\n<li>T\u00ednh l\u00e3i su\u1ea5t n\u0103m: T\u1ea1i \u00f4 H3 c\u00e1c b\u1ea1n nh\u1eadp: <strong>= G3*12\u00a0\u2192 Enter<\/strong> v\u00e0 sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4341 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/rate-3.gif\" width=\"600\" height=\"347\" title=\"rate-3\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u00a0 \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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-347.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12074,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12073","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\/12073","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=12073"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12074"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}