{"id":7159,"date":"2024-12-21T17:02:44","date_gmt":"2024-12-21T17:02:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/an-cong-thuc-trong-bang-tinh-excel\/"},"modified":"2024-12-21T17:02:44","modified_gmt":"2024-12-21T17:02:44","slug":"an-cong-thuc-trong-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/an-cong-thuc-trong-bang-tinh-excel\/","title":{"rendered":"\u1ea8n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng tinh Excel, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u1ea9n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. N\u00f3i \u0111\u1ebfn <strong><a href=\"http:\/\/blog.ezworkapp.com\/an-cong-thuc-trong-bang-tinh-excel.html\">\u1ea9n c\u00f4ng th\u1ee9c trong Excel,<\/a><\/strong> m\u1ee5c \u0111\u00edch c\u1ee7a \u0111i\u1ec1u n\u00e0y kh\u00f4ng nh\u1ea5t thi\u1ebft l\u00e0 \u0111\u1ec3 ng\u01b0\u1eddi kh\u00e1c kh\u00f4ng nh\u00ecn th\u1ea5y c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n k\u1ef3 di\u1ec7u nh\u01b0 th\u1ebf n\u00e0o, m\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 l\u00e0 ch\u00fang ta mu\u1ed1n ti\u1ebft ki\u1ec7m th\u1eddi gian cho nh\u1eefng ng\u01b0\u1eddi nh\u1eadn \u0111\u01b0\u1ee3c b\u1ea3ng t\u00ednh, s\u1eed d\u1ee5ng b\u1ea3ng t\u00ednh v\u00e0 kh\u00f4ng ph\u1ea3i b\u1eadn t\u00e2m t\u1edbi vi\u1ec7c c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o v\u00e0 quan tr\u1ecdng l\u00e0 kh\u00f4ng l\u00e0m h\u1ecfng b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n \u0111\u00e3 b\u1ecf c\u00f4ng s\u1ee9c \u0111\u1ec3 s\u00e1ng t\u1ea1o ra.<\/em><\/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-6766f4b38bb44\" 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\/an-cong-thuc-trong-bang-tinh-excel.html#Bo_chuc_nang_bao_ve_bang_tinh_%E2%80%93_protect_sheet\" title=\"B\u1ecf ch\u1ee9c n\u0103ng b\u1ea3o v\u1ec1 b\u1ea3ng t\u00ednh \u2013 protect sheet\">B\u1ecf ch\u1ee9c n\u0103ng b\u1ea3o v\u1ec1 b\u1ea3ng t\u00ednh \u2013 protect sheet<\/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\/an-cong-thuc-trong-bang-tinh-excel.html#An_cong_thuc_trong_bang_tinh_Excel\" title=\"\u1ea8n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel\">\u1ea8n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bo_chuc_nang_bao_ve_bang_tinh_%E2%80%93_protect_sheet\"><\/span><span style=\"font-size: 14pt\">B\u1ecf ch\u1ee9c n\u0103ng b\u1ea3o v\u1ec1 b\u1ea3ng t\u00ednh \u2013 protect sheet<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ea7u ti\u00ean, ch\u00fang ta c\u1ea7n b\u1ecf ch\u1ee9c n\u0103ng b\u1ea3o v\u1ec7 b\u1ea3ng t\u00ednh hay n\u00f3i c\u00e1ch kh\u00e1c b\u1eb1ng ti\u1ebfng anh: unprotect sheet b\u1eb1ng c\u00e1ch v\u00e0o th\u1ebb <strong>Review\u00a0<\/strong><\/p>\n<p>N\u1ebfu trong nh\u00f3m l\u1ec7nh\u00a0<em>Protect,\u00a0<\/em>c\u00f3 n\u00fat\u00a0<strong>Protect\u00a0<\/strong>nh\u01b0 h\u00ecnh ngh\u0129a l\u00e0 b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1edf kho\u00e1, b\u1ea1n kh\u00f4ng c\u1ea7n l\u00e0m th\u00eam g\u00ec c\u1ea3 m\u00e0 c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c \u1edf b\u01b0\u1edbc sau<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/an-cong-thuc-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31603\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/an-cong-thuc-trong-excel.png\" alt=\"\u1ea8n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel\" width=\"595\" height=\"167\" title=\"an-cong-thuc-trong-excel\"><\/a><\/p>\n<p>N\u1ebfu trong nh\u00f3m l\u1ec7nh\u00a0<em>Protect,\u00a0<\/em>c\u00f3 n\u00fat\u00a0<strong>Unprotect Sheet\u00a0<\/strong>nh\u01b0 h\u00ecnh d\u01b0\u1edbi, th\u00ec b\u1ea1n c\u1ea7n m\u1edf kho\u00e1 b\u1ea3ng t\u00ednh b\u1eb1ng vi\u1ec7c b\u1ea5m n\u00fat n\u00e0y v\u00e0 nh\u1eadp m\u1eadt kh\u1ea9u (n\u1ebfu c\u00f3) \u0111\u1ec3 m\u1edf b\u1ea3ng t\u00ednh ra tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u v\u1edbi b\u01b0\u1edbc ti\u1ebfp theo. N\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft m\u1eadt kh\u1ea9u \u0111\u1ec3 m\u1edf kho\u00e1, b\u1ea1n c\u1ea7n h\u1ecfi ng\u01b0\u1eddi \u0111\u00e3 g\u1eedi cho b\u1ea1n file Excel n\u00e0y.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/an-cong-thuc-trong-excel-unprotect.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31604 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/an-cong-thuc-trong-excel-unprotect.png\" alt=\"\u1ea8n c\u00f4ng th\u1ee9c trong Excel\" width=\"595\" height=\"147\" title=\"an-cong-thuc-trong-excel-unprotect\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"An_cong_thuc_trong_bang_tinh_Excel\"><\/span><span style=\"font-size: 14pt\">\u1ea8n c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f4ng th\u1ee9c c\u1ea7n \u1ea9n c\u00f3 th\u1ec3 n\u1eb1m \u1edf 1 hay nhi\u1ec1u \u00f4 kh\u00e1c nhau, \u0111\u1ec3 \u1ea9n c\u00f4ng th\u1ee9c trong 1 \u00f4 hay 1 v\u00f9ng tr\u00ean 1 b\u1ea3ng t\u00ednh Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn cho 1 \u00f4, hay nhi\u1ec1u v\u00f9ng kh\u00e1c nhau. Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c trong \u00f4 A1 nh\u01b0 sau<\/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\/2024\/12\/ex101_92019-nho-647.gif\" title=\"ex101_92019-nho-647\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_31605\" aria-describedby=\"caption-attachment-31605\" style=\"width: 247px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/an-cong-thuc-trong-bang-tinh-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31605\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/an-cong-thuc-trong-bang-tinh-excel.png\" alt=\"C\u00f4ng th\u1ee9c c\u1ea7n \u1ea9n trong \u00f4 A1\" width=\"247\" height=\"85\" title=\"an-cong-thuc-trong-bang-tinh-excel\"><\/a><figcaption id=\"caption-attachment-31605\" class=\"wp-caption-text\">C\u00f4ng th\u1ee9c c\u1ea7n \u1ea9n trong \u00f4 A1<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3 ch\u00fang ta b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng c\u1ea7n \u1ea9n c\u00f4ng th\u1ee9c v\u00e0 ch\u1ecdn trong menu ng\u1eef c\u1ea3nh\u00a0<strong>Format Cells\u2026\u00a0<\/strong>ho\u1eb7c b\u1ea5m ph\u00edm t\u1eaft CTRL + 1<\/p>\n<figure id=\"attachment_31606\" aria-describedby=\"caption-attachment-31606\" style=\"width: 350px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/an-cong-thuc-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31606\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/an-cong-thuc-excel.png\" alt=\"M\u1edf h\u1ed9p tho\u1ea1i Format Cells\" width=\"350\" height=\"439\" title=\"an-cong-thuc-excel\"><\/a><figcaption id=\"caption-attachment-31606\" class=\"wp-caption-text\">M\u1edf h\u1ed9p tho\u1ea1i Format Cells<\/figcaption><\/figure>\n<p>Trong h\u1ed9p tho\u1ea1i\u00a0<em>Format Cells\u2026\u00a0<\/em>ch\u00fang ta ch\u1ecdn th\u1ebb\u00a0<em>Protection\u00a0<\/em>sau \u0111\u00f3 t\u00edch v\u00e0o h\u1ed9p ki\u1ec3m \u1edf\u00a0<em>Hidden\u00a0<\/em>r\u1ed3i b\u1ea5m n\u00fat\u00a0<em>OK<\/em><\/p>\n<figure id=\"attachment_31607\" aria-describedby=\"caption-attachment-31607\" style=\"width: 350px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/an-cong-thuc-hop-thoai-format-cells.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31607\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/an-cong-thuc-hop-thoai-format-cells.png\" alt=\"Ch\u1ecdn hidden trong h\u1ed9p tho\u1ea1i Format Cells\" width=\"350\" height=\"385\" title=\"an-cong-thuc-hop-thoai-format-cells\"><\/a><figcaption id=\"caption-attachment-31607\" class=\"wp-caption-text\">Ch\u1ecdn hidden trong h\u1ed9p tho\u1ea1i Format Cells<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3, b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng t\u00ednh (sheet) hi\u1ec7n t\u1ea1i v\u00e0 ch\u1ecdn\u00a0<em>Protect sheet\u2026<\/em><\/p>\n<figure id=\"attachment_31608\" aria-describedby=\"caption-attachment-31608\" style=\"width: 350px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/chon-protect-sheet-an-cong-thuc-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31608\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-protect-sheet-an-cong-thuc-excel.png\" alt=\"Ch\u1ecdn protect sheet\" width=\"350\" height=\"549\" title=\"chon-protect-sheet-an-cong-thuc-excel\"><\/a><figcaption id=\"caption-attachment-31608\" class=\"wp-caption-text\">Ch\u1ecdn protect sheet<\/figcaption><\/figure>\n<p>Trong h\u1ed9p tho\u1ea1i\u00a0<em>Protect Sheet,\u00a0<\/em>b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t m\u1eadt kh\u1ea9u ho\u1eb7c kh\u00f4ng \u0111\u1eb7t, c\u00e1c thi\u1ebft l\u1eadp c\u01a1 b\u1ea3n nh\u01b0 h\u00ecnh minh ho\u1ea1<\/p>\n<figure id=\"attachment_31609\" aria-describedby=\"caption-attachment-31609\" style=\"width: 350px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cua-so-thiet-lap-protect-sheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31609\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cua-so-thiet-lap-protect-sheet.png\" alt=\"C\u1eeda s\u1ed5 thi\u1ebft l\u1eadp Protect Sheet\" width=\"350\" height=\"468\" title=\"cua-so-thiet-lap-protect-sheet\"><\/a><figcaption id=\"caption-attachment-31609\" class=\"wp-caption-text\">C\u1eeda s\u1ed5 thi\u1ebft l\u1eadp Protect Sheet<\/figcaption><\/figure>\n<p>Sau khi b\u1ea5m OK, b\u1ea1n ch\u1ecdn \u00f4 A1 v\u00e0 c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111i.<\/p>\n<p>Nh\u01b0 v\u1eady, vi\u1ec7c<strong> \u1ea9n c\u00f4ng th\u1ee9c trong Excel<\/strong> c\u0169ng kh\u00f4ng qu\u00e1 kh\u00f3 kh\u0103n n\u1ebfu ch\u00fang ta \u0111\u1ecdc qua b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> xin ch\u00fac c\u00e1c b\u1ea1n t\u00ecm \u0111\u01b0\u1ee3c nh\u1eefng \u1ee9ng d\u1ee5ng t\u1ed1t cho ki\u1ebfn th\u1ee9c \u0111\u00e3 h\u1ecdc \u0111\u01b0\u1ee3c trong b\u00e0i vi\u1ebft ng\u00e0y h\u00f4m nay. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\"><strong>Excel K\u1ebf to\u00e1n<\/strong><\/a>\u00a0c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 h\u1ed7 tr\u1ee3 cho c\u00f4ng vi\u1ec7c nh\u00e9.<\/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\/2024\/12\/ex101_92019-nho-647.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7160,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7159","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\/7159","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=7159"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7159\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7160"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}