{"id":6904,"date":"2024-12-21T16:27:59","date_gmt":"2024-12-21T16:27:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-if-va-cach-su-dung-ham-if-trong-excel\/"},"modified":"2024-12-21T16:27:59","modified_gmt":"2024-12-21T16:27:59","slug":"ham-if-va-cach-su-dung-ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-if-va-cach-su-dung-ham-if-trong-excel\/","title":{"rendered":"H\u00e0m IF v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><b><a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ham-voi-nhieu-dieu-kien-iferror-ifna-va-nhieu-hon-nua.html\">H\u00e0m If<\/a> l\u00e0 m\u1ed9t h\u00e0m \u0111i\u1ec1u ki\u1ec7n r\u1ea5t hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel. V\u1eady h\u00e0m If l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o, h\u00f4m nay m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n nh\u00e9!<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13095 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-if-va-cach-su-dung-ham-if-trong-excel.png\" alt=\"H\u00e0m IF v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel\" width=\"600\" height=\"367\" title=\"ham-if-va-cach-su-dung-ham-if-trong-excel\"><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m If: \u00a0<\/span><b>If (Logic_test, value_if_true, value_if_false)<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>Logic_test<\/b><span style=\"font-weight: 400\">: l\u00e0 gi\u00e1 tr\u1ecb hay bi\u1ec3u th\u1ee9c logic (nh\u1eadn 2 gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE).<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Value_if_true<\/b><span style=\"font-weight: 400\">: l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m n\u1ebfu bi\u1ec3u th\u1ee9c logic nh\u1eadn gi\u00e1 tr\u1ecb TRUE.<\/span><\/li>\n<li style=\"font-weight: 400\"><b>Value_if_false<\/b><span style=\"font-weight: 400\">: l\u00e0 gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m n\u1ebfu bi\u1ec3u th\u1ee9c logic nh\u1eadn gi\u00e1 tr\u1ecb FALSE.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Ch\u1ee9c n\u0103ng: H\u00e0m If cho ra m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 \u0111\u1ecbnh trong h\u00e0m \u0111\u00fang v\u00e0 cho ra gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 \u0111\u1ecbnh trong h\u00e0m sai.<\/span><\/p>\n<blockquote>\n<p>B\u1ed9 t\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">h\u01b0\u1edbng d\u1eabn h\u1ecdc Excel 2013<\/a>\u00a0hay nh\u1ea5t m\u1ecdi th\u1eddi \u0111\u1ea1i<\/p>\n<\/blockquote>\n<p><b>V\u00ed d\u1ee5:<\/b><\/p>\n<p><span style=\"font-weight: 400\">H\u00e3y l\u1eadp c\u00f4ng th\u1ee9c cho c\u1ed9t Ph\u1ee5 c\u1ea5p, bi\u1ebft r\u1eb1ng Ph\u1ee5 c\u1ea5p \u0111\u01b0\u1ee3c t\u00ednh theo nguy\u00ean t\u1eafc sau:<\/span><\/p>\n<p><span style=\"font-weight: 400\">N\u1ebfu l\u00e0 TP (tr\u01b0\u1edfng ph\u00f2ng) th\u00ec Ph\u1ee5 c\u1ea5p = 40%*L\u01b0\u01a1ng, c\u00f2n l\u1ea1i l\u00e0 30%*L\u01b0\u01a1ng<\/span><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-620.gif\" title=\"ex101_92019-nho-620\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li style=\"font-weight: 400\"><b>B\u01b0\u1edbc 1<\/b><span style=\"font-weight: 400\">: T\u1ea1i \u00f4 E4 l\u1eadp c\u00f4ng th\u1ee9c sau: <\/span><b>=If(C4=\u201dTP\u201d,40%*D4,30%*D4)<\/b><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3388\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/03\/VD-h%C3%A0m-if.gif\" alt=\"\" width=\"600\" height=\"303\"><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>B\u01b0\u1edbc 2:<\/b><span style=\"font-weight: 400\"> Sao ch\u00e9p c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng ti\u1ebfp theo:<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u00a0C\u00e1ch 1: D\u00f9ng ph\u00edm t\u1eaft <\/span><b>Ctrl+D.<\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1ch 2: Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a \u00f4 E4, th\u1ea5y chu\u1ed9t chuy\u1ec3n sang d\u1ea5u <strong>+<\/strong> th\u00ec b\u1ea5m chu\u1ed9t k\u00e9o xu\u1ed1ng d\u01b0\u1edbi.<\/span><\/li>\n<\/ul>\n<p>H\u00e0m If \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u00e0 c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng cao do c\u00f3 th\u1ec3 l\u1ed3ng c\u00f9ng c\u00e1c h\u00e0m kh\u00e1c trong Excel. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta c\u1ea7n n\u1eafm v\u1eefng v\u00e0 s\u1eed d\u1ee5ng t\u1ed1t \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m\u00a0v\u00e0 c\u00e1c\u00a0c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u00a0 \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p><strong>Xem \u0111\u1ea7y \u0111\u1ee7 c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 c\u1ee7a h\u00e0m if h\u01a1n t\u1ea1i b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n nh\u00e9! <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">C\u00e1ch d\u00f9ng h\u00e0m IF trong Excel<\/a>, c\u00f3 v\u00ed d\u1ee5 h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3, chi ti\u1ebft nh\u1ea5t\u00a0<\/strong><\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-620.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6904","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6904"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6904\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6905"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}