{"id":9445,"date":"2025-01-02T06:32:15","date_gmt":"2025-01-02T06:32:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-nhan-hai-cot-voi-nhau-trong-excel\/"},"modified":"2025-01-02T06:32:15","modified_gmt":"2025-01-02T06:32:15","slug":"huong-dan-cach-nhan-hai-cot-voi-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-nhan-hai-cot-voi-nhau-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u00e2n hai c\u1ed9t v\u1edbi nhau trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u00e0m th\u1ebf n\u00e0o <strong>nh\u00e2n hai c\u1ed9t v\u1edbi nhau<\/strong> theo nh\u1eefng c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t.<\/p>\n<p>V\u00ed d\u1ee5 d\u1eef li\u1ec7u c\u1ee7a ta nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24477\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-hai-cot-1-1.png\" width=\"437\" height=\"363\" title=\"nhan-hai-cot-1-1\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677632ee6fa51\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhan-hai-cot-voi-nhau-trong-excel.html#Nhan_hai_cot_voi_nhau_su_dung_dau\" title=\"Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng d\u1ea5u *\">Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng d\u1ea5u *<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/nhan-hai-cot-voi-nhau-trong-excel.html#Nhan_hai_cot_voi_nhau_su_dung_ham_PRODUCT\" title=\"Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng h\u00e0m PRODUCT\">Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng h\u00e0m PRODUCT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/nhan-hai-cot-voi-nhau-trong-excel.html#Su_dung_cong_thuc_mang_de_nhan_hai_cot_voi_nhau\" title=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u00e2n hai c\u1ed9t v\u1edbi nhau\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u00e2n hai c\u1ed9t v\u1edbi nhau<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_hai_cot_voi_nhau_su_dung_dau\"><\/span>Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng d\u1ea5u *<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 nh\u00e2n hai c\u1ed9t v\u1edbi nhau l\u00e0 s\u1eed d\u1ee5ng d\u1ea5u \u201c<strong>*<\/strong>\u201c. B\u1eb1ng vi\u1ec7c thao t\u00e1c t\u1ea1i \u00f4 D2 v\u1edbi c\u00f4ng th\u1ee9c <strong>=B2*C2<\/strong>, ta \u0111\u00e3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n hai s\u1ed1.<\/p>\n<p>Sau \u0111\u00f3, click \u0111\u00fap t\u1ea1i v\u1ecb tr\u00ed nh\u01b0 h\u00ecnh \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 c\u00e1c s\u1ed1 c\u00f2n l\u1ea1i. V\u1eady l\u00e0 ta \u0111\u00e3 nh\u00e2n cho hai c\u1ed9t r\u1ed3i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24478\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-hai-cot-2.png\" width=\"553\" height=\"369\" title=\"nhan-hai-cot-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nhan_hai_cot_voi_nhau_su_dung_ham_PRODUCT\"><\/span>Nh\u00e2n hai c\u1ed9t v\u1edbi nhau s\u1eed d\u1ee5ng h\u00e0m PRODUCT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m PRODUCT s\u1ebd t\u00ednh t\u00edch c\u1ee7a c\u00e1c \u0111\u1ed1i s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-54.gif\" title=\"ex101_92019-nho-54\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>=PRODUCT(s\u1ed1 th\u1ee9 nh\u1ea5t, s\u1ed1 th\u1ee9 2\u2026)<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24479\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/nhan-hai-cot-3.png\" width=\"743\" height=\"450\" title=\"nhan-hai-cot-3\"><\/p>\n<p>Sau khi s\u1eed d\u1ee5ng PRODUCT t\u1ea1i \u00f4 E2, s\u1eed d\u1ee5ng fill \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cong_thuc_mang_de_nhan_hai_cot_voi_nhau\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u00e2n hai c\u1ed9t v\u1edbi nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng th\u1ee9c m\u1ea3ng, nghe c\u00f3 v\u1ebb l\u1eb1ng nh\u1eb1ng, tuy nhi\u00ean trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y vi\u1ec7c b\u1ea1n c\u1ea7n l\u00e0m ch\u1ec9 l\u00e0\u2026 vi\u1ebft th\u1eb3ng ra. Hai c\u1ed9t nh\u00e2n v\u1edbi nhau nh\u01b0 n\u00e0o, di\u1ec5n gi\u1ea3i trong Excel y h\u1ec7t nh\u01b0 v\u1eady.<\/p>\n<p>=B2:B7*C2:C7<\/p>\n<p>B\u1edfi \u0111\u00e2y l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean ta ph\u1ea3i \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl+Shift+Enter<\/strong> \u0111\u1ec3 ch\u1ea1y. K\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 c\u00f3 l\u1ebd b\u1ea1n c\u0169ng \u0111o\u00e1n \u0111\u01b0\u1ee3c r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc th\u00eam v\u1ec1 c\u00e1c ph\u00e9p to\u00e1n kh\u00e1c trong Excel \u1edf link d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ol>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/cach-tinh-tong-trong-excel.html\">T\u00ednh t\u1ed5ng c\u01a1 b\u1ea3n trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-thuc-hien-phep-tru-trong-excel-co-ban.html\">Ph\u00e9p tr\u1eeb trong Excel (ph\u1ea7n 1)<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/phep-tru-ki-tu-trong-excel-co-ban-phan-2.html\">Ph\u00e9p tr\u1eeb trong Excel (ph\u1ea7n 2)<\/a><\/li>\n<\/ol>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-54.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9445","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9445"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9446"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}