{"id":878,"date":"2023-08-26T01:04:44","date_gmt":"2023-08-25T18:04:44","guid":{"rendered":"https:\/\/trannghiait.com\/?p=878"},"modified":"2023-08-26T01:04:44","modified_gmt":"2023-08-25T18:04:44","slug":"su-dung-ham-if-trong-excel-the-nao-moi-dung","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/su-dung-ham-if-trong-excel-the-nao-moi-dung\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m IF trong Excel th\u1ebf n\u00e0o m\u1edbi \u0111\u00fang"},"content":{"rendered":"\n<p>H\u00e0m IF trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n 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. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i s\u00e2u v\u00e0o c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/su-dung-ham-if-trong-excel-the-nao-moi-dung\/#Cu_phap_cua_ham_IF\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/su-dung-ham-if-trong-excel-the-nao-moi-dung\/#Cach_su_dung_ham_IF\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_IF\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(logical_test, &#91;value_if_true], &#91;value_if_false])<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>logical_test<\/code>: l\u00e0 \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/li>\n\n\n\n<li><code>value_if_true<\/code>: l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/li>\n\n\n\n<li><code>value_if_false<\/code>: l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/li>\n<\/ul>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 h\u00e0m hay c\u00f4ng th\u1ee9c n\u00e0o cho c\u00e1c gi\u00e1 tr\u1ecb <code>value_if_true<\/code> v\u00e0 <code>value_if_false<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_IF\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 minh h\u1ecda c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF, ch\u00fang ta s\u1ebd xem x\u00e9t m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n. H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a ch\u00fang nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>S\u1ea3n ph\u1ea9m<\/th><th>T\u1ed3n kho<\/th><\/tr><\/thead><tbody><tr><td>SP1<\/td><td>10<\/td><\/tr><tr><td>SP2<\/td><td>5<\/td><\/tr><tr><td>SP3<\/td><td>0<\/td><\/tr><tr><td>SP4<\/td><td>20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>B\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t c\u1ed9t m\u1edbi \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh li\u1ec7u s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u1ee7 h\u00e0ng trong kho hay kh\u00f4ng. N\u1ebfu s\u1ea3n ph\u1ea9m c\u00f3 s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10, b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb &#8220;\u0110\u1ee7 h\u00e0ng&#8221;, ng\u01b0\u1ee3c l\u1ea1i b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb &#8220;H\u1ebft h\u00e0ng&#8221;.<\/p>\n\n\n\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m IF nh\u01b0 sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IF(B2&gt;=10,\"\u0110\u1ee7 h\u00e0ng\",\"H\u1ebft h\u00e0ng\")<\/code><\/pre>\n\n\n\n<p>Trong \u0111\u00f3, <code>B2<\/code> l\u00e0 \u00f4 ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho c\u1ee7a s\u1ea3n ph\u1ea9m \u0111\u1ea7u ti\u00ean. N\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 10, h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 &#8220;\u0110\u1ee7 h\u00e0ng&#8221;, ng\u01b0\u1ee3c l\u1ea1i n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 &#8220;H\u1ebft h\u00e0ng&#8221;. B\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c \u0111\u1ec3 \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m trong b\u1ea3ng t\u00ednh.<\/p>\n\n\n\n<p>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 SUM, AVERAGE, MAX, MIN \u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n. H\u00e0m IF r\u1ea5t linh ho\u1ea1t v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u1ea3i quy\u1ebft nhi\u1ec1u v\u1ea5n \u0111\u1ec1 kh\u00e1c nhau trong Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u00e0m IF trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd nh\u1ea5t \u0111\u1ec3 ki\u1ec3m tra m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/26\/su-dung-ham-if-trong-excel-the-nao-moi-dung\/\" title=\"S\u1eed d\u1ee5ng h\u00e0m IF trong Excel th\u1ebf n\u00e0o m\u1edbi \u0111\u00fang\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=878"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/878\/revisions"}],"predecessor-version":[{"id":879,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/878\/revisions\/879"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}