{"id":2041,"date":"2024-12-02T06:52:50","date_gmt":"2024-12-02T06:52:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-thay-the-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel\/"},"modified":"2024-12-02T06:52:50","modified_gmt":"2024-12-02T06:52:50","slug":"cach-thay-the-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-thay-the-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel\/","title":{"rendered":"C\u00e1ch thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n trong \u00f4 t\u00ednh, \u0111\u01b0\u01a1ng nhi\u00ean b\u1ea1n ph\u1ea3i thay \u0111\u1ed5i t\u1eebng \u00f4 m\u1ed9t m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. Tuy nhi\u00ean, c\u00e1ch n\u00e0y t\u1ed1n r\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ed1i v\u1edbi s\u1ed1 l\u01b0\u1ee3ng \u00f4 l\u1edbn. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t v\u00e0i m\u1eb9o \u0111\u1ec3 nhanh ch\u00f3ng thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, t\u00f4i c\u00f3 m\u1ed9t d\u00e3y c\u00f4ng th\u1ee9c, b\u00e2y gi\u1edd t\u00f4i c\u1ea7n thay th\u1ebf nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0y b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 sau:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7049\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-29.png\" width=\"336\" height=\"353\" title=\"untitled-29\"><\/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-674d5941cffa1\" 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\/cach-thay-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel.html#Thay_the_cong_thuc_bang_ket_qua_hoac_gia_tri_bang_lenh_Paste_Special\" title=\"Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng l\u1ec7nh Paste Special\">Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng l\u1ec7nh Paste Special<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-thay-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel.html#Thay_the_cong_thuc_bang_ket_qua_hoac_gia_tri_bang_VBA\" title=\"Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng VBA\">Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_the_cong_thuc_bang_ket_qua_hoac_gia_tri_bang_lenh_Paste_Special\"><\/span><strong>Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng l\u1ec7nh Paste Special<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">L\u1ec7nh\u00a0<em><strong>Paste Special\u00a0<\/strong><\/em>c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c, ch\u1ec9 duy tr\u00ec k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n trong \u00f4 t\u00ednh.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n thao t\u00e1c.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n\u00a0<em><strong>Ctrl + C\u00a0<\/strong><\/em>\u0111\u1ec3 sao ch\u00e9p c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">3. Nh\u1ea5p ph\u1ea3i v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u1ea5n n\u00fat <em><strong>Paste Values<\/strong><\/em>\u00a0d\u01b0\u1edbi <em><strong>Paste Options<\/strong><\/em>.<\/p>\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\/2024\/12\/vba101_92019-nho-64.gif\" title=\"vba101_92019-nho-64\"><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\/2024\/12\/ex101_92019-nho-155.gif\" title=\"ex101_92019-nho-155\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-convert-formulas-to-values3.png\" alt=\"doc-convert-formulas-to-values3\" title=\"doc-convert-formulas-to-values3\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c trong ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n c\u00f9ng l\u00fac.<\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html\">c\u00e1ch copy d\u1eef li\u1ec7u trong excel<\/a><\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_the_cong_thuc_bang_ket_qua_hoac_gia_tri_bang_VBA\"><\/span><strong>Thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb b\u1eb1ng VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u00e0nh th\u1ea1o Microsoft Excel,\u00a0<em><strong>VBA Macro\u00a0<\/strong><\/em>l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn s\u00e1ng su\u1ed1t \u0111\u1ec3 nhanh ch\u00f3ng thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n.<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0<em><strong>Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 <em><strong>Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5p <em><strong>Insert &gt; Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o <em><strong>Module Window<\/strong><\/em>.<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/ed85a4f8a40147b09be04f1059ec29e5\">Gist<\/a>.<\/div>\n<div class=\"line number14 index13 alt1\">\n<div class=\"line number15 index14 alt2\" style=\"text-align: justify\">3. Nh\u1ea5n\u00a0<em><strong>F5\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, trong h\u1ed9p tho\u1ea1i hi\u1ec7n ra, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh gi\u00e1 tr\u1ecb th\u1ef1c nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/div>\n<div class=\"line number15 index14 alt2\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-convert-formulas-to-values6.png\" title=\"doc-convert-formulas-to-values6\"><\/div>\n<div class=\"line number15 index14 alt2\">4. Nh\u1ea5n OK.<br \/>\nR\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. 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: HocExcel.Online<\/div>\n<\/div>\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\/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\/2024\/12\/vba101_92019-nho-64.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2042,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2041","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=2041"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2041\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2042"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}