{"id":2024,"date":"2024-12-02T06:48:46","date_gmt":"2024-12-02T06:48:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-viet-ham-trong-excel-the-nao-cho-dung\/"},"modified":"2024-12-02T06:48:46","modified_gmt":"2024-12-02T06:48:46","slug":"huong-dan-cach-viet-ham-trong-excel-the-nao-cho-dung","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-viet-ham-trong-excel-the-nao-cho-dung\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft h\u00e0m trong Excel th\u1ebf n\u00e0o cho \u0111\u00fang"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong\u00a0Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m\u00a0\u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00e1c nhu c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau. Nh\u01b0ng l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 vi\u1ebft h\u00e0m \u0111\u00fang y\u00eau c\u1ea7u, gi\u00fap h\u00e0m t\u00ednh ra k\u1ebft qu\u1ea3 \u0111\u00fang? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u ch\u1ee7\u00a0\u0111\u1ec1 n\u00e0y nh\u00e9.<\/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-674d584d82187\" 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-viet-ham-trong-excel-nao-cho-dung.html#Cach_viet_ham_trong_Excel\" title=\"C\u00e1ch vi\u1ebft h\u00e0m trong Excel\">C\u00e1ch vi\u1ebft h\u00e0m trong Excel<\/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-viet-ham-trong-excel-nao-cho-dung.html#1_Cau_truc_cua_ham\" title=\"1. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\">1. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<\/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-viet-ham-trong-excel-nao-cho-dung.html#2_Gia_tri_nap_vao_ham\" title=\"2. Gi\u00e1 tr\u1ecb n\u1ea1p v\u00e0o h\u00e0m\">2. Gi\u00e1 tr\u1ecb n\u1ea1p v\u00e0o h\u00e0m<\/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-viet-ham-trong-excel-nao-cho-dung.html#3_Loai_du_lieu\" title=\"3. Lo\u1ea1i d\u1eef li\u1ec7u\">3. Lo\u1ea1i d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_viet_ham_trong_Excel\"><\/span>C\u00e1ch vi\u1ebft h\u00e0m trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c h\u00e0m t\u00ednh to\u00e1n r\u1ea5t \u0111a d\u1ea1ng v\u00e0 m\u1ee9c \u0111\u1ed9 ph\u1ee9c t\u1ea1p c\u0169ng kh\u00e1c nhau. Nh\u01b0ng t\u1ef1u chung l\u1ea1i \u0111\u1ec1u c\u00f3 3 th\u00e0nh t\u1ed1 ch\u00ednh. \u0110\u1ec3 d\u00f9ng h\u00e0m\u00a0\u0111\u00fang c\u00e1ch, ch\u00fang ta c\u1ea7n ch\u00fa\u00a0\u00fd c\u00e1c y\u1ebfu t\u1ed1 sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Cau_truc_cua_ham\"><\/span>1. C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m hay c\u00f2n g\u1ecdi l\u00e0 c\u00fa ph\u00e1p khi vi\u1ebft h\u00e0m. M\u1ed7i h\u00e0m c\u00f3 s\u1eb5n trong\u00a0Excel\u00a0\u0111\u1ec1u\u00a0\u0111\u01b0\u1ee3c g\u1ee3i\u00a0\u00fd v\u1ec1 c\u1ea5u tr\u00fac\u00a0\u0111\u1ec3 ch\u00fang ta vi\u1ebft\u00a0\u0111\u00fang:<\/p>\n<p>V\u00ed d\u1ee5: C\u1ea5u tr\u00fac h\u00e0m VLOOKUP:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27635\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cau-truc-ham-vlookup.png\" width=\"497\" height=\"56\" title=\"cau-truc-ham-vlookup\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 b\u1ea1n ch\u1ec9 c\u1ea7n n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1c th\u00e0nh ph\u1ea7n trong c\u1ea5u tr\u00fac h\u00e0m l\u00e0 hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c c\u00e1ch vi\u1ebft\u00a0\u0111\u00fang.<\/p>\n<p>V\u00ed d\u1ee5: V\u1edbi c\u1ea5u tr\u00fac h\u00e0m VLOOKUP ch\u00fang ta c\u00f3 th\u1ec3 d\u1ecbch theo ngh\u0129a ti\u1ebfng anh c\u1ee7a t\u1eebng n\u1ed9i dung ra ti\u1ebfng vi\u1ec7t \u0111\u1ec3 hi\u1ec3u:<\/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-152.gif\" title=\"ex101_92019-nho-152\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>lookup_value: l\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm, gi\u00e1 tr\u1ecb tham chi\u1ebfu<\/li>\n<li>table_array: l\u00e0 b\u1ea3ng, m\u1ea3ng d\u1eef li\u1ec7u (ph\u1ee5c v\u1ee5 cho vi\u1ec7c t\u00ecm ki\u1ebfm, tham chi\u1ebfu)<\/li>\n<li>col_index_num: col l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb column, ngh\u0129a l\u00e0 s\u1ed1 c\u1ed9t tham chi\u1ebfu t\u1edbi (c\u1ed9t k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm l\u00e0 s\u1ed1 m\u1ea5y)<\/li>\n<li>range_lookup: l\u00e0 ph\u1ea1m vi tham chi\u1ebfu, t\u00ecm ki\u1ebfm. Hay c\u00f2n c\u00f3 1 ngh\u0129a kh\u00e1c l\u00e0 ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu. Khi vi\u1ebft t\u1edbi tham s\u1ed1 n\u00e0y s\u1ebd c\u00f3 g\u1ee3i\u00a0\u00fd c\u1ee5 th\u1ec3:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-27636\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-range-lookup-guide-1024x81-1.png\" width=\"1024\" height=\"81\" title=\"vlookup-range-lookup-guide-1024x81-1\"><\/p>\n<p>Ti\u1ebfp t\u1ee5c d\u1ecbch n\u1ed9i dung h\u01b0\u1edbng d\u1eabn, g\u1ee3i\u00a0\u00fd ch\u00fang ta s\u1ebd th\u1ea5y gi\u00e1 tr\u1ecb nh\u1eadp v\u00e0o tham s\u1ed1\u00a0n\u00e0y c\u00f3 2 d\u1ea1ng:<\/p>\n<ul>\n<li>TRUE: nh\u1eadp ch\u1eef TRUE, th\u1ec3 hi\u1ec7n tham chi\u1ebfu t\u01b0\u01a1ng\u00a0\u0111\u1ed1i<\/li>\n<li>FALSE: nh\u1eadp ch\u1eef FALSE, th\u1ec3 hi\u1ec7n tham chi\u1ebfu ch\u00ednh x\u00e1c<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady vi\u1ec7c vi\u1ebft h\u00e0m d\u1ef1a v\u00e0o g\u1ee3i\u00a0\u00fd trong c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m s\u1ebd gi\u00fap ch\u00fang ta bi\u1ebft\u00a0\u0111\u01b0\u1ee3c h\u00e0m c\u1ea7n g\u00ec\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c. Ch\u1ec9 khi vi\u1ebft\u00a0\u0111\u00fang c\u1ea5u tr\u00fac th\u00ec h\u00e0m m\u1edbi t\u00ednh\u00a0\u0111\u00fang.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Gia_tri_nap_vao_ham\"><\/span>2. Gi\u00e1 tr\u1ecb n\u1ea1p v\u00e0o h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c vi\u1ebft\u00a0\u0111\u00fang c\u1ea5u tr\u00fac th\u00e0nh ph\u1ea7n trong h\u00e0m, ch\u00fang ta c\u00f2n ph\u1ea3i vi\u1ebft\u00a0\u0111\u00fang gi\u00e1 tr\u1ecb.<\/p>\n<p>V\u00ed d\u1ee5: Tham s\u1ed1 col_index_num\u00a0\u0111\u00f2i h\u1ecfi ch\u00fang ta ph\u1ea3i nh\u1eadp 1 con s\u1ed1. Con s\u1ed1\u00a0n\u00e0y\u00a0th\u1ec3 hi\u1ec7n s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm trong table_array. Nh\u01b0 v\u1eady gi\u00e1 tr\u1ecb n\u00e0y ph\u1ea3i:<\/p>\n<ul>\n<li>N\u1eb1m trong gi\u1edbi h\u1ea1n c\u1ee7a table_array. T\u1ee9c l\u00e0 table_array c\u00f3 5 c\u1ed9t th\u00ec col_index_num ch\u1ec9\u00a0\u0111\u01b0\u1ee3c nh\u1eadn gi\u00e1 tr\u1ecb t\u1ed1i\u00a0\u0111a l\u00e0 5, n\u1ebfu l\u1edbn h\u01a1n s\u1ebd sai.<\/li>\n<li>Kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1: N\u1ebfu nh\u1eadp k\u00fd t\u1ef1 Text\u00a0\u1edf\u00a0\u0111\u00e2y s\u1ebd b\u1ecb sai.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady gi\u00e1 tr\u1ecb n\u1ea1p v\u00e0o h\u00e0m ph\u1ea3i tu\u00e2n th\u1ee7 th\u00eam y\u1ebfu t\u1ed1 h\u1ee3p l\u00fd v\u1ec1 logic ch\u1ee9 kh\u00f4ng ph\u1ea3i mu\u1ed1n nh\u1eadp gi\u00e1 tr\u1ecb n\u00e0o c\u0169ng\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Ngo\u00e0i ra, khi nh\u1eadp gi\u00e1 tr\u1ecb v\u00e0o h\u00e0m c\u00f2n ph\u1ea3i ch\u00fa\u00a0\u00fd v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u1ea1p: Tr\u1ef1c ti\u1ebfp hay gi\u00e1n ti\u1ebfp.<\/p>\n<ul>\n<li>N\u1ea1p tr\u1ef1c ti\u1ebfp: Vi\u1ebft tr\u1ef1c ti\u1ebfp gi\u00e1 tr\u1ecb.<\/li>\n<li>N\u1ea1p gi\u00e1n ti\u1ebfp: Tham chi\u1ebfu t\u1edbi 1\u00a0\u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27637\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-viet-tham-chieu-trong-ham.png\" width=\"744\" height=\"266\" title=\"cach-viet-tham-chieu-trong-ham\"><\/p>\n<p>Trong 2 c\u00f4ng th\u1ee9c tr\u00ean\u00a0\u0111\u1ec1u ra k\u1ebft qu\u1ea3\u00a0\u0111\u00fang, nh\u01b0ng trong c\u00e1ch n\u1ea1p gi\u00e1 tr\u1ecb v\u00e0o h\u00e0m s\u1eed d\u1ee5ng 2 c\u00e1ch kh\u00e1c nhau:<\/p>\n<ul>\n<li>C\u00e1ch 1: C\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp s\u1ed1 3<\/li>\n<li>C\u00e1ch 2: Tham chi\u1ebfu t\u1edbi\u00a0\u00f4 C2 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 3<\/li>\n<\/ul>\n<p>Ngo\u00e0i ra c\u00e1c th\u00e0nh ph\u1ea7n kh\u00e1c c\u0169ng c\u00f3 th\u1ec3 ph\u00e2n t\u00edch:<\/p>\n<ul>\n<li>lookup_value: ch\u1eef Nga\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p, vi\u1ebft tr\u1ef1c ti\u1ebfp<\/li>\n<li>table_array: A3:C5 l\u00e0 b\u1ea3ng tham chi\u1ebfu, vi\u1ebft gi\u00e1n ti\u1ebfp (\u1edf\u00a0\u0111\u00e2y bu\u1ed9c ph\u1ea3i vi\u1ebft d\u1ea1ng tham chi\u1ebfu)<\/li>\n<li>range_lookup: ch\u1eef FALSE c\u00f3 th\u1ec3 vi\u1ebft tr\u1ef1c ti\u1ebfp, kh\u00f4ng c\u1ea7n\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<\/ul>\n<p>Sau khi\u00a0\u0111\u00e3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch n\u1ea1p d\u1eef li\u1ec7u v\u00e0o h\u00e0m, ch\u00fang ta c\u00f2n ph\u1ea3i ch\u00fa\u00a0\u00fd t\u1edbi 1 n\u1ed9i dung quan tr\u1ecdng: Lo\u1ea1i d\u1eef li\u1ec7u n\u1ea1p v\u00e0o l\u00e0 g\u00ec<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Loai_du_lieu\"><\/span>3. Lo\u1ea1i d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 2\u00a0\u0111i\u1ec3m c\u1ea7n ch\u00fa\u00a0\u00fd trong lo\u1ea1i d\u1eef li\u1ec7u:<\/p>\n<p>a. V\u1edbi d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp (ho\u1eb7c gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tham chi\u1ebfu): c\u00f3 3 lo\u1ea1i ch\u00ednh:<\/p>\n<ul>\n<li>Lo\u1ea1i Text: l\u00e0 k\u00fd t\u1ef1 v\u0103n b\u1ea3n. Khi vi\u1ebft tr\u1ef1c ti\u1ebfp ph\u1ea3i\u00a0\u0111\u1eb7t n\u1ed9i dung text trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>Lo\u1ea1i Number: l\u00e0 k\u00fd t\u1ef1 s\u1ed1. Khi vi\u1ebft tr\u1ef1c ti\u1ebfp c\u00f3 th\u1ec3 vi\u1ebft ngay m\u00e0 kh\u00f4ng c\u1ea7n\u00a0\u0111\u1eb7t trong c\u1eb7p\u00a0d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>Lo\u1ea1i Date: l\u00e0 k\u00fd t\u1ef1 s\u1ed1, nh\u01b0ng mang\u00a0\u00fd ngh\u0129a bi\u1ec3u di\u1ec5n ng\u00e0y th\u00e1ng, th\u1eddi gian. Khi vi\u1ebft tr\u1ef1c ti\u1ebfp ph\u1ea3i\u00a0\u0111\u01b0a v\u1ec1 d\u1ea1ng s\u1ed1 (General) ho\u1eb7c ph\u1ea3i vi\u1ebft d\u1ea1ng tham chi\u1ebfu<\/li>\n<\/ul>\n<p>b. V\u1edbi d\u1ea1ng tham chi\u1ebfu th\u00ec ch\u00fa\u00a0\u00fd t\u1edbi lo\u1ea1i Range v\u00e0\u00a0Array<\/p>\n<ul>\n<li>Range l\u00e0 1 v\u00f9ng\u00a0\u00f4, c\u00f3 th\u1ec3 g\u1ed3m 1 ho\u1eb7c nhi\u1ec1u\u00a0\u00f4 li\u00ean ti\u1ebfp nhau. Th\u01b0\u1eddng d\u1ea1ng range\u00a0\u00e1p d\u1ee5ng cho\u00a0v\u00f9ng d\u1eef li\u1ec7u c\u00f3 1 c\u1ed9t<\/li>\n<li>Array l\u00e0 1 m\u1ea3ng d\u1eef li\u1ec7u, c\u00f3 th\u1ec3 l\u00e0 to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong 1\u00a0\u00f4 ho\u1eb7c m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u b\u00ean trong\u00a0\u00f4\u00a0\u0111\u00f3<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady v\u1edbi tham chi\u1ebfu d\u1ea1ng Array\u00a0s\u1ebd r\u1ed9ng v\u00e0 ph\u1ee9c t\u1ea1p h\u01a1n d\u1ea1ng Range.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li>Tham s\u1ed1 table_array trong h\u00e0m VLOOKUP\u00a0l\u00e0 d\u1ea1ng\u00a0array.<\/li>\n<li>Tham s\u1ed1 sum_range trong h\u00e0m SUMIF l\u00e0 d\u1ea1ng range<\/li>\n<\/ul>\n<p>Khi t\u00ednh to\u00e1n, c\u00e1c h\u00e0m trong\u00a0Excel s\u1ebd c\u0103n c\u1ee9 theo b\u1ea3n ch\u1ea5t c\u1ee7a Lo\u1ea1i d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp\u00a0\u0111\u1ec3 t\u00ednh.<\/p>\n<p>V\u00ed d\u1ee5: H\u00e0m VLOOKUP sau\u00a0\u0111\u00e2y kh\u00f4ng ra k\u1ebft qu\u1ea3 do sai v\u1ec1 b\u1ea3n ch\u1ea5t c\u1ee7a lo\u1ea1i d\u1eef li\u1ec7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27638\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-ham-vlookup-do-sai-loai-du-lieu.png\" width=\"726\" height=\"256\" title=\"loi-ham-vlookup-do-sai-loai-du-lieu\"><\/p>\n<p>C\u00f9ng l\u00e0 c\u00f4ng th\u1ee9c VLOOKUP c\u00f3 c\u00e1ch vi\u1ebft gi\u1ed1ng nhau, nh\u01b0ng khi vi\u1ebft\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong lookup_value,\u00a0\u0111\u1eb7t s\u1ed1 84 trong d\u1ea5u nh\u00e1y k\u00e9p l\u1ea1i kh\u00f4ng ra k\u1ebft qu\u1ea3.<\/p>\n<p>Nguy\u00ean nh\u00e2n do trong b\u1ea3ng d\u1eef li\u1ec7u A3:C5, c\u1ed9t M\u00e3 ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng s\u1ed1. Khi tham chi\u1ebfu v\u1edbi s\u1ed1 84 trong c\u1eb7p d\u1ea5u nh\u00e1y k\u00e9p th\u00ec l\u1ea1i l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng Text, d\u1eabn t\u1edbi kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3.<\/p>\n<p><strong>* Ch\u00fa\u00a0\u00fd:<\/strong><\/p>\n<p>Lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 y\u1ebfu t\u1ed1 th\u01b0\u1eddng b\u1ecb\u00a0\u1ea9n, b\u1ecf qua do kh\u00f4ng nh\u00ecn th\u1ea5y, nh\u01b0ng n\u00f3 l\u1ea1i l\u00e0 nguy\u00ean nh\u00e2n ch\u00ednh g\u00e2y ra c\u00e1c l\u1ed7i m\u00e0 ch\u00fang ta kh\u00f3 ph\u00e1t hi\u1ec7n ra.<\/p>\n<p><strong>* Th\u1ee9 t\u1ef1 c\u00e1c b\u01b0\u1edbc ki\u1ec3m tra 1 h\u00e0m\u00a0nh\u01b0 sau<\/strong>:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Ki\u1ec3m tra vi\u1ebft\u00a0\u0111\u00fang c\u1ea5u tr\u00fac ch\u01b0a<\/li>\n<li>B\u01b0\u1edbc 2: Ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c n\u1ea1p v\u00e0o\u00a0\u0111\u00e3\u00a0\u0111\u00fang ch\u01b0a<\/li>\n<li>B\u01b0\u1edbc 3: Ki\u1ec3m tra lo\u1ea1i d\u1eef li\u1ec7u c\u1ee7a gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c n\u1ea1p v\u00e0o\u00a0\u0111\u00e3 t\u01b0\u01a1ng th\u00edch \/ kh\u1edbp v\u1edbi nhau hay ch\u01b0a<\/li>\n<\/ul>\n<p>Hy v\u1ecdng r\u1eb1ng sau b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 vi\u1ebft\u00a0\u0111\u00fang h\u00e0m v\u00e0 gi\u00fap c\u00e1c h\u00e0m t\u00ednh\u00a0\u0111\u00fang\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0\u00a0\u00fd mu\u1ed1n.<\/p>\n<p>Tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-lam-viec-voi-nhieu-ham-excel-phuc-tap.html\">C\u00e1ch l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u h\u00e0m Excel ph\u1ee9c t\u1ea1p<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-ham-ket-hop-ham-vlookup.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m VLOOKUP<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-nhieu-ham-if-long-nhau-de-hieu-de-thuc-hien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft nhi\u1ec1u h\u00e0m IF l\u1ed3ng nhau d\u1ec5 hi\u1ec3u d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-long-ghep-ham-viet-ham-long-nhau-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m, vi\u1ebft h\u00e0m l\u1ed3ng nhau trong Excel<\/a><\/p>\n<p>\u00a0<\/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-152.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2025,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2024","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\/2024","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=2024"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2024\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2025"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}