{"id":12490,"date":"2015-09-05T09:56:33","date_gmt":"2015-09-05T09:56:33","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=12490"},"modified":"2015-09-29T09:24:30","modified_gmt":"2015-09-29T09:24:30","slug":"cach-su-dung-ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=12490","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel"},"content":{"rendered":"

\"C\u00e1ch<\/span><\/h2>\n

H\u00e0m IF l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m c\u01a1 b\u1ea3n v\u00e0 th\u00f4ng d\u1ee5ng khi s\u1eed d\u1ee5ng excel, b\u1ea5t k\u1ec3 excel 2003, excel 2007, excel 2010\u2026 V\u1eady chi ti\u1ebft h\u00e0m IF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o? Sau \u0111\u00e2y K\u1ebf to\u00e1n Centax<\/a><\/strong> xin g\u1eedi t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n

1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF trong Excel<\/span><\/strong><\/span><\/h2>\n

C\u00fa ph\u00e1p:<\/strong> If(\u0110i\u1ec1u ki\u1ec7n, gi\u00e1 tr\u1ecb 1, gi\u00e1 tr\u1ecb 2)<\/span><\/p>\n

\u00dd ngh\u0129a:<\/strong> H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cGi\u00e1 tr\u1ecb 1\u201d n\u1ebfu nh\u01b0 \u0111i\u1ec1u ki\u1ebfn \u0111\u00fang, v\u00e0 tr\u1ea3 v\u1ec1 \u201c gi\u00e1 tr\u1ecb 2\u201d n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/span><\/p>\n

V\u00ed d\u1ee5:<\/strong> Cho b\u00e0ng l\u01b0\u01a1ng c\u1ee7a nh\u00e2n vi\u00ean, x\u00e9t s\u1ed1 ng\u00e0y c\u00f4ng \u0111i l\u00e0m \u0111\u1ec3 t\u00ednh ti\u1ec1n chuy\u00ean c\u1ea7n, n\u1ebfu s\u1ed1 ng\u00e0y c\u00f4ng l\u00e0 23\/26 c\u00f4ng th\u00ec \u0111\u01b0\u1ee3c ti\u1ec1n chuy\u00ean c\u1ea7n l\u00e0 500.000 \u0111\u1ed3ng, c\u00f2n l\u1ea1i l\u00e0m kh\u00f4ng \u0111\u1ee7 23 c\u00f4ng th\u00ec kh\u00f4ng \u0111\u01b0\u1ee3c<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

Ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 G3 l\u00e0: =If(E3>=23,500.000,0)<\/span><\/p>\n

Sau \u0111\u00f3 k\u00e9o chu\u1ed9t \u0111\u1ec3 copy c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi t\u1eeb G4->G12 v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3<\/span><\/p>\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m If trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/span><\/strong><\/span><\/h2>\n

Trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u h\u01a1n 2 s\u1ef1 l\u1ef1a ch\u1ecdn th\u00ec ta s\u1eed d\u1ee5ng nhi\u1ec1u h\u00e0m If l\u1ed3ng nhau<\/span><\/p>\n

V\u00ed d\u1ee5: C\u00f9ng v\u00ed d\u1ee5 tr\u00ean nh\u01b0ng ngo\u00e0i ti\u1ec1n chuy\u00ean c\u1ea7n, c\u00f4ng ty c\u00f2n c\u00f3 ch\u00ednh s\u00e1ch th\u01b0\u1edfng theo ng\u00e0y c\u00f4ng,<\/span><\/p>\n

N\u1ebfu s\u1ed1 ng\u00e0y c\u00f4ng >=26 (c\u00f3 l\u00e0m th\u00eam gi\u1edd) th\u00ec th\u01b0\u1edfng th\u00eam 500.000<\/span><\/p>\n

N\u1ebfu 26> s\u1ed1 ng\u00e0y c\u00f4ng >=20: Th\u00ec th\u01b0\u1edfng th\u00eam 200.000, c\u00f2n l\u1ea1i kh\u00f4ng c\u00f3 th\u01b0\u1edfng<\/span><\/p>\n

Khi \u0111\u00f3 ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ea1i \u00f4 H3 l\u00e0: =If(E3>=26,500000,if(E3>=20,200000,0))<\/span><\/p>\n

Ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/span><\/p>\n

\"C\u00e1ch<\/p>\n

M\u1ed9t v\u1ea5n \u0111\u1ec1 khi s\u1eed d\u1ee5ng h\u00e0m IF l\u00e0: Trong h\u00e0m If n\u1ebfu kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1 th\u1ee9 3 th\u00ec bi\u1ec3u th\u1ee9c \u0111i\u1ec1u ki\u1ec7n sai, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel nh\u01b0 th\u1ebf n\u00e0o? Sau \u0111\u00e2y K\u1ebf to\u00e1n Centax xin g\u1eedi t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n","protected":false},"author":7,"featured_media":14363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1552],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12490"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12490"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12490\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/14363"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12490"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}