{"id":9917,"date":"2025-01-04T21:08:55","date_gmt":"2025-01-04T21:08:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-phan-2\/"},"modified":"2025-01-04T21:08:55","modified_gmt":"2025-01-04T21:08:55","slug":"cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-phan-2\/","title":{"rendered":"C\u00e1ch t\u1ef1 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c \u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel \u2013 Ph\u1ea7n 2"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><strong>H\u1ecdc Excel Online<\/strong> ti\u1ebfp t\u1ee5c t\u00ecm hi\u1ec3u c\u00e1ch t\u1ef1 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c \u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel. Trong b\u00e0i vi\u1ebft t\u1ea1i ph\u1ea7n 1, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>\u0111\u00e3 t\u00ecm hi\u1ec3u xong v\u1ec1 s\u1ef1 ph\u1ee9c t\u1ea1p c\u1ee7a vi\u1ec7c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n\u00a0b\u1eb1ng\u00a0ch\u1eef theo ti\u1ebfng vi\u1ec7t .\u00a0 C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 b\u1eb1ng\u00a0ch\u1eef ti\u1ebfng vi\u1ec7t, trong\u00a0\u0111\u00f3 \u0111\u00e3 t\u00ecm hi\u1ec3u t\u1edbi ph\u1ea7n\u00a0\u0111\u1ecdc th\u00e0nh ch\u1eef cho h\u00e0ng t\u1ef7. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:<\/em><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c \u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel t\u1eeb A \u0111\u1ebfn Z \u2013 Ph\u1ea7n 1<\/a><\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2Upapa1\">http:\/\/bit.ly\/2Upapa1<\/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-6779a366dc764\" 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-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Cac_buoc_xay_dung_ham_doc_so_bang_chu_tieng_viet\" title=\"C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 b\u1eb1ng\u00a0ch\u1eef ti\u1ebfng vi\u1ec7t\">C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 b\u1eb1ng\u00a0ch\u1eef ti\u1ebfng vi\u1ec7t<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Doc_vi_tri_hang_tram_trieu\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Doc_vi_tri_hang_chuc_trieu\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c tri\u1ec7u\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c tri\u1ec7u<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Doc_vi_tri_hang_trieu\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tri\u1ec7u\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tri\u1ec7u<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Doc_vi_tri_hang_nghin\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ngh\u00ecn\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ngh\u00ecn<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Doc_vi_tri_hang_don_vi\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Xu_ly_viet_hoa_chu_cai_bat_dau\" title=\"X\u1eed l\u00fd vi\u1ebft hoa ch\u1eef c\u00e1i b\u1eaft\u00a0\u0111\u1ea7u\">X\u1eed l\u00fd vi\u1ebft hoa ch\u1eef c\u00e1i b\u1eaft\u00a0\u0111\u1ea7u<\/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\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Ghep_cac_tu_da_doc_thanh_ket_qua_so_tien_bang_chu\" title=\"Gh\u00e9p c\u00e1c t\u1eeb\u00a0\u0111\u00e3\u00a0\u0111\u1ecdc th\u00e0nh k\u1ebft qu\u1ea3 s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef\">Gh\u00e9p c\u00e1c t\u1eeb\u00a0\u0111\u00e3\u00a0\u0111\u1ecdc th\u00e0nh k\u1ebft qu\u1ea3 s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_buoc_xay_dung_ham_doc_so_bang_chu_tieng_viet\"><\/span>C\u00e1c b\u01b0\u1edbc x\u00e2y d\u1ef1ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 b\u1eb1ng\u00a0ch\u1eef ti\u1ebfng vi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_tram_trieu\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i v\u1ecb tr\u00ed n\u00e0y, vi\u1ec7c\u00a0\u0111\u1ecdc gi\u1ed1ng nh\u01b0\u00a0\u0111\u1ecdc\u00a0\u1edf v\u1ecb tr\u00ed h\u00e0ng tr\u0103m t\u1ef7. Tuy nhi\u00ean c\u00f3 th\u00eam m\u1ed9t s\u1ed1 y\u00eau c\u1ea7u:<\/p>\n<ul>\n<li>Ph\u1ea7n b\u00ean tr\u00e1i (t\u1eeb v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u t\u1edbi h\u00e0ng tr\u0103m t\u1ef7) c\u00f3 s\u1ed1 n\u00e0o l\u1edbn h\u01a1n 0 kh\u00f4ng. N\u1ebfu kh\u00f4ng c\u00f3 th\u00ec b\u1eb1ng r\u1ed7ng, n\u1ebfu c\u00f3 th\u00ec x\u00e9t th\u00eam tr\u01b0\u1eddng h\u1ee3p sau:<\/li>\n<li>To\u00e0n b\u1ed9 h\u00e0ng tri\u1ec7u c\u00f3 s\u1ed1 n\u00e0o &gt;0 kh\u00f4ng, n\u1ebfu kh\u00f4ng c\u00f3 (to\u00e0n b\u1eb1ng 0) t\u1ee9c l\u00e0 kh\u00f4ng ph\u00e1t sinh h\u00e0ng tri\u1ec7u, s\u1ebd tr\u1ea3 v\u1ec1 r\u1ed7ng t\u1ea1i v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u<\/li>\n<li>N\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o h\u00e0ng tri\u1ec7u, m\u00e0 t\u1ea1i v\u1ecb tr\u00ed F3 (h\u00e0ng tr\u0103m tri\u1ec7u) b\u1eb1ng 0 th\u00ec\u00a0\u0111\u1ecdc l\u00e0 \u201c<strong>kh\u00f4ng tr\u0103m<\/strong>\u201c<\/li>\n<li>C\u00f2n l\u1ea1i t\u00f9y theo s\u1ed1 t\u1ea1i F3 m\u00e0\u00a0\u0111\u1ecdc th\u00e0nh ch\u1eef t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1eeb \u201c<strong>m\u1ed9t<\/strong>\u201d\u00a0\u0111\u1ebfn \u201c<strong>ch\u00edn<\/strong>\u201c, k\u1ebft h\u1ee3p th\u00eam ch\u1eef \u201d\u00a0<strong>tr\u0103m\u201d<\/strong> (c\u00f3 d\u1ea5u c\u00e1ch tr\u01b0\u1edbc ch\u1eef tr\u0103m)<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef t\u1ea1i v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u:<\/p>\n<p style=\"padding-left: 30px\">F5=IF(SUM(C3:F3)=0,\u201d\u201d,IF(SUM(F3:H3)=0,\u201d\u201d,IF(F3=0,\u201dkh\u00f4ng tr\u0103m\u201d,CHOOSE(F3,\u201dm\u1ed9t\u201d,\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,\u201dn\u0103m\u201d,\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d tr\u0103m\u201d)))<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/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-107.gif\" title=\"ex101_92019-nho-107\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>SUM(C3:F3)=0\u00a0\u0111\u1ec3 x\u00e9t ph\u1ea7n t\u1eeb v\u1ecb tr\u00ed h\u00e0ng tr\u0103m tri\u1ec7u tr\u1edf v\u1ec1 b\u00ean tr\u00e1i (h\u00e0ng tr\u0103m t\u1ef7) c\u00f3 s\u1ed1 n\u00e0o l\u1edbn h\u01a1n 0 kh\u00f4ng<\/li>\n<li>SUM(F3:H3)=0\u00a0\u0111\u1ec3 x\u00e9t to\u00e0n b\u1ed9 c\u00e1c s\u1ed1 thu\u1ed9c h\u00e0ng tri\u1ec7u c\u00f3 s\u1ed1 n\u00e0o &gt;0 kh\u00f4ng<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_chuc_trieu\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c tri\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ecb tr\u00ed n\u00e0y\u00a0\u0111\u1ecdc gi\u1ed1ng nh\u01b0 h\u00e0ng ch\u1ee5c t\u1ef7. C\u00f4ng th\u1ee9c t\u1ea1i v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c tri\u1ec7u:<\/p>\n<p style=\"padding-left: 30px\">G5=IF(SUM(C3:G3)=0,\u201d\u201d,IF(AND(G3=0,H3=0),\u201d\u201d,IF(AND(G3=0,H3&lt;&gt;0),G4,CHOOSE(G3,\u201dm\u01b0\u1eddi\u201d,\u201dhai m\u01b0\u01a1i\u201d,\u201dba m\u01b0\u01a1i\u201d,\u201db\u1ed1n m\u01b0\u01a1i\u201d,\u201dn\u0103m m\u01b0\u01a1i\u201d,\u201ds\u00e1u m\u01b0\u01a1i\u201d,\u201db\u1ea3y m\u01b0\u01a1i\u201d,\u201dt\u00e1m m\u01b0\u01a1i\u201d,\u201dch\u00edn m\u01b0\u01a1i\u201d))))<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>SUM(C3:G3)=0\u00a0\u0111\u1ec3 x\u00e9t t\u1eeb v\u1ecb tr\u00ed h\u00e0ng\u00a0ch\u1ee5c\u00a0tri\u1ec7u tr\u1edf v\u1ec1 b\u00ean tr\u00e1i (h\u00e0ng tr\u0103m t\u1ef7) c\u00f3\u00a0s\u1ed1 n\u00e0o l\u1edbn h\u01a1n 0 kh\u00f4ng<\/li>\n<li>AND(G3=0,H3=0) x\u00e9t ph\u1ea7n h\u00e0ng ch\u1ee5c tri\u1ec7u v\u00e0 h\u00e0ng tri\u1ec7u c\u00f3 s\u1ed1 n\u00e0o &gt;0 kh\u00f4ng, n\u1ebfu\u00a0\u0111\u1ec1u =0 th\u00ec s\u1ebd kh\u00f4ng\u00a0\u0111\u1ecdc h\u00e0ng ch\u1ee5c tri\u1ec7u<\/li>\n<li>AND(G3=0,H3&lt;&gt;0) n\u1ebfu kh\u00f4ng c\u00f3 h\u00e0ng ch\u1ee5c tri\u1ec7u (s\u1ed1 0) m\u00e0 c\u00f3 h\u00e0ng tri\u1ec7u (kh\u00e1c 0) th\u00ec s\u1ebd\u00a0\u0111\u1ecdc theo t\u1eeb t\u1ea1i v\u1ecb tr\u00ed G4 (data validation\/ List\/ linh, l\u1ebb)<\/li>\n<li>C\u00f2n l\u1ea1i th\u00ec\u00a0\u0111\u1ecdc theo s\u1ed1 h\u00e0ng ch\u1ee5c t\u1eeb \u201c<strong>m\u01b0\u1eddi<\/strong>\u201d\u00a0\u0111\u1ebfn \u201c<strong>ch\u00edn m\u01b0\u01a1i<\/strong>\u201c<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_trieu\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tri\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ecb tr\u00ed n\u00e0y\u00a0\u0111\u1ecdc gi\u1ed1ng nh\u01b0 h\u00e0ng t\u1ef7. C\u00f4ng th\u1ee9c t\u1ea1i v\u1ecb tr\u00ed h\u00e0ng tri\u1ec7u:<\/p>\n<p style=\"padding-left: 30px\">H5=IF(SUM(F3:H3)=0,\u201d\u201d,IF(AND(SUM(C3:G3)&gt;0,H3=0),\u201d \u201c&amp;H4,CHOOSE(H3,IF(G3&gt;0,\u201dm\u1ed1t\u201d,\u201dm\u1ed9t\u201d),\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,IF(G3&gt;0,\u201dl\u0103m\u201d,\u201dn\u0103m\u201d),\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d \u201c&amp;H4))<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>SUM(F3:H3)=0 x\u00e9t to\u00e0n b\u1ed9 s\u1ed1 h\u00e0ng tri\u1ec7u, n\u1ebfu\u00a0\u0111\u1ec1u = 0 th\u00ec kh\u00f4ng\u00a0\u0111\u1ecdc h\u00e0ng tri\u1ec7u<\/li>\n<li>AND(SUM(C3:G3)&gt;0,H3=0) x\u00e9t khi c\u00f3 ph\u1ea7n l\u1edbn h\u01a1n h\u00e0ng tri\u1ec7u nh\u01b0ng t\u1ea1i v\u1ecb tr\u00ed h\u00e0ng tri\u1ec7u th\u00ec = 0, th\u00ec ch\u1ec9 \u0111\u1ecdc ch\u1eef \u201c<strong> tri\u1ec7u<\/strong>\u201d ch\u1ee9 kh\u00f4ng ph\u1ea3i\u00a0\u0111\u1ecdc l\u00e0 \u201ckh\u00f4ng tri\u1ec7u\u201d<\/li>\n<li>C\u00f2n l\u1ea1i tr\u01b0\u1eddng h\u1ee3p c\u00f3 s\u1ed1 h\u00e0ng tri\u1ec7u th\u00ec\u00a0\u0111\u1ecdc gi\u1ed1ng nh\u01b0 c\u00e1ch\u00a0\u0111\u1ecdc h\u00e0ng t\u1ef7, nh\u01b0ng thay ch\u1eef \u201ct\u1ef7\u201d b\u1eb1ng ch\u1eef \u201ctri\u1ec7u\u201d (v\u1ecb tr\u00ed H4) c\u00f3 k\u00e8m th\u00eam d\u1ea5u c\u00e1ch.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 h\u00e0ng tri\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22720\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b4-hoan-thanh-doc-so-bang-chu-hang-trieu.png\" width=\"945\" height=\"184\" title=\"b4-hoan-thanh-doc-so-bang-chu-hang-trieu\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_nghin\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ngh\u00ecn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c v\u1ecb tr\u00ed\u00a0\u1edf h\u00e0ng ngh\u00ecn: tr\u0103m ngh\u00ecn, ch\u1ee5c ngh\u00ecn, ngh\u00ecn\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecdc gi\u1ed1ng nh\u01b0\u00a0\u1edf h\u00e0ng tri\u1ec7u.\u00a0\u0110i\u1ec3m ch\u00fa\u00a0\u00fd duy nh\u1ea5t l\u00e0\u00a0\u0111\u01a1n v\u1ecb\u00a0\u1edf h\u00e0ng ngh\u00ecn c\u00f3 2 c\u00e1ch\u00a0\u0111\u1ecdc: <strong><em>ng\u00e0n\/ ngh\u00ecn<\/em><\/strong> t\u00f9y theo\u00a0\u0111\u1ecba ph\u01b0\u01a1ng. Do\u00a0\u0111\u00f3 c\u1ea7n t\u1ea1o danh s\u00e1ch ch\u1ecdn\u00a0\u0111\u01a1n v\u1ecb n\u00e0y t\u1ea1i d\u00f2ng 4, c\u1ed9t K (ch\u1eef s\u1ed1\u00a0\u0111\u01a1n v\u1ecb h\u00e0ng ngh\u00ecn)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22727\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b5-data-validation-tao-danh-sach-chon-ngan-nghin.png\" width=\"957\" height=\"646\" title=\"b5-data-validation-tao-danh-sach-chon-ngan-nghin\"><\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i c\u00e1c v\u1ecb tr\u00ed:<\/p>\n<ul>\n<li>H\u00e0ng tr\u0103m ngh\u00ecn<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">I5=IF(SUM(C3:I3)=0,\u201d\u201d,IF(SUM(I3:K3)=0,\u201d\u201d,IF(I3=0,\u201dkh\u00f4ng tr\u0103m\u201d,CHOOSE(I3,\u201dm\u1ed9t\u201d,\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,\u201dn\u0103m\u201d,\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d tr\u0103m\u201d)))<\/p>\n<ul>\n<li>H\u00e0ng ch\u1ee5c ngh\u00ecn<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">J5=IF(SUM(C3:J3)=0,\u201d\u201d,IF(AND(J3=0,K3=0),\u201d\u201d,IF(AND(J3=0,K3&lt;&gt;0),J4,CHOOSE(J3,\u201dm\u01b0\u1eddi\u201d,\u201dhai m\u01b0\u01a1i\u201d,\u201dba m\u01b0\u01a1i\u201d,\u201db\u1ed1n m\u01b0\u01a1i\u201d,\u201dn\u0103m m\u01b0\u01a1i\u201d,\u201ds\u00e1u m\u01b0\u01a1i\u201d,\u201db\u1ea3y m\u01b0\u01a1i\u201d,\u201dt\u00e1m m\u01b0\u01a1i\u201d,\u201dch\u00edn m\u01b0\u01a1i\u201d))))<\/p>\n<ul>\n<li>H\u00e0ng ngh\u00ecn<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">K5=IF(SUM(I3:K3)=0,\u201d\u201d,IF(AND(SUM(C3:J3)&gt;0,K3=0),\u201d \u201c&amp;K4,CHOOSE(K3,IF(J3&gt;0,\u201dm\u1ed1t\u201d,\u201dm\u1ed9t\u201d),\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,IF(J3&gt;0,\u201dl\u0103m\u201d,\u201dn\u0103m\u201d),\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d \u201c&amp;K4))<\/p>\n<p>Nh\u01b0 v\u1eady k\u1ebft qu\u1ea3 h\u00e0ng\u00a0ngh\u00ecn\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b6-hoan-thanh-doc-so-bang-chu-hang-nghin.png\" width=\"1232\" height=\"187\" title=\"b6-hoan-thanh-doc-so-bang-chu-hang-nghin\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_don_vi\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>G\u1ed3m c\u00e1c ch\u1eef s\u1ed1 th\u1ec3 hi\u1ec7n ti\u1ec1n \u201c<strong>l\u1ebb<\/strong>\u201c, g\u1ed3m <strong>tr\u0103m\u00a0\u0111\u1ed3ng, ch\u1ee5c\u00a0\u0111\u1ed3ng,\u00a0\u0111\u1ed3ng.<\/strong><\/p>\n<p>\u1ede h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb c\u00f3 ph\u00e2n ra 2 lo\u1ea1i l\u00e0 \u201cL\u1ebb\/ch\u1eb5n\u201d v\u00e0 c\u00e1ch\u00a0\u0111\u1ecdc c\u0169ng c\u00f3 s\u1ef1 kh\u00e1c nhau.<\/p>\n<ul>\n<li>C\u00f3 b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o\u00a0\u1edf h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb th\u00ec s\u1ebd l\u00e0 \u201cl\u1ebb\u201d v\u00e0\u00a0\u0111\u1ecdc chi ti\u1ebft t\u1eebng\u00a0\u0111\u1ed3ng<\/li>\n<li>Kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o\u00a0\u1edf h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb (\u0111\u1ec1u = 0) th\u00ec\u00a0\u0111\u1ecdc l\u00e0 \u201c\u0111\u1ed3ng ch\u1eb5n\u201d<\/li>\n<li>K\u1ebft th\u00fac\u00a0\u0111\u1ecdc ti\u1ec1n b\u1eb1ng ch\u1eef l\u00e0 d\u1ea5u \u201c.\/.\u201d\u00a0\u0111\u1ec3 th\u1ec3 hi\u1ec7n\u00a0\u0111\u00e3 k\u1ebft th\u00fac\u00a0\u0111o\u1ea1n b\u1eb1ng ch\u1eef.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ph\u1ea7n h\u00e0ng tr\u0103m v\u00e0 h\u00e0ng ch\u1ee5c kh\u00f4ng\u00a0\u1ea3nh h\u01b0\u1edfng g\u00ec, ch\u1ec9\u00a0\u1ea3nh h\u01b0\u1edfng\u00a0\u1edf h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb cu\u1ed1i c\u00f9ng.<\/p>\n<p><strong>\u0110\u1ecdc ch\u1eef s\u1ed1 h\u00e0ng tr\u0103m\u00a0\u0111\u1ed3ng:<\/strong><\/p>\n<p style=\"padding-left: 30px\">L5=IF(SUM(C3:L3)=0,\u201d\u201d,IF(SUM(L3:N3)=0,\u201d\u201d,IF(L3=0,\u201dkh\u00f4ng tr\u0103m\u201d,CHOOSE(L3,\u201dm\u1ed9t\u201d,\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,\u201dn\u0103m\u201d,\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d tr\u0103m\u201d)))<\/p>\n<p><strong>\u0110\u1ecdc ch\u1eef s\u1ed1 h\u00e0ng ch\u1ee5c\u00a0\u0111\u1ed3ng:<\/strong><\/p>\n<p style=\"padding-left: 30px\">M5=IF(SUM(C3:M3)=0,\u201d\u201d,IF(AND(M3=0,N3=0),\u201d\u201d,IF(AND(M3=0,N3&lt;&gt;0),M4,CHOOSE(M3,\u201dm\u01b0\u1eddi\u201d,\u201dhai m\u01b0\u01a1i\u201d,\u201dba m\u01b0\u01a1i\u201d,\u201db\u1ed1n m\u01b0\u01a1i\u201d,\u201dn\u0103m m\u01b0\u01a1i\u201d,\u201ds\u00e1u m\u01b0\u01a1i\u201d,\u201db\u1ea3y m\u01b0\u01a1i\u201d,\u201dt\u00e1m m\u01b0\u01a1i\u201d,\u201dch\u00edn m\u01b0\u01a1i\u201d))))<\/p>\n<p><strong>\u0110\u1ecdc ch\u1eef s\u1ed1 h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb\u00a0\u0111\u1ed3ng:<\/strong><\/p>\n<p style=\"padding-left: 30px\">N5=IF(SUM(C3:N3)=0,\u201dKh\u00f4ng \u201c&amp;N4,IF(AND(SUM(C3:K3)&gt;0,SUM(L3:N3)=0),\u201d \u201c&amp;N4&amp;\u201d ch\u1eb5n\u201d,IF(N3=0,\u201d \u201c&amp;N4,CHOOSE(N3,IF(M3&gt;0,\u201dm\u1ed1t\u201d,\u201dm\u1ed9t\u201d),\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,IF(M3&gt;0,\u201dl\u0103m\u201d,\u201dn\u0103m\u201d),\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d \u201c&amp;N4)))&amp;\u201d.\/.\u201d<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>SUM(C3:N3)=0 l\u00e0 t\u1ed5ng to\u00e0n b\u1ed9 c\u00e1c con s\u1ed1 trong d\u00e3y s\u1ed1 ti\u1ec1n. N\u1ebfu b\u1eb1ng 0 t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3\u00a0\u0111\u1ed3ng n\u00e0o =&gt;\u00a0\u0110\u1ecdc l\u00e0 \u201ckh\u00f4ng\u00a0\u0111\u1ed3ng\u201d.<\/li>\n<li>AND(SUM(C3:K3)&gt;0,SUM(L3:N3)=0) l\u00e0 c\u00f3 nhi\u1ec1u h\u01a1n 1\u00a0con s\u1ed1 t\u1eeb h\u00e0ng t\u1ef7 t\u1edbi h\u00e0ng ngh\u00ecn, k\u00e8m theo\u00a0\u0111\u00f3 l\u00e0 kh\u00f4ng c\u00f3 s\u1ed1\u00a0\u1edf h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb th\u00ec l\u00e0 \u201c\u0111\u1ed3ng ch\u1eb5n\u201d<\/li>\n<li>N3=0 l\u00e0 khi ngo\u00e0i 2 logic tr\u00ean s\u1ebd l\u00e0\u00a0\u0111\u1ed3ng l\u1ebb (kh\u00f4ng\u00a0\u0111\u1ecdc ch\u1eef \u201cl\u1ebb\u201d, ch\u1ec9\u00a0\u0111\u1ecdc l\u00e0 \u201c\u0111\u1ed3ng\u201d), s\u1ed1 0 s\u1ebd kh\u00f4ng\u00a0\u0111\u1ecdc.<\/li>\n<li>C\u00e1c s\u1ed1 c\u00f2n l\u1ea1i th\u00ec\u00a0\u0111\u1ecdc gi\u1ed1ng c\u00e1c ch\u1eef s\u1ed1 h\u00e0ng \u0111\u01a1n v\u1ecb kh\u00e1c. K\u1ebft th\u00fac v\u1edbi d\u1ea5u\u00a0\u201c<strong>.\/.<\/strong>\u201c<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22730\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b7-hoan-thanh-doc-so-bang-chu-hang-don-vi.png\" width=\"1522\" height=\"208\" title=\"b7-hoan-thanh-doc-so-bang-chu-hang-don-vi\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xu_ly_viet_hoa_chu_cai_bat_dau\"><\/span>X\u1eed l\u00fd vi\u1ebft hoa ch\u1eef c\u00e1i b\u1eaft\u00a0\u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 1 nguy\u00ean t\u1eafc l\u00e0 ph\u1ea3i vi\u1ebft hoa ch\u1eef c\u00e1i b\u1eaft\u00a0\u0111\u1ea7u trong c\u1ea3 d\u00e3y s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef. Tuy nhi\u00ean ch\u00fang ta ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c t\u1ea1i v\u1ecb tr\u00ed n\u00e0o l\u00e0 b\u1eaft\u00a0\u0111\u1ea7u, v\u00e0 t\u1ea1i v\u1ecb tr\u00ed\u00a0\u0111\u00f3 s\u1ebd t\u00e1ch k\u00fd t\u1ef1\u00a0\u0111\u1ea7u ti\u00ean ra\u00a0\u0111\u1ec3 vi\u1ebft hoa.<\/p>\n<p>Logic tr\u00ean c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i nh\u01b0 sau (vi\u1ebft c\u00f4ng th\u1ee9c tr\u00ean d\u00f2ng 6):<\/p>\n<ul>\n<li>N\u1ebfu t\u1ea1i v\u1ecb tr\u00ed \u0111\u1ecdc ra ch\u1eef t\u01b0\u01a1ng\u00a0\u1ee9ng l\u00e0\u00a0\u00f4 tr\u1ed1ng (gi\u00e1 tr\u1ecb r\u1ed7ng) th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng (kh\u00f4ng x\u1eed l\u00fd)<\/li>\n<li>N\u1ebfu t\u1ea1i v\u1ecb tr\u00ed \u0111\u00f3 kh\u00f4ng r\u1ed7ng th\u00ec x\u00e9t t\u1ed5ng s\u1ed1 \u00f4 tr\u1ed1ng\u00a0\u1edf ph\u00eda tr\u01b0\u1edbc n\u00f3 c\u00f3 b\u1eb1ng v\u1edbi v\u1ecb tr\u00ed s\u1ed1\u00a0\u0111\u00f3 kh\u00f4ng, n\u1ebfu\u00a0\u0111\u00fang th\u00ec s\u1ebd x\u1eed l\u00fd vi\u1ebft hoa ch\u1eef c\u00e1i\u00a0\u0111\u1ea7u ti\u00ean, n\u1ebfu kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0\u0111\u1ecdc b\u1eb1ng ch\u1eef\u00a0\u0111\u00e3 c\u00f3.<\/li>\n<\/ul>\n<p>T\u1ea1i C6 ta c\u00f3 c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"padding-left: 30px\">IF(C5=\u201d\u201d,\u201d\u201d,IF(COUNTIF(B5:B5,\u201d\u201d)=C2,UPPER(LEFT(C5,1))&amp;RIGHT(C5,LEN(C5)-1),C5))<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>C5 l\u00e0 v\u1ecb tr\u00ed k\u1ebft qu\u1ea3\u00a0\u0111\u00e3\u00a0\u0111\u1ecdc b\u1eb1ng ch\u1eef c\u1ea7n x\u1eed l\u00fd<\/li>\n<li>COUNTIF(B5:B5,\u201d\u201d) l\u00e0\u00a0\u0111\u1ebfm s\u1ed1\u00a0\u00f4 tr\u1ed1ng trong v\u00f9ng t\u1eeb B5. V\u1edbi c\u00e1c v\u1ecb tr\u00ed kh\u00e1c s\u1ebd b\u1eaft\u00a0\u0111\u1ea7u\u00a0\u0111\u1ebfm t\u1eeb B5 v\u00e0 t\u0103ng d\u1ea7n l\u00ean (sang b\u00ean ph\u1ea3i)<\/li>\n<li>UPPER(LEFT(C5,1))&amp;RIGHT(C5,LEN(C5)-1) l\u00e0 h\u00e0m x\u1eed l\u00fd vi\u1ebft hoa ch\u1eef c\u00e1i\u00a0\u0111\u1ea7u ti\u00ean trong n\u1ed9i dung\u00a0\u1edf C5<\/li>\n<\/ul>\n<p>Xem l\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-chi-viet-hoa-chu-cai-dau-tien-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch ch\u1ec9 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean trong Excel<\/a><\/p>\n<p>Fillright c\u00f4ng th\u1ee9c t\u1ea1i C6 t\u1edbi N6 (trong\u00a0\u0111\u00f3 ch\u00fa\u00a0\u00fd v\u1ecb tr\u00ed B5 \u0111\u1ea7u ti\u00ean trong h\u00e0m\u00a0COUNTIF ph\u1ea3i gi\u1eef nguy\u00ean, kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c thay\u00a0\u0111\u1ed5i; c\u00f3 th\u1ec3 c\u1ed1\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed n\u00e0y v\u1edbi ph\u00edm F4)<\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22732\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b8-viet-hoa-chu-cai-dau-tien.png\" width=\"1524\" height=\"293\" title=\"b8-viet-hoa-chu-cai-dau-tien\"><\/p>\n<p>(n\u00ean l\u00e0m b\u01b0\u1edbc n\u00e0y tr\u01b0\u1edbc, b\u1edfi l\u00e0m\u00a0\u1edf b\u01b0\u1edbc sau th\u00ec h\u00e0m x\u1eed l\u00fd vi\u1ebft hoa s\u1ebd r\u1ea5t d\u00e0i, d\u1ec5 b\u1ecb r\u1ed1i)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ghep_cac_tu_da_doc_thanh_ket_qua_so_tien_bang_chu\"><\/span>Gh\u00e9p c\u00e1c t\u1eeb\u00a0\u0111\u00e3\u00a0\u0111\u1ecdc th\u00e0nh k\u1ebft qu\u1ea3 s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eebng v\u1ecb tr\u00ed ch\u1eef s\u1ed1\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecdc, vi\u1ec7c c\u00f2n l\u1ea1i ch\u1ec9\u00a0\u0111\u01a1n gi\u1ea3n l\u00e0m gh\u00e9p l\u1ea1i c\u00e1c t\u1eeb n\u00e0y l\u00e0 xong.<\/p>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 12 v\u1ecb tr\u00ed n\u00ean s\u1ebd ph\u1ea3i gh\u00e9p theo nguy\u00ean t\u1eafc sau:<\/p>\n<ul>\n<li>M\u1ed7i v\u1ecb tr\u00ed (m\u1ed7i\u00a0\u00f4\u00a0\u1edf d\u00f2ng 6) s\u1ebd n\u1ed1i v\u1edbi v\u1ecb tr\u00ed b\u00ean c\u1ea1nh n\u00f3 v\u00e0 ph\u1ea3i th\u00eam 1 d\u1ea5u c\u00e1ch\u00a0\u1edf gi\u1eefa 2 ch\u1eef n\u00e0y.<\/li>\n<li>D\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-trim-trong-excel.html\">h\u00e0m TRIM<\/a>\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf nh\u1eefng d\u1ea5u c\u00e1ch th\u1eeba trong k\u1ebft qu\u1ea3 gh\u00e9p\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p>T\u1ea1i\u00a0\u00f4 B2 ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">B2=TRIM(C6&amp;\u201d \u201c&amp;D6&amp;\u201d \u201c&amp;E6&amp;\u201d \u201c&amp;F6&amp;\u201d \u201c&amp;G6&amp;\u201d \u201c&amp;H6&amp;\u201d \u201c&amp;I6&amp;\u201d \u201c&amp;J6&amp;\u201d \u201c&amp;K6&amp;\u201d \u201c&amp;L6&amp;\u201d \u201c&amp;M6&amp;\u201d \u201c&amp;N6)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22734\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/b9-ket-qua-tien-bang-chu.png\" width=\"1521\" height=\"328\" title=\"b9-ket-qua-tien-bang-chu\"><\/p>\n<p>N\u1ebfu vi\u1ec7c gh\u00e9p nh\u01b0 tr\u00ean l\u00e0 d\u00e0i v\u00e0 m\u1ea5t nhi\u1ec1u c\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m TEXTJOIN\u00a0\u1edf c\u00e1c phi\u00ean b\u1ea3n\u00a0Excel2016 tr\u1edf\u00a0\u0111i, c\u00f4ng vi\u1ec7c s\u1ebd\u00a0\u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n<p>Tham kh\u1ea3o b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\">GH\u00c9P N\u1ed0I K\u00dd T\u1ef0 V\u1edaI H\u00c0M CONCAT V\u00c0 TEXTJOIN TRONG EXCEL<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 b\u1eb1ng ch\u1eef trong\u00a0Excel r\u1ed3i. Logic tuy d\u00e0i d\u00f2ng nh\u01b0ng ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 ph\u00e2n t\u00edch\u00a0\u0111\u01b0\u1ee3c, s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m\u00a0Excel m\u00e0 ai c\u0169ng bi\u1ebft. B\u00e0i to\u00e1n n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n luy\u1ec7n t\u1eadp r\u1ea5t t\u1ed1t cho vi\u1ec7c ph\u00e2n t\u00edch logic, ph\u00e1t tri\u1ec3n logic th\u00e0nh c\u00f4ng th\u1ee9c, h\u00e0m trong\u00a0Excel.<\/p>\n<p>Ngo\u00e0i ra t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y r\u1ea5t\u00a0\u0111\u01a1n gi\u1ea3n, ch\u00fang ta ch\u1ec9 c\u1ea7n l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>G\u00e1n s\u1ed1 c\u1ea7n\u00a0\u0111\u1ecdc v\u00e0o v\u1ecb tr\u00ed Nh\u1eadp s\u1ed1<\/li>\n<li>G\u00e1n k\u1ebft qu\u1ea3\u00a0\u0111\u1ecdc ti\u1ec1n b\u1eb1ng ch\u1eef v\u00e0o v\u1ecb tr\u00ed k\u1ebft qu\u1ea3 c\u1ea7n\u00a0\u0111\u1ecdc.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22735\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ung-dung-doc-so-tien-thanh-chu-1.png\" width=\"1287\" height=\"757\" title=\"ung-dung-doc-so-tien-thanh-chu-1\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u1ee9ng d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh!<\/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-107.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9918,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9917","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\/9917","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=9917"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9917\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9918"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}