{"id":5004,"date":"2025-11-20T18:00:42","date_gmt":"2025-11-20T11:00:42","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-and-trong-excel-la-gi-cu-phap-va-cach-su-dung\/"},"modified":"2025-11-20T18:00:42","modified_gmt":"2025-11-20T11:00:42","slug":"ham-and-trong-excel-la-gi-cu-phap-va-cach-su-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-and-trong-excel-la-gi-cu-phap-va-cach-su-dung\/","title":{"rendered":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m AND trong Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 x\u00e2y d\u1ef1ng c\u00e1c ph\u00e9p ki\u1ec3m tra logic ph\u1ee9c h\u1ee3p, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u ti\u00eau ch\u00ed. Khi k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m IF ho\u1eb7c OR, AND gi\u00fap t\u1ea1o ra c\u00e1c \u0111i\u1ec1u ki\u1ec7n linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c h\u01a1n trong qu\u00e1 tr\u00ecnh ph\u00e2n lo\u1ea1i, so s\u00e1nh v\u00e0 ki\u1ec3m tra d\u1eef li\u1ec7u. \u0110\u1ec3 \u00e1p d\u1ee5ng hi\u1ec7u qu\u1ea3 trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn chi ti\u1ebft b\u00ean d\u01b0\u1edbi.<\/p>\n

\"H\u00e0mC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel \u0111\u01a1n gi\u1ea3n<\/em><\/p>\n

\n

1. H\u00e0m AND trong Excel l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m AND trong Excel thu\u1ed9c nh\u00f3m h\u00e0m logic, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac trong m\u1ed9t c\u00f4ng th\u1ee9c. H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 TRUE khi to\u00e0n b\u1ed9 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u th\u1ecfa m\u00e3n, ng\u01b0\u1ee3c l\u1ea1i ch\u1ec9 c\u1ea7n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00fang th\u00ec k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0 FALSE.<\/p>\n

Ngo\u00e0i vi\u1ec7c d\u00f9ng ri\u00eang l\u1ebb, h\u00e0m AND c\u00f2n \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m logic kh\u00e1c nh\u01b0 IF ho\u1eb7c OR \u0111\u1ec3 x\u00e2y d\u1ef1ng \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m tra linh ho\u1ea1t h\u01a1n.<\/p>\n

\"C\u00f4ngV\u00ed d\u1ee5 v\u1ec1 h\u00e0m AND trong Excel<\/em><\/p>\n

\n

2. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m AND trong Excel<\/h2>\n<\/div>\n

H\u00e0m AND trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng theo c\u00fa ph\u00e1p: =AND(logical1, logical2, …)<\/strong><\/p>\n

Gi\u1ea3i th\u00edch tham s\u1ed1:<\/strong><\/p>\n

    \n
  • logical1:<\/strong> M\u1ec7nh \u0111\u1ec1 logic b\u1eaft bu\u1ed9c<\/li>\n
  • logical2:<\/strong> M\u1ec7nh \u0111\u1ec1 logic kh\u00f4ng b\u1eaft bu\u1ed9c, \u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u0111\u1ec3 ti\u1ebfp t\u1ee5c ki\u1ec3m tra c\u00e1c m\u1ec7nh \u0111\u1ec1 logic kh\u00e1c.<\/li>\n<\/ul>\n

    K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1:<\/strong><\/p>\n

      \n
    • TRUE \u2192 Khi to\u00e0n b\u1ed9 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o \u0111\u1ec1u \u0111\u00fang<\/li>\n
    • FALSE \u2192 Khi xu\u1ea5t hi\u1ec7n b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o kh\u00f4ng \u0111\u00fang<\/li>\n<\/ul>\n
      Xem th\u00eam: <\/strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m QUOTIENT trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u<\/div>\n
      \n

      3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel<\/h2>\n<\/div>\n
      \n

      3.1 S\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ed9c l\u1eadp<\/h3>\n<\/div>\n

      V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng th\u00f4ng tin g\u1ed3m h\u1ecd t\u00ean h\u1ecdc sinh, gi\u1edbi t\u00ednh v\u00e0 \u0111i\u1ec3m thi m\u00f4n V\u0103n. Y\u00eau c\u1ea7u l\u00e0 x\u00e1c \u0111\u1ecbnh nh\u1eefng h\u1ecdc sinh v\u1eeba l\u00e0 Nam, v\u1eeba c\u00f3 \u0111i\u1ec3m V\u0103n \u2265 7. Ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra hai \u0111i\u1ec1u ki\u1ec7n n\u00e0y c\u00f9ng l\u00fac.<\/p>\n

      B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 k\u1ebft qu\u1ea3<\/strong><\/p>\n

      T\u1ea1i \u00f4 D2 (c\u1ed9t K\u1ebft qu\u1ea3), nh\u1eadp c\u00f4ng th\u1ee9c: =AND(B2=”Nam”, C2>=7)<\/strong><\/p>\n

      \"V\u00edNh\u1eadp c\u00f4ng th\u1ee9c AND ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n<\/em><\/p>\n

      B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3<\/strong><\/p>\n

      Sau khi nh\u1ea5n Enter<\/strong>, Excel s\u1ebd tr\u1ea3 v\u1ec1:<\/p>\n

        \n
      • TRUE n\u1ebfu h\u1ecdc sinh th\u1ecfa c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n<\/li>\n
      • FALSE n\u1ebfu c\u00f3 \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u1ea1t<\/li>\n<\/ul>\n

        \"H\u00e0mK\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 FALSE do kh\u00f4ng tho\u1ea3 m\u00e3n \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n<\/em><\/p>\n

        B\u01b0\u1edbc 3: Sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i<\/strong><\/p>\n

        Ti\u1ebfp t\u1ee5c ch\u1ecdn \u00f4 k\u1ebft qu\u1ea3 (D2), sau \u0111\u00f3 k\u00e9o \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i xu\u1ed1ng c\u00e1c d\u00f2ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 danh s\u00e1ch h\u1ecdc sinh.<\/p>\n

        \"DanhK\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i<\/em><\/p>\n

        \n

        3.2 S\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p h\u00e0m IF<\/h3>\n<\/div>\n

        Khi d\u00f9ng AND chung v\u1edbi IF, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t l\u1ea7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng t\u00f9y theo vi\u1ec7c c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng hay kh\u00f4ng.<\/p>\n

        C\u00fa ph\u00e1p: =IF(AND(\u0111i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 2, \u2026), “Gi\u00e1 tr\u1ecb n\u1ebfu \u0111\u00fang”, “Gi\u00e1 tr\u1ecb n\u1ebfu sai”)<\/strong><\/p>\n

        V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh g\u1ed3m nhi\u1ec1u m\u00f4n h\u1ecdc. N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c m\u00f4n \u0111\u1ec1u \u0111\u1ea1t \u0111i\u1ec3m t\u1eeb 5 tr\u1edf l\u00ean th\u00ec h\u1ecdc sinh \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i \u201c\u0110\u1ea0T\u201d. Ng\u01b0\u1ee3c l\u1ea1i, ch\u1ec9 c\u1ea7n m\u1ed9t m\u00f4n c\u00f3 \u0111i\u1ec3m d\u01b0\u1edbi 5 th\u00ec k\u1ebft qu\u1ea3 \u0111\u00e1nh gi\u00e1 s\u1ebd l\u00e0 \u201cKH\u00d4NG \u0110\u1ea0T\u201d.<\/p>\n

        B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 K\u1ebft qu\u1ea3<\/strong><\/p>\n

        T\u1ea1i \u00f4 F4, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c: =IF(AND(C4>=5, D4>=5, E4>=5), “\u0110\u1ea0T”, “KH\u00d4NG \u0110\u1ea0T”)<\/strong><\/p>\n

        Sau \u0111\u00f3 nh\u1ea5n Enter<\/strong> \u0111\u1ec3 nh\u1eadn gi\u00e1 tr\u1ecb mong mu\u1ed1n.<\/p>\n

        \"C\u00f4ngNh\u1eadp c\u00f4ng th\u1ee9c IF k\u1ebft h\u1ee3p AND v\u00e0o \u00f4 F4 \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec3m c\u1ee7a ba m\u00f4n h\u1ecdc<\/em><\/p>\n

        B\u01b0\u1edbc 2: Sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i<\/strong><\/p>\n

        Sau khi nh\u1eadp c\u00f4ng th\u1ee9c xong, b\u1ea1n k\u00e9o fill handle (\u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 F4) xu\u1ed1ng c\u00e1c d\u00f2ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 h\u1ecdc sinh.<\/p>\n

        \"K\u1ebftSao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/em><\/p>\n

        \n

        3.3 S\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p h\u00e0m OR<\/h3>\n<\/div>\n

        H\u00e0m AND v\u00e0 h\u00e0m OR khi k\u1ebft h\u1ee3p s\u1ebd gi\u00fap b\u1ea1n ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n, v\u1eeba y\u00eau c\u1ea7u \u0111\u1ed3ng th\u1eddi (AND), v\u1eeba cho ph\u00e9p linh ho\u1ea1t (OR).<\/p>\n

        C\u00f4ng th\u1ee9c: =IF(AND(\u0111i\u1ec1u ki\u1ec7n 1, OR(\u0111i\u1ec1u ki\u1ec7n 2, \u0111i\u1ec1u ki\u1ec7n 3)), “Gi\u00e1 tr\u1ecb n\u1ebfu \u0111\u00fang”, “Gi\u00e1 tr\u1ecb n\u1ebfu sai”)<\/strong><\/p>\n

        V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng \u0111i\u1ec3m c\u1ee7a h\u1ecdc sinh v\u1edbi ba m\u00f4n To\u00e1n – V\u0103n – Anh. H\u1ecdc sinh s\u1ebd \u0111\u01b0\u1ee3c xem l\u00e0 \u201c\u0110\u1ea0T\u201d n\u1ebfu c\u00f3 \u0111i\u1ec3m To\u00e1n t\u1eeb 8 tr\u1edf l\u00ean, v\u00e0 \u0111i\u1ec3m V\u0103n ho\u1eb7c \u0111i\u1ec3m Anh t\u1eeb 7 tr\u1edf l\u00ean. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu \u0111i\u1ec3m To\u00e1n kh\u00f4ng \u0111\u1ea1t m\u1ee9c 8 ho\u1eb7c c\u1ea3 hai m\u00f4n V\u0103n v\u00e0 Anh \u0111\u1ec1u d\u01b0\u1edbi 7, h\u1ecdc sinh s\u1ebd b\u1ecb x\u1ebfp lo\u1ea1i \u201cKH\u00d4NG \u0110\u1ea0T\u201d.<\/p>\n

        B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 k\u1ebft qu\u1ea3<\/strong><\/p>\n

        T\u1ea1i \u00f4 F4, nh\u1eadp c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p AND v\u00e0 OR: =IF(AND(C4>=8, OR(D4>=7, E4>=7)), “\u0110\u1ea0T”, “KH\u00d4NG \u0110\u1ea0T”)<\/strong>. Sau \u0111\u00f3 nh\u1ea5n Enter<\/strong> \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n

        \"V\u00edNh\u1eadp c\u00f4ng th\u1ee9c AND v\u00e0 OR v\u00e0o \u00f4 F4<\/em><\/p>\n

        B\u01b0\u1edbc 2: Sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 danh s\u00e1ch<\/strong><\/p>\n

        Sau khi c\u00f3 k\u1ebft qu\u1ea3 \u1edf \u00f4 F4, d\u00f9ng chu\u1ed9t k\u00e9o d\u1ea5u \u201c+\u201d \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 \u0111\u1ec3 copy c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 \u201c\u0110\u1ea0T\u201d ho\u1eb7c \u201cKH\u00d4NG \u0110\u1ea0T\u201d cho t\u1eebng h\u1ecdc sinh.<\/p>\n

        \"K\u1ebftK\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ec3 t\u00ednh to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3<\/em><\/p>\n

        \n

        4. M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m AND trong Excel<\/h2>\n<\/div>\n

        Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m AND ho\u1eb7c k\u1ebft h\u1ee3p AND trong h\u00e0m IF, b\u1ea1n n\u00ean ch\u00fa \u00fd c\u00e1c \u0111i\u1ec3m sau \u0111\u1ec3 h\u1ea1n ch\u1ebf l\u1ed7i:<\/p>\n

          \n
        • Lu\u00f4n b\u1eaft \u0111\u1ea7u c\u00f4ng th\u1ee9c b\u1eb1ng d\u1ea5u = tr\u01b0\u1edbc khi nh\u1eadp h\u00e0m.<\/li>\n
        • N\u1ebfu \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb logic (TRUE\/FALSE), h\u00e0m AND c\u00f3 th\u1ec3 b\u00e1o l\u1ed7i #VALUE!<\/li>\n
        • Khi d\u00f9ng h\u00e0m AND k\u1ebft h\u1ee3p h\u00e0m kh\u00e1c, c\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u00ean \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang.<\/li>\n
        • Gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 \u201c\u0111\u00fang\u201d v\u00e0 \u201csai\u201d trong h\u00e0m IF ph\u1ea3i \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/li>\n
        • H\u00e0m AND d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra t\u00ednh \u0111\u00fang\/sai c\u1ee7a bi\u1ec3u th\u1ee9c, kh\u00f4ng d\u00f9ng \u0111\u1ec3 tr\u1ef1c ti\u1ebfp th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh c\u1ed9ng tr\u1eeb nh\u00e2n chia (k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m AND lu\u00f4n l\u00e0 TRUE ho\u1eb7c FALSE, kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t con s\u1ed1)<\/li>\n
        • H\u00e0m AND kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng khi so s\u00e1nh v\u0103n b\u1ea3n (v\u00ed d\u1ee5: “A” v\u00e0 “a” \u0111\u01b0\u1ee3c xem l\u00e0 gi\u1ed1ng nhau).<\/li>\n<\/ul>\n

          \"L\u01b0uM\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m AND<\/em><\/p>\n

          \n

          5. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<\/div>\n
          \n

          5.1 H\u00e0m AND c\u00f3 d\u00f9ng \u0111\u01b0\u1ee3c cho v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng kh\u00f4ng?<\/h3>\n<\/div>\n

          H\u00e0m AND v\u1eabn c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho d\u1eef li\u1ec7u d\u1ea1ng v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng, nh\u01b0ng theo h\u00ecnh th\u1ee9c so s\u00e1nh logic. Ngh\u0129a l\u00e0 b\u1ea1n ph\u1ea3i \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 Excel tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE, ch\u1eb3ng h\u1ea1n nh\u01b0:<\/p>\n

            \n
          • B2=”Nam”<\/li>\n
          • C2 > DATE(2024,1,1)<\/li>\n<\/ul>\n

            H\u00e0m AND s\u1ebd d\u1ef1a v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c bi\u1ec3u th\u1ee9c n\u00e0y \u0111\u1ec3 \u0111\u01b0a ra TRUE ho\u1eb7c FALSE, thay v\u00ec x\u1eed l\u00fd v\u0103n b\u1ea3n hay ng\u00e0y th\u00e1ng tr\u1ef1c ti\u1ebfp.<\/p>\n

            \n

            5.2 H\u00e0m AND ki\u1ec3m tra \u0111\u01b0\u1ee3c t\u1ed1i \u0111a bao nhi\u00eau \u0111i\u1ec1u ki\u1ec7n?<\/h3>\n<\/div>\n

            H\u00e0m AND trong Excel h\u1ed7 tr\u1ee3 ki\u1ec3m tra t\u1ed1i \u0111a 255 \u0111i\u1ec1u ki\u1ec7n. N\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 TRUE, ng\u01b0\u1ee3c l\u1ea1i ch\u1ec9 c\u1ea7n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n sai, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 FALSE.<\/p>\n

            N\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t t\u1ed1t h\u01a1n c\u00e1c ph\u00e9p ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n trong Excel, \u0111\u1ed3ng th\u1eddi t\u1ea1o n\u1ec1n t\u1ea3ng \u0111\u1ec3 k\u1ebft h\u1ee3p linh ho\u1ea1t v\u1edbi c\u00e1c h\u00e0m IF v\u00e0 OR trong nh\u1eefng b\u1ea3ng t\u00ednh ph\u1ee9c t\u1ea1p. Khi \u00e1p d\u1ee5ng \u0111\u00fang c\u00e1ch, c\u00f4ng vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u1edf n\u00ean ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

            \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o Excel h\u1eefu \u00edch.<\/p>\n

            N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c tr\u00ean Excel b\u1eb1ng \u0111i\u1ec7n tho\u1ea1i hay m\u00e1y t\u00ednh b\u1ea3ng v\u00e0 mu\u1ed1n t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m s\u1eed d\u1ee5ng, \u0111\u1eebng qu\u00ean tham kh\u1ea3o c\u00e1c d\u00f2ng thi\u1ebft b\u1ecb m\u1edbi t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u00f3 hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c m\u01b0\u1ee3t m\u00e0 v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

            \u00a0 H\u00e0m AND trong Excel l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 x\u00e2y d\u1ef1ng c\u00e1c ph\u00e9p ki\u1ec3m tra logic ph\u1ee9c h\u1ee3p, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u ti\u00eau ch\u00ed. Khi k\u1ebft h\u1ee3p c\u00f9ng c\u00e1c h\u00e0m IF ho\u1eb7c OR, AND gi\u00fap t\u1ea1o ra c\u00e1c \u0111i\u1ec1u ki\u1ec7n linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c h\u01a1n trong […]<\/p>\n","protected":false},"author":1,"featured_media":5005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5004","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19401.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5004","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5004"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5004\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5005"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}