{"id":6023,"date":"2024-12-21T12:12:22","date_gmt":"2024-12-21T12:12:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xay-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z\/"},"modified":"2024-12-21T12:12:22","modified_gmt":"2024-12-21T12:12:22","slug":"cach-xay-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xay-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z\/","title":{"rendered":"C\u00e1ch X\u00e2y C\u00f4ng Th\u1ee9c \u0110\u1ecdc S\u1ed1 Ti\u1ec1n B\u1eb1ng Ch\u1eef Trong Excel t\u1eeb A \u0111\u1ebfn Z"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"l\u1eadp-c\u00f4ng-th\u1ee9c-s\u1ed1-ti\u1ec1n-b\u1eb1ng-ch\u1ee9-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html?lap-cong-thuc-so-tien-bang-chu-trong-excel\">\n<p><em>\u0110\u1ecdc s\u1ed1 ti\u1ec1n th\u00e0nh ch\u1eef l\u00e0 m\u1ed9t trong s\u1ed1 nh\u1eefng ch\u1ee7\u00a0\u0111\u1ec1 r\u1ea5t\u00a0\u0111\u01b0\u1ee3c quan t\u00e2m tr\u00ean\u00a0Excel.\u00a0Trong h\u1ea7u h\u1ebft c\u00e1c lo\u1ea1i giao d\u1ecbch: h\u1ee3p\u00a0\u0111\u1ed3ng, h\u00f3a\u00a0\u0111\u01a1n\u2026\u00a0\u0111\u1ec1u y\u00eau c\u1ea7u ph\u1ea3i<strong> \u0111\u1ecdc s\u1ed1 ti\u1ec1n\u00a0 b\u1eb1ng ch\u1eef<\/strong>. Trong nh\u1eefng b\u00e0i vi\u1ebft tr\u01b0\u1edbc\u00a0\u0111\u00e2y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a>, ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft t\u1edbi c\u00e1ch s\u1eed d\u1ee5ng Add-in trong\u00a0Excel\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y. C\u00f2n trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd bi\u1ebft th\u00eam m\u1ed9t c\u00e1ch l\u00e0m kh\u00e1c: S\u1eed d\u1ee5ng h\u00e0m, c\u00f4ng th\u1ee9c trong Excel\u00a0\u0111\u1ec3\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n th\u00e0nh ch\u1eef. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay n\u00e0o.<\/em><\/p>\n<\/blockquote>\n<p>\u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 ch\u00fang ta s\u1ebd\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22526 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-doc-so-thanh-chu.png\" alt=\"\u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef\" width=\"1491\" height=\"263\" title=\"ket-qua-doc-so-thanh-chu\"><\/p>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2Upapa1\" rel=\"noopener nofollow\">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-6766b0a5dbfd2\" 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-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Su_phuc_tap_cua_viec_doc_so_tien_bang_chu_theo_tieng_viet\" title=\"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\">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<\/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-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Chuyen_so_bat_ky_ve_dang_so_co_tren_12_chu_so\" title=\"Chuy\u1ec3n s\u1ed1 b\u1ea5t k\u1ef3 v\u1ec1 d\u1ea1ng s\u1ed1 c\u00f3 tr\u00ean 12 ch\u1eef s\u1ed1\">Chuy\u1ec3n s\u1ed1 b\u1ea5t k\u1ef3 v\u1ec1 d\u1ea1ng s\u1ed1 c\u00f3 tr\u00ean 12 ch\u1eef s\u1ed1<\/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-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Tach_tung_chu_so_ra_12_vi_tri\" title=\"T\u00e1ch t\u1eebng\u00a0ch\u1eef s\u1ed1 ra 12 v\u1ecb tr\u00ed\">T\u00e1ch t\u1eebng\u00a0ch\u1eef s\u1ed1 ra 12 v\u1ecb tr\u00ed<\/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-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Ham_doc_tung_vi_tri_bang_chu\" title=\"H\u00e0m\u00a0\u0111\u1ecdc t\u1eebng v\u1ecb tr\u00ed b\u1eb1ng ch\u1eef\">H\u00e0m\u00a0\u0111\u1ecdc t\u1eebng v\u1ecb tr\u00ed b\u1eb1ng ch\u1eef<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Doc_vi_tri_hang_tram_ty\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m t\u1ef7\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m t\u1ef7<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Doc_vi_tri_hang_chuc_ty\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c t\u1ef7\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c t\u1ef7<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-so-tien-bang-chu-trong-excel-tu-a-den-z.html#Doc_vi_tri_hang_ty_hang_don_vi\" title=\"\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng t\u1ef7 (h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb)\">\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng t\u1ef7 (h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_phuc_tap_cua_viec_doc_so_tien_bang_chu_theo_tieng_viet\"><\/span>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<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc khi\u00a0\u0111i v\u00e0o t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m, xin ph\u00e9p\u00a0\u0111\u01b0\u1ee3c nh\u1eafc l\u1ea1i m\u1ed9t s\u1ed1 v\u1ea5n\u00a0\u0111\u1ec1 khi\u1ebfn cho vi\u1ec7c\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef l\u1ea1i \u201c<strong>kh\u00f3<\/strong>\u201c, khi\u1ebfn nhi\u1ec1u ng\u01b0\u1eddi kh\u00f4ng l\u00e0m\u00a0\u0111\u01b0\u1ee3c:<\/p>\n<ul>\n<li>S\u1ed1 ti\u1ec1n c\u00f3 th\u1ec3 l\u1edbn, l\u00ean t\u1edbi h\u00e0ng t\u1ef7, ngh\u00ecn t\u1ef7, th\u1eadm ch\u00ed l\u1edbn h\u01a1n n\u1eefa. Do\u00a0\u0111\u00f3 vi\u1ec7c ph\u00e2n t\u00e1ch c\u00e1ch th\u00e0nh ph\u1ea7n t\u1ef7 \/ tri\u1ec7u \/ ngh\u00ecn \/ tr\u0103m khi\u1ebfn kh\u00f4ng th\u1ec3 d\u00f9ng 1 c\u00f4ng th\u1ee9c m\u00e0\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c ngay. Ph\u1ea3i ph\u1ed1i h\u1ee3p nhi\u1ec1u c\u00f4ng th\u1ee9c kh\u00e1c nhau, m\u1ed7i nh\u00f3m l\u1ea1i c\u00f3 logic kh\u00e1c nhau.<\/li>\n<li>Phi\u00ean\u00a0\u00e2m c\u00f3 s\u1ef1 thay\u00a0\u0111\u1ed5i kh\u00f4ng\u00a0\u0111\u1ed3ng nh\u1ea5t gi\u1eefa c\u00e1c\u00a0\u0111\u1ecba ph\u01b0\u01a1ng. Nh\u1eefng t\u1eeb nh\u01b0 <em>\u201cb\u1ea3y\/ b\u1ea9y\u201d, \u201cngh\u00ecn \/ ng\u00e0n\u201d, \u201clinh \/ l\u1ebb\u201d<\/em>\u00a0\u0111\u00f4i khi c\u00f3 th\u1ec3 d\u00f9ng m\u1ed7i n\u01a1i m\u1ed9t kh\u00e1c, nh\u01b0ng\u00a0\u0111\u1ec1u\u00a0\u0111\u00fang. Do\u00a0\u0111\u00f3 c\u1ea7n c\u00f3 s\u1ef1 bi\u1ebfn\u00a0\u0111\u1ed5i linh ho\u1ea1t\u00a0c\u00e1c t\u1eeb n\u00e0y\u00a0\u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u s\u1eed d\u1ee5ng.<\/li>\n<li>S\u1ed1 ti\u1ec1n ch\u1eb5n v\u00e0 l\u1ebb s\u1ebd c\u00f3\u00a0\u0111u\u00f4i k\u1ebft th\u00fac kh\u00e1c nhau. V\u1edbi ti\u1ec1n ch\u1eb5n s\u1ebd c\u00f3 k\u1ebft th\u00fac l\u00e0 \u201c\u0111\u1ed3ng ch\u1eb5n\u201d, c\u00f2n ti\u1ec1n l\u1ebb ch\u1ec9 k\u1ebft th\u00fac v\u1edbi \u201c\u0111\u1ed3ng\u201d. Do\u00a0\u0111\u00f3 vi\u1ec7c t\u00f9y bi\u1ebfn ph\u1ea7n k\u1ebft th\u00fac c\u0169ng khi\u1ebfn v\u1ea5n \u0111\u1ec1 tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p khi x\u00e1c\u00a0\u0111\u1ecbnh khi n\u00e0o l\u00e0 l\u1ebb, khi n\u00e0o l\u00e0 ch\u1eb5n (trong khi c\u00e1c c\u00e1ch\u00a0\u0111\u1ecdc c\u1ee7a ti\u1ec1n\u00a0USD kh\u00f4ng quy\u00a0\u0111\u1ecbnh vi\u1ec7c n\u00e0y)<\/li>\n<li>Trong ch\u00ednh nh\u1eefng t\u1eeb nh\u01b0 <em>\u201cm\u1ed9t \/ m\u1ed1t\u201d, \u201cb\u1ed1n \/ t\u01b0\u201d, \u201cn\u0103m \/ l\u0103m\u201d<\/em> l\u1ea1i thay\u00a0\u0111\u1ed5i trong nh\u1eefng ho\u00e0n c\u1ea3nh nh\u1ea5t\u00a0\u0111\u1ecbnh. Vi\u1ec7c x\u00e1c\u00a0\u0111\u1ecbnh khi n\u00e0o d\u00f9ng t\u1eeb n\u00e0o\u00a0\u0111\u00f2i h\u1ecfi ph\u1ea3i bi\u1ec7n lu\u1eadn logic ph\u1ee9c t\u1ea1p h\u01a1n nhi\u1ec1u so v\u1edbi c\u00e1ch\u00a0\u0111\u1ecdc tr\u1ef1c ti\u1ebfp t\u1eebng s\u1ed1.<\/li>\n<li>Ngo\u00e0i ra c\u00f2n m\u1ed9t ph\u1ea7n m\u1edf r\u1ed9ng n\u1eefa l\u00e0 khi\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n ngo\u1ea1i t\u1ec7 theo c\u00e1ch ti\u1ebfng vi\u1ec7t c\u00f3 th\u1ec3 kh\u00e1c v\u1edbi c\u00e1ch\u00a0\u0111\u1ecdc c\u1ee7a n\u01b0\u1edbc ngo\u00e0i (ti\u1ebfng anh). Do\u00a0\u0111\u00f3 c\u1ea7n l\u01b0u\u00a0\u00fd khi thay\u00a0\u0111\u1ed5i c\u00e1ch\u00a0\u0111\u1ecdc v\u1edbi c\u00e1c lo\u1ea1i ngo\u1ea1i t\u1ec7<\/li>\n<\/ul>\n<p>V\u1edbi nh\u1eefng v\u1ea5n\u00a0\u0111\u1ec1 ph\u1ee9c t\u1ea1p tr\u00ean, ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00e2y d\u1ef1ng h\u00e0m\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng\u00a0ch\u1eef theo t\u1eebng b\u01b0\u1edbc\u00a0\u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn.<\/p>\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<p><em>Trong ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch\u00a0\u0111\u1ecdc s\u1ed1 t\u1edbi h\u00e0ng tr\u0103m t\u1ef7 (g\u1ed3m 12 ch\u1eef s\u1ed1). Nh\u1eefng s\u1ed1 t\u1eeb h\u00e0ng ngh\u00ecn t\u1ef7 tr\u1edf l\u00ean c\u00e1c b\u1ea1n t\u1ef1 ph\u00e1t tri\u1ec3n ti\u1ebfp theo\u00a0\u00fd t\u01b0\u1edfng c\u1ee7a b\u00e0i vi\u1ebft.<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chuyen_so_bat_ky_ve_dang_so_co_tren_12_chu_so\"><\/span>Chuy\u1ec3n s\u1ed1 b\u1ea5t k\u1ef3 v\u1ec1 d\u1ea1ng s\u1ed1 c\u00f3 tr\u00ean 12 ch\u1eef s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea3n ch\u1ea5t c\u1ee7a 1 con s\u1ed1 l\u00e0 kh\u00f4ng c\u00f3 s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc (ho\u1eb7c c\u00f3 th\u00ec c\u0169ng kh\u00f4ng c\u00f3\u00a0\u00fd ngh\u0129a g\u00ec). Tuy nhi\u00ean khi mu\u1ed1n ph\u00e2n t\u00e1ch th\u1ee9 t\u1ef1 c\u1ee7a t\u1eebng v\u1ecb tr\u00ed c\u00e1c s\u1ed1 ra t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1eebng ch\u1eef s\u1ed1, ch\u00fang ta l\u1ea1i c\u1ea7n ph\u1ea3i chuy\u1ec3n con s\u1ed1 v\u1ec1 d\u1ea1ng c\u00f3\u00a0\u0111\u1ee7 12 ch\u1eef s\u1ed1, n\u1ebfu s\u1ed1\u00a0\u0111\u00f3 nh\u1ecf h\u01a1n h\u00e0ng tr\u0103m t\u1ef7 th\u00ec ph\u1ea3i th\u00eam s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc.<\/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-539.gif\" title=\"ex101_92019-nho-539\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ph\u01b0\u01a1ng ph\u00e1p\u00a0\u0111\u01a1n gi\u1ea3n\u00a0\u0111\u1ec3 chuy\u1ec3n 1 s\u1ed1 v\u1ec1 d\u1ea1ng s\u1ed1 c\u00f3 tr\u00ean 12 ch\u1eef s\u1ed1 l\u00e0 c\u1ed9ng s\u1ed1\u00a0\u0111\u00f3 v\u1edbi 10 m\u0169 12 (m\u1ed9t s\u1ed1 c\u00f3 12 ch\u1eef s\u1ed1 0\u00a0\u1edf ph\u00eda sau)<\/p>\n<p><strong><em>V\u00ed d\u1ee5:<\/em><\/strong><\/p>\n<p>S\u1ed1 10.010.001.010 l\u00e0 s\u1ed1 c\u00f3 11 ch\u1eef s\u1ed1. Khi\u00a0\u0111em s\u1ed1 n\u00e0y c\u1ed9ng v\u1edbi 10^12 ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0: 1.0<strong>10.010.001.010<\/strong><\/p>\n<p>N\u1ebfu l\u1ea5y 12 ch\u1eef s\u1ed1 t\u1eeb ph\u1ea3i qua tr\u00e1i th\u00ec ta c\u00f3 k\u1ebft qu\u1ea3\u00a00<strong>10.010.001.010<\/strong>. S\u1ed1 n\u00e0y v\u1ec1 b\u1ea3n ch\u1ea5t gi\u1ed1ng v\u1edbi s\u1ed1 ban\u00a0\u0111\u1ea7u v\u1edbi 11 ch\u1eef s\u1ed1, nh\u01b0ng c\u00f3 th\u00eam s\u1ed1 0\u00a0\u1edf tr\u01b0\u1edbc\u00a0\u0111\u1ec3 ph\u1ea3n\u00a0\u00e1nh\u00a0\u0111\u00fang t\u1eebng con s\u1ed1 trong c\u00e1c ch\u1eef s\u1ed1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22653 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b1-chuyen-so-ve-12-chu-so.png\" alt=\"C\u00e1ch \u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef\" width=\"1521\" height=\"306\" title=\"b1-chuyen-so-ve-12-chu-so\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tach_tung_chu_so_ra_12_vi_tri\"><\/span>T\u00e1ch t\u1eebng\u00a0ch\u1eef s\u1ed1 ra 12 v\u1ecb tr\u00ed<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb c\u1ed9t C\u00a0\u0111\u1ebfn c\u1ed9t N, ch\u00fang ta c\u00f3 12 s\u1ed1 t\u01b0\u01a1ng\u00a0\u1ee9ng t\u1eeb 1\u00a0\u0111\u1ebfn 12 (d\u00f2ng 2) gi\u00fap nh\u1eadn bi\u1ebft t\u1eebng v\u1ecb tr\u00ed c\u00e1c ch\u1eef s\u1ed1.<\/p>\n<p>T\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u00e1c c\u1ed9t n\u00e0y, t\u1ea1i d\u00f2ng 3 ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m\u00a0\u0111\u1ec3 t\u00e1ch t\u1eebng v\u1ecb tr\u00ed c\u00e1c ch\u1eef s\u1ed1 trong d\u00e3y s\u1ed1\u00a0\u1edf\u00a0\u00f4 B2 nh\u01b0 sau:<\/p>\n<p>S\u1eed d\u1ee5ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-mid-va-cach-su-dung-ham-mid-trong-excel.html\">h\u00e0m MID<\/a><\/strong>\u00a0\u0111\u1ec3 t\u00e1ch t\u1eebng v\u1ecb tr\u00ed trong d\u00e3y s\u1ed1, trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>Text<\/strong>: l\u00e0 d\u00e3y s\u1ed1\u00a0\u1edf\u00a0\u00f4 B2. Khi vi\u1ebft c\u00f4ng th\u1ee9c ch\u00fang ta ch\u00fa\u00a0\u00fd c\u1ed1\u00a0\u0111\u1ecbnh tham chi\u1ebfu\u00a0\u00f4 B2<\/li>\n<li><strong>Start_num<\/strong>: l\u00e0 b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb k\u00fd t\u1ef1 th\u1ee9 m\u1ea5y. V\u00ec d\u00e3y s\u1ed1\u00a0\u1edf\u00a0\u00f4 B2 c\u00f3 13 k\u00fd t\u1ef1, trong khi ch\u00fang ta ch\u1ec9 l\u1ea5y 12 k\u00fd t\u1ef1 b\u00ean ph\u1ea3i, t\u1ee9c l\u00e0 l\u1ec7ch so v\u1edbi k\u00fd t\u1ef1 b\u1eaft\u00a0\u0111\u1ea7u 1 ch\u1eef s\u1ed1. Do\u00a0\u0111\u00f3 Start_num s\u1ebd b\u1eb1ng s\u1ed1 t\u01b0\u01a1ng \u1ee9ng \u1edf d\u00f2ng 2 + 1<\/li>\n<li><strong>Num_char<\/strong>: l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y.\u00a0\u1ede\u00a0\u0111\u00e2y ch\u00fang ta ch\u1ec9 l\u1ea5y duy nh\u1ea5t 1 k\u00fd t\u1ef1 t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi v\u1ecb tr\u00ed ch\u1eef s\u1ed1 c\u1ea7n t\u00e1ch.<\/li>\n<\/ul>\n<p>Tuy nhi\u00ean h\u00e0m MID ch\u1ec9 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng text. Do\u00a0\u0111\u00f3 ch\u00fang ta k\u1ebft h\u1ee3p th\u00eam <a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-value-va-cac-tuy-chon-khac-de-chuyen-doi-dinh-dang-cua-tu-text-sang-number.html\">h\u00e0m VALUE<\/a>\u00a0\u0111\u1ec3 chuy\u1ec3n k\u1ebft qu\u1ea3 v\u1ec1 d\u1eef li\u1ec7u d\u1ea1ng Number (tr\u00e1nh xung\u00a0\u0111\u1ed9t v\u1ec1 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u)<\/p>\n<p style=\"padding-left: 30px\">C3=MID($B$2,C2+1,1)<\/p>\n<p>T\u1eeb C3:N3 ch\u00fang ta sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb C3 sang ph\u1ea3i (thao t\u00e1c <strong>Fill Right<\/strong>, ph\u00edm t\u1eaft <strong>Ctrl+R<\/strong>)<\/p>\n<p>K\u1ebft qu\u1ea3 ch\u00fang ta c\u00f3\u00a0\u0111\u01b0\u1ee3c t\u1eebng v\u1ecb tr\u00ed c\u00e1c con s\u1ed1 t\u01b0\u01a1ng\u00a0\u1ee9ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22699 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b1-ket-qua-tach-vi-tri-12-chu-so.png\" alt=\"C\u00e1ch \u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel\" width=\"1521\" height=\"247\" title=\"b1-ket-qua-tach-vi-tri-12-chu-so\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_doc_tung_vi_tri_bang_chu\"><\/span>H\u00e0m\u00a0\u0111\u1ecdc t\u1eebng v\u1ecb tr\u00ed b\u1eb1ng ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ec c\u00e1c v\u1ecb tr\u00ed c\u00f3 th\u1ec3 bao g\u1ed3m c\u00e1c s\u1ed1 t\u1eeb 0\u00a0\u0111\u1ebfn 9, trong\u00a0\u0111\u00f3 s\u1ed1 0 l\u1ea1i c\u00f3 c\u00e1ch\u00a0\u0111\u1ecdc r\u1ea5t\u00a0\u0111\u1eb7c bi\u1ec7t, ph\u1ee5 thu\u1ed9c v\u00e0o tr\u01b0\u1edbc\u00a0\u0111\u00f3 c\u00f3 s\u1ed1 n\u00e0o kh\u00e1c 0 kh\u00f4ng, n\u00ean khi\u00a0\u0111\u1ecdc s\u1ed1 ra ch\u1eef ch\u00fang ta ph\u1ea3i x\u00e9t 2 ph\u1ea7n:<\/p>\n<ul>\n<li>Ph\u1ea7n\u00a0ph\u00eda b\u00ean tr\u00e1i\u00a0t\u00ednh t\u1eeb v\u1ecb tr\u00ed\u00a0\u0111\u00f3 tr\u1edf\u00a0\u0111i<\/li>\n<li>S\u1ed1 t\u1ea1i v\u1ecb tr\u00ed\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<p>C\u00e1c h\u00e0m s\u1ebd vi\u1ebft\u00a0\u1edf d\u00f2ng 5 (d\u00f2ng 4 ph\u1ee5c v\u1ee5 cho m\u1ee5c\u00a0\u0111\u00edch chuy\u1ec3n\u00a0\u0111\u1ed5i c\u00e1c t\u1eeb mang y\u1ebfu t\u1ed1\u00a0\u0111\u1ecba ph\u01b0\u01a1ng\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn c\u00e1ch\u00a0\u0111\u1ecdc cho ph\u00f9 h\u1ee3p)<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_tram_ty\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng tr\u0103m t\u1ef7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1ea1i v\u1ecb tr\u00ed n\u00e0y l\u00e0 v\u1ecb tr\u00ed\u00a0\u0111\u1ea7u ti\u00ean trong chu\u1ed7i 12 ch\u1eef s\u1ed1, do\u00a0\u0111\u00f3 kh\u00f4ng x\u00e9t ph\u1ea7n b\u00ean tr\u00e1i m\u00e0 x\u00e9t ngay t\u1ea1i v\u1ecb tr\u00ed\u00a0\u0111\u00f3 l\u00e0\u00a0\u00f4 C3<\/p>\n<ul>\n<li>N\u1ebfu\u00a0 C3=0 th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng, t\u1ee9c kh\u00f4ng\u00a0\u0111\u1ecdc g\u00ec c\u1ea3<\/li>\n<li>N\u1ebfu C3 kh\u00e1c 0 th\u00ec s\u1ebd\u00a0\u0111\u1ecdc t\u1eeb m\u1ed9t\u00a0\u0111\u1ebfn ch\u00edn, k\u00e8m theo\u00a0\u0111\u01a1n v\u1ecb l\u00e0 \u201ctr\u0103m\u201d (h\u00e0ng tr\u0103m t\u1ef7)<\/li>\n<\/ul>\n<p>H\u00e0m t\u1ea1i C5\u00a0\u0111\u01b0\u1ee3c\u00a0vi\u1ebft\u00a0nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">IF(C3=0,\u201d\u201d,CHOOSE(C3,\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<ul>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\">H\u00e0m\u00a0IF<\/a><\/strong>\u00a0\u0111\u1ec3 x\u00e9t logic t\u1ea1i C3 c\u00f3 b\u1eb1ng 0 hay kh\u00f4ng.<\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">H\u00e0m CHOOSE<\/a>\u00a0\u0111\u1ec3 l\u1ea5y t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1ecb tr\u00ed s\u1ed1\u00a0\u1edf C3 v\u1edbi c\u00e1c t\u1eeb phi\u00ean\u00a0\u00e2m b\u1eb1ng ch\u1eef c\u1ee7a s\u1ed1\u00a0\u0111\u00f3. C\u00e1c t\u1eeb phi\u00ean\u00a0\u00e2m b\u1eb1ng ch\u1eef\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p v\u00ec l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng text.<\/li>\n<li>N\u1ed1i h\u00e0m CHOOSE v\u1edbi t\u1eeb \u201ctr\u0103m\u201d b\u1edfi d\u1ea5u &amp;, tr\u01b0\u1edbc t\u1eeb \u201ctr\u0103m\u201d c\u00f3 th\u00eam d\u1ea5u c\u00e1ch l\u00e0 \u201d tr\u0103m\u201d\u00a0\u0111\u1ec3 t\u1ea1o kho\u1ea3ng c\u00e1ch gi\u1eefa t\u1eeb phi\u00ean\u00a0\u00e2m v\u1edbi\u00a0\u0111\u01a1n v\u1ecb. To\u00e0n b\u1ed9 ph\u1ea7n n\u00e0y\u00a0\u0111\u1eb7t trong m\u1ec7nh\u00a0\u0111\u1ec1 value_if_false c\u1ee7a h\u00e0m\u00a0IF. Do\u00a0\u0111\u00f3 ph\u00eda sau m\u1ec7nh\u00a0\u0111\u1ec1 n\u00e0y s\u1ebd\u00a0\u0111\u00f3ng ngo\u1eb7c\u00a0\u0111\u1ec3 k\u1ebft th\u00fac h\u00e0m\u00a0IF.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_chuc_ty\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c t\u1ef7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c tr\u01b0\u1eddng h\u1ee3p logic c\u00f3 th\u1ec3 x\u1ea3y ra v\u1edbi v\u1ecb tr\u00ed n\u00e0y bao g\u1ed3m:<\/p>\n<ul>\n<li>Ph\u1ea7n t\u1eeb v\u1ecb tr\u00ed h\u00e0ng ch\u1ee5c t\u1ef7 tr\u1edf v\u1ec1 b\u00ean tr\u00e1i (t\u1eeb C3:D3) c\u00f3 v\u1ecb tr\u00ed n\u00e0o c\u00f3 s\u1ed1 li\u1ec7u kh\u00f4ng, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 so s\u00e1nh t\u1ed5ng C3:D3 c\u00f3 =0 hay kh\u00f4ng. N\u1ebfu =0 th\u00ec t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 n\u1ed9i dung g\u00ec. Khi\u00a0\u0111\u00f3 s\u1ebd kh\u00f4ng c\u1ea7n\u00a0\u0111\u1ecdc v\u1ecb tr\u00ed n\u00e0y, k\u1ebft qu\u1ea3 l\u00e0 r\u1ed7ng.<\/li>\n<li>N\u1ebfu logic tr\u00ean l\u00e0 sai, t\u1ee9c l\u00e0 c\u00f3 th\u1ec3 c\u00f3 1 trong 2 v\u1ecb tr\u00ed\u00a0\u1edf h\u00e0ng tr\u0103m t\u1ef7 ho\u1eb7c ch\u1ee5c t\u1ef7 (ho\u1eb7c c\u1ea3 2) th\u00ec s\u1ebd x\u00e9t chi ti\u1ebft h\u01a1n, bao g\u1ed3m:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">1. H\u00e0ng ch\u1ee5c t\u1ef7 v\u00e0 h\u00e0ng t\u1ef7 kh\u00f4ng c\u00f3 con s\u1ed1 n\u00e0o (\u0111\u1ec1u b\u1eb1ng 0) th\u00ec s\u1ebd kh\u00f4ng\u00a0\u0111\u1ecdc ph\u1ea7n h\u00e0ng ch\u1ee5c t\u1ef7 (d\u00f9 c\u00f3 s\u1ed1 h\u00e0ng tr\u0103m t\u1ef7 th\u00ec ch\u1ec9\u00a0\u0111\u1ecdc h\u00e0ng tr\u0103m, kh\u00f4ng\u00a0\u0111\u1ecdc h\u00e0ng ch\u1ee5c)<\/p>\n<p style=\"padding-left: 60px\">2. H\u00e0ng ch\u1ee5c t\u1ef7 = 0 nh\u01b0ng h\u00e0ng t\u1ef7 th\u00ec c\u00f3 (kh\u00e1c 0) th\u00ec s\u1ebd\u00a0\u0111\u1ecdc theo phi\u00ean\u00a0\u00e2m\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u1edf D4, l\u00e0 \u201clinh\u201d ho\u1eb7c \u201cl\u1ebb\u201d (t\u1ee9c l\u00e0 c\u00f3 h\u00e0ng tr\u0103m, c\u00f3 h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb nh\u01b0ng kh\u00f4ng c\u00f3 h\u00e0ng ch\u1ee5c th\u00ec s\u1ebd\u00a0\u0111\u1ecdc h\u00e0ng ch\u1ee5c l\u00e0 linh\/l\u1ebb t\u00f9y theo ti\u1ebfng\u00a0\u0111\u1ecba ph\u01b0\u01a1ng)<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 D5\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">D5=IF(SUM(C3:D3)=0,\u201d\u201d,IF(AND(D3=0,E3=0),\u201d\u201d,IF(AND(D3=0,E3&lt;&gt;0),D4,CHOOSE(D3,\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>Ch\u00fa\u00a0\u00fd: H\u00e0ng\u00a0\u0111\u01a1n v\u1ecb khi\u00a0\u0111\u1ecdc c\u00e1c con s\u1ed1 b\u1eb1ng ch\u1eef s\u1ebd kh\u00e1c v\u1edbi h\u00e0ng tr\u0103m\u00a0\u1edf nh\u1eefng v\u1ecb tr\u00ed:<\/p>\n<ul>\n<li>1\u00a0\u0111\u1ecdc l\u00e0 <strong>m\u01b0\u1eddi<\/strong> thay v\u00ec <strong>m\u1ed9t<\/strong>, kh\u00f4ng ph\u1ea3i\u00a0\u0111\u1ecdc l\u00e0 <strong>m\u01b0\u01a1i<\/strong> m\u00e0 l\u00e0 <strong>m\u01b0\u1eddi<\/strong><\/li>\n<li>t\u1eeb 2\u00a0\u0111\u1ebfn 9\u00a0\u0111\u1ecdc c\u00f3 k\u00e8m theo ch\u1eef <strong>m\u01b0\u01a1i<\/strong> ch\u1ee9 kh\u00f4ng ph\u1ea3i to\u00e0n b\u1ed9 gh\u00e9p v\u1edbi ch\u1eef <strong>m\u01b0\u01a1i<\/strong> nh\u01b0 v\u1edbi h\u00e0ng tr\u0103m (\u0111o\u1ea1n &amp;\u201d tr\u0103m\u201d).<\/li>\n<\/ul>\n<p>T\u1ea1i v\u1ecb tr\u00ed D4 thi\u1ebft l\u1eadp danh s\u00e1ch ch\u1ecdn theo Data Validation\/List:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22700 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b2-thiet-lap-data-validation-hang-chuc-ty-khi-le.png\" alt=\"\u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel\" width=\"1182\" height=\"743\" title=\"b2-thiet-lap-data-validation-hang-chuc-ty-khi-le\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c x\u00e9t nhi\u1ec1u h\u00e0m\u00a0IF h\u01a1n, b\u1edfi logic ph\u1ee9c t\u1ea1p h\u01a1n. Trong m\u1ed9t s\u1ed1 logic c\u00f3 s\u1eed d\u1ee5ng th\u00eam h\u00e0m SUM, h\u00e0m AND\u00a0\u0111\u1ec3 x\u00e9t\u00a0\u0111\u1ed3ng th\u1eddi c\u00e1c v\u1ecb tr\u00ed.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Doc_vi_tri_hang_ty_hang_don_vi\"><\/span>\u0110\u1ecdc v\u1ecb tr\u00ed h\u00e0ng t\u1ef7 (h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c tr\u01b0\u1eddng h\u1ee3p logic c\u00f3 th\u1ec3 x\u1ea3y ra v\u1edbi v\u1ecb tr\u00ed n\u00e0y bao g\u1ed3m:<\/p>\n<ul>\n<li>Ph\u1ea7n t\u1eeb v\u1ecb tr\u00ed h\u00e0ng t\u1ef7 tr\u1edf v\u1ec1 b\u00ean tr\u00e1i (t\u1eeb C3:E3) c\u00f3 v\u1ecb tr\u00ed n\u00e0o c\u00f3 s\u1ed1 li\u1ec7u kh\u00f4ng, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 so s\u00e1nh t\u1ed5ng C3:E3 c\u00f3 =0 hay kh\u00f4ng. N\u1ebfu =0 th\u00ec t\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 n\u1ed9i dung g\u00ec. Khi\u00a0\u0111\u00f3 s\u1ebd kh\u00f4ng c\u1ea7n\u00a0\u0111\u1ecdc v\u1ecb tr\u00ed n\u00e0y, k\u1ebft qu\u1ea3 l\u00e0 r\u1ed7ng.<\/li>\n<li>N\u1ebfu logic tr\u00ean l\u00e0 sai, t\u1ee9c l\u00e0 c\u00f3 th\u1ec3 c\u00f3 1 trong\u00a03 v\u1ecb tr\u00ed th\u00ec s\u1ebd x\u00e9t chi ti\u1ebft h\u01a1n, bao g\u1ed3m:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">1.\u00a0T\u1ea1i v\u1ecb tr\u00ed h\u00e0ng t\u1ef7 = 0 v\u00e0 tr\u01b0\u1edbc\u00a0\u0111\u00f3 c\u00f3 s\u1ed1 &gt;0 th\u00ec ch\u1ec9\u00a0\u0111\u1ecdc l\u00e0 \u201ct\u1ef7\u201d m\u00e0 kh\u00f4ng th\u00e8m theo ph\u1ea7n\u00a0\u0111\u1ecdc ch\u1eef s\u1ed1. C\u00f3 th\u1ec3 phi\u00ean\u00a0\u00e2m l\u00e0 \u201ct\u1ef7\u201d hay \u201ct\u1ec9\u201d t\u00f9y theo ti\u1ebfng\u00a0\u0111\u1ecba ph\u01b0\u01a1ng. V\u1eady c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp data validation \/ list ch\u1ecdn t\u1ea1i\u00a0\u00f4 E4\u00a0\u0111\u1ec3 l\u1ea5y theo v\u1ecb tr\u00ed E4<\/p>\n<p style=\"padding-left: 60px\">2.\u00a0Kh\u00f4ng\u00a0\u0111\u00fang theo logic 1 th\u00ec t\u1ee9c l\u00e0 t\u1ea1i v\u1ecb tr\u00ed E3 c\u00f3 con s\u1ed1. Khi\u00a0\u0111\u00f3 vi\u1ec7c\u00a0\u0111\u1ecdc s\u1ed1\u00a0\u1edf E3 ra ch\u1eef ph\u1ee5 thu\u1ed9c theo ch\u1eef s\u1ed1\u00a0\u1edf ph\u00eda tr\u01b0\u1edbc n\u00f3 (h\u00e0ng ch\u1ee5c). Ch\u00fa\u00a0\u00fd s\u1ebd\u00a0\u0111\u1ecdc kh\u00e1c\u00a0\u1edf v\u1ecb tr\u00ed s\u1ed1 1 v\u00e0 s\u1ed1 5 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 90px\">N\u1ebfu c\u00f3 ph\u1ea7n h\u00e0ng ch\u1ee5c th\u00ec h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb\u00a0\u0111\u1ecdc l\u00e0 1=m\u1ed1t v\u00e0 5=l\u0103m<\/p>\n<p style=\"padding-left: 90px\">N\u1ebfu kh\u00f4ng c\u00f3 ph\u1ea7n h\u00e0ng ch\u1ee5c th\u00ec h\u00e0ng\u00a0\u0111\u01a1n v\u1ecb\u00a0\u0111\u1ecdc l\u00e0 1=m\u1ed9t v\u00e0 5=n\u0103m<\/p>\n<p>L\u01b0u\u00a0\u00fd: Ngo\u00e0i ra c\u00f3 th\u1ec3 t\u00f9y bi\u1ebfn\u00a0\u1edf v\u1ecb tr\u00ed <strong>s\u1ed1 4<\/strong>\u00a0\u0111\u1ecdc l\u00e0 \u201c<strong>b\u1ed1n<\/strong>\u201d hay \u201c<strong>t\u01b0<\/strong>\u201d t\u00f9y theo c\u00e1ch\u00a0\u0111\u1ecdc t\u1eebng\u00a0\u0111\u1ecba ph\u01b0\u01a1ng. C\u00f3 th\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn ri\u00eang cho t\u1eeb n\u00e0y v\u00e0 tham chi\u1ebfu\u00a0\u1edf v\u1ecb tr\u00ed \u201c<strong>b\u1ed1n<\/strong>\u201d cho gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u0111\u00f3.<\/p>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 E5\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">E5=IF(SUM(C3:E3)=0,\u201d\u201d,IF(AND(SUM(C3:D3)&gt;0,E3=0),\u201d \u201c&amp;E4,CHOOSE(E3,IF(D3&gt;0,\u201dm\u1ed1t\u201d,\u201dm\u1ed9t\u201d),\u201dhai\u201d,\u201dba\u201d,\u201db\u1ed1n\u201d,IF(D3&gt;0,\u201dl\u0103m\u201d,\u201dn\u0103m\u201d),\u201ds\u00e1u\u201d,\u201db\u1ea3y\u201d,\u201dt\u00e1m\u201d,\u201dch\u00edn\u201d)&amp;\u201d \u201c&amp;E4))<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3\u00a0\u0111\u1ecdc xong ph\u1ea7n h\u00e0ng t\u1ef7. K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22708 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/b3-hoan-thanh-doc-so-bang-chu-hang-ty.png\" alt=\"C\u00e1ch l\u1eadp h\u00e0m \u0110\u1ecdc s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef trong excel\" width=\"1523\" height=\"246\" title=\"b3-hoan-thanh-doc-so-bang-chu-hang-ty\"><\/p>\n<p>N\u1ed9i dung b\u00e0i vi\u1ebft \u0111\u00e3 d\u00e0i, m\u1eddi c\u00e1c b\u1ea1n xem ti\u1ebfp n\u1ed9i dung\u00a0\u1edf ph\u1ea7n 2 c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y t\u1ea1i\u00a0\u0111\u1ecba ch\u1ec9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-xay-dung-cong-thuc-doc-tien-bang-chu-trong-excel-phan-2.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 \u2013 Ph\u1ea7n 2<\/a><\/p>\n<p>C\u1ea3m\u00a0\u01a1n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 ch\u00fa\u00a0\u00fd theo d\u00f5i!<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/addin-doc-thanh-chu-tu-hoc-excel-online.html\">Add-in \u0111\u1ecdc s\u1ed1 th\u00e0nh ch\u1eef t\u1eeb H\u1ecdc Excel Online<\/a><\/p>\n<p><strong>C\u00e1ch vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-cong-thuc-viet-so-tien-bang-chu-trong-ke-toan.html\">s\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1ee9 trong excel<\/a> theo c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/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-539.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6024,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6023","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\/6023","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=6023"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6023\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6024"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}