{"id":4991,"date":"2025-11-20T17:58:30","date_gmt":"2025-11-20T10:58:30","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-not-trong-excel-chi-tiet-de-hieu\/"},"modified":"2025-11-20T17:58:30","modified_gmt":"2025-11-20T10:58:30","slug":"cach-su-dung-ham-not-trong-excel-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-not-trong-excel-chi-tiet-de-hieu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOT trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n

H\u00e0m NOT l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic c\u01a1 b\u1ea3n trong Excel, gi\u00fap \u0111\u1ea3o ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t bi\u1ec3u th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n ch\u00ednh x\u00e1c h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOT \u0111\u1ed9c l\u1eadp ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi IF, AND, OR, k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p.<\/p>\n

\"C\u00e1chC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOT trong Excel<\/em><\/p>\n

\n

1. H\u00e0m NOT trong Excel l\u00e0 g\u00ec? \u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m NOT<\/h2>\n<\/div>\n

H\u00e0m NOT l\u00e0 h\u00e0m logic c\u01a1 b\u1ea3n trong Excel, c\u00f3 nhi\u1ec7m v\u1ee5 \u0111\u1ea3o ng\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t bi\u1ec3u th\u1ee9c ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n \u0111ang \u0111\u01b0\u1ee3c ki\u1ec3m tra.<\/p>\n

