{"id":1306,"date":"2020-09-24T14:33:20","date_gmt":"2020-09-24T07:33:20","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1306"},"modified":"2020-09-24T14:35:29","modified_gmt":"2020-09-24T07:35:29","slug":"ham-if-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-if-nhieu-dieu-kien\/","title":{"rendered":"H\u00e0m IF Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n V\u00e0 C\u00e1ch L\u1ed3ng Gh\u00e9p Nhi\u1ec1u C\u00f4ng Th\u1ee9c"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u00a0<\/p>

H\u00e0m IF<\/a> l\u00e0 m\u1ed9t trong 10 h\u00e0m Excel \u0111\u01b0\u1ee3c d\u00f9ng nhi\u1ec1u nh\u1ea5t. H\u00e0m IF th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n so s\u00e1nh l\u00f4-gic v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u1ea1n mong mu\u1ed1n.<\/span><\/p>

\u00a0<\/span><\/p>

C\u00f4ng th\u1ee9c h\u00e0m IF s\u1ebd r\u1ea5t \u0111\u01a1n gi\u1ea3n n\u1ebfu ch\u1ec9 c\u00f3 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n. Nh\u01b0ng n\u1ebfu c\u00f4ng th\u1ee9c h\u00e0m c\u1ee7a b\u1ea1n c\u1ea7n ph\u1ea3i ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n?<\/span><\/p>

\u00a0<\/span><\/p>

M\u1ed9t trong nh\u1eefng c\u00e1ch hay \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0 s\u1eed d\u1ee5ng <\/span>ha\u0300m IF la\u0300m \u0111\u00f4\u0301i s\u00f4\u0301 trong c\u00f4ng th\u01b0\u0301c c\u1ee7a ch\u00ednh n\u00f3 – hay c\u00f2n \u0111\u01b0\u01a1\u0323c go\u0323i la\u0300 l\u00f4\u0300ng gh\u00e9p h\u00e0m.<\/span> B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ed3ng nhau hay nhi\u1ec1u h\u00e0m IF l\u1ed3ng gh\u00e9p trong m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t

M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
<\/i><\/div>\n\t\t\t\t
<\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t<\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

1, H\u00e0m IF Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n Trong Excel V\u00e0 C\u00e1c V\u00ed D\u1ee5 \u0110\u01a1n Gi\u1ea3n<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

C\u00e2u l\u1ec7nh h\u00e0m IF trong Excel:<\/span><\/p>

=IF(logical_test, [value_if_true], [value_if_false])<\/span><\/p>

\u00a0<\/span><\/p>

Trong c\u00e1c phi\u00ean b\u1ea3n Excel 2007, 2010, 2013, 2016, 2019 v\u00e0 365, b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng t\u1ed1i \u0111a 64 h\u00e0m trong m\u1ed9t c\u00f4ng th\u1ee9c. V\u1edbi Excel 2003 tr\u1edf v\u1ec1 tr\u01b0\u1edbc, t\u1ed1i \u0111a ch\u1ec9 \u0111\u01b0\u1ee3c 7 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>

\u00a0<\/span><\/p>

\u0110\u1ec3 l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m hi\u1ec7u qu\u1ea3, b\u1ea1n c\u1ea7n hi\u1ec3u r\u00f5 logic c\u1ee7a c\u00f4ng th\u1ee9c v\u00e0 y\u00eau c\u1ea7u \u0111\u1ec1 b\u00e0i. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u 2 v\u00ed d\u1ee5 c\u01a1 b\u1ea3n nh\u1ea5t \u0111\u1ec3 n\u1eafm v\u1eefng c\u00e1ch ch\u1ecdn h\u01b0\u1edbng gi\u1ea3i quy\u1ebft cho b\u00e0i to\u00e1n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

1.1, V\u00ed D\u1ee5 H\u00e0m IF L\u1ed3ng Gh\u00e9p H\u00e0m Kh\u00e1c<\/span> <\/span>Ki\u1ec3m Tra 2 \u0110i\u1ec1u Ki\u1ec7n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

V\u00ed d\u1ee5 sau v\u1ec1 H\u00e0m IF 2 \u0111i\u1ec1u ki\u1ec7n: K\u1ebft qu\u1ea3 c\u1ee7a h\u1ecdc sinh \u0111\u1ea1t khi \u0111i\u1ec3m c\u1ea3 2 m\u00f4n tr\u00ean 5.<\/span><\/p>

L\u00fac n\u00e0y, h\u00e0m IF c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0110i\u1ec3m m\u00f4n th\u1ee9 1 l\u1edbn h\u01a1n 5, v\u00e0 \u0110i\u1ec3m m\u00f4n th\u1ee9 2 c\u0169ng ph\u1ea3i l\u1edbn h\u01a1n 5.<\/span><\/p>

\u00a0<\/span><\/p>

B\u00e0i to\u00e1n th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n khi\u1ebfn ta li\u00ean t\u01b0\u1edfng \u0111\u1ebfn h\u00e0m logic AND, tr\u1ea3 v\u1ec1 TRUE khi t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 TRUE- ch\u1ec9 c\u1ea7n 1 \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng th\u1ecfa m\u00e3n th\u00ec h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 FALSE.<\/span><\/p>

\u00a0<\/p>

T\u1eeb \u0111\u00f3, c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m IF AND l\u1ed3ng gh\u00e9p v\u1edbi nhau \u0111\u1ec3 t\u00ecm ra k\u1ebft qu\u1ea3 h\u1ecdc t\u1eadp c\u1ee7a h\u1ecdc sinh c\u00f3 \u0111\u1ea1t \u0111i\u1ec1u ki\u1ec7n c\u1ea3 2 m\u00f4n tr\u00ean 5 hay kh\u00f4ng:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"h\u00e0m\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

1.2, V\u00ed D\u1ee5 H\u00e0m IF L\u1ed3ng Gh\u00e9p Nhi\u1ec1u \u0110i\u1ec1u Ki\u1ec7n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Khi s\u1eed d\u1ee5ng h\u00e0m IF 1 \u0111i\u1ec1u ki\u1ec7n th\u00f4ng th\u01b0\u1eddng, h\u00e0m IF ki\u1ec3m tra bi\u1ec3u th\u1ee9c logic, n\u1ebfu \u0111\u00fang th\u00ec tr\u1ea3 v\u1ec1 Value_if_true, n\u1ebfu sai th\u00ec tr\u1ea3 v\u1ec1 Value_if_false.<\/span><\/p>

H\u00e0m n\u00e0y r\u1ea5t d\u1ec5 s\u1eed d\u1ee5ng n\u1ebfu nh\u01b0 ch\u1ec9 c\u00f3 2 gi\u00e1 tr\u1ecb c\u1ea7n tr\u1ea3 v\u1ec1 khi ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>

N\u1ebfu th\u1ef1c t\u1ebf c\u00f3 t\u1eeb 3 gi\u00e1 tr\u1ecb tr\u1edf l\u00ean th\u00ec sao?<\/span><\/p>

B\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i \u0111\u1ed5i h\u00e0m kh\u00e1c ho\u1eb7c n\u1ebfu v\u1eabn s\u1eed d\u1ee5ng h\u00e0m IF th\u00ec ph\u1ea3i l\u1ed3ng gh\u00e9p nhi\u1ec1u h\u00e0m IF v\u1edbi nhau nh\u01b0 v\u00ed d\u1ee5 sau:<\/span><\/p>

\u00a0<\/span><\/p>

\u0110\u1ec3 ki\u1ec3m tra c\u00e1c h\u1ecdc sinh \u0111\u01b0\u1ee3c c\u1ed9ng \u0111i\u1ec3m theo \u0111\u1ed1i t\u01b0\u1ee3ng \u01b0u ti\u00ean n\u00e0o trong nh\u00f3m 3 \u0111\u1ed1i t\u01b0\u1ee3ng, c\u1ea7n s\u1eed d\u1ee5ng 2 h\u00e0m IF l\u1ed3ng nhau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t