{"id":10395,"date":"2025-01-13T21:58:06","date_gmt":"2025-01-13T21:58:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel\/"},"modified":"2025-01-13T21:58:06","modified_gmt":"2025-01-13T21:58:06","slug":"huong-dan-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/13\/huong-dan-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m, vi\u1ebft h\u00e0m l\u1ed3ng nhau trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi vi\u1ebft\u00a0c\u00f4ng th\u1ee9c\u00a0trong Excel th\u00ec kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng vi\u1ebft duy nh\u1ea5t 1 h\u00e0m. B\u1edfi th\u1ef1c t\u1ebf th\u00ec c\u00e1c v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng kh\u00e1 ph\u1ee9c t\u1ea1p do \u0111\u00f3 1 h\u00e0m kh\u00f4ng \u0111\u1ec3 bao qu\u00e1t \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 v\u1ea5n \u0111\u1ec1. Vi\u1ec7c vi\u1ebft h\u00e0m l\u1ed3ng gh\u00e9p nhau c\u00f3 kh\u00f3 kh\u00f4ng? B\u1ea1n s\u1ebd t\u00ecm \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi sau khi \u0111\u1ecdc xong b\u00e0i vi\u1ebft n\u00e0y. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m, vi\u1ebft h\u00e0m l\u1ed3ng nhau trong Excel n\u00e0o:<\/p>\n<p>C\u00f3 2 tr\u01b0\u1eddng h\u1ee3p ch\u00ednh th\u01b0\u1eddng x\u1ea3y ra vi\u1ec7c l\u1ed3ng h\u00e0m:<\/p>\n<ul>\n<li>Tr\u01b0\u1eddng h\u1ee3p 1: L\u1ed3ng gh\u00e9p h\u00e0m \u0111\u1ec3 tr\u00e1nh l\u1ed7i cho h\u00e0m ch\u00ednh<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p 2: \u0110\u1ea3m b\u1ea3o \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1<\/li>\n<\/ul>\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-67858c6de936c\" 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-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel.html#Long_ghep_ham_de_tranh_loi_cho_ham_chinh\" title=\"L\u1ed3ng gh\u00e9p h\u00e0m \u0111\u1ec3 tr\u00e1nh l\u1ed7i cho h\u00e0m ch\u00ednh\">L\u1ed3ng gh\u00e9p h\u00e0m \u0111\u1ec3 tr\u00e1nh l\u1ed7i cho h\u00e0m ch\u00ednh<\/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-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel.html#Dam_bao_du_tinh_logic_cua_van_de\" title=\"\u0110\u1ea3m b\u1ea3o \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1\">\u0110\u1ea3m b\u1ea3o \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Long_ghep_ham_de_tranh_loi_cho_ham_chinh\"><\/span>L\u1ed3ng gh\u00e9p h\u00e0m \u0111\u1ec3 tr\u00e1nh l\u1ed7i cho h\u00e0m ch\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng x\u1ea3y ra v\u1edbi c\u00e1c h\u00e0m tham chi\u1ebfu. B\u1edfi vi\u1ec7c tham chi\u1ebfu r\u1ea5t d\u1ec5 x\u1ea3y ra l\u1ed7i. Do \u0111\u00f3 \u0111\u1ec3 tr\u00e1nh l\u1ed7i th\u00ec ch\u00fang ta l\u1ed3ng gh\u00e9p th\u00eam c\u00e1c h\u00e0m b\u1eaby l\u1ed7i, h\u00e0m logic \u0111\u1ec3 tr\u00e1nh l\u1ed7i.<\/p>\n<p>V\u00ed d\u1ee5 th\u01b0\u1eddng th\u1ea5y l\u00e0 vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Vlookup<\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/loi-value-cua-ham-vlookup-nguyen-nhan-va-cach-khac-phuc.html\">L\u1ed7i #VALUE c\u1ee7a h\u00e0m VLOOKUP, nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/a><\/p>\n<p>H\u00e0m VLOOKUP r\u1ea5t d\u1ec5 x\u1ea3y ra l\u1ed7i n\u1ebfu nh\u01b0:<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 \u00f4 tr\u1ed1ng<\/li>\n<li>Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng b\u1ea3ng t\u00ecm ki\u1ebfm<\/li>\n<li>Gi\u00e1 tr\u1ecb col_index_num (c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3) v\u01b0\u1ee3t qu\u00e1 s\u1ed1 c\u1ed9t hi\u1ec7n c\u00f3 c\u1ee7a b\u1ea3ng t\u00ecm ki\u1ebfm<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 \u0111\u1ec3 tr\u00e1nh l\u1ed7i th\u00ec ch\u00fang ta hay th\u00eam m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0:<\/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\/2025\/01\/ex101_92019-nho-163.gif\" title=\"ex101_92019-nho-163\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html\">H\u00e0m IF + h\u00e0m IsBlank<\/a> \u0111\u1ec3 bi\u1ec7n lu\u1eadn n\u1ebfu gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 \u00f4 tr\u1ed1ng<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-countif-trong-excel-dem-neu-khong-phai-la-o-trong-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html\">H\u00e0m COUNTIF<\/a> \u0111\u1ec3 \u0111\u1ebfm xem gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u00f3 n\u1eb1m trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng b\u1ea3ng t\u00ecm ki\u1ebfm kh\u00f4ng<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-match-va-ung-dung-cua-ham-match-trong-excel-2007-2010-2013-2016.html\">H\u00e0m MATCH<\/a> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 l\u00e0 c\u1ed9t th\u1ee9 m\u1ea5y trong b\u1ea3ng<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 m\u1ee5c \u0111\u00edch ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP, nh\u01b0ng \u0111\u1ec3 tr\u00e1nh l\u1ed7i c\u1ee7a h\u00e0m n\u00e0y th\u00ec c\u00f3 th\u1ec3 ph\u1ea3i d\u00f9ng t\u1edbi r\u1ea5t nhi\u1ec1u h\u00e0m ph\u1ee5 \u0111\u1ec3 l\u1ed3ng gh\u00e9p v\u00e0o h\u00e0m ch\u00ednh.<\/p>\n<p><strong>V\u00ed d\u1ee5 nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20136\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-vi-du-ve-loi.png\" width=\"989\" height=\"214\" title=\"vlookup-vi-du-ve-loi\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta th\u1ea5y t\u1ea1i \u00f4 G2 v\u00e0 G3 c\u00f3 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP v\u00e0 x\u1ea3y ra l\u1ed7i. L\u1ed7i n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0:<\/p>\n<ul>\n<li>G2: Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 F2 kh\u00f4ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t A c\u1ee7a v\u00f9ng b\u1ea3ng A2:D8 =&gt; L\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb #N\/A<\/li>\n<li>G3: Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm \u1edf \u00f4 F3 l\u00e0 \u00f4 tr\u1ed1ng\u00a0=&gt; L\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb #N\/A<\/li>\n<\/ul>\n<p>Do \u0111\u00f3 \u0111\u1ec3 tr\u00e1nh b\u00e1o k\u1ebft qu\u1ea3 l\u1ed7i #N\/A th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1ec3 b\u1eaby l\u1ed7i v\u00e0 ph\u00e1t hi\u1ec7n nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20137\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vlookup-bay-loi-01.png\" width=\"882\" height=\"105\" title=\"vlookup-bay-loi-01\"><\/p>\n<p>T\u1ea1i G2 l\u1ed3ng gh\u00e9p th\u00eam h\u00e0m IF \u0111\u1ec3 x\u00e9t:<\/p>\n<ul>\n<li>N\u1ebfu \u0111\u1ebfm gi\u00e1 tr\u1ecb F2 trong v\u00f9ng A2:A8 ra k\u1ebft qu\u1ea3 b\u1eb1ng 0 (k\u1ebft qu\u1ea3 h\u00e0m COUNTIF=0) th\u00ec tr\u1ea3 v\u1ec1 d\u00f2ng ch\u1eef \u201cKh\u00f4ng c\u00f3 m\u00e3 n\u00e0y\u201d<\/li>\n<li>N\u1ebfu k\u1ebft qu\u1ea3 h\u00e0m COUNTIF ra kh\u00e1c kh\u00f4ng (t\u1ee9c l\u00e0 tr\u01b0\u1eddng h\u1ee3p gi\u1ea3 thi\u1ebft h\u00e0m IF sai, t\u1ea1i value_if_false) s\u1ebd s\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/li>\n<\/ul>\n<p>T\u1ea1i G3 x\u00e9t gi\u1ea3 thi\u1ebft gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 \u00f4 tr\u1ed1ng<\/p>\n<ul>\n<li>N\u1ebfu F3 l\u00e0 \u00f4 tr\u1ed1ng (m\u1ec7nh \u0111\u1ec1 F3=\u201d\u201d) th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u00f4 tr\u1ed1ng (hai d\u1ea5u nh\u00e1y k\u00e9p th\u1ec3 hi\u1ec7n \u00f4 tr\u1ed1ng)<\/li>\n<li>N\u1ebfu F3 kh\u00f4ng ph\u1ea3i \u00f4 tr\u1ed1ng\u00a0(t\u1ee9c l\u00e0 tr\u01b0\u1eddng h\u1ee3p gi\u1ea3 thi\u1ebft h\u00e0m IF sai, t\u1ea1i value_if_false) s\u1ebd s\u1eed d\u1ee5ng h\u00e0m VLOOKUP \u0111\u1ec3 t\u00ecm k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<p>Tuy nhi\u00ean n\u1ebfu\u00a0F2 l\u00e0 \u00f4 tr\u1ed1ng th\u00ec sao? Gi\u00e1 tr\u1ecb \u1edf F3 kh\u00f4ng ph\u1ea3i \u00f4 tr\u1ed1ng nh\u01b0ng l\u00e0 gi\u00e1 tr\u1ecb kh\u00f4ng c\u00f3 trong c\u1ed9t A th\u00ec sao? Tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta ph\u1ea3i l\u1ed3ng gh\u00e9p vi\u1ec7c b\u1eaby l\u1ed7i c\u1ea3 \u1edf G2 v\u00e0 G3 v\u00e0o 1 h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=IF(F2=\u201d\u201d,\u201d\u201d,IF(COUNTIF($A$2:$A$8,F2)=0,\u201dKh\u00f4ng c\u00f3 m\u00e3 n\u00e0y\u201d,VLOOKUP(F2,$A$2:$D$8,4,0)))<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>IF(F2=\u201d\u201d,\u201d\u201d,<\/strong> l\u00e0 x\u00e9t tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 \u00f4 tr\u1ed1ng<\/li>\n<li><strong>IF(COUNTIF($A$2:$A$8,F2)=0,\u201dKh\u00f4ng c\u00f3 m\u00e3 n\u00e0y\u201d,<\/strong> l\u00e0 x\u00e9t tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm kh\u00f4ng n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ecm ki\u1ebfm. H\u00e0m IF n\u00e0y n\u1eb1m \u1edf m\u1ec7nh \u0111\u1ec1 <em><strong>value_if_false<\/strong><\/em> c\u1ee7a h\u00e0m IF \u0111\u1ea7u ti\u00ean \u0111\u1ec3 x\u00e9t khi F2 kh\u00f4ng ph\u1ea3i l\u00e0 \u00f4 tr\u1ed1ng<\/li>\n<li><strong>VLOOKUP(F2,$A$2:$D$8,4,0)<\/strong> gi\u00e1 tr\u1ecb s\u1ebd th\u1ef1c thi khi m\u00e0 c\u1ea3 2 gi\u1ea3 thi\u1ebft h\u00e0m IF \u0111\u1ec1u sai. H\u00e0m Vlookup n\u1eb1m \u1edf m\u1ec7nh \u0111\u1ec1\u00a0<strong><em>value_if_false<\/em> <\/strong>c\u1ee7a h\u00e0m IF th\u1ee9 2, m\u00e0 h\u00e0m IF th\u1ee9 2 l\u1ea1i n\u1eb1m trong m\u1ec7nh \u0111\u1ec1\u00a0<em><strong>value_if_false\u00a0<\/strong><\/em>c\u1ee7a h\u00e0m IF th\u1ee9 1 n\u00ean \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 khi c\u1ea3 2 m\u1ec7nh \u0111\u1ec1 \u0111\u1ec1u sai.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady d\u00f9 c\u00f4ng th\u1ee9c nh\u00ecn c\u00f3 v\u1ebb d\u00e0i v\u00e0 ph\u1ee9c t\u1ea1p, l\u1ed3ng nhi\u1ec1u h\u00e0m IF v\u00e0o nhau, nh\u01b0ng th\u1ef1c ch\u1ea5t th\u00ec ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 s\u1eed d\u1ee5ng h\u00e0m VLOOKUP c\u1ed9ng th\u00eam vi\u1ec7c b\u1eaby l\u1ed7i c\u1ee7a h\u00e0m VLOOKUP m\u00e0 th\u00f4i.<\/p>\n<p>* L\u01b0u \u00fd: Ngo\u00e0i c\u00e1c l\u1ed7i th\u01b0\u1eddng th\u1ea5y, ch\u00fang ta c\u00f2n ph\u1ea3i bi\u1ebft v\u1ec1 l\u1ed7i Lo\u1ea1i d\u1eef li\u1ec7u. B\u1edfi n\u1ebfu kh\u00f4ng \u0111\u00fang lo\u1ea1i d\u1eef li\u1ec7u th\u00ec ch\u00fang ta kh\u00f4ng th\u1ec3 t\u00ednh to\u00e1n \u0111\u00fang \u0111\u01b0\u1ee3c.<\/p>\n<p>Tham kh\u1ea3o: Lo\u1ea1i d\u1eef li\u1ec7u \u1ea3nh h\u01b0\u1edfng th\u1ebf n\u00e0o t\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m trong Excel<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dam_bao_du_tinh_logic_cua_van_de\"><\/span>\u0110\u1ea3m b\u1ea3o \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c \u0111\u1ea3m b\u1ea3o \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng ph\u1ee9c t\u1ea1p h\u01a1n nhi\u1ec1u so v\u1edbi vi\u1ec7c b\u1eaby l\u1ed7i. B\u1edfi vi\u1ec7c ph\u00e2n t\u00edch \u0111\u1ee7 v\u00e0 ch\u00ednh x\u00e1c t\u00ednh logic c\u1ee7a nh\u1eefng tr\u01b0\u1eddng h\u1ee3p ph\u1ee9c t\u1ea1p\u00a0kh\u00e1 kh\u00f3 th\u1ef1c hi\u1ec7n, ngay c\u1ea3 v\u1edbi nh\u1eefng ai \u0111\u00e3 l\u00e0m t\u1ed1t Excel.<\/p>\n<p>Do \u0111\u00f3 \u0111\u1ec3 l\u00e0m quen v\u1edbi vi\u1ec7c n\u00e0y, ch\u00fang ta n\u00ean h\u00ecnh th\u00e0nh 1 th\u00f3i quen \u0111\u00f3 l\u00e0 ph\u00e2n t\u00edch logic c\u1ee7a v\u1ea5n \u0111\u1ec1 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 \u0111\u00f3. Khi \u0111\u00e3 ph\u00e2n t\u00edch \u0111\u00fang v\u00e0 \u0111\u1ee7 t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1 th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c \u0111\u00e2u l\u00e0 \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u, \u0111\u00e2u l\u00e0 \u0111i\u1ec3m k\u1ebft th\u00fac. T\u1eeb \u0111\u00f3 ch\u00fang ta s\u1ebd bi\u1ebft c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m n\u00e0o, l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m theo th\u1ee9 t\u1ef1 n\u00e0o, khi n\u00e0o th\u00ec ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>X\u00e9t v\u00ed d\u1ee5 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20139\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/long-ghep-ham-xet-logic.png\" width=\"604\" height=\"306\" title=\"long-ghep-ham-xet-logic\"><\/p>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n y\u00eau c\u1ea7u X\u1ebfp lo\u1ea1i, ch\u00fang ta c\u1ea7n ph\u00e2n t\u00edch t\u00ednh logic c\u1ee7a y\u00eau c\u1ea7u n\u00e0y tr\u01b0\u1edbc khi vi\u1ebft h\u00e0m, c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>M\u1ee5c ti\u00eau<\/strong>: \u0110i\u1ec1n k\u1ebft qu\u1ea3 v\u00e0o c\u1ed9t X\u1ebfp lo\u1ea1i l\u00e0 2 gi\u00e1 tr\u1ecb \u201c\u0110\u1ed7\u201d ho\u1eb7c \u201cTr\u01b0\u1ee3t\u201d d\u1ef1a theo \u0111i\u1ec1u ki\u1ec7n \u1edf c\u1ed9t Kh\u00f3a h\u1ecdc v\u00e0 \u0110i\u1ec3m thi<\/p>\n<p><strong>N\u1ed9i dung logic c\u1ee7a \u0111i\u1ec1u ki\u1ec7n<\/strong>:<\/p>\n<ul>\n<li><strong>Logic\u00a01<\/strong>: N\u1ebfu \u0111i\u1ec3m thi Excel d\u01b0\u1edbi 7 l\u00e0 tr\u01b0\u1ee3t. T\u1ea1i \u0111\u00e2y ta c\u00f3: \u0110i\u1ec3m thi m\u00f4n Excel ph\u1ee5 thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb \u1edf c\u1ed9t Kh\u00f3a h\u1ecdc (c\u1ed9t C) v\u00e0 c\u1ed9t \u0110i\u1ec3m thi (c\u1ed9t D). Hai \u0111i\u1ec1u ki\u1ec7n n\u00e0y x\u00e9t \u0111\u1ed3ng th\u1eddi do \u0111\u00f3 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 k\u1ebft h\u1ee3p 2 n\u1ed9i dung n\u00e0y. H\u00e0m IF \u0111\u1ec3 x\u00e9t t\u00ednh logic: n\u1ebfu th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi 2 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a logic 1 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 \u201cTr\u01b0\u1ee3t\u201d<\/li>\n<li><strong>Logic 2<\/strong>: logic 2 s\u1ebd th\u1ef1c hi\u1ec7n khi m\u1ec7nh \u0111\u1ec1 logic 1 l\u00e0 sai. Do \u0111\u00f3 sau khi x\u00e9t m\u1ec7nh \u0111\u1ec1 \u0111\u00fang c\u1ee7a logic 1 xong th\u00ec ch\u00fang ta s\u1ebd x\u00e9t ngay logic 2. Logic 2 l\u00e0 k\u1ebft h\u1ee3p \u0111i\u1ec1u ki\u1ec7n Kh\u00f3a h\u1ecdc = Word, \u0111i\u1ec3m thi d\u01b0\u1edbi 8 n\u00ean s\u1ebd d\u00f9ng h\u00e0m AND. Logic 2 \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi h\u00e0m IF \u0111\u1ec3 x\u00e9t: n\u1ebfu th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi 2 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a logic 2 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 \u201cTr\u01b0\u1ee3t\u201d<\/li>\n<li><strong>C\u00f2n l\u1ea1i<\/strong> n\u1ebfu c\u1ea3 2 logic tr\u00ean \u0111\u1ec1u sai (t\u1ee9c l\u00e0 m\u1ec7nh \u0111\u1ec1 sai \u1edf logic 2 c\u0169ng l\u00e0 m\u1ec7nh \u0111\u1ec1 sai c\u1ee7a logic 1) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng ph\u1ea3i l\u00e0 \u201cTr\u01b0\u1ee3t\u201d, khi \u0111\u00f3 s\u1ebd l\u00e0 \u201c\u0110\u1ed7\u201d<\/li>\n<\/ul>\n<p>C\u00e1ch vi\u1ebft h\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">E2=IF(AND(C2=\u201dExcel\u201d,D2&lt;7),\u201dTr\u01b0\u1ee3t\u201d,IF(AND(C2=\u201dWord\u201d,D2&lt;8),\u201dTr\u01b0\u1ee3t\u201d,\u201d\u0110\u1ed7\u201d))<\/p>\n<ul>\n<li>Logic 1 = IF(AND(C2=\u201dExcel\u201d,D2&lt;7),\u201dTr\u01b0\u1ee3t\u201d,\u2026.\u00a0 \u00a0 x\u00e9t logic 2 t\u1ea1i v\u1ecb tr\u00ed d\u1ea5u \u2026. m\u1ec7nh \u0111\u1ec1 value_if_false c\u1ee7a h\u00e0m IF<\/li>\n<li>Logic 2 =IF(AND(C2=\u201dWord\u201d,D2&lt;8),\u201dTr\u01b0\u1ee3t\u201d,\u201d\u0110\u1ed7\u201d)) t\u1ea1i \u0111\u00e2y \u0111\u00f3ng 2 ngo\u1eb7c \u0111\u1ec3 k\u1ebft th\u00fac cho 2 h\u00e0m IF<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20141\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/long-ghep-ham-xet-logic-ket-qua.png\" width=\"604\" height=\"314\" title=\"long-ghep-ham-xet-logic-ket-qua\"><\/p>\n<p>Tham kh\u1ea3o<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-hoa-hong-ban-hang-bang-ham-if-long-nhau-tren-excel.html\">C\u00e1ch t\u00ednh hoa h\u1ed3ng b\u00e1n h\u00e0ng b\u1eb1ng h\u00e0m IF l\u1ed3ng nhau tr\u00ean Excel<\/a><\/p>\n<p>Vi\u1ec7c l\u1ed3ng gh\u00e9p h\u00e0m kh\u00f4ng ch\u1ec9 li\u00ean quan t\u1edbi c\u00e1c h\u00e0m IF, AND, OR m\u00e0 x\u1ea3y ra trong r\u1ea5t nhi\u1ec1u h\u00e0m. Th\u00f4ng th\u01b0\u1eddng ch\u00fang ta hay d\u00f9ng t\u1edbi h\u00e0m IF \u0111\u1ec3 di\u1ec5n \u0111\u1ea1t t\u00ednh logic c\u1ee7a v\u1ea5n \u0111\u1ec1 m\u00e0 th\u00f4i. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t v\u00e0i \u1ee9ng d\u1ee5ng c\u1ee7a vi\u1ec7c l\u1ed3ng gh\u00e9p h\u00e0m trong c\u00e1c h\u00e0m SUMPRODUCT, SUMIFS, COUNTIFS d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html\">So s\u00e1nh h\u00e0m COUNTIFS v\u1edbi SUMPRODUCT trong vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-bao-cao-tong-hop-theo-tung-thang-voi-ham-sumifs.html\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p theo t\u1eebng th\u00e1ng v\u1edbi h\u00e0m SUMIFS<\/a><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 n\u1ed9i dung c\u01a1 b\u1ea3n trong vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m, vi\u1ebft h\u00e0m l\u1ed3ng nhau trong Excel. \u0110\u1ec3 c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch c\u00f3 h\u1ec7 th\u1ed1ng, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2u5tVMY\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y s\u1ebd cung c\u1ea5p cho c\u00e1c b\u1ea1n \u0111\u1ea7y \u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 trong Excel v\u00e0 vi\u1ec7c \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c. \u0110\u1ec3 \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n b\u1ea5m v\u00e0o h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/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-163.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10395","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\/10395","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=10395"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10396"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}