\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m NOT:<\/strong><\/p>\n

    \n
  • Tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ed1i l\u1eadp v\u1edbi \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c gi\u00e1 tr\u1ecb b\u1ea1n \u0111ang d\u00f9ng.<\/li>\n
  • Gi\u00fap thao t\u00e1c tr\u00ean Excel tr\u1edf n\u00ean linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c h\u01a1n.<\/li>\n
  • D\u1ec5 d\u00e0ng k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n
    \n

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

    C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m NOT: =NOT(value)<\/p>\n

    Trong \u0111\u00f3:<\/strong><\/p>\n

      \n
    • value:<\/strong> Gi\u00e1 tr\u1ecb ho\u1eb7c bi\u1ec3u th\u1ee9c c\u1ea7n ki\u1ec3m tra.<\/li>\n<\/ul>\n

      L\u01b0u \u00fd khi s\u1eed d\u1ee5ng:<\/strong><\/p>\n

        \n
      • H\u00e0m NOT th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n c\u00f9ng h\u00e0m IF \u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea3o ng\u01b0\u1ee3c.<\/li>\n
      • N\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ki\u1ec3m tra l\u00e0 FALSE<\/strong>, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 TRUE<\/strong>; ng\u01b0\u1ee3c l\u1ea1i, khi gi\u00e1 tr\u1ecb l\u00e0 TRUE<\/strong>, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 FALSE<\/strong>.<\/li>\n
      • Khi nh\u1eadp m\u1ed9t s\u1ed1, ch\u1eb3ng h\u1ea1n NOT(10), Excel coi s\u1ed1 \u0111\u00f3 l\u00e0 gi\u00e1 tr\u1ecb TRUE<\/strong>, v\u00ec v\u1eady k\u1ebft qu\u1ea3 h\u00e0m tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 FALSE<\/strong>.<\/li>\n<\/ul>\n

        \"C\u00faC\u00fa ph\u00e1p h\u00e0m NOT trong Excel<\/em><\/p>\n

        Xem th\u00eam: <\/strong>C\u00e1ch s\u1eeda l\u1ed7i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/div>\n
        \n

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

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

        V\u00ed d\u1ee5:<\/strong> S\u1eed d\u1ee5ng h\u00e0m NOT \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb \u0111\u1ea3o ng\u01b0\u1ee3c.<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong Excel, nh\u1eadp c\u00f4ng th\u1ee9c =NOT(TRUE) \u0111\u1ec3 th\u1eed ki\u1ec3m tra k\u1ebft qu\u1ea3 h\u00e0m.<\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch l\u00e0m t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c trong b\u1ea3ng, v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ed1i l\u1eadp nh\u01b0 minh h\u1ecda.<\/p>\n

        \"B\u1ea3ngV\u00ed d\u1ee5 d\u00f9ng h\u00e0m NOT \u0111\u1ea3o gi\u00e1 tr\u1ecb logic<\/em><\/p>\n

        \n

        3.2. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF<\/h3>\n<\/div>\n

        H\u00e0m IF c\u00f3 th\u1ec3 ph\u1ed1i h\u1ee3p c\u00f9ng NOT \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m tra trong c\u00f4ng th\u1ee9c. Khi \u0111\u00f3, NOT \u0111\u00f3ng vai tr\u00f2 l\u00e0 bi\u1ec3u th\u1ee9c logic m\u00e0 IF s\u1ebd \u0111\u00e1nh gi\u00e1.<\/p>\n

        C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF:<\/strong><\/p>\n

        =IF(Logical_test, Value_if_true, Value_if_false)<\/p>\n

        Trong \u0111\u00f3:<\/strong><\/p>\n

          \n
        • Logical_test:<\/strong> \u0110i\u1ec1u ki\u1ec7n c\u1ea7n ki\u1ec3m tra.<\/li>\n
        • Value_if_true:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n
        • Value_if_false:<\/strong> K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n

          L\u01b0u \u00fd: <\/strong>N\u1ebfu b\u1ea1n b\u1ecf tr\u1ed1ng c\u1ea3 Value_if_true<\/em> v\u00e0 Value_if_false<\/em>, khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang Excel s\u1ebd tr\u1ea3 v\u1ec1 0<\/strong>, v\u00e0 khi \u0111i\u1ec1u ki\u1ec7n sai s\u1ebd tr\u1ea3 v\u1ec1 FALSE<\/strong>.<\/p>\n

          V\u00ed d\u1ee5:<\/strong>Ph\u00e2n lo\u1ea1i k\u1ebft qu\u1ea3 l\u00e0m vi\u1ec7c c\u1ee7a nh\u00e2n vi\u00ean<\/strong><\/p>\n

          Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng th\u1ed1ng k\u00ea nh\u01b0 h\u00ecnh minh h\u1ecda. Y\u00eau c\u1ea7u l\u00e0 x\u00e1c \u0111\u1ecbnh nh\u00e2n vi\u00ean \u0111\u1ea1t hay kh\u00f4ng \u0111\u1ea1t d\u1ef1a tr\u00ean s\u1ed1 l\u01b0\u1ee3ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/p>\n

          \"K\u1ebftK\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 NOT trong Excel<\/em><\/p>\n

          Ph\u00e2n t\u00edch y\u00eau c\u1ea7u:<\/strong><\/p>\n

            \n
          • N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng th\u1ef1c t\u1ebf (c\u1ed9t C) l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/strong> k\u1ebf ho\u1ea1ch \u0111\u1eb7t ra (c\u1ed9t B) \u2192 ghi \u201c\u0110\u1ea1t<\/strong>\u201d.<\/li>\n
          • Ng\u01b0\u1ee3c l\u1ea1i \u2192 ghi \u201cKh\u00f4ng \u0111\u1ea1t<\/strong>\u201d.<\/li>\n
          • \u0110\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p so s\u00e1nh n\u00e0y, c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m NOT \u0111\u1ec3 \u0111\u1ea3o \u0111i\u1ec1u ki\u1ec7n nh\u1ecf h\u01a1n.<\/li>\n<\/ul>\n

            C\u00e1ch th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n

              \n
            • T\u1ea1i \u00f4 D2, nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 h\u00ecnh minh h\u1ecda.<\/li>\n
            • Nh\u1ea5n Enter <\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean.<\/li>\n
            • \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i, ch\u1ecdn \u00f4 D2, k\u00e9o n\u00fat vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 xu\u1ed1ng h\u1ebft b\u1ea3ng.<\/li>\n<\/ul>\n

              \"C\u00e1chC\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c IF k\u1ebft h\u1ee3p NOT<\/em><\/p>\n

              Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0 cho ra k\u1ebft qu\u1ea3 ph\u00e2n lo\u1ea1i t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

              \n

              3.3. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m AND<\/h3>\n<\/div>\n

              V\u00ed d\u1ee5: <\/strong>Ki\u1ec3m tra xem m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 n\u1eb1m ngo\u00e0i ph\u1ea1m vi cho tr\u01b0\u1edbc hay kh\u00f4ng.<\/p>\n

              B\u01b0\u1edbc 1: <\/strong>T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong Excel, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

              =IF(AND(NOT(B4>1), NOT(B4=10)), B4, “Gi\u00e1 tr\u1ecb kh\u00f4ng thu\u1ed9c ph\u1ea1m vi”)<\/p>\n

              Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

                \n
              • IF, AND, NOT:<\/strong> \u0110\u00e2y \u0111\u1ec1u l\u00e0 c\u00e1c h\u00e0m logic d\u00f9ng \u0111\u1ec3 x\u00e2y d\u1ef1ng \u0111i\u1ec1u ki\u1ec7n.<\/li>\n
              • NOT(B4>1) v\u00e0 NOT(B4=10):<\/strong> Hai bi\u1ec3u th\u1ee9c \u0111\u1ea3o ng\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n, nh\u1eb1m ki\u1ec3m tra gi\u00e1 tr\u1ecb trong \u00f4 B4 theo hai h\u01b0\u1edbng kh\u00e1c nhau.<\/li>\n
              • “Gi\u00e1 tr\u1ecb kh\u00f4ng thu\u1ed9c ph\u1ea1m vi”:<\/strong> Chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u00e1p \u1ee9ng.<\/li>\n<\/ul>\n

                \"V\u00edD\u00f9ng h\u00e0m AND v\u00e0 NOT ki\u1ec3m tra ph\u1ea1m vi<\/em><\/p>\n

                B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter \u0111\u1ec3 xem k\u1ebft qu\u1ea3. Sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

                \"K\u1ebftK\u1ebft qu\u1ea3 h\u00e0m AND k\u1ebft h\u1ee3p NOT<\/em><\/p>\n

                \n

                3.4. K\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR<\/h3>\n<\/div>\n

                V\u00ed d\u1ee5:<\/strong> \u0110\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3 c\u1ee7a h\u1ecdc sinh d\u1ef1a tr\u00ean \u0111i\u1ec3m To\u00e1n v\u00e0 V\u0103n. N\u1ebfu m\u1ed9t trong hai m\u00f4n c\u00f3 \u0111i\u1ec3m d\u01b0\u1edbi 5, h\u1ecdc sinh s\u1ebd b\u1ecb x\u1ebfp lo\u1ea1i tr\u01b0\u1ee3t.<\/p>\n

                B\u01b0\u1edbc 1: <\/strong>T\u1ea1i m\u1ed9t \u00f4 b\u1ea5t k\u1ef3, nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n

                =IF(OR(NOT(B4>5), NOT(C4>5)), “Tr\u01b0\u1ee3t”, “\u0110\u1eadu”)<\/p>\n

                Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/strong><\/p>\n

                  \n
                • IF, OR, NOT<\/strong> l\u00e0 c\u00e1c h\u00e0m logic \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n.<\/li>\n
                • NOT(B4>5) v\u00e0 NOT(C4>5):<\/strong> \u0111\u1ea3o ng\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n >5, d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh khi \u0111i\u1ec3m nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 5.<\/li>\n
                • “Tr\u01b0\u1ee3t”, “\u0110\u1eadu”:<\/strong> l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u00f9y theo \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang hay sai.<\/li>\n<\/ul>\n

                  \"D\u00f9ngD\u00f9ng h\u00e0m OR v\u00e0 NOT x\u00e9t \u0111i\u1ec3m h\u1ecdc sinh<\/em><\/p>\n

                  B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t ph\u00e9p t\u00ednh. Ti\u1ebfp theo, k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n k\u1ebft qu\u1ea3 cho c\u00e1c h\u00e0ng ti\u1ebfp theo.<\/p>\n

                  \"K\u1ebftK\u1ebft qu\u1ea3 h\u00e0m OR k\u1ebft h\u1ee3p NOT<\/em><\/p>\n

                  \n

                  4. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m NOT<\/h2>\n<\/div>\n
                  \n

                  4.1. L\u1ed7i #VALUE<\/h3>\n<\/div>\n

                  L\u1ed7i n\u00e0y th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi h\u00e0m NOT nh\u1eadn v\u00e0o m\u1ed9t gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i bi\u1ec3u th\u1ee9c logic.<\/p>\n

                  V\u00ed d\u1ee5:<\/strong> c\u00f4ng th\u1ee9c =NOT(1+1=2) ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng v\u00ec Excel hi\u1ec3u \u0111\u00e2y l\u00e0 ph\u00e9p so s\u00e1nh v\u00e0 c\u00f3 th\u1ec3 \u0111\u1ea3o k\u1ebft qu\u1ea3.<\/p>\n

                  Nh\u01b0ng n\u1ebfu b\u1ea1n nh\u1eadp 1+1=2<\/strong> v\u00e0o m\u1ed9t \u00f4 (v\u00ed d\u1ee5 \u00f4 A2) d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n r\u1ed3i d\u00f9ng =NOT(A2), Excel s\u1ebd coi A2 l\u00e0 chu\u1ed7i k\u00fd t\u1ef1, kh\u00f4ng ph\u1ea3i bi\u1ec3u th\u1ee9c logic, d\u1eabn \u0111\u1ebfn l\u1ed7i #VALUE!<\/strong>.<\/p>\n

                  C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> Thay v\u00ec tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a chu\u1ed7i v\u0103n b\u1ea3n, h\u00e3y vi\u1ebft tr\u1ef1c ti\u1ebfp bi\u1ec3u th\u1ee9c logic trong c\u00f4ng th\u1ee9c, ch\u1eb3ng h\u1ea1n =NOT(1+1=2), \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang nh\u01b0 mong mu\u1ed1n.<\/p>\n

                  \"L\u1ed7iL\u1ed7i #VALUE khi d\u00f9ng h\u00e0m NOT<\/em><\/p>\n

                  \n

                  4.2. L\u1ed7i #NAME?<\/h3>\n<\/div>\n

                  Nguy\u00ean nh\u00e2n:<\/strong> L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n khi \u0111\u1ed1i s\u1ed1 truy\u1ec1n v\u00e0o h\u00e0m NOT kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c logic h\u1ee3p l\u1ec7. Ch\u1eb3ng h\u1ea1n, n\u1ebfu b\u1ea1n nh\u1eadp =NOT(a), Excel s\u1ebd kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c k\u00fd t\u1ef1 a nh\u01b0 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 l\u1eadp t\u1ee9c b\u00e1o l\u1ed7i #NAME?<\/strong>.<\/p>\n

                  C\u00e1ch kh\u1eafc ph\u1ee5c:<\/strong> \u0110\u1ea3m b\u1ea3o r\u1eb1ng tham s\u1ed1 c\u1ee7a h\u00e0m l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c logic ho\u00e0n ch\u1ec9nh, v\u00ed d\u1ee5 =NOT(5>3), \u0111\u1ec3 Excel c\u00f3 th\u1ec3 x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u00fang.<\/p>\n

                  \"L\u1ed7iL\u1ed7i #NAME? trong h\u00e0m NOT Excel<\/em><\/p>\n

                  H\u00e0m NOT gi\u00fap b\u1ea1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n linh ho\u1ea1t h\u01a1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u ch\u00ednh x\u00e1c trong Excel. Khi hi\u1ec3u c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi IF, AND, OR, b\u1ea1n s\u1ebd t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n. 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 v\u1edbi Excel v\u00e0 c\u1ea7n m\u1ed9t thi\u1ebft b\u1ecb linh ho\u1ea1t \u0111\u1ec3 h\u1ecdc t\u1eadp, x\u1eed l\u00fd b\u1ea3ng t\u00ednh m\u1ecdi l\u00fac m\u1ecdi n\u01a1i, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Nhi\u1ec1u l\u1ef1a ch\u1ecdn c\u1ea5u h\u00ecnh m\u1ea1nh, m\u00e0n h\u00ecnh l\u1edbn, gi\u00e1 t\u1ed1t \u0111ang ch\u1edd b\u1ea1n kh\u00e1m ph\u00e1.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                  H\u00e0m NOT l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m logic c\u01a1 b\u1ea3n trong Excel, gi\u00fap \u0111\u1ea3o ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t bi\u1ec3u th\u1ee9c \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n ch\u00ednh x\u00e1c h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m NOT \u0111\u1ed9c l\u1eadp ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi IF, AND, OR, k\u00e8m v\u00ed d\u1ee5 […]<\/p>\n","protected":false},"author":1,"featured_media":4992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4991","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\/19402.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4991","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=4991"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4991\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4992"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}