{"id":784,"date":"2024-12-02T02:49:25","date_gmt":"2024-12-02T02:49:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016\/"},"modified":"2024-12-02T02:49:25","modified_gmt":"2024-12-02T02:49:25","slug":"huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn hi\u1ec3n th\u1ecb v\u00e0 in c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh Excel 2010, 2013 v\u00e0 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 <strong>hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel<\/strong> 2016, 2013, 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n; c\u00e1c <strong>ph\u00edm t\u1eaft hi\u1ec7n c\u00f4ng th\u1ee9c trong excel<\/strong>. \u0110\u1ed3ng th\u1eddi, H\u1ecdc Excel Online c\u0169ng h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch <strong>in c\u00f4ng th\u1ee9c<\/strong> c\u0169ng nh\u01b0 gi\u1ea3i th\u00edch t\u1ea1i sao th\u1ec9nh tho\u1ea3ng Excel hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c, thay v\u00ec k\u1ebft qu\u1ea3 trong m\u1ed9t \u00f4 t\u00ednh.<\/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-674d2034ee09e\" 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\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016.html#Cach_hien_thi_cong_thuc_trong_Excel\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel:\">C\u00e1ch hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel:<\/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\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016.html#Phim_tat_hien_cong_thuc_Excel\" title=\"Ph\u00edm t\u1eaft hi\u1ec7n c\u00f4ng th\u1ee9c Excel:\">Ph\u00edm t\u1eaft hi\u1ec7n c\u00f4ng th\u1ee9c Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016.html#Cach_in_cong_thuc_trong_Excel\" title=\"C\u00e1ch in c\u00f4ng th\u1ee9c trong Excel:\">C\u00e1ch in c\u00f4ng th\u1ee9c trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016.html#Tai_sao_Excel_hien_thi_cong_thuc_khong_phai_ket_qua\" title=\"T\u1ea1i sao Excel hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c, kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3?\">T\u1ea1i sao Excel hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c, kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_cong_thuc_trong_Excel\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>1. L\u1ef1a ch\u1ecdn \u2018Show Formulas\u2019<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 th\u1ec3 xem c\u00f4ng th\u1ee9c tr\u00ean Excel, Tr\u00ean trang t\u00ednh Excel, di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Formulas, <\/em><\/strong>nh\u1ea5n ch\u1ecdn <strong><em>Show Formulas <\/em><\/strong>trong ph\u1ea7n<strong><em> Formula Auditing.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Microsoft Excel <\/strong>l\u1eadp t\u1ee9c hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 t\u00ednh thay v\u00ec k\u1ebft qu\u1ea3. \u0110\u1ec3 hi\u1ec3n th\u1ecb l\u1ea1i k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n, nh\u1ea5p ch\u1ecdn <strong><em>Show Formulas <\/em><\/strong>m\u1ed9t\u00a0 l\u1ea7n n\u1eefa.<\/p>\n<p>\u00a0<\/p>\n<figure id=\"attachment_37371\" aria-describedby=\"caption-attachment-37371\" style=\"width: 764px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37371 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-show-hide-formula-bar-01.png\" alt=\"The Show Formulas option on the Excel ribbon\" width=\"764\" height=\"168\" title=\"doc-show-hide-formula-bar-01\"><figcaption id=\"caption-attachment-37371\" class=\"wp-caption-text\">The Show Formulas option on the Excel ribbon<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>2. L\u1ef1a ch\u1ecdn \u2018Show formulas in cells instead of their results\u2019<\/strong><\/p>\n<p style=\"text-align: justify\">Trong Excel 2010, 2013, 2016, di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>File <\/em><\/strong><em>&gt; <strong>Options. <\/strong><\/em>Trong Excel 2007, nh\u1ea5p v\u00e0o <strong><em>Office Button <\/em><\/strong><em>&gt; <strong>Excel 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-15.gif\" title=\"vba101_92019-nho-15\"><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-44.gif\" title=\"ex101_92019-nho-44\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Ch\u1ecdn <strong><em>Advanced<\/em><\/strong> \u1edf b\u1ea3ng b\u00ean tr\u00e1i, k\u00e9o xu\u1ed1ng ph\u1ea7n<strong><em> Display options for this worksheet <\/em><\/strong>v\u00e0 \u0111\u00e1nh d\u1ea5u ch\u1ecdn<strong><em> Show formulas in cells instead of their calculated results.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Tho\u1ea1t ti\u00ean, c\u00e1ch s\u1eed d\u1ee5ng n\u00e0y c\u00f3 v\u1ebb m\u1ea5t nhi\u1ec1u th\u1eddi gian h\u01a1n, nh\u01b0ng b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 hi\u1ec7u qu\u1ea3 khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong nhi\u1ec1u trang t\u00ednh. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn t\u00ean trang t\u00ednh t\u1eeb danh s\u00e1ch l\u1ef1a ch\u1ecdn c\u1ee7a <strong><em>Display options for this worksheet.<\/em><\/strong><\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4556 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/show-formulas-in-cells.png\" width=\"600\" height=\"335\" title=\"show-formulas-in-cells\"><\/p>\n<blockquote>\n<p style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">T\u1ef1 h\u1ecdc Excel 2010 <\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Phim_tat_hien_cong_thuc_Excel\"><\/span>Ph\u00edm t\u1eaft hi\u1ec7n c\u00f4ng th\u1ee9c Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u1ea5y m\u1ecdi c\u00f4ng th\u1ee9c trong trang t\u00ednh Excel l\u00e0 nh\u1ea5n theo <strong>ph\u00edm t\u1eaft hi\u1ec7n c\u00f4ng th\u1ee9c trong excel<\/strong> sau \u0111\u00e2y: <strong>Ctrl + ` <\/strong>(ph\u00edm ` ngay k\u1ebf ph\u00edm s\u1ed1 1)<\/p>\n<p style=\"text-align: justify\">Ph\u00edm t\u1eaft n\u00e0y c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb \u00f4 t\u00ednh v\u00e0 c\u00f4ng th\u1ee9c \u00f4 t\u00ednh. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n <strong>Ctrl + ` <\/strong>m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>Cho d\u00f9 b\u1ea1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0o, Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c tr\u00ean <strong>trang t\u00ednh \u0111ang l\u00e0m vi\u1ec7c. <\/strong>\u0110\u1ec3 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong trang t\u00ednh ho\u1eb7c b\u1ea3ng t\u00ednh kh\u00e1c, b\u1ea1n c\u1ea7n l\u1eb7p l\u1ea1i thao t\u00e1c tr\u00ean t\u1eebng trang t\u00ednh\/b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n xem d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho vi\u1ec7c t\u00ednh to\u00e1n theo c\u00f4ng th\u1ee9c, s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 ph\u01b0\u01a1ng ph\u00e1p n\u00e0o ph\u00eda tr\u00ean \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 t\u00ednh, sau \u0111\u00f3 ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ea7n th\u1ef1c hi\u1ec7n, v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/show-formula-dependencies.png\" alt=\"Viewing the data used in the formula calculations\" title=\"show-formula-dependencies\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n nh\u1ea5p ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh v\u1edbi c\u00f4ng th\u1ee9c, nh\u01b0ng c\u00f4ng th\u1ee9c \u0111\u00f3 kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean thanh c\u00f4ng th\u1ee9c, nh\u01b0 v\u1eady r\u1ea5t c\u00f3 kh\u1ea3 n\u0103ng c\u00f4ng th\u1ee9c n\u00e0y \u0111\u00e3 b\u1ecb \u1ea9n \u0111i v\u00e0 trang t\u00ednh n\u00e0y \u0111ang \u0111\u01b0\u1ee3c b\u1ea3o m\u1eadt.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/phim-tat\">Tra c\u1ee9u ph\u00edm t\u1eaft Excel nhanh v\u1edbi H\u1ecdc Excel Online<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_in_cong_thuc_trong_Excel\"><\/span><strong>C\u00e1ch in c\u00f4ng th\u1ee9c trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n <strong>in c\u00f4ng th\u1ee9c<\/strong> trong trang t\u00ednh Excel thay v\u00ec in k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n, ch\u1ec9 c\u1ea7n 3 ph\u01b0\u01a1ng ph\u00e1p hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 t\u00ednh, sau \u0111\u00f3 in trang t\u00ednh nh\u01b0 b\u00ecnh th\u01b0\u1eddng (<strong><em>File <\/em><\/strong><em>&gt; <strong>Print<\/strong><\/em>).<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tai_sao_Excel_hien_thi_cong_thuc_khong_phai_ket_qua\"><\/span><strong>T\u1ea1i sao Excel hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c, kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u00ecn chung, Microsoft Excel hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c thay v\u00ec gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n do nh\u1eefng l\u00fd do sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong>Nguy\u00ean nh\u00e2n 1.<\/strong> C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 v\u00f4 t\u00ecnh ch\u1ecdn <strong><em>Show Formulas<\/em><\/strong>, ho\u1eb7c nh\u1ea5n <strong><em>Ctrl + `<\/em><\/strong>. \u0110\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n, b\u1ecf ch\u1ecdn <strong><em>Show Formulas<\/em><\/strong> ho\u1eb7c nh\u1ea5n ph\u00edm <strong><em>Ctrl + `<\/em><\/strong> l\u1ea7n n\u1eefa.<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c b\u1eadt t\u00ednh n\u0103ng\u00a0<strong>Show Formulas<\/strong> s\u1ebd hi\u1ec3n th\u1ecb\u00a0<strong>to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c<\/strong>. B\u1edfi v\u1eady, n\u1ebfu b\u1ea1n g\u1eb7p v\u1ea5n \u0111\u1ec1 v\u1edbi\u00a0<strong>ch\u1ec9 m\u1ed9t<\/strong> ho\u1eb7c\u00a0<strong>m\u1ed9t s\u1ed1<\/strong> c\u00f4ng th\u1ee9c, l\u1ed7i kh\u00f4ng n\u1eb1m \u1edf\u00a0<strong>Show Formulas.<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Nguy\u00ean nh\u00e2n 2.<\/strong> C\u00f3 th\u1ec3 b\u1ea1n v\u00f4 t\u00ecnh g\u00f5 m\u1ed9t kho\u1ea3ng tr\u1eafng ho\u1eb7c d\u1ea5u nh\u00e1y \u0111\u01a1n (<strong>\u2018<\/strong>) tr\u01b0\u1edbc d\u1ea5u b\u1eb1ng trong c\u00f4ng th\u1ee9c<\/p>\n<p style=\"text-align: justify\">Khi m\u1ed9t kho\u1ea3ng tr\u1eafng ho\u1eb7c m\u1ed9t d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1eb7t tr\u01b0\u1edbc d\u1ea5u b\u1eb1ng, Excel s\u1ebd xem \u00f4 t\u00ednh nh\u01b0 m\u1ed9t v\u0103n b\u1ea3n th\u00f4ng th\u01b0\u1eddng v\u00e0 kh\u00f4ng th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 \u0111\u00f3. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n x\u00f3a d\u1ea5u nh\u00e1y \u0111\u01a1n ho\u1eb7c kho\u1ea3ng tr\u1eafng \u1ea5y \u0111i.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-shows-formula-not-result.png\" alt=\"Here's why Excel shows a formula, not result.\" title=\"excel-shows-formula-not-result\"><\/p>\n<p style=\"text-align: justify\"><strong>Nguy\u00ean nh\u00e2n 3.<\/strong> Tr\u01b0\u1edbc khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 t\u00ednh, c\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng <strong><em>Text <\/em><\/strong>\u00a0cho \u00f4 \u0111\u00f3. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Excel s\u1ebd xem \u00f4 \u0111\u00f3 ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i v\u00e0 kh\u00f4ng th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh v\u1edbi n\u00f3.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/formula-entered-as-text.png\" alt=\"Excel formulas entered as text display as formulas in cells and are not calculated.\" title=\"formula-entered-as-text\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, ch\u1ecdn \u00f4 t\u00ednh \u0111\u00f3, v\u00e0o th\u1ebb <strong><em>Home <\/em><\/strong><em>&gt; <strong>Number<\/strong><\/em>, ch\u1ecdn l\u1ea1i \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh l\u00e0 <strong><em>General<\/em><\/strong>, quay l\u1ea1i trang t\u00ednh v\u00e0 nh\u1ea5n F2.<\/p>\n<p><strong>Ho\u1eb7c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0ng thi\u1ebfu d\u1ea5u \u201c=\u201d<\/strong><\/p>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n qu\u00ean nh\u1eadp d\u1ea5u \u201c<strong>=<\/strong>\u201d \u0111\u1eb1ng tr\u01b0\u1edbc c\u00f4ng th\u1ee9c. Khi \u0111\u00f3, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd th\u00e0nh\u00a0<em><strong>SUM(A7:C7)<\/strong>\u00a0<\/em>v\u00e0 b\u1ecb li\u1ec7t k\u00ea v\u00e0o TEXT.<\/p>\n<figure id=\"attachment_25805\" aria-describedby=\"caption-attachment-25805\" style=\"width: 345px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25805 size-full\" title='Thi\u1ebfu d\u1ea5u \"=\"' src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-khong-hien-ket-qua-5.png\" alt='Thi\u1ebfu d\u1ea5u \"=\"' width=\"345\" height=\"126\"><figcaption id=\"caption-attachment-25805\" class=\"wp-caption-text\">Thi\u1ebfu d\u1ea5u \u201c=\u201d<\/figcaption><\/figure>\n<p><strong>\u0110\u01b0a c\u00f4ng th\u1ee9c v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p<\/strong><\/p>\n<p>\u0110\u00f4i khi ta b\u1ecb nh\u1ea7m l\u1eabn v\u00e0 \u0111\u1eb7t c\u00f4ng th\u1ee9c v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p. Khi \u0111\u00f3, c\u00f4ng th\u1ee9c c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng\u00a0<strong>TEXT:<\/strong><\/p>\n<figure id=\"attachment_25807\" aria-describedby=\"caption-attachment-25807\" style=\"width: 383px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25807 size-full\" title=\"\u0110\u01b0a c\u00f4ng th\u1ee9c v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-khong-hien-ket-qua-7.png\" alt=\"\u0110\u01b0a c\u00f4ng th\u1ee9c v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p\" width=\"383\" height=\"121\"><figcaption id=\"caption-attachment-25807\" class=\"wp-caption-text\">\u0110\u01b0a c\u00f4ng th\u1ee9c v\u00e0o trong d\u1ea5u nh\u00e1y k\u00e9p<\/figcaption><\/figure>\n<p><strong>\u0110\u1ecbnh d\u1ea1ng TEXT b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>D\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u s\u1ebd \u0111\u01b0\u1ee3c \u1ea9n \u0111i v\u00e0 Excel hi\u1ec3u d\u1eef li\u1ec7u trong \u00f4 l\u00e0\u00a0<strong>TEXT:<\/strong><\/p>\n<figure id=\"attachment_25808\" aria-describedby=\"caption-attachment-25808\" style=\"width: 384px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25808 size-full\" title=\"\u0110\u1ecbnh d\u1ea1ng TEXT b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-khong-hien-ket-qua-8.png\" alt=\"\u0110\u1ecbnh d\u1ea1ng TEXT b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u\" width=\"384\" height=\"169\"><figcaption id=\"caption-attachment-25808\" class=\"wp-caption-text\">\u0110\u1ecbnh d\u1ea1ng TEXT b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 t\u00ecm hi\u1ec3u nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi Excel kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 m\u00e0 ch\u1ec9 \u0111\u01b0a c\u00f4ng th\u1ee9c r\u1ed3i. B\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng <strong>excel ch\u1ec9 hi\u1ec7n c\u00f4ng th\u1ee9c kh\u00f4ng hi\u1ec7n k\u1ebft qu\u1ea3<\/strong>.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel.Online.<\/em><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\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\/2wc4dYg\">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: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">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\/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-15.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":785,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-784","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\/784","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=784"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/784\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/785"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}