{"id":11856,"date":"2025-01-15T05:37:41","date_gmt":"2025-01-15T05:37:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-thay-the-cong-thuc-bang-cac-gia-tri-cua-chung-trong-excel\/"},"modified":"2025-01-15T05:37:41","modified_gmt":"2025-01-15T05:37:41","slug":"huong-dan-thay-the-cong-thuc-bang-cac-gia-tri-cua-chung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-thay-the-cong-thuc-bang-cac-gia-tri-cua-chung-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch ti\u1ebft ki\u1ec7m th\u1eddi gian c\u1ee7a b\u1ea1n trong vi\u1ec7c thay th\u1ebf c\u00e1c c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 Excel b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 c\u00e1c l\u00fd do kh\u00e1c nhau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c c\u00f4ng th\u1ee9c th\u00e0nh c\u00e1c gi\u00e1 tr\u1ecb:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 c\u00f3 th\u1ec3 nhanh ch\u00f3ng ch\u00e8n gi\u00e1 tr\u1ecb v\u00e0o c\u00e1c b\u1ea3ng t\u00ednh ho\u1eb7c trang t\u00ednh kh\u00e1c m\u00e0 kh\u00f4ng l\u00e3ng ph\u00ed th\u1eddi gian sao ch\u00e9p, d\u00e1n \u0111\u1eb7c bi\u1ec7t.<\/li>\n<li>\u0110\u1ec3 gi\u1eef l\u1ea1i c\u00e1c c\u00f4ng th\u1ee9c ban \u0111\u1ea7u c\u1ee7a b\u1ea1n khi b\u1ea1n g\u1eedi m\u1ed9t b\u1ea3ng t\u00ednh cho ng\u01b0\u1eddi kh\u00e1c (v\u00ed d\u1ee5: gi\u00e1 b\u00e1n l\u1ebb c\u1ee7a b\u1ea1n v\u1edbi gi\u00e1 b\u00e1n bu\u00f4n).<\/li>\n<li>\u0110\u1ec3 ng\u0103n ch\u1eb7n k\u1ebft qu\u1ea3 t\u1eeb s\u1eeda \u0111\u1ed5i khi c\u00e1c con s\u1ed1 trong c\u00e1c \u00f4 li\u00ean k\u1ebft thay \u0111\u1ed5i.<\/li>\n<li>L\u01b0u k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c rand ()<\/li>\n<li>N\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p trong b\u1ea3ng t\u00ednh l\u00e0m cho vi\u1ec7c t\u00ednh to\u00e1n r\u1ea5t ch\u1eadm. V\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u00f9y ch\u1ecdn \u201cT\u00ednh to\u00e1n c\u1ee7a b\u1ea3ng t\u00ednh\u201d sang ch\u1ebf \u0111\u1ed9 th\u1ee7 c\u00f4ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Chuy\u1ec3n \u0111\u1ed5i c\u00f4ng th\u1ee9c sang gi\u00e1 tr\u1ecb s\u1eed d\u1ee5ng l\u1ed1i t\u1eaft Excel<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c t\u00ean mi\u1ec1n t\u1eeb URL.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u1ea7n ph\u1ea3i thay th\u1ebf c\u00e1c k\u1ebft qu\u1ea3 \u0111\u00f3 b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6418\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-dialog-box-launcher-1-186.png\" width=\"600\" height=\"138\" title=\"excel-dialog-box-launcher-1-186\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n l\u00e0m theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/li>\n<li>Nh\u1ea5n Ctrl + C ho\u1eb7c Ctrl + Ins \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a ch\u00fang v\u00e0o khay nh\u1edb t\u1ea1m.<\/li>\n<li>Nh\u1ea5n Shift + F10 v\u00e0 sau \u0111\u00f3 V \u0111\u1ec3 d\u00e1n c\u00e1c gi\u00e1 tr\u1ecb tr\u1edf v\u1ec1 c\u00e1c \u00f4 c\u1ee7a Excel. Shift + F10 + V l\u00e0 ph\u00edm t\u1eaft \u0111\u1ec3 s\u1eed d\u1ee5ng h\u1ed9p tho\u1ea1i \u201cD\u00e1n \u0111\u1eb7c bi\u1ec7t \u2013 gi\u00e1 tr\u1ecb\u201d c\u1ee7a Excel.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/formula-converted-to-value.png\" alt=\"\u0421onverting formulas to values using Excel shortcuts\" title=\"formula-converted-to-value\"><\/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\/2025\/01\/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\/2025\/01\/ex101_92019-nho-330.gif\" title=\"ex101_92019-nho-330\"><br \/>\n<\/a>\n<\/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\/2025\/01\/vba101_92019-nho-64.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11857,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11856","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\/11856","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=11856"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11856\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11857"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}