{"id":12280,"date":"2025-01-15T07:59:52","date_gmt":"2025-01-15T07:59:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhap-cong-thuc-hoa-hoc-trong-excel\/"},"modified":"2025-01-15T07:59:52","modified_gmt":"2025-01-15T07:59:52","slug":"cach-nhap-cong-thuc-hoa-hoc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-nhap-cong-thuc-hoa-hoc-trong-excel\/","title":{"rendered":"C\u00e1ch nh\u1eadp c\u00f4ng th\u1ee9c h\u00f3a h\u1ecdc trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m vi\u1ec7c c\u00e1c c\u00f4ng th\u1ee9c H\u00f3a h\u1ecdc tr\u00ean Excel m\u00e0 ch\u01b0a bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n th\u00ec h\u00e3y theo d\u00f5i b\u00e0i h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y nh\u00e9. Hi v\u1ecdng nh\u1eefng chia s\u1ebb c\u1ee7a m\u00ecnh s\u1ebd gi\u00fap \u00edch cho b\u1ea1n.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ch\u1eb3ng h\u1ea1n, b\u1ea1n mu\u1ed1n nh\u1eadp c\u00f4ng th\u1ee9c H\u00f3a h\u1ecdc chu\u1ea9n cho b\u1ea3ng s\u1ed1 li\u1ec7u sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3581 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-hoa-hoc-excel.png\" width=\"600\" height=\"418\" title=\"cong-thuc-hoa-hoc-excel\"><\/p>\n<ul>\n<li style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1<\/strong>: G\u00f5 t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c th\u00f4 ch\u01b0a \u0111\u1ecbnh d\u1ea1ng v\u00e0o c\u1ed9t c\u00f4ng th\u1ee9c.<\/li>\n<li style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ea7n l\u01b0\u1ee3t b\u00f4i \u0111en k\u00ed t\u1ef1 l\u00e0 ch\u1ec9 s\u1ed1 d\u01b0\u1edbi \u00a0trong c\u00f4ng th\u1ee9c, nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn <strong>Format Cells<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3582 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-hoa-hoc-excel-1.png\" width=\"600\" height=\"417\" title=\"cong-thuc-hoa-hoc-excel-1\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 3<\/strong>:\u00a0H\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n t\u00edch ch\u1ecdn m\u1ee5c <strong>Subscript<\/strong>\u00a0v\u00e0 nh\u1ea5p\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3590 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-hoa-hoc.png\" width=\"600\" height=\"295\" title=\"cong-thuc-hoa-hoc\"><\/p>\n<ul>\n<li style=\"text-align: justify\">T\u01b0\u01a1ng t\u1ef1 cho c\u00e1c c\u00f4ng th\u1ee9c c\u00f2n l\u1ea1i trong b\u1ea3ng, ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3586 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cong-thuc-hoa-hoc-excel-3.png\" width=\"600\" height=\"416\" title=\"cong-thuc-hoa-hoc-excel-3\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y: \u0111o\u1ea1n code n\u00e0y s\u1ebd chuy\u1ec3n t\u1ea5t c\u1ea3 s\u1ed1 trong 1 \u00f4 th\u00e0nh subscript. N\u1ebfu ch\u01b0a bi\u1ebft d\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o <a href=\"https:\/\/blog.hocexcel.online\/cach-chay-file-macro-chay-file-vba-trong-excel.html\" target=\"_blank\">C\u00e1ch s\u1eed d\u1ee5ng v\u00e0 th\u00eam code n\u00e0y v\u00e0o VBA<\/a><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/102cd3d3b5c5388c25710869f6e9c9a7\">Gist<\/a>.<\/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-378.gif\" title=\"ex101_92019-nho-378\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.hocexcel.online\/vba101\">https:\/\/www.hocexcel.online\/vba101<\/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-378.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12280","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\/12280","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=12280"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12281"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}