{"id":19319,"date":"2023-12-05T13:21:14","date_gmt":"2023-12-05T13:21:14","guid":{"rendered":"https:\/\/masterskills.org\/blog\/ham-if-trong-excel-la-gi-huong-dan-thao-tac-ham-if-cuc-de.html"},"modified":"2023-12-22T04:49:22","modified_gmt":"2023-12-21T21:49:22","slug":"ham-if-trong-excel-la-gi-huong-dan-thao-tac-ham-if-cuc-de","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/ham-if-trong-excel-la-gi-huong-dan-thao-tac-ham-if-cuc-de.html","title":{"rendered":"H\u00e0m If Trong Excel L\u00e0 G\u00ec? H\u01b0\u1edbng D\u1eabn Thao T\u00e1c H\u00e0m If C\u1ef1c D\u1ec5"},"content":{"rendered":"
\n

Hi\u1ec7n nay, trong c\u00f4ng vi\u1ec7c hi\u1ec7n \u0111\u1ea1i, vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng. V\u00e0 trong h\u1ec7 th\u1ed1ng c\u00e1c c\u00f4ng c\u1ee5 v\u0103n ph\u00f2ng, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n. Trong \u0111\u00f3, h\u00e0m IF (If function) l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 quan tr\u1ecdng v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t trong Excel. H\u00e3y c\u00f9ng <\/span>Masterskills<\/span> t\u00ecm hi\u1ec3u v\u1ec1 h\u00e0m IF trong Excel qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n

H\u00e0m IF trong Excel c\u00f3 ch\u1ee9c n\u0103ng g\u00ec?<\/strong><\/h2>\n

H\u00e0m IF trong Excel c\u00f3 ch\u1ee9c n\u0103ng ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n logic v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3.<\/span><\/p>\n

H\u00e0m IF trong Excel cung c\u1ea5p cho b\u1ea1n kh\u1ea3 n\u0103ng t\u00f9y ch\u1ec9nh v\u00e0 linh ho\u1ea1t trong vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh d\u1ef1a tr\u00ean m\u1ed9t s\u1ed1 ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c IF, b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch th\u00f4ng minh v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c quy tr\u00ecnh t\u00ednh to\u00e1n trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n.<\/span><\/p>\n

C\u00f4ng th\u1ee9c t\u00ednh h\u00e0m IF trong Excel<\/strong><\/h3>\n

C\u00f4ng th\u1ee9c t\u00ednh h\u00e0m IF trong Excel c\u00f3 c\u1ea5u tr\u00fac nh\u01b0 sau:<\/span><\/p>\n

=IF(\u0111i\u1ec1u_ki\u1ec7n, gi\u00e1_tr\u1ecb_khi_\u0111\u00fang, gi\u00e1_tr\u1ecb_khi_sai)<\/span><\/p>\n

    \n<\/ul>\n

    V\u00ed d\u1ee5<\/strong>, h\u00e3y xem x\u00e9t m\u1ed9t t\u00ecnh hu\u1ed1ng \u0111\u01a1n gi\u1ea3n: b\u1ea1n mu\u1ed1n ki\u1ec3m tra n\u1ebfu m\u1ed9t s\u1ed1 trong \u00f4 A1 l\u1edbn h\u01a1n 10, n\u1ebfu \u0111\u00fang, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb “\u0110\u1ea1t” v\u00e0 n\u1ebfu sai, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb “Kh\u00f4ng \u0111\u1ea1t”. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng \u0111\u01b0\u1ee3c v\u00ed d\u1ee5 nh\u01b0 sau:<\/span><\/p>\n

    =IF(A1>10, “\u0110\u1ea1t”, “Kh\u00f4ng \u0111\u1ea1t”)<\/span><\/p>\n

    K\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 “\u0110\u1ea1t” n\u1ebfu s\u1ed1 trong \u00f4 A1 l\u1edbn h\u01a1n 10 v\u00e0 tr\u1ea3 v\u1ec1 “Kh\u00f4ng \u0111\u1ea1t” n\u1ebfu s\u1ed1 \u0111\u00f3 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 10.<\/span><\/p>\n

    >>> :\u00a0<\/strong><\/p>\n

    H\u1ecdc logistic ra l\u00e0m g\u00ec? L\u01b0\u01a1ng v\u00e0 c\u01a1 h\u1ed9i vi\u1ec7c l\u00e0m ra sao<\/p>\n

    M\u1ed9t s\u1ed1 c\u00e1ch t\u00ednh h\u00e0m \u0111i\u1ec1u ki\u1ec7n ph\u1ed5 bi\u1ebfn trong Excel v\u00e0 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3<\/strong><\/h2>\n

    H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ed3ng nhi\u1ec1u h\u00e0m IF trong Excel<\/strong><\/h3>\n

    B\u1eb1ng c\u00e1ch l\u1ed3ng nhi\u1ec1u h\u00e0m IF, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. V\u00ed d\u1ee5:<\/span><\/p>\n

    =IF(A1>10, “A”, IF(B1=”X”, “B”, IF(C1=TRUE, “C”, “D”)))<\/span><\/p>\n

    Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n 10, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “A”. N\u1ebfu kh\u00f4ng, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 B1 l\u00e0 “X”, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “B”. N\u1ebfu kh\u00f4ng, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 C1 l\u00e0 TRUE, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “C”. Cu\u1ed1i c\u00f9ng, n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u00ean, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “D”.<\/span><\/p>\n

    \n

    M\u1ed9t v\u00e0i c\u00e1ch l\u1ed3ng nhi\u1ec1u h\u00e0m IF l\u1ea1i v\u1edbi nhau trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

    H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h3>\n
      \n<\/ul>\n

      H\u00e0m AND trong Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang. V\u00ed d\u1ee5:<\/span><\/p>\n

      =IF(AND(A1>10, B1=”X”, C1<>0), “\u0110\u1ea1t”, “Kh\u00f4ng \u0111\u1ea1t”)<\/span><\/p>\n

      Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 “\u0110\u1ea1t” n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n 10, gi\u00e1 tr\u1ecb trong \u00f4 B1 l\u00e0 “X”, v\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 C1 kh\u00e1c 0. N\u1ebfu m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u00ean kh\u00f4ng \u0111\u00fang, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “Kh\u00f4ng \u0111\u1ea1t”.<\/span><\/p>\n

      <\/span><\/p>\n

      S\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

        \n<\/ul>\n

        H\u00e0m OR trong Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00fang. V\u00ed d\u1ee5:<\/span><\/p>\n

        =IF(OR(A1>10, B1=”X”, C1<>0), “\u0110\u1ea1t”, “Kh\u00f4ng \u0111\u1ea1t”)<\/span><\/p>\n

        Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 “\u0110\u1ea1t” n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n 10, ho\u1eb7c gi\u00e1 tr\u1ecb trong \u00f4 B1 l\u00e0 “X”, ho\u1eb7c gi\u00e1 tr\u1ecb trong \u00f4 C1 kh\u00e1c 0. N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n tr\u00ean \u0111\u1ec1u sai, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “Kh\u00f4ng \u0111\u1ea1t”.<\/span><\/p>\n

        \n

        S\u1eed d\u1ee5ng h\u00e0m OR k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF trong Excel (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

        >>> :\u00a0<\/strong><\/p>\n

        H\u1ecdc ng\u00f4n ng\u1eef Anh ra l\u00e0m g\u00ec? M\u1ee9c l\u01b0\u01a1ng v\u00e0 c\u01a1 h\u1ed9i vi\u1ec7c l\u00e0m h\u1ea5p d\u1eabn<\/span><\/p>\n

        H\u1ecdc kinh t\u1ebf ra l\u00e0m g\u00ec? C\u01a1 h\u1ed9i ph\u00e1t tri\u1ec3n v\u00e0 m\u1ee9c l\u01b0\u01a1ng ng\u00e0nh kinh t\u1ebf<\/span><\/p>\n

        H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh h\u00e0m IF v\u1edbi h\u00e0m t\u00ednh kh\u00e1c<\/strong><\/h3>\n

        B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n kh\u00e1c \u0111\u1ec3 t\u1ea1o ra c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p. V\u00ed d\u1ee5:<\/span><\/p>\n

        =IF(A1>10, SUM(B1:C1), AVERAGE(D1:E1))<\/span><\/p>\n

        Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n 10, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 t\u1ed5ng c\u1ee7a c\u00e1c \u00f4 B1 v\u00e0 C1. N\u1ebfu kh\u00f4ng, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c \u00f4 D1 v\u00e0 E1.<\/span><\/p>\n

        \n

        <\/em><\/p>\n

        H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m IF cho ng\u00e0y, th\u00e1ng<\/strong><\/h3>\n

        Khi s\u1eed d\u1ee5ng h\u00e0m \u0111i\u1ec1u ki\u1ec7n cho ng\u00e0y v\u00e0 th\u00e1ng trong Excel, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh d\u1ef1a tr\u00ean ng\u00e0y v\u00e0 th\u00e1ng. V\u00ed d\u1ee5:<\/span><\/p>\n

        =IF(MONTH(A1)=1, “Th\u00e1ng \u0111\u1ea7u”, IF(MONTH(A1)=2, “Th\u00e1ng hai”, “Th\u00e1ng kh\u00e1c”))<\/span><\/p>\n

        Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu ng\u00e0y trong \u00f4 A1 thu\u1ed9c th\u00e1ng 1, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 “Th\u00e1ng \u0111\u1ea7u”, n\u1ebfu thu\u1ed9c th\u00e1ng 2 th\u00ec tr\u1ea3 v\u1ec1 “Th\u00e1ng hai”, c\u00f2n kh\u00f4ng th\u00ec tr\u1ea3 v\u1ec1 “Th\u00e1ng kh\u00e1c”.<\/span><\/p>\n

        Nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel \u0111\u1ec3 tr\u00e1nh sai s\u00f3t<\/strong><\/h2>\n
          \n<\/ul>\n

          \n

          B\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t v\u00e0i \u0111i\u1ec1u tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n h\u00e0m IF (Ngu\u1ed3n: Internet)<\/span><\/em><\/p>\n

          >>> :\u00a0<\/strong><\/p>\n

          H\u1ecdc lu\u1eadt ra l\u00e0m g\u00ec? N\u00ean h\u1ecdc ng\u00e0nh lu\u1eadt kh\u00f4ng? M\u1ee9c l\u01b0\u01a1ng ra sao?<\/span><\/p>\n

          H\u1ecdc c\u00f4ng ngh\u1ec7 sinh h\u1ecdc ra l\u00e0m g\u00ec? C\u01a1 h\u1ed9i, m\u1ee9c l\u01b0\u01a1ng hi\u1ec7n nay<\/span><\/p>\n

          M\u1ed9t s\u1ed1 l\u1ed7i sai th\u00f4ng th\u01b0\u1eddng trong h\u00e0m \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1ch s\u1eeda c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/strong><\/h2>\n

          K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb b\u1eb1ng 0<\/strong><\/h3>\n

          M\u1ed9t l\u1ed7i th\u00f4ng th\u01b0\u1eddng khi s\u1eed d\u1ee5ng h\u00e0m IF trong Excel l\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1eb1ng 0, th\u1eadm ch\u00ed khi \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u00fang. L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n kh\u00f4ng \u0111\u1eb7t gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang. \u0110\u1ec3 s\u1eeda l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 x\u00e1c \u0111\u1ecbnh r\u00f5 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 khi \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/span><\/p>\n

          K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb #NAME?<\/strong><\/h3>\n

          M\u1ed9t l\u1ed7i kh\u00e1c c\u00f3 th\u1ec3 x\u1ea3y ra khi \u00f4 ch\u1ee9a h\u00e0m \u0111i\u1ec1u ki\u1ec7n hi\u1ec3n th\u1ecb “#NAME?”. L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi Excel kh\u00f4ng nh\u1eadn ra t\u00ean h\u00e0m IF. C\u00e1ch s\u1eeda l\u1ed7i n\u00e0y \u0111\u01a1n gi\u1ea3n l\u00e0 ki\u1ec3m tra l\u1ea1i c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 nh\u1eadp \u0111\u00fang t\u00ean h\u00e0m, \u0111\u00fang d\u1ea5u ngo\u1eb7c \u0111\u01a1n v\u00e0 d\u1ea5u ph\u1ea9y. \u0110\u1ed3ng th\u1eddi, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111ang s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Excel h\u1ed7 tr\u1ee3 h\u00e0m IF. N\u1ebfu l\u1ed7i v\u1eabn ti\u1ebfp t\u1ee5c x\u1ea3y ra, h\u00e3y ki\u1ec3m tra xem c\u00f2n b\u1ea5t k\u1ef3 l\u1ed7i ch\u00ednh t\u1ea3 ho\u1eb7c l\u1ed7i c\u00fa ph\u00e1p n\u00e0o kh\u00e1c trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n hay kh\u00f4ng.<\/span><\/p>\n

          \u0110\u1ed1i v\u1edbi c\u00e1c l\u1ed7i sai kh\u00e1c, h\u00e3y ki\u1ec3m tra c\u00fa ph\u00e1p, ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a c\u00f4ng th\u1ee9c. N\u1ebfu v\u1eabn g\u1eb7p kh\u00f3 kh\u0103n, h\u00e3y tham kh\u1ea3o t\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn ho\u1eb7c t\u00ecm ki\u1ebfm tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 t\u00ecm ra gi\u1ea3i ph\u00e1p cho v\u1ea5n \u0111\u1ec1 m\u00e0 b\u1ea1n \u0111ang g\u1eb7p ph\u1ea3i. H\u00e3y nh\u1edb r\u1eb1ng, vi\u1ec7c ki\u1ec3m tra v\u00e0 s\u1eeda l\u1ed7i l\u00e0 r\u1ea5t quan tr\u1ecdng, gi\u00fap \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m IF trong Excel.<\/span><\/p>\n

          \u00a0<\/p>\n

          Th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean, <\/span>Masterskills<\/span> \u0111\u00e3 gi\u00fap b\u1ea1n kh\u00e1m ph\u00e1 v\u1ec1 h\u00e0m IF trong Excel. V\u1edbi s\u1ef1 m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t c\u1ee7a h\u00e0m IF trong Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh. Hi\u1ec3u r\u00f5 v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 tr\u1edf th\u00e0nh m\u1ed9t chuy\u00ean gia v\u1ec1 vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel.<\/span><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

          Hi\u1ec7n nay, trong c\u00f4ng vi\u1ec7c hi\u1ec7n \u0111\u1ea1i, vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng. V\u00e0 trong h\u1ec7 th\u1ed1ng c\u00e1c c\u00f4ng c\u1ee5 v\u0103n ph\u00f2ng, Excel \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n. Trong […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19319"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19319"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19319\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}