{"id":226087,"date":"2023-07-04T15:03:07","date_gmt":"2023-07-04T08:03:07","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=226087"},"modified":"2023-07-04T15:03:07","modified_gmt":"2023-07-04T08:03:07","slug":"huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ph\u00e9p nh\u00e2n trong Excel<\/strong> l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn trong t\u00ednh to\u00e1n c\u0169ng nh\u01b0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Tuy nhi\u00ean, v\u1edbi nh\u1eefng d\u00e3y s\u1ed1 ph\u1ee9c t\u1ea1p th\u00ec ph\u00e9p t\u00ednh n\u00e0y s\u1eed d\u00f9ng h\u00e0m g\u00ec? B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>T\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi bi\u1ebft \u0111\u1ebfn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n kh\u00f3 th\u00ec ch\u00fang ta c\u1ea7n t\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m <strong>ph\u00e9p nh\u00e2n trong Excel<\/strong> l\u00e0 g\u00ec? C\u1ee5 th\u1ec3 \u0111\u00e2y l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng quan tr\u1ecdng gi\u00fap ng\u01b0\u1eddi d\u00f9ng nh\u00e2n (*) hai ho\u1eb7c nhi\u1ec1u s\u1ed1 l\u1ea1i v\u1edbi nhau \u0111\u1ec3 cho ra m\u1ed9t k\u1ebft qu\u1ea3.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ph\u00e9p t\u00ednh n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n th\u00f4ng qua to\u00e1n t\u1eed nh\u00e2n (*) ho\u1eb7c h\u00e0m PRODUCT. V\u1edbi hai t\u00ednh n\u0103ng \u0111\u1eb7c bi\u1ec7t n\u00e0y, b\u1ea1n r\u1ea5t d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng ph\u00e9p nh\u00e2n cho t\u1eebng \u00f4 s\u1ed1 ri\u00eang l\u1ebb ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n \u0111\u1ec3 t\u00ednh to\u00e1n nhi\u1ec1u gi\u00e1 tr\u1ecb c\u00f9ng m\u1ed9t l\u00fac. C\u00f3 nh\u01b0 v\u1eady, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian c\u0169ng nh\u01b0 \u0111\u1ea1t \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c ch\u00ednh x\u00e1c h\u01a1n.<\/span><\/p>\n<figure id=\"attachment_226525\" aria-describedby=\"caption-attachment-226525\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-6.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-6-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-6-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-226525 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-6.png\" alt=\"T\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-6.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-6-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-6-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226525\" class=\"wp-caption-text\">T\u00ecm hi\u1ec3u kh\u00e1i ni\u1ec7m<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><b>Ph\u00e9p nh\u00e2n trong Excel d\u00f9ng h\u00e0m g\u00ec?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n gi\u1eefa c\u00e1c s\u1ed1 ho\u1eb7c c\u00e1c \u00f4 d\u1eef li\u1ec7u, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m PRODUCT. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 t\u00ednh t\u00edch c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb ph\u1ee9c t\u1ea1p. Do \u0111\u00f3, n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng v\u00ec mang l\u1ea1i t\u00ednh ch\u00ednh x\u00e1c cao.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 s\u1eed d\u1ee5ng to\u00e1n t\u1eed nh\u00e2n (*) ch\u1ec9 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00e1c b\u00e0i to\u00e1n \u0111\u01a1n gi\u1ea3n nh\u01b0 t\u00ednh t\u00edch c\u1ee7a hai \u00f4 hay hai s\u1ed1. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PRODUCT, b\u1ea1n c\u00f3 th\u1ec3 nh\u00e2n nhi\u1ec1u gi\u00e1 tr\u1ecb v\u1edbi nhau m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng.<\/span><\/p>\n<figure id=\"attachment_226545\" aria-describedby=\"caption-attachment-226545\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-226545 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-7.jpg\" alt=\"B\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m g\u00ec?\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226545\" class=\"wp-caption-text\">B\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m g\u00ec?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><b>L\u1ee3i \u00edch s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel th\u00f4ng qua h\u00e0m PRODUCT<\/b><\/h2>\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch khi b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m PRODUCT trong vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. H\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m danh qua c\u00e1c l\u1ee3i \u00edch c\u1ee5 th\u1ec3 \u0111\u00f3 l\u00e0 g\u00ec nh\u00e9!<\/p>\n<h3 style=\"text-align: justify;\"><b>Ti\u1ebft ki\u1ec7m th\u1eddi gian<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PRODUCT cho ph\u00e9p t\u00ednh to\u00e1n t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c nh\u00e2n l\u1ea1i v\u1edbi nhau m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 thu\u1eadn ti\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u00e2n t\u1eebng gi\u00e1 tr\u1ecb m\u1ed9t v\u00e0 c\u1ed9ng l\u1ea1i, m\u00e0 ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m PRODUCT \u0111\u1ec3 t\u00ednh to\u00e1n theo c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>Linh ho\u1ea1t trong vi\u1ec7c \u00e1p d\u1ee5ng ph\u00e9p nh\u00e2n<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PRODUCT cho ph\u00e9p b\u1ea1n \u00e1p d\u1ee5ng ph\u00e9p nh\u00e2n cho c\u00e1c \u00f4 ri\u00eang l\u1ebb ho\u1eb7c m\u1ed9t d\u00e3y gi\u00e1 tr\u1ecb kh\u00f4ng li\u00ean ti\u1ebfp.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian c\u0169ng nh\u01b0 c\u00f4ng s\u1ee9c trong vi\u1ec7c t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb nh\u00e2n l\u1ea1i v\u1edbi nhau.<\/span><\/li>\n<\/ul>\n<h3><b>X\u1eed l\u00fd c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n c\u00f3 c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn v\u00e0 mu\u1ed1n t\u00ednh t\u00edch c\u1ee7a ch\u00fang, h\u00e0m PRODUCT l\u00e0 c\u00f4ng c\u1ee5 hi\u1ec7u qu\u1ea3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y cho m\u1ed9t d\u00e3y d\u1eef li\u1ec7u d\u00e0i v\u00e0 nhanh ch\u00f3ng thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>D\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PRODUCT \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong Excel v\u00e0 n\u00f3 c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c c\u0169ng nh\u01b0 h\u00e0m kh\u00e1c nhau (h\u00e0m SUM, IF).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c n\u00e2ng cao h\u01a1n \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>\u0110\u1ed9 ch\u00ednh x\u00e1c v\u00e0 tin c\u1eady cao<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m PRODUCT \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c v\u00e0 tin c\u1eady trong vi\u1ec7c t\u00ednh to\u00e1n t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb khi nh\u00e2n ch\u00fang l\u1ea1i v\u1edbi nhau. Nh\u01b0ng h\u00e3y ch\u1eafc ch\u1eafn l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng \u0111\u00fang c\u00f4ng th\u1ee9c nh\u00e9.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00e0 l\u1ee3i \u00edch n\u00e0y \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1 c\u1ea7n \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_226546\" aria-describedby=\"caption-attachment-226546\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-226546 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-8.jpg\" alt=\"L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m PRODUCT\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226546\" class=\"wp-caption-text\">L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m PRODUCT<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel v\u1edbi h\u00e0m PRODUCT<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p t\u00ednh to\u00e1n m\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m PRODUCT. Sau \u0111\u00e2y l\u00e0 2 tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng g\u1eb7p k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. M\u1eddi b\u1ea1n c\u00f9ng theo d\u00f5i nh\u00e9!<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Tr\u01b0\u1eddng h\u1ee3p 1: Nh\u00e2n t\u1eebng c\u1ed9t trong Excel, k\u00e8m v\u00ed d\u1ee5<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea7u ti\u00ean r\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed nh\u00e2n (*) hay h\u00e0m PRODUCT \u0111\u1ec1u \u0111\u01b0\u1ee3c. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Thao t\u00e1c theo c\u00f4ng th\u1ee9c <\/span><b>=PRODUCT(s\u1ed1 \u0111\u1ea7u ti\u00ean trong c\u1ed9t, s\u1ed1 cu\u1ed1i c\u00f9ng trong c\u1ed9t)<\/b><span style=\"font-weight: 400;\">. Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00fa ph\u00e1p =PRODUCT(k\u00e9o chu\u1ed9t \u0111\u1ec3 qu\u00e9t t\u1eeb s\u1ed1 \u0111\u1ea7u ti\u00ean xu\u1ed1ng s\u1ed1 cu\u1ed1i c\u00f9ng trong c\u1ed9t).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ec9 c\u1ea7n b\u1ea1n nh\u1ea5n Enter l\u00e0 k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n ngay l\u1eadp t\u1ee9c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda, d\u1ef1a v\u00e0o h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 b\u1ea1n d\u1ec5 h\u00ecnh dung v\u1ec1 h\u00e0m PRODUCT h\u01a1n nh\u00e9!<\/span><\/p>\n<figure id=\"attachment_226091\" aria-describedby=\"caption-attachment-226091\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-1.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-1-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-1-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-226091 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-1.png\" alt=\"V\u00ed d\u1ee5: Nh\u00e2n t\u1eebng c\u1ed9t trong Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-1.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-1-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-1-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226091\" class=\"wp-caption-text\">V\u00ed d\u1ee5: Nh\u00e2n t\u1eebng c\u1ed9t trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><b>Tr\u01b0\u1eddng h\u1ee3p 2: Nh\u00e2n hai c\u1ed9t trong Excel, k\u00e8m v\u00ed d\u1ee5<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m PRODUCT ti\u1ebfp theo c\u0169ng ph\u1ed5 bi\u1ebfn kh\u00f4ng k\u00e9m tr\u01b0\u1eddng h\u1ee3p 1. Tuy nhi\u00ean, c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng s\u1ebd ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat, c\u00e1c b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo \u0111\u00fang h\u01b0\u1edbng d\u1eabn nh\u00e9.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng c\u00fa ph\u00e1p <\/span><b>=PRODUCT([s\u1ed1 th\u1ee9 nh\u1ea5t], [s\u1ed1 th\u1ee9 hai]\u2026)<\/b><span style=\"font-weight: 400;\">. L\u01b0u \u00fd, b\u1ea1n c\u1ea7n nh\u00e1y chu\u1ed9t \u0111\u00fang v\u00e0o \u00f4 c\u1ea7n t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n c\u0169ng nh\u1ea5n ch\u1ecdn Enter l\u00e0 m\u00e1y t\u00ednh s\u1ebd t\u1ef1 \u0111\u1ed9ng cho ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi \u0111\u00e2y, ch\u00fang ta th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i c\u1ed9t E2 ch\u00fang ta l\u00e0m theo c\u00f4ng th\u1ee9c <\/span><b>=PRODUCT(C2:D2)<\/b><span style=\"font-weight: 400;\">. \u0110\u1eebng qu\u00ean l\u00e0 click chu\u1ed9t v\u00e0o C2 v\u00e0 D2 b\u1ea1n nh\u00e9!<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_226092\" aria-describedby=\"caption-attachment-226092\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-2.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-2-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-2-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-226092 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-2.png\" alt=\"V\u00ed d\u1ee5: Nh\u00e2n hai c\u1ed9t trong Excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-2.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-2-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-2-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226092\" class=\"wp-caption-text\">V\u00ed d\u1ee5: Nh\u00e2n hai c\u1ed9t trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng h\u01b0\u1edbng d\u1eabn tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n hi\u1ec7u qu\u1ea3 trong Excel v\u1edbi h\u00e0m PRODUCT \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed5ng s\u1ea3n ph\u1ea9m c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb. N\u1ebfu b\u1ea1n mu\u1ed1n h\u1ecdc th\u1ee7 thu\u1eadt n\u00e2ng cao h\u01a1n th\u00ec h\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i ph\u1ea7n n\u1ed9i dung b\u00ean d\u01b0\u1edbi \u0111\u00e2y nh\u00e9!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel v\u1edbi h\u00e0m PRODUCT k\u1ebft h\u1ee3p c\u00e1c h\u00e0m kh\u00e1c<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m PRODUCT \u0111\u01a1n thu\u1ea7n, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 t\u00ednh nhi\u1ec1u b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p h\u01a1n nh\u1edd v\u00e0o vi\u1ec7c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c. C\u1ee5 th\u1ec3, trong b\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n k\u1ebft h\u1ee3p h\u00e0m PRODUCT v\u1edbi h\u00e0m SUM v\u00e0 IF.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m SUM, k\u00e8m v\u00ed d\u1ee5<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m PRODUCT v\u00e0 h\u00e0m SUM l\u00e0 hai h\u00e0m t\u00ednh to\u00e1n trong Excel c\u00f3 vai tr\u00f2 kh\u00e1c nhau, nh\u01b0ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhau. C\u1ee5 th\u1ec3 khi k\u1ebft h\u1ee3p h\u00e0m PRODUCT v\u00e0 h\u00e0m SUM, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p nh\u01b0 t\u00ednh t\u1ed5ng s\u1ea3n ph\u1ea9m c\u1ee7a c\u00e1c d\u00e3y s\u1ea3n ph\u1ea9m ri\u00eang bi\u1ec7t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u00ednh h\u00e0m PRODUCT &amp; h\u00e0m SUM <\/span><b>=PRODUCT(SUM(s\u1ed1 l\u01b0\u1ee3ng 1:s\u1ed1 l\u01b0\u1ee3ng 2);\u0111\u01a1n gi\u00e1).<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: S\u1ebfp giao cho b\u1ea1n m\u1ed9t file d\u1eef li\u1ec7u v\u00e0 y\u00eau c\u1ea7u ph\u1ea3i t\u00ednh th\u00e0nh ti\u1ec1n c\u00e1c s\u1ea3n ph\u1ea9m nh\u01b0 b\u1ea3ng minh h\u1ecda b\u00ean d\u01b0\u1edbi \u0111\u00e2y. C\u00e1ch gi\u1ea3i quy\u1ebft nhanh ch\u00f3ng v\u00e0 kh\u00f4ng t\u1ed1n nhi\u1ec1u th\u1eddi gian l\u00e0 h\u00e3y \u00e1p d\u1ee5ng h\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m SUM nh\u00e9.<\/span><\/p>\n<figure id=\"attachment_226110\" aria-describedby=\"caption-attachment-226110\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-226110 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1.png\" alt=\"H\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m SUM\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-3-1-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226110\" class=\"wp-caption-text\">H\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m SUM<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i \u00f4 F2, ch\u00fang ta \u00e1p d\u1ee5ng l\u1ec7nh <\/span><b>=PRODUCT(SUM(C2:D2);E2)<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u00fang ta ch\u1ec9 c\u1ea7n nh\u1ea5n Enter v\u00e0 k\u00e9o chu\u1ed9t xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i l\u00e0 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_226094\" aria-describedby=\"caption-attachment-226094\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-4.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-4-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-4-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-226094 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-4.png\" alt=\"K\u1ebft qu\u1ea3 v\u00ed d\u1ee5 h\u00e0m PRODUCT v\u00e0 h\u00e0m SUM\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-4.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-4-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-4-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226094\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 v\u00ed d\u1ee5 h\u00e0m PRODUCT v\u00e0 h\u00e0m SUM<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><b>H\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m IF, k\u00e8m v\u00ed d\u1ee5<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m PRODUCT v\u00e0 h\u00e0m IF \u0111\u1ed1i v\u1edbi <strong>ph\u00e9p nh\u00e2n trong Excel<\/strong> s\u1ebd gi\u00fap b\u1ea1n so s\u00e1nh 1 gi\u00e1 tr\u1ecb v\u1edbi 1 gi\u00e1 tr\u1ecb kh\u00e1c. Hay n\u00f3i c\u1ee5 th\u1ec3 h\u01a1n, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n h\u00e0m IF th\u1ef1c hi\u1ec7n \u0111\u00fang th\u00ec ph\u00e9p nh\u00e2n (*) A1 v\u00e0 B1 s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n h\u00e0m IF sai th\u00ec Excel s\u1ebd th\u1ef1c hi\u1ec7n nh\u00e2n A2 v\u00e0 B2.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c t\u00ednh h\u00e0m PRODUCT k\u1ebft h\u1ee3p h\u00e0m IF <\/span><b>=IF(\u0110i\u1ec1u ki\u1ec7n, PRODUCT(A1, B1), PRODUCT(A2, B2)).<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: S\u1ebfp giao cho b\u1ea1n t\u00ednh t\u1ed5ng l\u01b0\u01a1ng nh\u00e2n vi\u00ean, n\u1ebfu nh\u00e2n vi\u00ean l\u00e0m vi\u1ec7c \u1edf ca m\u1ed9t th\u00ec t\u00ednh ti\u1ec1n theo ca m\u1ed9t. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu nh\u00e2n vi\u00ean l\u00e0m vi\u1ec7c \u1edf ca hai th\u00ec t\u00ednh ti\u1ec1n theo ca hai (tr\u01b0\u1eddng h\u1ee3p b\u1ea1n t\u00ednh ti\u1ec1n theo ca m\u1ed9t l\u00e0 sai).\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngay l\u00fac n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n 2 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: D\u1ef1a theo c\u00f4ng th\u1ee9c h\u01b0\u1edbng d\u1eabn, t\u1ea1i c\u1ed9t t\u1ed5ng l\u01b0\u01a1ng G3 b\u1ea1n nh\u1eadp c\u00fa ph\u00e1p <\/span><b>=IF(C3=1,PRODUCT(D3,E3),PRODUCT(D3,F3))<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Lu\u00f4n lu\u00f4n nh\u1ea5n Enter \u0111\u1ec3 Excel ch\u1ea1y k\u1ebft qu\u1ea3, n\u1ebfu C3=1 l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang th\u00ec ti\u1ec1n l\u01b0\u01a1ng c\u1ee7a nh\u00e2n vi\u00ean Cao B\u00e1 Duy theo ca 1 l\u00e0 3.300.000.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_226100\" aria-describedby=\"caption-attachment-226100\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-5.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-5-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/phep-nhan-trong-excel-5-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-226100 size-full webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-5.png\" alt=\"H\u00e0m PRODUCT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-5.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-5-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel-5-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-226100\" class=\"wp-caption-text\">H\u00e0m PRODUCT k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m PRODUCT k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m SUM v\u00e0 IF \u0111\u00e3 gi\u00fap t\u00ednh to\u00e1n c\u1ee7a ch\u00fang ta linh ho\u1ea1t h\u01a1n r\u1ea5t nhi\u1ec1u. H\u01a1n n\u1eefa, h\u00e0m n\u00e0y c\u00f2n t\u0103ng t\u00ednh hi\u1ec7u qu\u1ea3 v\u00e0 ch\u00ednh x\u00e1c c\u1ee7a ph\u00e9p t\u00ednh. Th\u1eadt s\u1ef1 h\u00e0m PRODUCT l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong vi\u1ec7c th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong Excel.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m PRODUCT v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m PRODUCT \u0111\u1ec3 t\u00ednh to\u00e1n\u00a0b\u1ea1n c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn b\u00ean d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #VALUE!<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i h\u00e0m PRODUCT th\u01b0\u1eddng g\u1eb7p n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n khi m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00e1c \u00f4 v\u00e0 xem ch\u00fang c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 h\u1ee3p l\u1ec7 ch\u01b0a. Ho\u1eb7c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam b\u00e0i vi\u1ebft<strong> <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-cach-sua-loi-value-trong-excel\"><span style=\"color: #339966;\">h\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i<\/span> <span style=\"color: #339966;\">value trong Excel<\/span><\/a><\/strong> c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #REF!<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00ednh to\u00e1n d\u1ef1a tr\u00ean h\u00e0m PRODUCT khi g\u1eb7p l\u1ed7i n\u00e0y s\u1ebd c\u00f3 m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 \u0111\u00e3 b\u1ecb delete ho\u1eb7c di chuy\u1ec3n, d\u1eabn \u0111\u1ebfn sai l\u1ec7ch trong c\u00f4ng th\u1ee9c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00e1c \u00f4 v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang \u0111ang d\u1eabn \u0111\u1ebfn c\u00e1c s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #DIV\/0!<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ed9t quy t\u1eafc khi t\u00ednh <strong>ph\u00e9p nh\u00e2n trong Excel<\/strong> m\u00e0 b\u1ea1n c\u1ea7n nh\u1edb, \u0111\u00f3 ch\u00ednh l\u00e0 h\u00e0m PRODUCT kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n khi c\u00f3 m\u1ed9t s\u1ed1 b\u1eb1ng 0.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y l\u00e0 ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb \u0111ang \u0111\u01b0\u1ee3c nh\u00e2n v\u00e0 \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o b\u1eb1ng 0.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #NUM!<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i th\u1ee9 4 c\u0169ng \u0111\u00e3 c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea1n g\u1eb7p ph\u1ea3i, khi \u0111\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p nh\u00e2n v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n s\u1ed1 li\u1ec7u m\u00e0 Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e3y ki\u1ec3m tra l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang n\u1eb1m trong ph\u1ea1m vi cho ph\u00e9p c\u1ee7a Excel.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><b>L\u1ed7i #N\/A!<\/b><\/h3>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ed7i cu\u1ed1i c\u00f9ng x\u1ea3y ra khi trong h\u00e0m PRODUCT c\u00f3 \u00f4 ch\u01b0a c\u00f3 gi\u00e1 tr\u1ecb ho\u1eb7c kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c, h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00e1c \u00f4 v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u00fang ch\u1ee9a gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 ho\u1eb7c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c Excel t\u00ecm th\u1ea5y.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb9o hay d\u00e0nh cho b\u1ea1n, n\u1ebfu nh\u01b0 g\u1eb7p c\u00e1c l\u1ed7i n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 ki\u1ec3m tra l\u1ed7i (Error Checking) trong Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 s\u1eeda l\u1ed7i. H\u01a1n n\u1eefa, h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c \u00f4 \u0111ang \u0111\u01b0\u1ee3c tham chi\u1ebfu v\u00e0 gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 \u0111\u1ec1u h\u1ee3p l\u1ec7 nh\u00e9!<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>Ph\u00e9p nh\u00e2n trong Excel<\/strong>\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n th\u00f4ng qua h\u00e0m PRODUCT, l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng m\u00e0 ai c\u0169ng n\u00ean bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng. \u0110\u1eb7c bi\u1ec7t v\u1edbi h\u00e0m PRODUCT, n\u00f3 s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian, t\u0103ng t\u00ednh hi\u1ec7u qu\u1ea3 v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c khi x\u1eed l\u00fd th\u00f4ng tin.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, khi k\u1ebft h\u1ee3p h\u00e0m PRODUCT c\u00f9ng c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c, b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng li\u00ean ti\u1ebfp nhau c\u0169ng nh\u01b0 x\u1eed l\u00fd c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn v\u1edbi \u0111\u1ed9 ch\u00ednh x\u00e1c cao.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u00e2y, <strong><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\">Ho\u00e0ng H\u00e0 Mobile<\/a><\/span> <\/strong>\u0111\u00e3 t\u1ed5ng k\u1ebft l\u1ea1i t\u1ea5t c\u1ea3 th\u00f4ng tin li\u00ean quan \u0111\u1ebfn h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<strong> ph\u00e9p nh\u00e2n trong Excel<\/strong>. Hy v\u1ecdng b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 quan t\u00e2m v\u00e0 h\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i website \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c nhi\u1ec1u ki\u1ebfn th\u1ee9c h\u1eefu \u00edch kh\u00e1c nh\u00e9!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ph\u00e9p nh\u00e2n trong Excel l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t ph\u1ed5 bi\u1ebfn trong t\u00ednh to\u00e1n c\u0169ng nh\u01b0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Tuy nhi\u00ean, v\u1edbi nh\u1eefng d\u00e3y s\u1ed1 ph\u1ee9c t\u1ea1p th\u00ec ph\u00e9p t\u00ednh n\u00e0y s\u1eed d\u00f9ng h\u00e0m g\u00ec? B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":226088,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,412,28840],"tags":[],"class_list":["post-226087","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat","category-thu-thuat-may-tinh","category-word"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T08:03:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daisy Daisy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daisy Daisy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u\",\"datePublished\":\"2023-07-04T08:03:07+00:00\",\"dateModified\":\"2023-07-04T08:03:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\"},\"wordCount\":3332,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg\",\"articleSection\":[\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\",\"Word\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg\",\"datePublished\":\"2023-07-04T08:03:07+00:00\",\"dateModified\":\"2023-07-04T08:03:07+00:00\",\"description\":\"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u","description":"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u","og_description":"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-07-04T08:03:07+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30"},"headline":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u","datePublished":"2023-07-04T08:03:07+00:00","dateModified":"2023-07-04T08:03:07+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/"},"wordCount":3332,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg","articleSection":["Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh","Word"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg","datePublished":"2023-07-04T08:03:07+00:00","dateModified":"2023-07-04T08:03:07+00:00","description":"B\u00e0i vi\u1ebft sau \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong excel th\u00f4ng qua h\u00e0m PRODUCT v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda r\u1ea5t d\u1ec5 hi\u1ec3u. C\u00f9ng theo d\u00f5i nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/phep-nhan-trong-excel.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/huong-dan-su-dung-phep-nhan-trong-excel-meo-hay-de-hieu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n trong Excel, m\u1eb9o hay d\u1ec5 hi\u1ec3u"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/506edc7aab4e26e80b30c1a70bffcb30","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0443357de7d3a062390e44ee102b08d6?s=96&d=mm&r=g","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/226087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=226087"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/226087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/226088"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=226087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=226087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=226087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}