{"id":275882,"date":"2023-10-25T19:01:18","date_gmt":"2023-10-25T12:01:18","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=275882"},"modified":"2023-10-25T19:01:18","modified_gmt":"2023-10-25T12:01:18","slug":"ham-if-and","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/","title":{"rendered":"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"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Microsoft Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i kh\u00f4ng ch\u1ec9 trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n m\u00e0 c\u00f2n \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Trong \u0111\u00f3, h\u00e0m IF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quen thu\u1ed9c gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. Tuy nhi\u00ean, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u1ea7n hi\u1ec3u c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi h\u00e0m AND \u0111\u1ec3 x\u1eed l\u00fd nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, trong b\u00e0i vi\u1ebft n\u00e0y, <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng <\/span><b>h\u00e0m IF AND<\/b><span style=\"font-weight: 400;\"> trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">T\u1ea1i sao h\u00e0m IF AND l\u1ea1i \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng ng\u01b0\u1eddi d\u00f9ng c\u1ea7n ki\u1ec3m tra v\u00e0 th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0nh \u0111\u1ed9ng n\u1ebfu m\u1ed9t h\u00e0ng lo\u1ea1t \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c th\u1ecfa m\u00e3n. H\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND cho ph\u00e9p b\u1ea1n k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ea1i v\u1edbi nhau. \u0110\u1ed3ng th\u1eddi, gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u theo c\u00e1ch m\u00e0 h\u00e0m IF \u0111\u01a1n gi\u1ea3n kh\u00f4ng th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n nhanh ch\u00f3ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c vi\u1ec7c x\u1eed l\u00fd, ph\u00e2n t\u00edch d\u1eef li\u1ec7u trong c\u00e1c t\u00ecnh hu\u1ed1ng ph\u1ee9c t\u1ea1p m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 g\u1eb7p trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<figure id=\"attachment_275885\" aria-describedby=\"caption-attachment-275885\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-275885 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-1.jpg\" alt=\"ham-if-and-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-275885\" class=\"wp-caption-text\">T\u1ea1i sao h\u00e0m IF v\u00e0 h\u00e0m AND l\u1ea1i \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Excel?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, h\u00e0m IF AND c\u00f2n c\u00f3 kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng h\u00f3a quy\u1ebft \u0111\u1ecbnh trong b\u1ea3ng t\u00ednh. Ch\u1eb3ng h\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 ki\u1ec3m tra l\u1ed7i trong d\u1eef li\u1ec7u, ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u ho\u1eb7c t\u1ea1o c\u00e1c b\u00e1o c\u00e1o d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Thay v\u00ec ph\u1ea3i th\u1ef1c hi\u1ec7n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 quy\u1ebft \u0111\u1ecbnh b\u1eb1ng tay, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND trong Excel \u0111\u1ec3 t\u1ea1o c\u00e1c b\u00e1o c\u00e1o t\u00f9y ch\u1ec9nh d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3 v\u00e0 l\u1ecdc d\u1eef li\u1ec7u theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n mong mu\u1ed1n. T\u1eeb \u0111\u00f3 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m nguy c\u01a1 sai s\u00f3t trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd m\u1ed9t kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn s\u1ed1 li\u1ec7u.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n c\u1ee7a h\u00e0m IF v\u00e0 h\u00e0m AND trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng hi\u1ec7u qu\u1ea3 h\u00e0m IF AND, tr\u01b0\u1edbc ti\u00ean b\u1ea1n ph\u1ea3i xem l\u1ea1i c\u00e1ch ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00fa ph\u00e1p c\u1ee7a t\u1eebng h\u00e0m trong Excel. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 g\u1ee3i \u00fd c\u01a1 b\u1ea3n \u0111\u1ec3 gi\u00fap b\u1ea1n n\u1eafm b\u1eaft c\u00e1c ki\u1ebfn th\u1ee9c \u0111\u00f3.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m IF<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m IF trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. H\u00e0m IF c\u00f3 c\u1ea5u tr\u00fac c\u01a1 b\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>=IF(\u0111i\u1ec1u_ki\u1ec7n, gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang , gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u_ki\u1ec7n: \u0110\u00e2y l\u00e0 bi\u1ec3u th\u1ee9c ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang (TRUE): L\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00fang.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1_tr\u1ecb_n\u1ebfu_sai (FALSE): L\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n l\u00e0 sai.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_275886\" aria-describedby=\"caption-attachment-275886\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-275886 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-2.jpg\" alt=\"ham-if-and-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-275886\" class=\"wp-caption-text\">C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m IF trong c\u00f4ng c\u1ee5 Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Qua c\u00fa ph\u00e1p tr\u00ean c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng, h\u00e0m IF AND l\u00e0 c\u00f4ng c\u1ee5 c\u01a1 b\u1ea3n nh\u01b0ng c\u00f3 th\u1ec3 m\u1edf ra nhi\u1ec1u c\u01a1 h\u1ed9i \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c quy\u1ebft \u0111\u1ecbnh logic. B\u1edfi, h\u00e0m IF ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u1ebfu \u0111\u00fang (TRUE). Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u1ebfu sai (FALSE).\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m AND<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m AND \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic c\u01a1 b\u1ea3n. Th\u00f4ng th\u01b0\u1eddng, h\u00e0m n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac. Theo \u0111\u00f3, h\u00e0m AND tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang (TRUE) n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu b\u1ea5t k\u1ef3 m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n l\u00e0 sai, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai (FALSE).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng h\u00e0m IF AND v\u1edbi nhau, b\u1ea1n n\u00ean n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u1ea5u tr\u00fac c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m AND nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>=AND(\u0111i\u1ec1u_ki\u1ec7n1, \u0111i\u1ec1u_ki\u1ec7n2,&#8230;)<\/b><\/p>\n<figure id=\"attachment_275887\" aria-describedby=\"caption-attachment-275887\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-275887 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-3.jpg\" alt=\"ham-if-and-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-275887\" class=\"wp-caption-text\">C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m AND trong c\u00f4ng c\u1ee5 Excel<\/figcaption><\/figure>\n<p><b>L\u01b0u \u00fd<\/b><span style=\"font-weight: 400;\">: C\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u00f3 trong h\u00e0m AND l\u00e0 danh s\u00e1ch c\u00e1c \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra trong qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u00ean Excel.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m AND trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi k\u1ebft h\u1ee3p h\u00e0m IF AND trong Excel, b\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac. C\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111i\u1ec1u ki\u1ec7n v\u00e0 sau \u0111\u00f3, s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m AND th\u00f4ng qua c\u1ea5u tr\u00fac c\u01a1 b\u1ea3n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: center;\"><b>=IF(AND(\u0111i\u1ec1u_ki\u1ec7n1, \u0111i\u1ec1u_ki\u1ec7n2,&#8230;), gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang, gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110i\u1ec1u_ki\u1ec7n1, \u0111i\u1ec1u_ki\u1ec7n2,&#8230;: L\u00e0 danh s\u00e1ch c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi h\u00e0m AND.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang: \u0110\u00e2y l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m AND \u0111\u00fang.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u00e1_tr\u1ecb_n\u1ebfu_sai: L\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m AND sai.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_275888\" aria-describedby=\"caption-attachment-275888\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-275888 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-4.jpg\" alt=\"ham-if-and-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-275888\" class=\"wp-caption-text\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m AND trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Nh\u1eb1m gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1ch \u00e1p d\u1ee5ng h\u00e0m IF AND, Ho\u00e0ng H\u00e0 Mobile s\u1ebd t\u1ed5ng h\u1ee3p m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 th\u00f4ng qua n\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y. H\u00e3y theo d\u00f5i \u0111\u1ec3 n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00e1ch tri\u1ec3n khai c\u00fa ph\u00e1p c\u1ee7a hai h\u00e0m c\u01a1 b\u1ea3n n\u00e0y nh\u00e9.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda 1\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec1 b\u00e0i: H\u00e3y \u00e1p d\u1ee5ng h\u00e0m IF AND \u0111\u1ec3 ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a d\u1eef li\u1ec7u trong b\u1ea3ng sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a c\u00f4ng c\u1ee5 Excel, ng\u01b0\u1eddi d\u00f9ng h\u00e3y nh\u1eadp c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 th\u1ec3 hi\u1ec7n \u0111\u1ec3 ki\u1ec3m tra gi\u00e1 tr\u1ecb. C\u1ee5 th\u1ec3, b\u1ea1n s\u1ebd nh\u1eadp \u201c=IF(AND(C4&gt;50,D4&gt;50),TRUE,FALSE)\u201d trong v\u00ed d\u1ee5 minh h\u1ecda n\u00e0y.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275889 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-5.jpg\" alt=\"ham-if-and-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n ti\u1ebfp t\u1ee5c nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 c\u00f4ng c\u1ee5 xu\u1ea5t ra k\u1ebft qu\u1ea3. Sau \u0111\u00f3, t\u1ea1i \u00f4 b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n \u0111\u00e3 th\u1ef1c. T\u1ea1i \u0111\u00e2y, n\u1ebfu mu\u1ed1n k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb tr\u00ean c\u00e1c \u00f4 c\u00f2n l\u1ea1i, b\u1ea1n ch\u1ec9 c\u1ea7n ti\u1ebfn h\u00e0nh d\u00f9ng con tr\u1ecf chu\u1ed9t k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275890 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-6.jpg\" alt=\"ham-if-and-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda 2<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec1 b\u00e0i: S\u1eed d\u1ee5ng h\u00e0m IF AND \u0111\u1ec3 x\u00e1c th\u1ef1c k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh theo b\u1ea3n s\u1ed1 li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ph\u1ea7n m\u1ec1m Excel, b\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00e1c th\u1ef1c: =IF(E4&gt;=5, \u201c\u0110\u1eadu\u201d, \u201cR\u1edbt\u201d).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275891 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-7.jpg\" alt=\"ham-if-and-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau khi \u0111\u00e3 nh\u1eadp c\u00f4ng th\u1ee9c, b\u1ea1n nh\u1ea5p v\u00e0o ph\u00edm Enter \u0111\u1ec3 ph\u1ea7n m\u1ec1m xu\u1ea5t k\u1ebft qu\u1ea3. T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u0169ng d\u00f9ng con tr\u1ecf chu\u1ed9t k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ec3 ti\u1ebft ki\u1ec7m qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n nh\u1eadp c\u00fa ph\u00e1p cho h\u00e0m IF v\u00e0 h\u00e0m h\u00e0m AND.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275892 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-8.jpg\" alt=\"ham-if-and-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda 3<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec1 b\u00e0i: \u00c1p d\u1ee5ng h\u00e0m IF AND \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh th\u00f4ng qua b\u1ea3ng s\u1ed1 li\u1ec7u c\u1ee5 th\u1ec3 nh\u01b0 sau.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Trong b\u1ea3ng t\u00ednh d\u1eef li\u1ec7u c\u1ee7a Excel, b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p sau v\u00e0o \u00f4 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ec3 h\u1ec7 th\u1ed1ng xu\u1ea5t k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm. C\u00fa ph\u00e1p: =IF(AND(C4&gt;=5,D4&gt;=5), \u201c\u0110\u1eadu\u201d, \u201cR\u1edbt\u201d).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275893 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-9.jpg\" alt=\"ham-if-and-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1ea5n v\u00e0o ph\u00edm Enter \u0111\u1ec3 h\u1ec7 th\u1ed1ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm. Th\u1eadm ch\u00ed, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c k\u00e9o con tr\u1ecf chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong b\u1ea3n t\u00ednh c\u1ee7a Excel.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-275894 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-10.jpg\" alt=\"ham-if-and-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">Nh\u1eefng l\u01b0u \u00fd khi \u00e1p d\u1ee5ng h\u00e0m IF AND trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng h\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND trong Excel, b\u1ea1n c\u0169ng c\u1ea7n n\u00ean l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u quan tr\u1ecdng sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e3y \u0111\u1ea3m b\u1ea3o b\u1ea1n tu\u00e2n theo c\u00fa ph\u00e1p ch\u00ednh x\u00e1c c\u1ee7a h\u00e0m AND. H\u00e0m AND y\u00eau c\u1ea7u b\u1ea1n li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n ki\u1ec3m tra, v\u00ed d\u1ee5: AND(\u0111i\u1ec1u_ki\u1ec7n1, \u0111i\u1ec1u_ki\u1ec7n2, &#8230;). \u0110i\u1ec1u n\u00e0y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i \u0111\u00fang \u0111\u1ec3 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd r\u1eb1ng, h\u00e0m AND lu\u00f4n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u1eeb tr\u00e1i qua ph\u1ea3i. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a r\u1eb1ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean trong AND s\u1ebd \u0111\u01b0\u1ee3c ki\u1ec3m tra tr\u01b0\u1edbc. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean sai, Excel s\u1ebd kh\u00f4ng ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau v\u00e0 ngay l\u1eadp t\u1ee9c tr\u1ea3 v\u1ec1 FALSE.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_275895\" aria-describedby=\"caption-attachment-275895\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-275895 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-11.jpg\" alt=\"ham-if-and-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-275895\" class=\"wp-caption-text\">Nh\u1eefng l\u01b0u \u00fd khi \u00e1p d\u1ee5ng h\u00e0m IF v\u00e0 h\u00e0m AND trong Excel<\/figcaption><\/figure>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF AND, h\u00e3y \u0111\u1ea3m b\u1ea3o kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p ho\u1eb7c kh\u00f4ng r\u00f5 r\u00e0ng. C\u00e1c \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m AND c\u00f3 th\u1ec3 b\u1ecb \u1ea3nh h\u01b0\u1edfng n\u1ebfu c\u00f3 s\u1ef1 tr\u00f9ng l\u1eb7p trong d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Thay v\u00ec ch\u1ec9 s\u1eed d\u1ee5ng \u00f4 c\u1ee5 th\u1ec3 (v\u00ed d\u1ee5: C4, D4), n\u00ean s\u1eed d\u1ee5ng t\u00ean mi\u1ec1n \u00f4 tham chi\u1ebfu. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c khi c\u1ea7n thi\u1ebft v\u00e0 n\u00f3 gi\u00fap l\u00e0m cho c\u00f4ng th\u1ee9c d\u1ec5 \u0111\u1ecdc h\u01a1n.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m IF AND trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m IF AND trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng h\u1eefu \u00edch trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn m\u00e0 b\u1ea1n s\u1ebd hay g\u1eb7p ph\u1ea3i:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng<\/b><span style=\"font-weight: 400;\">: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 h\u00e0m AND \u0111\u1ec3 ph\u00e2n lo\u1ea1i kh\u00e1ch h\u00e0ng d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, ch\u1eb3ng h\u1ea1n nh\u01b0 doanh s\u1ed1 mua h\u00e0ng, t\u1ea7n su\u1ea5t mua h\u00e0ng v\u00e0 th\u1eddi gian t\u1eeb l\u1ea7n mua cu\u1ed1i c\u00f9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Qu\u1ea3n l\u00fd kho h\u00e0ng<\/b><span style=\"font-weight: 400;\">: Trong m\u00f4i tr\u01b0\u1eddng qu\u1ea3n l\u00fd kho h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 h\u00e0m AND \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh xem m\u1ed9t s\u1ea3n ph\u1ea9m c\u00f3 s\u1eb5n \u0111\u1ec3 giao h\u00e0ng kh\u00f4ng. \u0110i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 bao g\u1ed3m s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u00f2n l\u1ea1i, t\u00ecnh tr\u1ea1ng ki\u1ec3m tra ch\u1ea5t l\u01b0\u1ee3ng v\u00e0 v\u1ecb tr\u00ed trong kho h\u00e0ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-if-and-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-275896 size-full aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-12.jpg\" alt=\"ham-if-and-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>T\u1ea1o b\u00e1o c\u00e1o t\u00f9y ch\u1ec9nh<\/b><span style=\"font-weight: 400;\">: Khi b\u1ea1n c\u1ea7n t\u1ea1o b\u00e1o c\u00e1o t\u00f9y ch\u1ec9nh d\u1ef1a tr\u00ean nhi\u1ec1u ti\u00eau ch\u00ed, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF v\u00e0 h\u00e0m AND \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o theo c\u00e1c ti\u00eau ch\u00ed ri\u00eang bi\u1ec7t, ch\u1eb3ng h\u1ea1n nh\u01b0 t\u1ea1o b\u00e1o c\u00e1o doanh s\u1ed1 cho m\u1ed9t danh m\u1ee5c s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3 trong m\u1ed9t th\u1eddi gian c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a t\u00e0i li\u1ec7u<\/b><span style=\"font-weight: 400;\">: Trong l\u0129nh v\u1ef1c qu\u1ea3n l\u00fd t\u00e0i li\u1ec7u v\u00e0 h\u1ed3 s\u01a1, h\u00e0m IF v\u00e0 h\u00e0m AND c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a t\u00e0i li\u1ec7u ho\u1eb7c h\u1ed3 s\u01a1 d\u1ef1a tr\u00ean nhi\u1ec1u y\u1ebfu t\u1ed1 nh\u01b0 ng\u00e0y t\u1ea1o, ch\u1eef k\u00fd s\u1ed1 v\u00e0 quy\u1ec1n truy c\u1eadp.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u<\/b><span style=\"font-weight: 400;\">: H\u00e0m IF AND c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3, ch\u1eb3ng h\u1ea1n nh\u01b0 vi\u1ec7c l\u1ecdc danh s\u00e1ch h\u1ecdc sinh th\u00e0nh danh s\u00e1ch h\u1ecdc sinh xu\u1ea5t s\u1eafc, danh s\u00e1ch h\u1ecdc sinh gi\u1ecfi,&#8230;d\u1ef1a tr\u00ean \u0111i\u1ec3m s\u1ed1 v\u00e0 tham gia c\u00e1c ho\u1ea1t \u0111\u1ed9ng ngo\u1ea1i kh\u00f3a.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">L\u1eddi k\u1ebft<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00f3 l\u00e0 c\u00e1ch \u00e1p d\u1ee5ng <\/span><b>h\u00e0m IF AND<\/b><span style=\"font-weight: 400;\"> h\u1eefu \u00edch trong c\u00f4ng c\u1ee5 Excel m\u00e0 <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> mu\u1ed1n qu\u00fd \u0111\u1ed9c gi\u1ea3 c\u1ee7a m\u00ecnh n\u1eafm b\u1eaft. Hy v\u1ecdng r\u1eb1ng nh\u1eefng th\u00f4ng tin v\u00e0 c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3 b\u00ean tr\u00ean b\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch tri\u1ec3n khai c\u00fa ph\u00e1p c\u1ee7a hai h\u00e0m c\u01a1 b\u1ea3n n\u00e0y trong Excel. T\u1eeb \u0111\u00f3 \u00e1p d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0o vi\u1ec7c h\u1ecdc t\u1eadp c\u0169ng nh\u01b0 l\u00e0m vi\u1ec7c \u0111\u1ec3 n\u00e2ng cao n\u0103ng su\u1ea5t. Ngo\u00e0i ra, n\u1ebfu c\u00f2n g\u1eb7p b\u1ea5t k\u1ef3 v\u01b0\u1edbng m\u1eafc n\u00e0o c\u1ea7n \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p trong n\u1ed9i dung b\u00e0i vi\u1ebft, h\u00e3y \u0111\u1ec3 l\u1ea1i ngay b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi \u0111\u1ec3 ch\u00fang t\u00f4i h\u1ed7 tr\u1ee3 c\u00e1c b\u1ea1n nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">XEM TH\u00caM<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-sumifs\/\"><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIFS ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-or\/\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR trong Excel m\u00e0 kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\"><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tinh-trung-binh-trong-excel\/\"><span style=\"font-weight: 400;\">H\u00e0m AVERAGE trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m trung b\u00ecnh c\u1ed9ng<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i kh\u00f4ng ch\u1ec9 trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n m\u00e0 c\u00f2n \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Trong \u0111\u00f3, h\u00e0m IF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quen thu\u1ed9c gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean [&hellip;]<\/p>\n","protected":false},"author":101,"featured_media":275884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-275882","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 v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>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<\/title>\n<meta name=\"description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.\" \/>\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-if-and\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"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\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\" \/>\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-10-25T12:01:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.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-if-and\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3\"},\"headline\":\"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\",\"datePublished\":\"2023-10-25T12:01:18+00:00\",\"dateModified\":\"2023-10-25T12:01:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\"},\"wordCount\":3182,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\",\"name\":\"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\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg\",\"datePublished\":\"2023-10-25T12:01:18+00:00\",\"dateModified\":\"2023-10-25T12:01:18+00:00\",\"description\":\"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-if-and\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#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\":\"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\"}]},{\"@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\/eba26093435c6ea84a54a079eec56af3\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?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":"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","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.","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-if-and\/","og_locale":"vi_VN","og_type":"article","og_title":"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","og_description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-25T12:01:18+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.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-if-and\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/eba26093435c6ea84a54a079eec56af3"},"headline":"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","datePublished":"2023-10-25T12:01:18+00:00","dateModified":"2023-10-25T12:01:18+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/"},"wordCount":3182,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/","name":"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","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg","datePublished":"2023-10-25T12:01:18+00:00","dateModified":"2023-10-25T12:01:18+00:00","description":"Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd g\u1ee3i \u00fd cho b\u1ea1n c\u00e1ch d\u00f9ng h\u00e0m IF AND c\u01a1 b\u1ea3n trong Excel th\u00f4ng qua m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 d\u01b0\u1edbi \u0111\u00e2y.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-if-and.jpg","width":1200,"height":628,"caption":"ham-if-and"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if-and\/#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":"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"}]},{"@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\/eba26093435c6ea84a54a079eec56af3","name":"Nguy\u1ec5n Xu\u00e2n Hi\u1ebfu","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2d280f97630fa8c32ae987d44b99e6?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\/275882","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=275882"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/275882\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/275884"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=275882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=275882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=275882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}