{"id":115556,"date":"2025-02-04T11:42:54","date_gmt":"2025-02-04T04:42:54","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=115556"},"modified":"2025-02-04T11:43:53","modified_gmt":"2025-02-04T04:43:53","slug":"tong-hop-cac-ham-trong-excel-thuong-dung","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m trong Excel th\u01b0\u1eddng d\u00f9ng v\u00e0 v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u"},"content":{"rendered":"\n<p>B\u1ea1n \u0111ang g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u b\u1eb1ng Excel? B\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News<\/a> s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00e2u tr\u1ea3 l\u1eddi v\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/tat-tan-tat-ve-excel-co-ban-de-hieu-danh-cho-nguoi-moi\/?srsltid=AfmBOopiKPBo1GkFxcyAAdqWQBsg7vVLs6h4Nj0xaqhh35ZuGq55KRyU\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 Excel c\u01a1 b\u1ea3n, d\u1ec5 hi\u1ec3u d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/3-cach-tao-bang-trong-excel-don-gian\/?srsltid=AfmBOorBx1xo7S1c4SJjg24BAN-MNXJMIcYYC9Xz8Z3PoFdaHZ7YOU3T\">3 C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel \u0111\u01a1n gi\u1ea3n cho m\u1ecdi phi\u00ean b\u1ea3n<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-round-cach-su-dung-ham-round-trong-excel\/?srsltid=AfmBOoqm0S1CV8yE6jbwnNTtafxxoAmjFlm1JfSU1d4WzSYDRLj9WVTV\">H\u00e0m ROUND l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a2b7711791c1\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a2b7711791c1\"  type=\"checkbox\" id=\"item-6a2b7711791c1\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#I_Nhom_ham_tinh_toan_co_ban_trong_Excel\" title=\"I. Nh\u00f3m h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n trong Excel\">I. Nh\u00f3m h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n trong Excel<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_SUM_Tinh_tong\" title=\"H\u00e0m SUM (T\u00ednh t\u1ed5ng)\">H\u00e0m SUM (T\u00ednh t\u1ed5ng)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_MINMAX_Tim_gia_tri_nho_nhatlon_nhat\" title=\"H\u00e0m MIN\/MAX (T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/l\u1edbn nh\u1ea5t)\">H\u00e0m MIN\/MAX (T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/l\u1edbn nh\u1ea5t)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_COUNTCOUNTA_Dem_o_chua_soDem_o_khong_trong\" title=\"H\u00e0m COUNT\/COUNTA (\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1\/\u0110\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng)\">H\u00e0m COUNT\/COUNTA (\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1\/\u0110\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_ODDEVEN_Lam_tron_len_so_lechan_gan_nhat\" title=\"H\u00e0m ODD\/EVEN (L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb\/ch\u1eb5n g\u1ea7n nh\u1ea5t)\">H\u00e0m ODD\/EVEN (L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb\/ch\u1eb5n g\u1ea7n nh\u1ea5t)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_AVERAGE_Tinh_trung_binh_cong\" title=\"H\u00e0m AVERAGE (T\u00ednh trung b\u00ecnh c\u1ed9ng)\">H\u00e0m AVERAGE (T\u00ednh trung b\u00ecnh c\u1ed9ng)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_PRODUCT_Tinh_tich\" title=\"H\u00e0m PRODUCT (T\u00ednh t\u00edch)\">H\u00e0m PRODUCT (T\u00ednh t\u00edch)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#II_Nhom_ham_dieu_kien_logic\" title=\"II. Nh\u00f3m h\u00e0m \u0111i\u1ec1u ki\u1ec7n logic\">II. Nh\u00f3m h\u00e0m \u0111i\u1ec1u ki\u1ec7n logic<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_COUNTIF_Dem_o_thoa_man_dieu_kien\" title=\"H\u00e0m COUNTIF (\u0110\u1ebfm \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n)\">H\u00e0m COUNTIF (\u0110\u1ebfm \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_IF_Kiem_tra_dieu_kien\" title=\"H\u00e0m IF (Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n)\">H\u00e0m IF (Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_SUMIF_Tinh_tong_co_dieu_kien\" title=\"H\u00e0m SUMIF (T\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n)\">H\u00e0m SUMIF (T\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#III_Nhom_ham_su_dung_trong_van_ban\" title=\"III. Nh\u00f3m h\u00e0m s\u1eed d\u1ee5ng trong v\u0103n b\u1ea3n\">III. Nh\u00f3m h\u00e0m s\u1eed d\u1ee5ng trong v\u0103n b\u1ea3n<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_LEFTRIGHTMID_Cat_chuoi_ky_tu\" title=\"H\u00e0m LEFT\/RIGHT\/MID (C\u1eaft chu\u1ed7i k\u00fd t\u1ef1)\">H\u00e0m LEFT\/RIGHT\/MID (C\u1eaft chu\u1ed7i k\u00fd t\u1ef1)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_LEN_Dem_ky_tu\" title=\"H\u00e0m LEN (\u0110\u1ebfm k\u00fd t\u1ef1)\">H\u00e0m LEN (\u0110\u1ebfm k\u00fd t\u1ef1)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#IV_Nhom_ham_ngay_thang\" title=\"IV. Nh\u00f3m h\u00e0m ng\u00e0y th\u00e1ng\">IV. Nh\u00f3m h\u00e0m ng\u00e0y th\u00e1ng<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_NOW_Ngay_va_gio_hien_tai\" title=\"H\u00e0m NOW (Ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i)\">H\u00e0m NOW (Ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_DATE_Tao_ngay\" title=\"H\u00e0m DATE (T\u1ea1o ng\u00e0y)\">H\u00e0m DATE (T\u1ea1o ng\u00e0y)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_TIME_Tao_thoi_gian\" title=\"H\u00e0m TIME (T\u1ea1o th\u1eddi gian)\">H\u00e0m TIME (T\u1ea1o th\u1eddi gian)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#V_Nhom_ham_tra_cuu_du_lieu\" title=\"V. Nh\u00f3m h\u00e0m tra c\u1ee9u d\u1eef li\u1ec7u\">V. Nh\u00f3m h\u00e0m tra c\u1ee9u d\u1eef li\u1ec7u<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_VLOOKUP_Tra_cuu_theo_cot_doc\" title=\"H\u00e0m VLOOKUP (Tra c\u1ee9u theo c\u1ed9t d\u1ecdc)\">H\u00e0m VLOOKUP (Tra c\u1ee9u theo c\u1ed9t d\u1ecdc)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_INDEX_Tra_ve_gia_tri_theo_vi_tri\" title=\"H\u00e0m INDEX (Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed)\">H\u00e0m INDEX (Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_MATCH_Tim_vi_tri_cua_gia_tri\" title=\"H\u00e0m MATCH (T\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb)\">H\u00e0m MATCH (T\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_HLOOKUP_Tra_cuu_theo_hang_ngang\" title=\"H\u00e0m HLOOKUP (Tra c\u1ee9u theo h\u00e0ng ngang)\">H\u00e0m HLOOKUP (Tra c\u1ee9u theo h\u00e0ng ngang)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/phongvu.vn\/cong-nghe\/tong-hop-cac-ham-trong-excel-thuong-dung\/#Ham_CHOOSE_Chon_gia_tri_tu_danh_sach\" title=\"H\u00e0m CHOOSE (Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch)\">H\u00e0m CHOOSE (Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch)<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"I_Nhom_ham_tinh_toan_co_ban_trong_Excel\"><\/span><strong>I. Nh\u00f3m h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n<\/strong> <strong>trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUM_Tinh_tong\"><\/span><a><\/a><strong>H\u00e0m SUM (T\u00ednh t\u1ed5ng)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng<\/strong>: T\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t d\u00e3y \u00f4 ho\u1eb7c c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =SUM(Number1,Number2,&#8230;) ho\u1eb7c =SUM(Range)<\/li>\n\n\n\n<li><strong>Number1, Number2,&#8230;:<\/strong> C\u00e1c s\u1ed1 c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n\n\n\n<li><strong>Range:<\/strong> Ph\u1ea1m vi \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n\n\n\n<ul>\n<li>=SUM(30,70,80) k\u1ebft qu\u1ea3 l\u00e0 180.<\/li>\n\n\n\n<li>=SUM(A1:A3) t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 A1, A2 v\u00e0 A3. N\u1ebfu A1=40, A2=50, A3=10 th\u00ec k\u1ebft qu\u1ea3 l\u00e0 100.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM\" class=\"wp-image-115526\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_MINMAX_Tim_gia_tri_nho_nhatlon_nhat\"><\/span><a><\/a><strong>H\u00e0m MIN\/MAX (T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/l\u1edbn nh\u1ea5t)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t ho\u1eb7c l\u1edbn nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00fa ph\u00e1p:<\/strong><\/p>\n\n\n\n<ul>\n<li>=MIN(Number1,Number2,&#8230;) ho\u1eb7c =MIN(Range)<\/li>\n\n\n\n<li>=MAX(Number1,Number2,&#8230;) ho\u1eb7c =MAX(Range)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu v\u00f9ng d\u1eef li\u1ec7u A1:C3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb:<\/p>\n\n\n\n<p>10&nbsp; 20&nbsp; 30<\/p>\n\n\n\n<p>40&nbsp; 50&nbsp; 60<\/p>\n\n\n\n<p>70&nbsp; 80&nbsp; 90<\/p>\n\n\n\n<ul>\n<li>=MIN(A1:C3) k\u1ebft qu\u1ea3 l\u00e0 10.<\/li>\n\n\n\n<li>=MAX(A1:C3) k\u1ebft qu\u1ea3 l\u00e0 90.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-1024x640.jpg\" alt=\"T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t b\u1eb1ng h\u00e0m Min\" class=\"wp-image-115527\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t b\u1eb1ng h\u00e0m Min<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_COUNTCOUNTA_Dem_o_chua_soDem_o_khong_trong\"><\/span><a><\/a><strong>H\u00e0m COUNT\/COUNTA (\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1\/\u0110\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>COUNT:<\/strong> \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 ch\u1ee9a s\u1ed1 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>COUNTA: <\/strong>\u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 kh\u00f4ng tr\u1ed1ng trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u (bao g\u1ed3m c\u1ea3 s\u1ed1, ch\u1eef v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t).<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00fa ph\u00e1p:<\/strong><\/p>\n\n\n\n<ul>\n<li>=COUNT(Value1,&#8230;) ho\u1eb7c =COUNT(Range)<\/li>\n\n\n\n<li>=COUNTA(Value1,&#8230;) ho\u1eb7c =COUNTA(Range)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu v\u00f9ng d\u1eef li\u1ec7u A1:C3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb:<\/p>\n\n\n\n<p>10&nbsp; abc&nbsp;&nbsp; 30<\/p>\n\n\n\n<p>40&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp; &#8220;&#8221;<\/p>\n\n\n\n<p>70&nbsp; xyz&nbsp;&nbsp; 90<\/p>\n\n\n\n<ul>\n<li>=COUNT(A1:C3) k\u1ebft qu\u1ea3 l\u00e0 6 (\u0111\u1ebfm c\u00e1c \u00f4 10, 30, 40, 50, 70, 90).<\/li>\n\n\n\n<li>=COUNTA(A1:C3) k\u1ebft qu\u1ea3 l\u00e0 8 (\u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1eeb \u00f4 tr\u1ed1ng &#8220;&#8221;).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-1024x640.jpg\" alt=\"\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 b\u1eb1ng h\u00e0m COUNT\" class=\"wp-image-115528\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 b\u1eb1ng h\u00e0m COUNT<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_ODDEVEN_Lam_tron_len_so_lechan_gan_nhat\"><\/span><a><\/a><strong>H\u00e0m ODD\/EVEN (L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb\/ch\u1eb5n g\u1ea7n nh\u1ea5t)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> L\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 l\u00ean s\u1ed1 nguy\u00ean l\u1ebb ho\u1eb7c ch\u1eb5n g\u1ea7n nh\u1ea5t.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong><\/li>\n<\/ul>\n\n\n\n<ul>\n<li>=ODD(Number)<\/li>\n\n\n\n<li>=EVEN(Number)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong><\/p>\n\n\n\n<ul>\n<li>=ODD(4.6) k\u1ebft qu\u1ea3 l\u00e0 5.<\/li>\n\n\n\n<li>=EVEN(63.5) k\u1ebft qu\u1ea3 l\u00e0 64.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-1024x640.jpg\" alt=\"L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t\" class=\"wp-image-115529\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb g\u1ea7n nh\u1ea5t<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_AVERAGE_Tinh_trung_binh_cong\"><\/span><a><\/a><strong>H\u00e0m AVERAGE (T\u00ednh trung b\u00ecnh c\u1ed9ng)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ednh trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =AVERAGE(number1,number2,&#8230;) ho\u1eb7c =AVERAGE(Range)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5<\/strong>: =AVERAGE(10,20,30,10,10) k\u1ebft qu\u1ea3 l\u00e0 16.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-1024x640.jpg\" alt=\"C\u00e1ch t\u00ednh trung b\u00ecnh c\u1ed9ng b\u1eb1ng h\u00e0m Average\" class=\"wp-image-115530\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch t\u00ednh trung b\u00ecnh c\u1ed9ng b\u1eb1ng h\u00e0m Average<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_PRODUCT_Tinh_tich\"><\/span><a><\/a><strong>H\u00e0m PRODUCT (T\u00ednh t\u00edch)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ednh t\u00edch c\u1ee7a c\u00e1c s\u1ed1.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =PRODUCT(number1, number2,&#8230;) ho\u1eb7c =PRODUCT(Range)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>=PRODUCT(2,3,4) k\u1ebft qu\u1ea3 l\u00e0 24.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-1024x640.jpg\" alt=\"T\u00ednh t\u00edch b\u1eb1ng h\u00e0m Product\" class=\"wp-image-115531\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ednh t\u00edch b\u1eb1ng h\u00e0m Product<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"II_Nhom_ham_dieu_kien_logic\"><\/span><a><\/a><strong>II. Nh\u00f3m h\u00e0m \u0111i\u1ec1u ki\u1ec7n logic<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_Dem_o_thoa_man_dieu_kien\"><\/span><a><\/a><strong>H\u00e0m COUNTIF (\u0110\u1ebfm \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng d\u1ee5ng: <\/strong>\u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n\n\n\n<p><strong>C\u00fa ph\u00e1p:<\/strong> =COUNTIF(range,criteria)<\/p>\n\n\n\n<ul>\n<li><strong>range:<\/strong> V\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ebfm.<\/li>\n\n\n\n<li><strong>criteria: <\/strong>\u0110i\u1ec1u ki\u1ec7n \u0111\u1ebfm (v\u00ed d\u1ee5: &#8220;&gt;10&#8221;, &#8220;&lt;5&#8221;, &#8220;apple&#8221;).<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu v\u00f9ng B1:B5 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb: 10, 20, 5, 15, 25.<\/p>\n\n\n\n<ul>\n<li>=COUNTIF(C2:C7,&#8221;&gt;15&#8243;) k\u1ebft qu\u1ea3 l\u00e0 2 (\u0111\u1ebfm c\u00e1c \u00f4 20, 15, 25).<\/li>\n\n\n\n<li>=COUNTIF(C2:C7,&#8221;&lt;10&#8243;) k\u1ebft qu\u1ea3 l\u00e0 1 (\u0111\u1ebfm \u00f4 5).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-1024x640.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m COUNTIF\" class=\"wp-image-115532\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch d\u00f9ng h\u00e0m COUNTIF<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_IF_Kiem_tra_dieu_kien\"><\/span><a><\/a><strong>H\u00e0m IF (Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong> Ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/p>\n\n\n\n<p><strong>C\u00fa ph\u00e1p: <\/strong>=IF(Logical_test,Value_if_true,Value_if_false)<\/p>\n\n\n\n<ul>\n<li><strong>Logical_test: <\/strong>\u0110i\u1ec1u ki\u1ec7n c\u1ea7n ki\u1ec3m tra.<\/li>\n\n\n\n<li><strong>Value_if_true: <\/strong>Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n\n\n\n<li><strong>Value_if_false:<\/strong> Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> =IF(A1&gt;6,&#8221;L\u1edbn h\u01a1n 6&#8243;,&#8221;Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 6&#8243;) N\u1ebfu A1&gt;6, k\u1ebft qu\u1ea3 l\u00e0 &#8220;\u0110\u1ea0T&#8221;. N\u1ebfu A1&lt;6, k\u1ebft qu\u1ea3 l\u00e0 &#8220;kH\u00d4NG \u0110\u1ea0T&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-1024x640.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m IF\" class=\"wp-image-115533\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch d\u00f9ng h\u00e0m IF<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_SUMIF_Tinh_tong_co_dieu_kien\"><\/span><a><\/a><strong>H\u00e0m SUMIF (T\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng d\u1ee5ng: <\/strong>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n.<\/p>\n\n\n\n<p><strong>C\u00fa ph\u00e1p: <\/strong>=SUMIF(range,criteria,[sum_range])<\/p>\n\n\n\n<ul>\n<li><strong>range: <\/strong>Ph\u1ea1m vi \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n.<\/li>\n\n\n\n<li><strong>criteria: <\/strong>\u0110i\u1ec1u ki\u1ec7n.<\/li>\n\n\n\n<li><strong>sum_range:<\/strong> Ph\u1ea1m vi \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng (n\u1ebfu b\u1ecf qua, Excel s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c \u00f4 trong range th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n).<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu c\u1ed9t A ch\u1ee9a t\u00ean s\u1ea3n ph\u1ea9m (&#8220;cam&#8221;, &#8220;t\u00e1o&#8221;, &#8220;cam&#8221;, &#8220;chu\u1ed1i&#8221;, &#8220;cam&#8221;) v\u00e0 c\u1ed9t B ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng (10, 5, 15, 8, 20).<\/p>\n\n\n\n<p>=SUMIF(A1:A5,&#8221;cam&#8221;,B1:B5) k\u1ebft qu\u1ea3 l\u00e0 45 (10+15+20).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-1024x640.jpg\" alt=\"V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIF\" class=\"wp-image-115534\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMIF<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"III_Nhom_ham_su_dung_trong_van_ban\"><\/span><a><\/a><strong>III. Nh\u00f3m h\u00e0m s\u1eed d\u1ee5ng trong v\u0103n b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_LEFTRIGHTMID_Cat_chuoi_ky_tu\"><\/span><a><\/a><strong>H\u00e0m LEFT\/RIGHT\/MID (C\u1eaft chu\u1ed7i k\u00fd t\u1ef1)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>LEFT: <\/strong>C\u1eaft m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb b\u00ean tr\u00e1i c\u1ee7a chu\u1ed7i.<\/li>\n\n\n\n<li><strong>RIGHT: <\/strong>C\u1eaft m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a chu\u1ed7i.<\/li>\n\n\n\n<li><strong>MID: <\/strong>C\u1eaft m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb gi\u1eefa chu\u1ed7i, b\u1eaft \u0111\u1ea7u t\u1eeb m\u1ed9t v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u00fa ph\u00e1p:<\/strong><\/p>\n\n\n\n<ul>\n<li>=LEFT(text,[num_chars])<\/li>\n\n\n\n<li>=RIGHT(text,[num_chars])<\/li>\n\n\n\n<li>=MID(text, start_num, num_chars)<\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>text: <\/strong>Chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n\n\n\n<li><strong>num_chars:<\/strong> S\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 c\u1ea7n c\u1eaft.<\/li>\n\n\n\n<li><strong>start_num: <\/strong>V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1eaft (cho h\u00e0m MID).<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>N\u1ebfu \u00f4 B3 ch\u1ee9a &#8220;Ph\u1ea1m V\u0103n A&#8221;:<\/p>\n\n\n\n<ul>\n<li>=LEFT(A2,3) k\u1ebft qu\u1ea3 l\u00e0 &#8220;Ph\u1ea1&#8221;.<\/li>\n\n\n\n<li>=RIGHT(B3,1) k\u1ebft qu\u1ea3 l\u00e0 &#8220;A&#8221;.<\/li>\n\n\n\n<li>=MID(B3,3,7) k\u1ebft qu\u1ea3 l\u00e0 &#8220;\u1ea1m V\u0103n &#8220;.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-1024x640.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m LEFT\" class=\"wp-image-115535\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-11.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch d\u00f9ng h\u00e0m LEFT<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_LEN_Dem_ky_tu\"><\/span><a><\/a><strong>H\u00e0m LEN (\u0110\u1ebfm k\u00fd t\u1ef1)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 trong m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =LEN(text)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> N\u1ebfu \u00f4 A1 ch\u1ee9a &#8220;PH\u1ea0M V\u0102N A&#8221;, =LEN(A2) k\u1ebft qu\u1ea3 l\u00e0 10.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-1024x640.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN\" class=\"wp-image-115536\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LEN<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"IV_Nhom_ham_ngay_thang\"><\/span><a><\/a><strong>IV. Nh\u00f3m h\u00e0m ng\u00e0y th\u00e1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_NOW_Ngay_va_gio_hien_tai\"><\/span><a><\/a><strong>H\u00e0m NOW (Ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng: <\/strong>Tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i c\u1ee7a h\u1ec7 th\u1ed1ng.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =NOW()<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> =NOW() s\u1ebd tr\u1ea3 v\u1ec1 ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i (v\u00ed d\u1ee5: 24\/01\/2025 9:00).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-1024x640.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOW\" class=\"wp-image-115537\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-13.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOW<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_DATE_Tao_ngay\"><\/span><a><\/a><strong>H\u00e0m DATE (T\u1ea1o ng\u00e0y)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u1ea1o m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3 d\u1ef1a tr\u00ean n\u0103m, th\u00e1ng v\u00e0 ng\u00e0y.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p: <\/strong>=DATE(Year,Month,Day)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> =DATE(2023,10,26) k\u1ebft qu\u1ea3 l\u00e0 ng\u00e0y 26 th\u00e1ng 10 n\u0103m 2023.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-1024x640.jpg\" alt=\"C\u00e1ch d\u00f9ng h\u00e0m DATE\" class=\"wp-image-115538\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-14.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch d\u00f9ng h\u00e0m DATE<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_TIME_Tao_thoi_gian\"><\/span><a><\/a><strong>H\u00e0m TIME (T\u1ea1o th\u1eddi gian)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng: <\/strong>T\u1ea1o m\u1ed9t th\u1eddi gian c\u1ee5 th\u1ec3 d\u1ef1a tr\u00ean gi\u1edd, ph\u00fat v\u00e0 gi\u00e2y.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =TIME(Hour,Minute,Second)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>=TIME(10,30,0) k\u1ebft qu\u1ea3 l\u00e0 10:30:00.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-1024x640.jpg\" alt=\"S\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 t\u1ea1o th\u1eddi gian\" class=\"wp-image-115539\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-15.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">S\u1eed d\u1ee5ng h\u00e0m TIME \u0111\u1ec3 t\u1ea1o th\u1eddi gian<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"V_Nhom_ham_tra_cuu_du_lieu\"><\/span><a><\/a><strong>V. Nh\u00f3m h\u00e0m tra c\u1ee9u d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_VLOOKUP_Tra_cuu_theo_cot_doc\"><\/span><a><\/a><strong>H\u00e0m VLOOKUP (Tra c\u1ee9u theo c\u1ed9t d\u1ecdc)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng: <\/strong>T\u00ecm ki\u1ebfm m\u1ed9t gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t b\u1ea3ng v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong c\u00f9ng h\u00e0ng \u1edf m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)<\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Lookup_value:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n\n\n\n<li><strong>Table_array: <\/strong>B\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 t\u00ecm ki\u1ebfm.<\/li>\n\n\n\n<li><strong>Col_index_num:<\/strong> S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 (t\u00ednh t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a Table_array).<\/li>\n\n\n\n<li><strong>Range_lookup: <\/strong>TRUE (ho\u1eb7c 1) cho t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang (y\u00eau c\u1ea7u c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a Table_array \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n), FALSE (ho\u1eb7c 0) cho t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea3ng H3:I8 ch\u1ee9a th\u00f4ng tin v\u1ec1 m\u1ee9c ph\u1ee5 c\u1ea5p theo ch\u1ee9c v\u1ee5. N\u1ebfu \u00f4 D4 ch\u1ee9a ch\u1ee9c v\u1ee5 &#8220;Gi\u00e1m \u0111\u1ed1c&#8221;, c\u00f4ng th\u1ee9c =VLOOKUP(D4,$H$3:$I$8,2,0) s\u1ebd t\u00ecm ch\u1ee9c v\u1ee5 &#8220;Gi\u00e1m \u0111\u1ed1c&#8221; trong c\u1ed9t H v\u00e0 tr\u1ea3 v\u1ec1 m\u1ee9c ph\u1ee5 c\u1ea5p t\u01b0\u01a1ng \u1ee9ng t\u1eeb c\u1ed9t I.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-1024x640.jpg\" alt=\"Tra c\u1ee9u d\u1eef li\u1ec7u c\u1ed9t d\u1ecdc b\u1eb1ng h\u00e0m VLOOKUP\" class=\"wp-image-115540\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-16.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Tra c\u1ee9u d\u1eef li\u1ec7u c\u1ed9t d\u1ecdc b\u1eb1ng h\u00e0m VLOOKUP<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_INDEX_Tra_ve_gia_tri_theo_vi_tri\"><\/span><a><\/a><strong>H\u00e0m INDEX (Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1ea1i m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong m\u1ed9t ph\u1ea1m vi ho\u1eb7c m\u1ea3ng.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =INDEX(array, row_num, column_num)<\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>array: <\/strong>Ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>row_num: <\/strong>S\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng.<\/li>\n\n\n\n<li><strong>column_num:<\/strong> S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t.<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5: <\/strong>=INDEX(B4:E13,4,1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u1edf h\u00e0ng th\u1ee9 4, c\u1ed9t th\u1ee9 1 c\u1ee7a ph\u1ea1m vi B4:E13.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-1024x640.jpg\" alt=\"Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed b\u1eb1ng h\u00e0m INDEX\" class=\"wp-image-115541\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-17.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed b\u1eb1ng h\u00e0m INDEX<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_MATCH_Tim_vi_tri_cua_gia_tri\"><\/span><a><\/a><strong>H\u00e0m MATCH (T\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> T\u00ecm v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t m\u1ea3ng.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p: <\/strong>=MATCH(Lookup_value, Lookup_array, Match_type)<\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>Lookup_value:<\/strong> Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n\n\n\n<li><strong>Lookup_array: <\/strong>M\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Match_type: <\/strong>0 cho t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c, 1 cho t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang (nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng), -1 cho t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang (l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng).<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> =MATCH(&#8220;L\u00e2m Thi\u00ean Trang&#8221;,A2:A9,0) s\u1ebd tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a &#8220;L\u00e2m Thi\u00ean Trang&#8221; trong ph\u1ea1m vi A2:A9.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-1024x640.jpg\" alt=\"C\u00e1ch t\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb b\u1eb1ng h\u00e0m MATCH\" class=\"wp-image-115542\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-18.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1ch t\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb b\u1eb1ng h\u00e0m MATCH<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_HLOOKUP_Tra_cuu_theo_hang_ngang\"><\/span><strong>H\u00e0m HLOOKUP (Tra c\u1ee9u theo h\u00e0ng ngang)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng: <\/strong>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 VLOOKUP nh\u01b0ng t\u00ecm ki\u1ebfm theo h\u00e0ng ngang.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =HLOOKUP(Lookup_value, Table_array, Row_index_Num, Range_lookup)<\/li>\n<\/ul>\n\n\n\n<p><strong>V\u00ed d\u1ee5:<\/strong> S\u1eed d\u1ee5ng HLOOKUP \u0111\u1ec3 t\u00ecm ki\u1ebfm ph\u1ee5 c\u1ea5p nh\u00e2n vi\u00ean d\u1ef1a tr\u00ean \u0111i\u1ec3m s\u1ed1 trong m\u1ed9t b\u1ea3ng x\u1ebfp lo\u1ea1i \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed theo h\u00e0ng ngang.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-1024x640.jpg\" alt=\"Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng ngang b\u1eb1ng h\u00e0m HLOOKUP\" class=\"wp-image-115543\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-19.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Tra c\u1ee9u d\u1eef li\u1ec7u theo h\u00e0ng ngang b\u1eb1ng h\u00e0m HLOOKUP<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Ham_CHOOSE_Chon_gia_tri_tu_danh_sach\"><\/span><a><\/a><strong>H\u00e0m CHOOSE (Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul>\n<li><strong>C\u00f4ng d\u1ee5ng:<\/strong> Ch\u1ecdn m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1ed9t ch\u1ec9 s\u1ed1.<\/li>\n\n\n\n<li><strong>C\u00fa ph\u00e1p:<\/strong> =CHOOSE(index_num, value1, value2, &#8230;)<\/li>\n<\/ul>\n\n\n\n<p><strong>Trong \u0111\u00f3:<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>index_num: <\/strong>Ch\u1ec9 s\u1ed1 c\u1ee7a gi\u00e1 tr\u1ecb c\u1ea7n ch\u1ecdn (b\u1eaft \u0111\u1ea7u t\u1eeb 1).<\/li>\n\n\n\n<li><strong>value1, value2,&#8230;: <\/strong>Danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-1024x640.jpg\" alt=\"Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch b\u1eb1ng h\u00e0m CHOOSE\" class=\"wp-image-115544\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2025\/02\/cac-ham-trong-excel-20.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch b\u1eb1ng h\u00e0m CHOOSE<\/figcaption><\/figure>\n\n\n\n<p>B\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 t\u1ed5ng h\u1ee3p m\u1ed9t s\u1ed1 h\u00e0m Excel th\u00f4ng d\u1ee5ng, \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo nh\u00f3m ch\u1ee9c n\u0103ng, k\u00e8m theo c\u00fa ph\u00e1p v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda. Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c h\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian trong c\u00f4ng vi\u1ec7c. Tuy nhi\u00ean, Excel c\u00f2n r\u1ea5t nhi\u1ec1u h\u00e0m kh\u00e1c v\u1edbi c\u00e1c ch\u1ee9c n\u0103ng n\u00e2ng cao h\u01a1n.<\/p>\n\n\n\n<p>\u0110\u1ec3 khai th\u00e1c t\u1ed1i \u0111a s\u1ee9c m\u1ea1nh c\u1ee7a Excel, b\u1ea1n n\u00ean ti\u1ebfp t\u1ee5c t\u00ecm hi\u1ec3u v\u00e0 th\u1ef1c h\u00e0nh th\u00eam. Hy v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y s\u1ebd l\u00e0 m\u1ed9t ngu\u1ed3n t\u00e0i li\u1ec7u h\u1eefu \u00edch cho b\u1ea1n tr\u00ean con \u0111\u01b0\u1eddng chinh ph\u1ee5c Excel! Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111ang g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u b\u1eb1ng Excel? B\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3? B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a Phong V\u0169 Tech News s\u1ebd cung c\u1ea5p cho b\u1ea1n c\u00e2u tr\u1ea3 l\u1eddi v\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u00e0 v\u00ed d\u1ee5 minh h\u1ecda d\u1ec5 hi\u1ec3u. [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":115525,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115556"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=115556"}],"version-history":[{"count":5,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115556\/revisions"}],"predecessor-version":[{"id":115574,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/115556\/revisions\/115574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/115525"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=115556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=115556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=115556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}