{"id":9044,"date":"2024-12-31T22:45:39","date_gmt":"2024-12-31T22:45:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-1\/"},"modified":"2024-12-31T22:45:39","modified_gmt":"2024-12-31T22:45:39","slug":"19-tips-huu-hieu-cho-ham-if-long-nhau-phan-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-1\/","title":{"rendered":"19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau (Ph\u1ea7n 1)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n 19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau gi\u00fap vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y trong c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. B\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c d\u1ecbch v\u00e0 chia s\u1ebb l\u1ea1i t\u1eeb ExcelJet:\u00a0<a href=\"https:\/\/exceljet.net\/nested-ifs\">https:\/\/exceljet.net\/nested-ifs<\/a><\/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-6774741266feb\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Ham_IF_co_ban\" title=\"H\u00e0m IF c\u01a1 b\u1ea3n\">H\u00e0m IF c\u01a1 b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#The_nao_la_cong_thuc_long_nhau\" title=\"Th\u1ebf n\u00e0o l\u00e0 c\u00f4ng th\u1ee9c l\u1ed3ng nhau?\">Th\u1ebf n\u00e0o l\u00e0 c\u00f4ng th\u1ee9c l\u1ed3ng nhau?<\/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\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Ham_IF_long_nhau_don_gian\" title=\"H\u00e0m IF l\u1ed3ng nhau \u0111\u01a1n gi\u1ea3n\">H\u00e0m IF l\u1ed3ng nhau \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Xep_hang_bang_ham_IF_long_nhau\" title=\"X\u1ebfp h\u1ea1ng b\u1eb1ng h\u00e0m IF l\u1ed3ng nhau\">X\u1ebfp h\u1ea1ng b\u1eb1ng h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Logic_hoat_dong_cua_ham_IF_long_nhau\" title=\"Logic ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m IF l\u1ed3ng nhau\">Logic ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Cach_xem_logic_cua_ham_IF_long_nhau\" title=\"C\u00e1ch xem logic c\u1ee7a h\u00e0m IF l\u1ed3ng nhau\">C\u00e1ch xem logic c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Tinh_tung_thanh_phan_trong_cong_thuc_voi_phim_F9\" title=\"T\u00ednh t\u1eebng th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9\">T\u00ednh t\u1eebng th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Gioi_han_cua_ham_IF_long_nhau\" title=\"Gi\u1edbi h\u1ea1n c\u1ee7a h\u00e0m IF l\u1ed3ng nhau\">Gi\u1edbi h\u1ea1n c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Su_dung_dau_ngoac_hop_ly\" title=\"S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c h\u1ee3p l\u00fd\">S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c h\u1ee3p l\u00fd<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Su_dung_mau\" title=\"S\u1eed d\u1ee5ng m\u00e0u\">S\u1eed d\u1ee5ng m\u00e0u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#In_dam_trong_Windows\" title=\"In \u0111\u1eadm trong Windows\">In \u0111\u1eadm trong Windows<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Su_dung_goi_y_de_theo_doi_cong_thuc\" title=\"S\u1eed d\u1ee5ng g\u1ee3i \u00fd \u0111\u1ec3 theo d\u00f5i c\u00f4ng th\u1ee9c\">S\u1eed d\u1ee5ng g\u1ee3i \u00fd \u0111\u1ec3 theo d\u00f5i c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Nhap_dung_so_va_chu\" title=\"Nh\u1eadp \u0111\u00fang s\u1ed1 v\u00e0 ch\u1eef\">Nh\u1eadp \u0111\u00fang s\u1ed1 v\u00e0 ch\u1eef<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau.html#Xuong_dong_%E2%80%93_vi_mot_cong_thuc_de_nhin_hon\" title=\"Xu\u1ed1ng d\u00f2ng \u2013 v\u00ec m\u1ed9t c\u00f4ng th\u1ee9c d\u1ec5 nh\u00ecn h\u01a1n\">Xu\u1ed1ng d\u00f2ng \u2013 v\u00ec m\u1ed9t c\u00f4ng th\u1ee9c d\u1ec5 nh\u00ecn h\u01a1n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IF_co_ban\"><\/span>H\u00e0m IF c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi n\u00f3i t\u1edbi h\u00e0m IF l\u1ed3ng nhau, h\u00e3y ngh\u00eda m\u1ed9t ch\u00fat qua h\u00e0m IF c\u01a1 b\u1ea3n \u0111\u00e3:<\/p>\n<p><strong>=IF(bi\u1ec3u th\u1ee9c logic, [k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu \u0111\u00fang], [k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu sai])<\/strong><\/p>\n<p>H\u00e0m IF s\u1ebd \u0111\u1eb7t m\u1ed9t bi\u1ec3u th\u1ee9c logic v\u00e0o, ki\u1ec3m tra k\u1ebft qu\u1ea3 v\u00e0 \u0111\u01b0a ra gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong hai tr\u01b0\u1eddng h\u1ee3p \u0111\u00fang\/sai.<\/p>\n<p>H\u00e3y \u0111\u1ec3 \u00fd r\u1eb1ng d\u1ea5u ngo\u1eb7c vu\u00f4ng l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c. Tuy nhi\u00ean, b\u1ea1n ph\u1ea3i \u0111\u1eb7t v\u00e0o m\u1ed9t trong hai gi\u00e1 tr\u1ecb: k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu \u0111\u00fang ho\u1eb7c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu sai.<\/p>\n<p>Ta s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 <strong>\u0110\u1ed7\u00a0<\/strong>ho\u1eb7c\u00a0<strong>Tr\u01b0\u1ee3t\u00a0<\/strong>trong v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25846\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-1.png\" width=\"611\" height=\"256\" title=\"19-tips-if-1\"><\/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-852.gif\" title=\"ex101_92019-nho-852\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"The_nao_la_cong_thuc_long_nhau\"><\/span>Th\u1ebf n\u00e0o l\u00e0 c\u00f4ng th\u1ee9c l\u1ed3ng nhau?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c l\u1ed3ng nhau l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c bao g\u1ed3m nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c l\u1ed3ng gh\u00e9p v\u00e0o v\u1edbi nhau, c\u00e1i n\u00e0y trong c\u00e1i kia. C\u00f4ng th\u1ee9c ngo\u00e0i s\u1ebd x\u1eed l\u00fd k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c trong. V\u00ed d\u1ee5:<\/p>\n<p><strong><em>=MONTH(TODAY())<\/em><\/strong><\/p>\n<p>H\u00e0m TODAY s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m hi\u1ec7n t\u1ea1i. H\u00e0m MONTH s\u1ebd nh\u1eadn k\u1ebft qu\u1ea3 \u0111\u00f3 v\u00e0 tr\u1ea3 v\u1ec1 th\u00e1ng \u0111\u01b0\u1ee3c nh\u0103c \u0111\u1ebfn trong h\u00e0m TODAY.<\/p>\n<p>\u0110a ph\u1ea7n c\u00e1c c\u00f4ng th\u1ee9c hi\u1ec7n nay \u0111\u1ec1u x\u00e2y d\u1ef1ng d\u01b0\u1edbi d\u1ea1ng h\u00e0m l\u1ed3ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IF_long_nhau_don_gian\"><\/span>H\u00e0m IF l\u1ed3ng nhau \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t h\u00e0m IF l\u1ed3ng nhau \u0111\u01a1n gi\u1ea3n bao g\u1ed3m 2 h\u00e0m IF \u0111\u01b0\u1ee3c gh\u00e9p n\u1ed1i v\u1edbi nhau, m\u1ed9t h\u00e0m s\u1ebd n\u1eb1m trong h\u00e0m c\u00f2n l\u1ea1i.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u00ecnh dung \u0111\u01b0\u1ee3c ta s\u1ebd \u0111\u1ebfn v\u1edbi v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25847\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-2.png\" width=\"633\" height=\"258\" title=\"19-tips-if-2\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 C2 nh\u01b0 sau:<\/p>\n<p><em><strong>=IF(B2&lt;6.5,\u201dTrung b\u00ecnh\u201d,IF(B2&lt;8,\u201dKh\u00e1\u201d,\u201dGi\u1ecfi\u201d))<\/strong><\/em><\/p>\n<p>H\u00e0m IF \u1edf ngo\u00e0i s\u1ebd ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n li\u1ec7u B2 c\u00f3 nh\u1ecf h\u01a1n 6.5 kh\u00f4ng. N\u1ebfu k\u1ebft qu\u1ea3 l\u00e0 \u0111\u00fang, h\u00e0m tr\u1ea3 lu\u00f4n k\u1ebft qu\u1ea3 trung b\u00ecnh, n\u1ebfu kh\u00f4ng s\u1ebd ti\u1ebfn h\u00e0nh ki\u1ec3m tra h\u00e0m IF b\u00ean trong. N\u1ebfu B2 &lt; 8 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cKh\u00e1\u201d. Tr\u01b0\u1eddng h\u1ee3p c\u00f2n l\u1ea1i l\u00e0 \u201cGi\u1ecfi\u201d.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xep_hang_bang_ham_IF_long_nhau\"><\/span>X\u1ebfp h\u1ea1ng b\u1eb1ng h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n s\u1ebd th\u01b0\u1eddng th\u1ea5y v\u00ed d\u1ee5 tr\u00ean \u1edf ngo\u00e0i \u0111\u1eddi th\u1ef1c: x\u1ebfp h\u1ea1ng h\u1ecdc sinh d\u1ef1a v\u00e0o \u0111i\u1ec3m s\u1ed1. Ngo\u00e0i ra, ta c\u00f2n hay b\u1eaft g\u1eb7p nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ebfp th\u1ee9 b\u1eadc kh\u00e1c nh\u01b0 ph\u00ed ship, thu\u1ebf, gi\u00e1 tr\u1ecb theo m\u1ee9c\u2026<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau s\u1ebd l\u00e0 m\u1ed9t s\u1ef1 l\u1ef1a ch\u1ecdn. Tuy nhi\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft c\u00e1ch s\u1eafp x\u1ebfp \u0111\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng b\u1ecb lo\u1ea1n ho\u1eb7c sai th\u1ee9 b\u1eadc. T\u1ed1t nh\u1ea5t l\u00e0 x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25848\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-3.png\" width=\"429\" height=\"222\" title=\"19-tips-if-3\"><\/p>\n<p>Theo nh\u01b0 b\u1ea3ng tr\u00ean, ta s\u1ebd thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m IF nh\u01b0 sau:<\/p>\n<p><em><strong>=IF(\u0110i\u1ec3m &lt;5,\u201dK\u00e9m\u201d)<\/strong><\/em><\/p>\n<p><strong><em>=IF(\u0110i\u1ec3m &lt;5,\u201dK\u00e9m\u201d,IF(\u0110i\u1ec3m &lt;6.5,\u201dTrung b\u00ecnh\u201d))<\/em><\/strong><\/p>\n<p><em><strong>=IF(\u0110i\u1ec3m &lt;5,\u201dK\u00e9m\u201d,IF(\u0110i\u1ec3m &lt;6.5,\u201dTrung b\u00ecnh\u201d,IF(\u0110i\u1ec3m &lt;8,\u201dKh\u00e1\u201d)))<\/strong><\/em><\/p>\n<p>Cu\u1ed1i c\u00f9ng ta c\u00f3:<\/p>\n<p><em><strong>=IF(\u0110i\u1ec3m &lt;5,\u201dK\u00e9m\u201d,IF(\u0110i\u1ec3m &lt;6.5,\u201dTrung b\u00ecnh\u201d,IF(\u0110i\u1ec3m &lt;8,\u201dKh\u00e1\u201d,\u201dGi\u1ecfi\u201d))))<\/strong><\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Logic_hoat_dong_cua_ham_IF_long_nhau\"><\/span>Logic ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m IF l\u1ed3ng nhau ho\u1ea1t \u0111\u1ed9ng theo logic t\u1eeb ngo\u00e0i v\u00e0o trong, ngh\u0129a l\u00e0 Excel s\u1ebd ki\u1ec3m tra k\u1ebft qu\u1ea3 t\u1eeb ngo\u00e0i tr\u01b0\u1edbc r\u1ed3i m\u1edbi chuy\u1ec3n v\u00e0o trong.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25948\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-4.png\" width=\"700\" height=\"325\" title=\"19-tips-if-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_xem_logic_cua_ham_IF_long_nhau\"><\/span>C\u00e1ch xem logic c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>Evaluate formula\u00a0<\/strong>\u0111\u1ec3 ki\u1ec3m tra c\u00f4ng th\u1ee9c theo t\u1eebng b\u01b0\u1edbc. \u0110\u00e2y l\u00e0 c\u00e1ch h\u1eefu hi\u1ec7u \u0111\u1ec3 t\u00ecm ra l\u1ed7i c\u0169ng nh\u01b0 bi\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang\/sai th\u1ebf n\u00e0o.<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-5.png\" width=\"565\" height=\"351\" title=\"19-tips-if-5\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_tung_thanh_phan_trong_cong_thuc_voi_phim_F9\"><\/span>T\u00ednh t\u1eebng th\u00e0nh ph\u1ea7n trong c\u00f4ng th\u1ee9c v\u1edbi ph\u00edm F9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb m\u1ed9t ph\u1ea7n c\u00f4ng th\u1ee9c d\u01b0\u1edbi d\u1ea1ng k\u1ebft qu\u1ea3, h\u00e3y s\u1eed d\u1ee5ng ph\u00edm F9. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t c\u00e1ch \u0111\u1ec3 bi\u1ebft li\u1ec7u c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 \u0111ang ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang kh\u00f4ng. \u0110\u1eb7c bi\u1ec7t v\u1edbi h\u00e0m IF l\u1ed3ng nhau, \u0111\u00e2y l\u00e0 m\u1ed9t bi\u1ec7n ph\u00e1p r\u1ea5t h\u1eefu hi\u1ec7u \u0111\u1ec3 x\u1eed l\u00ed m\u00e0 kh\u00f4ng b\u1ecb r\u1ed1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25952\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-6.png\" width=\"551\" height=\"200\" title=\"19-tips-if-6\"><\/p>\n<p>\u0110\u1ec3 h\u1ee7y b\u1ecf vi\u1ec7c chuy\u1ec3n th\u00e0nh c\u00f4ng th\u1ee9c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm F9 ho\u1eb7c n\u00fat Esc \u0111\u1ec3 tho\u00e1t m\u00e0 kh\u00f4ng g\u00e2y ra b\u1ea5t c\u1ee9 thay \u0111\u1ed5i g\u00ec.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_han_cua_ham_IF_long_nhau\"><\/span>Gi\u1edbi h\u1ea1n c\u1ee7a h\u00e0m IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel c\u00f3 m\u1ed9t gi\u1edbi h\u1ea1n v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0m IF l\u1ed3ng nhau c\u1ee7a b\u1ea1n. \u0110\u1ed1i v\u1edbi b\u1ea3n 2007 tr\u1edf xu\u1ed1ng b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng t\u1ed1i \u0111a 7 l\u1ea7n. V\u1edbi b\u1ea3n 2007 v\u1ec1 sau, t\u0103ng l\u00ean 64 l\u1ea7n.<\/p>\n<p>D\u00f9 v\u1eady b\u1ea1n kh\u00f4ng n\u00ean l\u1ed3ng qu\u00e1 nhi\u1ec1u h\u00e0m IF, khi\u1ebfn cho c\u00f4ng th\u1ee9c tr\u1edf n\u00ean n\u1eb7ng n\u1ec1 v\u00e0 kh\u00f3 \u0111\u1ec3 ki\u1ec3m tra. C\u00f2n trong tr\u01b0\u1eddng h\u1ee3p b\u1eaft bu\u1ed9c, h\u00e3y ti\u1ebfp t\u1ee5c tham kh\u1ea3o nh\u1eefng tip d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_dau_ngoac_hop_ly\"><\/span>S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c h\u1ee3p l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t trong nh\u1eefng v\u1ea5n \u0111\u1ec1 c\u1ea7n quan t\u00e2m kh\u1ec9 s\u1eed d\u1ee5ng h\u00e0m IF l\u1ed3ng nhau \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c h\u1ee3p l\u00fd. N\u1ebfu b\u1ea1n sai d\u1ea5u, \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u00f4ng th\u1ee9c kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. Hi\u1ec3u \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, Excel cung c\u1ea5p cho b\u1ea1n c\u00e1ch \u0111\u1ec3 nh\u1eadn bi\u1ebft v\u1ecb tr\u00ed c\u00e1c d\u1ea5u h\u1ee3p l\u00fd.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_mau\"><\/span>S\u1eed d\u1ee5ng m\u00e0u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed7i c\u1eb7p d\u1ea5u ngo\u1eb7c trong Excel \u0111\u01b0\u1ee3c t\u00f4 m\u1ed9t m\u00e0u ri\u00eang bi\u1ec7t. N\u1ebfu m\u1edf \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac c\u1ee7a b\u1ea1n c\u00f3 m\u00e0u kh\u00e1c nhau, b\u1ea1n sai.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25953\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-7.png\" width=\"423\" height=\"109\" title=\"19-tips-if-7\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"In_dam_trong_Windows\"><\/span>In \u0111\u1eadm trong Windows<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel tr\u00ean Windows, khi b\u1ea1n di chuy\u1ec3n d\u1ea5u nh\u00e1y tr\u00ean thanh c\u00f4ng th\u1ee9c qua d\u1ea5u ngo\u1eb7c, c\u1ea3 \u0111\u1ea7u v\u00e0 \u0111u\u00f4i s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u1eadm l\u00ean.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25954\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel.gif\" width=\"494\" height=\"293\" title=\"excel\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_goi_y_de_theo_doi_cong_thuc\"><\/span>S\u1eed d\u1ee5ng g\u1ee3i \u00fd \u0111\u1ec3 theo d\u00f5i c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>G\u1ee3i \u00fd c\u1ee7a Excel s\u1ebd gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t \u0111\u01b0\u1ee3c m\u00ecnh \u0111ang \u1edf \u0111\u00e2u c\u1ee7a c\u00f4ng th\u1ee9c, nh\u1eb1m tr\u00e1nh nh\u1eefng tr\u01b0\u1eddng h\u1ee3p nh\u1eadp sai d\u1ea5u. V\u00ed d\u1ee5: nh\u1eadp d\u1ea5u ch\u1ea5m ph\u1ea9y th\u00e0nh ph\u1ea9y v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/p>\n<figure id=\"attachment_25955\" aria-describedby=\"caption-attachment-25955\" style=\"width: 303px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25955\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-8.png\" width=\"303\" height=\"77\" title=\"19-tips-if-8\"><figcaption id=\"caption-attachment-25955\" class=\"wp-caption-text\">G\u1ee3i \u00fd cho th\u1ea5y v\u1ecb tr\u00ed \u0111\u1eb7t d\u1ea5u nh\u00e1y (h\u00e0m IF th\u1ee9 2) \u0111ang \u1edf \u0111\u00fang v\u1ecb tr\u00ed value_if_false<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Nhap_dung_so_va_chu\"><\/span>Nh\u1eadp \u0111\u00fang s\u1ed1 v\u00e0 ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y nh\u1edb r\u1eb1ng Excel ph\u00e2n bi\u1ec7t ch\u1eef v\u00e0 s\u1ed1, b\u1edfi v\u1eady n\u1ebfu b\u1ea1n nh\u1eadp sai \u0111\u1ecbnh d\u1ea1ng, c\u00f4ng th\u1ee9c s\u1ebd c\u00f3 th\u1ec3 sai \u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_25956\" aria-describedby=\"caption-attachment-25956\" style=\"width: 830px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25956\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-9.png\" width=\"830\" height=\"106\" title=\"19-tips-if-9\"><figcaption id=\"caption-attachment-25956\" class=\"wp-caption-text\">L\u00fd do \u1edf \u0111\u00e2y l\u00e0 g\u00ec? \u0110\u00f3 l\u00e0 s\u1ed1 7 \u1edf \u00f4 C8 \u0111\u1ecbnh d\u1ea1ng Text<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Xuong_dong_%E2%80%93_vi_mot_cong_thuc_de_nhin_hon\"><\/span>Xu\u1ed1ng d\u00f2ng \u2013 v\u00ec m\u1ed9t c\u00f4ng th\u1ee9c d\u1ec5 nh\u00ecn h\u01a1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m IF l\u1ed3ng nhau, c\u00f3 m\u1ed9t c\u00e1ch khi\u1ebfn cho c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n d\u1ec5 nh\u00ecn h\u01a1n.<\/p>\n<figure id=\"attachment_25957\" aria-describedby=\"caption-attachment-25957\" style=\"width: 543px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25957\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-10.png\" width=\"543\" height=\"105\" title=\"19-tips-if-10\"><figcaption id=\"caption-attachment-25957\" class=\"wp-caption-text\">Kh\u00f4ng ph\u1ea3i nh\u01b0 n\u00e0y<\/figcaption><\/figure>\n<p>B\u1edfi Excel kh\u00f4ng quan t\u00e2m t\u1edbi nh\u1eefng kho\u1ea3ng tr\u1eafng trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm ng\u1eaft d\u00f3ng (<strong>Alt<\/strong><strong>+Enter)<\/strong> \u0111\u1ec3 khi\u1ebfn c\u00f4ng th\u1ee9c nh\u00ecn \u201cd\u1ec5 th\u1edf\u201d h\u01a1n m\u00e0 v\u1eabn \u0111\u00fang.<\/p>\n<figure id=\"attachment_25958\" aria-describedby=\"caption-attachment-25958\" style=\"width: 539px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25958\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-11.png\" width=\"539\" height=\"309\" title=\"19-tips-if-11\"><figcaption id=\"caption-attachment-25958\" class=\"wp-caption-text\">Nh\u01b0 th\u1ebf n\u00e0y<\/figcaption><\/figure>\n<h3><\/h3>\n<p><strong>\u0110\u00f3n xem ph\u1ea7n 2 <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\">H\u00e0m IF l\u1ed3ng gh\u00e9p<\/a>, k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t\u00a0<\/strong><\/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-852.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9045,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9044","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\/9044","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=9044"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9044\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9045"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}