{"id":1010,"date":"2024-12-02T03:53:21","date_gmt":"2024-12-02T03:53:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-sua-loi-khong-nhan-cong-thuc-trong-excel-2007-2010-2013-2016\/"},"modified":"2024-12-02T03:53:21","modified_gmt":"2024-12-02T03:53:21","slug":"cach-sua-loi-khong-nhan-cong-thuc-trong-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-sua-loi-khong-nhan-cong-thuc-trong-excel-2007-2010-2013-2016\/","title":{"rendered":"C\u00e1ch s\u1eeda l\u1ed7i kh\u00f4ng nh\u1eadn c\u00f4ng th\u1ee9c trong Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"kh\u00f4ng-th\u1ef1c-hi\u1ec7n-\u0111\u01b0\u1ee3c-ph\u00e9p-t\u00ednh-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-khong-nhan-cong-thuc-excel-2007-2010-2013-2016.html?khong-thuc-hien-duoc-phep-tinh-trong-excel\">\n<p><em>Khi b\u1ea1n nh\u1eadp 1 c\u00f4ng th\u1ee9c v\u00e0o trong Excel m\u00e0\u00a0Excel kh\u00f4ng nh\u1eadn, ch\u1ec9 ghi l\u1ea1i n\u1ed9i dung c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng cho ra k\u1ebft qu\u1ea3, h\u1eb3n\u00a0\u0111i\u1ec1u n\u00e0y khi\u1ebfn b\u1ea1n th\u1eadt\u00a0b\u1ed1i r\u1ed1i. H\u00e3y v\u00f9ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc\u00a0Excel Online<\/a><\/strong> t\u00ecm hi\u1ec3u c\u00e1ch s\u1eeda l\u1ed7i kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh trong excel\u00a0nh\u00e9.<\/em><\/p>\n<\/blockquote>\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-674d2f30802fc\" 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-sua-loi-khong-nhan-cong-thuc-excel-2007-2010-2013-2016.html#Cach_sua_loi_Excel_khong_nhan_cong_thuc\" title=\"C\u00e1ch s\u1eeda l\u1ed7i\u00a0Excel kh\u00f4ng nh\u1eadn c\u00f4ng th\u1ee9c\">C\u00e1ch s\u1eeda l\u1ed7i\u00a0Excel kh\u00f4ng nh\u1eadn c\u00f4ng th\u1ee9c<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-khong-nhan-cong-thuc-excel-2007-2010-2013-2016.html#Thu_1_Nhap_cong_thuc_vao_1_o_dang_dinh_dang_Text\" title=\"Th\u1ee9 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o 1\u00a0\u00f4\u00a0\u0111ang\u00a0\u0111\u1ecbnh d\u1ea1ng Text\">Th\u1ee9 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o 1\u00a0\u00f4\u00a0\u0111ang\u00a0\u0111\u1ecbnh d\u1ea1ng Text<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-loi-khong-nhan-cong-thuc-excel-2007-2010-2013-2016.html#Thu_2_Excel_dang_o_che_do_chi_hien_thi_cong_thuc\" title=\"Th\u1ee9 2:\u00a0Excel\u00a0\u0111ang\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c\">Th\u1ee9 2:\u00a0Excel\u00a0\u0111ang\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sua_loi_Excel_khong_nhan_cong_thuc\"><\/span>C\u00e1ch s\u1eeda l\u1ed7i\u00a0Excel kh\u00f4ng nh\u1eadn c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 2 tr\u01b0\u1eddng h\u1ee3p l\u1ed7i<strong> kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh trong excel<\/strong> n\u00e0y x\u1ea3y ra:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thu_1_Nhap_cong_thuc_vao_1_o_dang_dinh_dang_Text\"><\/span>Th\u1ee9 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o 1\u00a0\u00f4\u00a0\u0111ang\u00a0\u0111\u1ecbnh d\u1ea1ng Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17658\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-loi-khong-nhan-cong-thuc-01.png\" width=\"887\" height=\"267\" title=\"heo-loi-khong-nhan-cong-thuc-01\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta th\u1ea5y\u00a0\u00f4 A1\u00a0\u0111ang\u00a0\u0111\u1ecbnh d\u1ea1ng Text.<\/p>\n<p>Khi nh\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng c\u00e1c\u00a0\u00f4 t\u1eeb C1\u00a0\u0111\u1ebfn C5 th\u00ec kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng m\u00e0 l\u1ea1i ch\u1ec9 ghi l\u1ea1i n\u1ed9i dung c\u1ee7a h\u00e0m SUM<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n<ul>\n<li>\u0110\u1ecbnh\u00a0\u0111\u1ea1ng l\u1ea1i cho\u00a0\u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u1ec1 d\u1ea1ng kh\u00e1c <strong>kh\u00f4ng ph\u1ea3i d\u1ea1ng Text<\/strong><\/li>\n<li>Double click (b\u1ea5m chu\u1ed9t 2 l\u1ea7n) v\u00e0o c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 v\u00e0o ch\u1ebf \u0111\u1ed9 s\u1eeda c\u00f4ng th\u1ee9c, sau\u00a0\u0111\u00f3 b\u1ea5m Enter\u00a0\u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i c\u00f4ng th\u1ee9c. Khi\u00a0\u0111\u00f3\u00a0Excel s\u1ebd nh\u1eadn c\u00f4ng th\u1ee9c v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-hien-thi-va-in-cong-thuc-trong-bang-tinh-excel-2010-2013-va-2016.html\">xem c\u00f4ng th\u1ee9c trong Excel<\/a> b\u1ecb \u1ea9n \u0111i<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thu_2_Excel_dang_o_che_do_chi_hien_thi_cong_thuc\"><\/span>Th\u1ee9 2:\u00a0Excel\u00a0\u0111ang\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 1 ch\u1ebf\u00a0\u0111\u1ed9 c\u1ee7a\u00a0Excel,\u00a0\u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp trong m\u1ee5c <strong>Options\/Advanced\/Show formulas in cells\u00a0instead\u00a0of their calculated results <\/strong>(ph\u00edm t\u1eaft ctrl + `)<\/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-68.gif\" title=\"ex101_92019-nho-68\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17665\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-loi-khong-nhan-cong-thuc-02.png\" width=\"660\" height=\"358\" title=\"heo-loi-khong-nhan-cong-thuc-02\"><\/p>\n<p>\u1ede ch\u1ebf\u00a0\u0111\u1ed9 n\u00e0y to\u00e0n b\u1ed9 c\u00e1c c\u00f4ng th\u1ee9c trong 1 sheet s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb n\u1ed9i dung c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/p>\n<p>Khi b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c th\u00ec c\u0169ng ch\u1ec9 tr\u1ea3 v\u1ec1 n\u1ed9i dung c\u00f4ng th\u1ee9c ch\u1ee9 kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong><\/p>\n<ul>\n<li>T\u1eaft t\u00ednh n\u0103ng n\u00e0y b\u1eb1ng c\u00e1ch b\u1ecf d\u1ea5u t\u00edch trong m\u1ee5c\u00a0Show formulas in cells\u00a0instead\u00a0of their calculated results<\/li>\n<li>Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m ph\u00edm t\u1eaft Ctrl + ` m\u1ed9t l\u1ea7n n\u1eefa\u00a0\u0111\u1ec3 t\u1eaft t\u00ednh n\u0103ng ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p><strong>T\u1ea1i sao\u00a0Excel l\u1ea1i c\u00f3 ch\u1ebf\u00a0\u0111\u1ed9 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c<\/strong><\/p>\n<ul>\n<li>Nh\u1eb1m gi\u00fap ng\u01b0\u1eddi d\u00f9ng s\u1eeda n\u1ed9i dung c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c nhanh h\u01a1n,\u00a0Excel cho ph\u00e9p\u00a0\u0111\u01b0a tr\u1ea1ng th\u00e1i Sheet v\u1ec1 d\u1ea1ng ch\u1ec9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3\u00a0vi\u1ec7c s\u1eeda c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c nhanh h\u01a1n, d\u1ec5 d\u00e0ng h\u01a1n, tr\u00e1nh nh\u1ea7m l\u1eabn v\u1edbi c\u00e1c n\u1ed9i dung kh\u00e1c.<\/li>\n<li>T\u00e1c d\u1ee5ng th\u1ee9 2 l\u00e0 gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n ra nh\u1eefng v\u1ecb tr\u00ed c\u00f3 c\u00f4ng th\u1ee9c m\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 r\u1ed7ng, khi\u1ebfn b\u1ea1n kh\u00f4ng nh\u1eadn ra b\u1eb1ng m\u1eaft th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady\u00a0\u0111\u00e2y l\u00e0 1 t\u00ednh n\u0103ng trong\u00a0Excel, khi ch\u00fang ta hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y th\u00ec ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 tr\u00e1nh\u00a0\u0111\u01b0\u1ee3c c\u00e1c l\u1ed7i <strong>kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e9p t\u00ednh trong excel.<\/strong><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c. \u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t \u0111\u1ea7y \u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong Excel \u0111\u1ec3 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel. Chi ti\u1ebft kh\u00f3a h\u1ecdc xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/a><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-68.gif\" title=\"ex101_92019-nho-68\"><br \/>\n<\/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\/2024\/12\/ex101_92019-nho-68.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1011,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1010","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\/1010","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=1010"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1011"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}