{"id":281463,"date":"2023-11-07T15:40:51","date_gmt":"2023-11-07T08:40:51","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=281463"},"modified":"2023-11-07T15:40:51","modified_gmt":"2023-11-07T08:40:51","slug":"ham-and-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/","title":{"rendered":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft"},"content":{"rendered":"<p><i><span style=\"font-weight: 400;\">Trong c\u00f4ng c\u1ee5 Excel, AND l\u00e0 m\u1ed9t h\u00e0m ph\u1ed5 bi\u1ebfn th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m quan tr\u1ecdng kh\u00e1c \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac. T\u1eeb \u0111\u00f3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Tuy nhi\u00ean, th\u1ef1c t\u1ebf th\u00ec <\/span><\/i><b><i>h\u00e0m AND trong Excel<\/i><\/b><i><span style=\"font-weight: 400;\"> l\u1ea1i g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho nh\u1eefng ng\u01b0\u1eddi m\u1edbi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. Ch\u00ednh v\u00ec v\u1eady, b\u00e0i vi\u1ebft h\u00f4m nay, <\/span><\/i><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/\"><b><i>Ho\u00e0ng H\u00e0 Mobile<\/i><\/b><\/a><i><span style=\"font-weight: 400;\"> s\u1ebd tr\u00ecnh b\u00e0y c\u1ee5 th\u1ec3 h\u01a1n v\u1ec1 c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 nh\u1eefng v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u \u0111\u1ec3 gi\u00fap b\u1ea1n n\u1eafm b\u1eaft v\u00e0 ho\u00e0n th\u00e0nh c\u00e1c b\u00e0i to\u00e1n li\u00ean quan \u0111\u1ebfn h\u00e0m n\u00e0y.\u00a0<\/span><\/i><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m AND trong Excel \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a nh\u01b0 th\u1ebf n\u00e0o?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">AND trong c\u00f4ng c\u1ee5 Excel l\u00e0 m\u1ed9t h\u00e0m logic \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra xem m\u1ed9t lo\u1ea1t c\u00e1c \u0111i\u1ec1u ki\u1ec7n trong t\u1ec7p d\u1eef li\u1ec7u c\u00f3 th\u1ef1c s\u1ef1 \u0111\u00fang hay kh\u00f4ng. C\u1ee5 th\u1ec3, h\u00e0m n\u00e0y ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch \u0111\u00e1nh gi\u00e1 c\u00e1c bi\u1ec3u th\u1ee9c ho\u1eb7c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c cung c\u1ea5p v\u00e0 tr\u1ea3 ch\u00fang v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c ki\u1ec3m tra \u0111\u1ec1u \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong s\u1ed1 ch\u00fang sai, h\u00e0m AND trong Excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng l\u00e0 FALSE.<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-281465\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-1.jpg\" alt=\"ham-and-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ng\u01b0\u1eddi d\u00f9ng c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem gi\u00e1 b\u00e1n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m \u0111\u00f3 c\u00f3 c\u00f2n h\u00e0ng hay kh\u00f4ng th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 k\u1ebft h\u1ee3p hai \u0111i\u1ec1u ki\u1ec7n n\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Theo \u0111\u00f3, n\u1ebfu c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng v\u00e0 gi\u00e1 b\u00e1n \u0111\u1ec1u \u0111\u00fang, h\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 TRUE. \u0110i\u1ec1u n\u00e0y th\u1ec3 hi\u1ec7n r\u1eb1ng s\u1ea3n ph\u1ea9m \u0111\u00f3 \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 b\u1ea1n ti\u1ebfp t\u1ee5c b\u00e0y b\u00e1n. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong s\u1ed1 c\u00e1c \u0111i\u1ec1u ki\u1ec7n sai, h\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 FALSE v\u00e0 \u0111i\u1ec1u n\u00e0y ch\u1ec9 ra r\u1eb1ng s\u1ea3n ph\u1ea9m \u0111\u00f3 kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n v\u1ec1 gi\u00e1 b\u00e1n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Vai tr\u00f2 c\u1ee7a h\u00e0m AND trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c t\u1ebf, m\u1ee5c ti\u00eau cu\u1ed1i c\u00f9ng c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m AND trong Excel l\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a vi\u1ec7c ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n logic m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng. \u0110\u1eb7c bi\u1ec7t, h\u00e0m n\u00e0y c\u00f2n r\u1ea5t h\u1eefu \u00edch trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng nh\u01b0:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Ki\u1ec3m tra \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\">: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng ch\u00fang cho c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c trong c\u00f4ng c\u1ee5 Excel. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra xem t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb nh\u1eadp v\u00e0o c\u00e1c \u00f4 l\u00e0 s\u1ed1 d\u01b0\u01a1ng trong Excel nh\u1edd \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m AND.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-281466\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-2.jpg\" alt=\"ham-and-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>X\u00e2y d\u1ef1ng c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p<\/b><span style=\"font-weight: 400;\">: H\u00e0m AND th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng trong c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Th\u1eadm ch\u00ed, b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m AND, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 \u0111\u1ed9 ph\u1ee9c t\u1ea1p cao. T\u1eeb \u0111\u00f3 \u0111\u01b0a ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t quy\u1ebft \u0111\u1ecbnh \u0111\u00fang \u0111\u1eafn trong l\u1ef1a ch\u1ecdn c\u1ee7a m\u00ecnh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>L\u1ecdc d\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\">: H\u00e0m AND trong Excel c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m AND \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c d\u00f2ng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 b\u1ea1n \u0111\u1eb7t ra. T\u1eeb \u0111\u00f3 gi\u00fap t\u1ed1i \u01b0u h\u00f3a th\u1eddi gian t\u00ecm v\u00e0 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u tr\u00ean Excel.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m AND trong Excel hi\u1ec7u qu\u1ea3 b\u1ea1n n\u00ean bi\u1ebft<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c ch\u1ea5t, h\u00e0m AND r\u1ea5t \u00e1p d\u1ee5ng v\u00e0 kh\u00f4ng kh\u00f3 nh\u01b0 b\u1ea1n ngh\u0129 n\u1ebfu ng\u01b0\u1eddi d\u00f9ng n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n. Do \u0111\u00f3, tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m AND \u0111\u1ec3 gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n li\u00ean quan, b\u1ea1n n\u00ean theo d\u00f5i th\u00f4ng tin v\u1ec1 c\u1ea5u tr\u00fac v\u00e0 c\u00fa ph\u00e1p thao t\u00e1c ch\u00fang qua g\u1ee3i \u00fd sau:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m AND trong Excel<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m AND c\u00f3 c\u00fa ph\u00e1p ch\u00ednh x\u00e1c nh\u01b0 sau: =<\/span><b>AND(\u0111i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2,&#8230;)<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, \u201c\u0111i\u1ec1u ki\u1ec7n 1\u201d, \u201c\u0111i\u1ec1u ki\u1ec7n 2\u201d,&#8230; l\u00e0 c\u00e1c bi\u1ec3u th\u1ee9c ho\u1eb7c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra t\u00ednh ch\u00ednh x\u00e1c trong b\u1ea3ng t\u00ednh c\u1ee7a Excel. \u0110\u1ed3ng th\u1eddi, c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m AND c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp t\u1eeb hai \u0111i\u1ec1u ki\u1ec7n tr\u1edf l\u00ean, t\u00f9y v\u00e0o \u0111\u1ec1 b\u00e0i v\u00e0 m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-281467\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-3.jpg\" alt=\"ham-and-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/span><b>L\u01b0u \u00fd<\/b><span style=\"font-weight: 400;\">:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m AND trong Excel th\u01b0\u1eddng s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ch\u1ee7 y\u1ebfu trong vi\u1ec7c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF \u0111\u1ec3 t\u1ea1o ra c\u00e1c c\u00e2u l\u1ec7nh s\u1edf h\u1eefu \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m AND khi \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u, ch\u00fang s\u1ebd \u0111\u01b0a ra k\u1ebft lu\u1eadn TRUE khi t\u1ea5t c\u1ea3 c\u00e1c bi\u1ec3u th\u1ee9c logic th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n. Tr\u01b0\u1eddng h\u1ee3p n\u1ebfu m\u1ed9t trong s\u1ed1 bi\u1ec3u th\u1ee9c b\u1ecb sai, h\u00e0m AND s\u1ebd \u0111\u01b0a ra k\u1ebft lu\u1eadn FALSE.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea5p gi\u00e1 tr\u1ecb s\u1ed1 cho h\u00e0m AND, ch\u1eb3ng h\u1ea1n nh\u01b0 AND(10) th\u00ec h\u00e0m n\u00e0y v\u1eabn \u0111\u01b0a ra k\u1ebft lu\u1eadn l\u00e0 TRUE. Do \u0111\u00f3, b\u1ea1n c\u1ea7n l\u01b0u \u00fd tr\u00e1nh cung c\u1ea5p gi\u00e1 tr\u1ecb t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 h\u00e0m AND ho\u1ea1t \u0111\u1ed9ng hi\u1ec7u qu\u1ea3 h\u01a1n.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m AND trong Excel \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Tr\u00ean c\u00f4ng c\u1ee5 Excel, h\u00e0m AND th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 t\u00ednh ph\u1ee9c t\u1ea1p cao v\u00e0 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m kh\u00e1c \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n logic. V\u00ed d\u1ee5 ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u00f3 l\u00e0 ng\u01b0\u1eddi d\u00f9ng hay s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 sau \u0111\u00f3 k\u1ebft h\u1ee3p ch\u00fang v\u1edbi h\u00e0m IF \u0111\u1ec3 t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p. Song, \u0111\u1ec3 gi\u00fap b\u1ea1n n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng c\u1ee5 th\u1ec3 h\u00e0m AND trong Excel th\u00ec Ho\u00e0ng H\u00e0 Mobile s\u1ebd cung c\u1ea5p c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda ngay trong ph\u1ea7n d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h4><strong>V\u00ed d\u1ee5 minh h\u1ecda 1<\/strong><\/h4>\n<p><b>\u0110\u1ec1 b\u00e0i<\/b><span style=\"font-weight: 400;\">: M\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c th\u00f4ng tin v\u1ec1 h\u1ecdc sinh nh\u01b0 h\u1ecd t\u00ean, gi\u1edbi t\u00ednh v\u00e0 \u0111i\u1ec3m thi c\u1ee7a m\u00f4n V\u0103n. C\u1ee5 th\u1ec3, b\u1ea3ng n\u00e0y bao g\u1ed3m 5 h\u1ecdc sinh, trong \u0111\u00f3 c\u00f3 2 n\u1eef v\u00e0 3 nam. B\u1ea1n h\u00e3y s\u1eed d\u1ee5ng h\u00e0m AND trong Excel \u0111\u1ec3 ki\u1ec3m tra xem c\u00f3 bao nhi\u00eau h\u1ecdc sinh gi\u1edbi t\u00ednh nam \u0111\u00e3 \u0111\u1ea1t \u0111i\u1ec3m s\u1ed1 tr\u00ean 7 trong m\u00f4n V\u0103n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi gi\u1ea3i, b\u1ea1n c\u1ea7n ph\u1ea3i x\u00e9t hai \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n 1: H\u1ecdc sinh ph\u1ea3i l\u00e0 nam.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n 2: \u0110i\u1ec3m thi c\u1ee7a m\u00f4n V\u0103n ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 7.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh gi\u1ea3i b\u00e0i to\u00e1n th\u00f4ng qua t\u1eebng b\u01b0\u1edbc nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ti\u1ebfn h\u00e0nh m\u1edf trang Excel ch\u1ee9a d\u1eef li\u1ec7u v\u00e0 b\u1eaft \u0111\u1ea7u nh\u1eadp c\u00fa ph\u00e1p: <\/span><b>=AND(B2=&#8217;Nam&#8217;, C2&gt;=7)<\/b><span style=\"font-weight: 400;\"> v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb \u0111\u1ec3 ki\u1ec3m tra. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, AND \u0111\u01b0\u1ee3c xem l\u00e0 l\u1ec7nh c\u1ee7a h\u00e0m, c\u00f2n \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u00e9t duy\u1ec7t \u0111\u00f3 l\u00e0 B2=&#8217;Nam&#8217;, C2&gt;=7.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-282209\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-4-1.jpg\" alt=\"ham-and-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-4-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-4-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-4-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau khi nh\u1eadp c\u00fa ph\u00e1p, b\u1ea1n nh\u1ea5n n\u00fat Enter \u0111\u1ec3 h\u1ec7 th\u1ed1ng cho ra k\u1ebft qu\u1ea3. Trong \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u00ecn th\u1ea5y r\u1eb1ng \u00f4 d\u1eef li\u1ec7u th\u1ee9 nh\u1ea5t hi\u1ec3n th\u1ecb k\u1ebft lu\u1eadn \u201cFALSE\u201d b\u1edfi s\u1edf h\u1eefu \u0111i\u1ec3m v\u0103n l\u00e0 6 n\u00ean kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n c\u1ee7a h\u00e0m AND.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-282210\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-5-1.jpg\" alt=\"ham-and-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-5-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-5-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-5-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00fa ph\u00e1p cho c\u00e1c h\u00e0ng d\u1eef li\u1ec7u c\u00f2n l\u1ea1i, b\u1ea1n d\u00f9ng chu\u1ed9t k\u00e9o v\u00e0 th\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u01b0\u1edbng d\u1eabn c\u1ee7a h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-282211\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-6-1.jpg\" alt=\"ham-and-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-6-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-6-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-6-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: L\u00fac n\u00e0y, t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u00e1nh gi\u00e1 s\u1ebd th\u1ec3 hi\u1ec7n tr\u1ef1c ti\u1ebfp tr\u00ean \u00f4 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng c\u00fa ph\u00e1p. Trong \u0111\u00f3, nh\u1eefng \u00f4 hi\u1ec3n th\u1ecb k\u1ebft lu\u1eadn \u201cTRUE\u201d l\u00e0 k\u1ebft qu\u1ea3 b\u1ea1n \u0111ang \u0111i t\u00ecm.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-282212\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-7-1.jpg\" alt=\"ham-and-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-7-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-7-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-7-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h4><strong>V\u00ed d\u1ee5 minh h\u1ecda 2<\/strong><\/h4>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng t\u00ednh b\u00ean tr\u00ean, l\u1ea7n n\u00e0y \u0111\u1ec3 b\u00e0i y\u00eau c\u1ea7u ng\u01b0\u1eddi d\u00f9ng \u00e1p d\u1ee5ng h\u00e0m AND trong Excel \u0111\u1ec3 ki\u1ec3m tra c\u00e1c b\u1ea1n h\u1ecdc sinh \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea1t \u0111i\u1ec3m trung b\u00ecnh trong l\u1edbp h\u1ecdc.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u00ed d\u1ee5 1, ch\u00fang ta s\u1ebd x\u00e1c \u0111\u1ecbnh hai \u0111i\u1ec1u ki\u1ec7n cho \u0111\u1ec1 b\u00e0i n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n 1: \u0110i\u1ec3m m\u00f4n V\u0103n ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 5.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u ki\u1ec7n 2: \u0110i\u1ec3m m\u00f4n To\u00e1n c\u0169ng ph\u1ea3i b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n 5.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c, ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng c\u00fa ph\u00e1p c\u1ee7a h\u00e0m AND v\u00e0o b\u1ea3ng t\u00ednh n\u00e0y th\u00f4ng qua c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean b\u1ea3ng t\u00ednh c\u1ee7a d\u1eef li\u1ec7u Excel, ng\u01b0\u1eddi d\u00f9ng ti\u1ebfn h\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 l\u00e0 =AND(B2&gt;=5, C2&gt;=5). Trong \u0111\u00f3, AND lu\u00f4n lu\u00f4n l\u00e0 l\u1ec7nh h\u00e0m trong Excel, c\u00f2n \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u00e9t duy\u1ec7t s\u1ebd thay \u0111\u1ed5i th\u00e0nh B2&gt;=5 v\u00e0 C2&gt;=5.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-282213\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-8-1.jpg\" alt=\"ham-and-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-8-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-8-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-8-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u01b0\u01a1ng t\u1ef1, b\u1ea1n nh\u1ea5n n\u00fat Enter \u0111\u1ec3 h\u1ec7 th\u1ed1ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a b\u00e0i to\u00e1n. Sau \u0111\u00f3 d\u00f9ng chu\u1ed9t ti\u1ebfp t\u1ee5c k\u00e9o c\u00fa ph\u00e1p cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ec3 h\u1ec7 th\u00f4ng cho ra k\u1ebft lu\u1eadn b\u1ea1n c\u1ea7n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u201cFALSE\u201d l\u00e0 k\u1ebft qu\u1ea3 nh\u1eefng b\u1ea1n h\u1ecdc sinh c\u00f3 \u0111i\u1ec3m s\u1ed1 kh\u00f4ng \u0111\u1ea1t tr\u00ean trung b\u00ecnh. B\u1ea1n c\u1ea7n lo\u1ea1i tr\u1ef1c ti\u1ebfp c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb k\u1ebft lu\u1eadn n\u00e0y \u0111\u1ec3 \u0111\u01b0a ra \u0111\u00e1p \u00e1n cu\u1ed1i c\u00f9ng.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-281473\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-9.jpg\" alt=\"ham-and-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">Nh\u1eefng l\u01b0u \u00fd khi d\u00f9ng h\u00e0m AND trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 h\u00e0m AND \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1i \u0111a trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng, b\u1ea1n n\u00ean c\u00e2n nh\u1eafc ch\u00fang v\u1edbi m\u1ed9t s\u1ed1 y\u1ebfu t\u1ed1 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>S\u1ed1 l\u01b0\u1ee3ng \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\">: H\u00e0m AND trong Excel c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n logic. Tuy nhi\u00ean, h\u00e3y c\u00e2n nh\u1eafc r\u1eb1ng s\u1ed1 l\u01b0\u1ee3ng \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c qu\u00e1 nhi\u1ec1u c\u00f3 th\u1ec3 l\u00e0m cho ch\u00fang tr\u1edf n\u00ean ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f3 qu\u1ea3n l\u00fd.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Th\u1ee9 t\u1ef1 ki\u1ec3m tra<\/b><span style=\"font-weight: 400;\">: H\u00e0m AND ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u1eeb tr\u00e1i sang ph\u1ea3i v\u00e0 d\u1eebng l\u1ea1i ngay khi g\u1eb7p m\u1ed9t \u0111i\u1ec1u ki\u1ec7n sai (FALSE). \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a r\u1eb1ng n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n sai \u1edf \u0111\u1ea7u, c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau \u0111\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c ki\u1ec3m tra. Do \u0111\u00f3, b\u1ea1n c\u0169ng n\u00ean \u0111\u1ea3m b\u1ea3o vi\u1ec7c \u0111\u1eb7t c\u00e1c \u0111i\u1ec1u ki\u1ec7n quan tr\u1ecdng \u1edf ph\u00eda tr\u01b0\u1edbc \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-281474\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-10.jpg\" alt=\"ham-and-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>S\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c<\/b><span style=\"font-weight: 400;\">: \u0110\u1ec3 tr\u00e1nh l\u1ed7i trong vi\u1ec7c k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n ho\u1eb7c ngo\u1eb7c \u0111\u00f4i \u0111\u1ec3 gom nh\u00f3m c\u00e1c \u0111i\u1ec1u ki\u1ec7n li\u00ean quan l\u1ea1i v\u1edbi nhau. \u0110i\u1ec1u n\u00e0y gi\u00fap \u0111\u1ea3m b\u1ea3o th\u1ee9 t\u1ef1 ki\u1ec3m tra \u0111\u00fang \u0111\u1eafn v\u00e0 tr\u00e1nh s\u1ef1 hi\u1ec3u l\u1ea7m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>X\u1eed l\u00fd l\u1ed7i<\/b><span style=\"font-weight: 400;\">: H\u00e0m AND s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i n\u1ebfu m\u1ed9t ho\u1eb7c nhi\u1ec1u trong s\u1ed1 c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ecb l\u1ed7i. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra s\u1ef1 kh\u00f3 ch\u1ecbu trong b\u1ea3ng t\u00ednh. B\u1ea1n n\u00ean x\u1eed l\u00fd c\u00e1c l\u1ed7i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IFERROR ho\u1eb7c ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m AND.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Ki\u1ec3m tra ki\u1ec3u d\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\">: H\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111ang ki\u1ec3m tra ph\u00f9 h\u1ee3p v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mong \u0111\u1ee3i. N\u1ebfu b\u1ea1n ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u ngo\u1eb7c k\u00e9p (&#8221; &#8220;) xung quanh gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">L\u1eddi k\u1ebft<\/span><\/h2>\n<p><i><span style=\"font-weight: 400;\">Nh\u00ecn chung, <\/span><\/i><b><i>h\u00e0m AND trong Excel <\/i><\/b><i><span style=\"font-weight: 400;\">kh\u00f4ng qu\u00e1 kh\u00f3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n trong qu\u00e1 tr\u00ecnh \u00e1p d\u1ee5ng ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n cho d\u1eef li\u1ec7u. Th\u1eadm ch\u00ed, \u0111\u00e2y c\u00f2n l\u00e0 h\u00e0m c\u00f3 thao t\u00e1c t\u01b0\u01a1ng \u0111\u1ed1i d\u1ec5 v\u1edbi nh\u1eefng ng\u01b0\u1eddi n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c quy t\u1eafc \u0111i\u1ec1n c\u00fa ph\u00e1p v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p ch\u00fang v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m \u0111\u1eb7c bi\u1ec7t kh\u00e1c. H\u01a1n h\u1ebft, \u0111\u00e2y l\u00e0 m\u1ed9t h\u00e0m c\u01a1 b\u1ea3n trong c\u00f4ng c\u1ee5 Excel m\u00e0 b\u1ea5t c\u1ee9 ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u0169ng ph\u1ea3i b\u1eaft bu\u1ed9c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a \u0111\u01b0\u1ee3c th\u1eddi gian x\u1eed l\u00fd v\u00e0 ki\u1ec3m tra \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u. Do \u0111\u00f3, \u0111\u1eebng ng\u1ea7n ng\u1ea1i \u0111\u1eb7t th\u00eam nh\u1eefng c\u00e2u h\u1ecfi v\u00e0 v\u1ea5n \u0111\u1ec1 c\u1ee7a b\u1ea1n v\u1ec1 h\u00e0m n\u00e0y \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p k\u1ecbp th\u1eddi t\u1eeb <\/span><\/i><b><i>Ho\u00e0ng H\u00e0 Mobile<\/i><\/b><i><span style=\"font-weight: 400;\"> nh\u00e9!<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\">C\u00e1ch d\u00f9ng h\u00e0m IF k\u1ebft h\u1ee3p h\u00e0m AND trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-right\/\">H\u00e0m RIGHT trong Excel: C\u00e1ch c\u1eaft chu\u1ed7i b\u00ean ph\u1ea3i, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-find\/\">H\u00e0m FIND v\u00e0 SEARCH trong Excel v\u1edbi c\u00e1c v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong c\u00f4ng c\u1ee5 Excel, AND l\u00e0 m\u1ed9t h\u00e0m ph\u1ed5 bi\u1ebfn th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m quan tr\u1ecdng kh\u00e1c \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac. T\u1eeb \u0111\u00f3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Tuy nhi\u00ean, [&hellip;]<\/p>\n","protected":false},"author":101,"featured_media":281464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-281463","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft<\/title>\n<meta name=\"description\" content=\"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\" \/>\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\/ham-and-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/\" \/>\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:published_time\" content=\"2023-11-07T08:40:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-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=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\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=\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\" \/>\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\\\/ham-and-trong-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#\\\/schema\\\/person\\\/fd8638ba163a2893d51313fda044e61d\"},\"headline\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft\",\"datePublished\":\"2023-11-07T08:40:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/\"},\"wordCount\":3069,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/ham-and-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/\",\"name\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/ham-and-trong-excel.jpg\",\"datePublished\":\"2023-11-07T08:40:51+00:00\",\"description\":\"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/ham-and-trong-excel.jpg\",\"contentUrl\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/ham-and-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-and-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/ham-and-trong-excel\\\/#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\":\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/category\\\/thu-thuat\\\/thu-thuat-may-tinh\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel\",\"item\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/category\\\/thu-thuat\\\/thu-thuat-may-tinh\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft\"}]},{\"@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\\\/fd8638ba163a2893d51313fda044e61d\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\"},\"url\":\"https:\\\/\\\/hoanghamobile.com\\\/tin-tuc\\\/author\\\/nguyen-xuan-hieu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft","description":"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","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\/ham-and-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft","og_description":"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-07T08:40:51+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","\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\/ham-and-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fd8638ba163a2893d51313fda044e61d"},"headline":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft","datePublished":"2023-11-07T08:40:51+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/"},"wordCount":3069,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/","name":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel.jpg","datePublished":"2023-11-07T08:40:51+00:00","description":"H\u00e0m AND trong Excel g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi l\u1ea7n \u0111\u1ea7u s\u1eed d\u1ee5ng. V\u00ec th\u1ebf, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang trong b\u00e0i vi\u1ebft sau.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-and-trong-excel.jpg","width":1200,"height":628,"caption":"ham-and-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-and-trong-excel\/#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":"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/thu-thuat-may-tinh\/"},{"@type":"ListItem","position":4,"name":"Excel","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/thu-thuat-may-tinh\/excel\/"},{"@type":"ListItem","position":5,"name":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng, c\u00fa ph\u00e1p, v\u00ed d\u1ee5 chi ti\u1ebft"}]},{"@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\/fd8638ba163a2893d51313fda044e61d","name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7215428eef2a3c7df68cfafc54564adae113d2129326392c9efb9aae96d9ac00?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-hieu\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/281463","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\/101"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=281463"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/281463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/281464"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=281463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=281463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=281463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}