{"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<h2><strong>I. Nh\u00f3m h\u00e0m t\u00ednh to\u00e1n c\u01a1 b\u1ea3n<\/strong> <strong>trong Excel<\/strong><\/h2>\n\n\n\n<h3><a><\/a><strong>H\u00e0m SUM (T\u00ednh t\u1ed5ng)<\/strong><\/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><a><\/a><strong>H\u00e0m MIN\/MAX (T\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/l\u1edbn nh\u1ea5t)<\/strong><\/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><a><\/a><strong>H\u00e0m COUNT\/COUNTA (\u0110\u1ebfm \u00f4 ch\u1ee9a s\u1ed1\/\u0110\u1ebfm \u00f4 kh\u00f4ng tr\u1ed1ng)<\/strong><\/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><a><\/a><strong>H\u00e0m ODD\/EVEN (L\u00e0m tr\u00f2n l\u00ean s\u1ed1 l\u1ebb\/ch\u1eb5n g\u1ea7n nh\u1ea5t)<\/strong><\/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><a><\/a><strong>H\u00e0m AVERAGE (T\u00ednh trung b\u00ecnh c\u1ed9ng)<\/strong><\/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><a><\/a><strong>H\u00e0m PRODUCT (T\u00ednh t\u00edch)<\/strong><\/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><a><\/a><strong>II. Nh\u00f3m h\u00e0m \u0111i\u1ec1u ki\u1ec7n logic<\/strong><\/h2>\n\n\n\n<h3><a><\/a><strong>H\u00e0m COUNTIF (\u0110\u1ebfm \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n)<\/strong><\/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><a><\/a><strong>H\u00e0m IF (Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n)<\/strong><\/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><a><\/a><strong>H\u00e0m SUMIF (T\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n)<\/strong><\/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><a><\/a><strong>III. Nh\u00f3m h\u00e0m s\u1eed d\u1ee5ng trong v\u0103n b\u1ea3n<\/strong><\/h2>\n\n\n\n<h3><a><\/a><strong>H\u00e0m LEFT\/RIGHT\/MID (C\u1eaft chu\u1ed7i k\u00fd t\u1ef1)<\/strong><\/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><a><\/a><strong>H\u00e0m LEN (\u0110\u1ebfm k\u00fd t\u1ef1)<\/strong><\/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><a><\/a><strong>IV. Nh\u00f3m h\u00e0m ng\u00e0y th\u00e1ng<\/strong><\/h2>\n\n\n\n<h3><a><\/a><strong>H\u00e0m NOW (Ng\u00e0y v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i)<\/strong><\/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><a><\/a><strong>H\u00e0m DATE (T\u1ea1o ng\u00e0y)<\/strong><\/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><a><\/a><strong>H\u00e0m TIME (T\u1ea1o th\u1eddi gian)<\/strong><\/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><a><\/a><strong>V. Nh\u00f3m h\u00e0m tra c\u1ee9u d\u1eef li\u1ec7u<\/strong><\/h2>\n\n\n\n<h3><a><\/a><strong>H\u00e0m VLOOKUP (Tra c\u1ee9u theo c\u1ed9t d\u1ecdc)<\/strong><\/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><a><\/a><strong>H\u00e0m INDEX (Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb theo v\u1ecb tr\u00ed)<\/strong><\/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><a><\/a><strong>H\u00e0m MATCH (T\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb)<\/strong><\/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><strong>H\u00e0m HLOOKUP (Tra c\u1ee9u theo h\u00e0ng ngang)<\/strong><\/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><a><\/a><strong>H\u00e0m CHOOSE (Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch)<\/strong><\/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}]}}