{"id":4720,"date":"2024-12-08T07:29:26","date_gmt":"2024-12-08T07:29:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te\/"},"modified":"2024-12-08T07:29:26","modified_gmt":"2024-12-08T07:29:26","slug":"cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te\/","title":{"rendered":"C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nO_m37Xw#1\">\n<p><i><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html\"><strong>s\u1eed d\u1ee5ng c\u00e1c<\/strong> <strong>h\u00e0m IF l\u1ed3ng nhau trong Excel<\/strong><\/a> \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Ngo\u00e0i ra ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u m\u1ed9t v\u00e0i h\u00e0m kh\u00e1c c\u00f3 th\u1ec3 thay th\u1ebf nh\u00e9!<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n th\u01b0\u1eddng tri\u1ec3n khai c\u00e1c quy\u1ebft \u0111\u1ecbnh logic c\u1ee7a m\u00ecnh nh\u01b0 th\u1ebf n\u00e0o trong Excel? Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c IF \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng, gi\u00e1 tr\u1ecb kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. Nh\u01b0ng, \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 nhi\u1ec1u h\u01a1n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 th\u00ec b\u1ea1n c\u1ea7n l\u1ed3ng nhi\u1ec1u h\u00e0m IF v\u00e0o nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1eb7c d\u00f9 r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng, tuy nhi\u00ean <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\"><em><strong>h\u00e0m IF l\u1ed3ng nhau <\/strong><\/em><em><strong>trong Excel<\/strong><\/em><\/a> kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch duy nh\u1ea5t \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel. Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t s\u1ed1 c\u00e1ch thay th\u1ebf ch\u1eafc ch\u1eafn \u0111\u00e1ng \u0111\u1ec3 kh\u00e1m ph\u00e1 \u0111\u1ea5y.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67554ad4dfe37\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#Cau_lenh_IF_long_nhau\" title=\"C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau\">C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#IF_long_nhau_voi_dieu_kien_OR_AND\" title=\"IF l\u1ed3ng nhau v\u1edbi \u0111i\u1ec1u ki\u1ec7n OR \/ AND\">IF l\u1ed3ng nhau v\u1edbi \u0111i\u1ec1u ki\u1ec7n OR \/ AND<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#IF_long_nhau_trong_Excel_voi_cac_cau_lenh_OR\" title=\"IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e1c c\u00e2u l\u1ec7nh OR\">IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e1c c\u00e2u l\u1ec7nh OR<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#IF_long_nhau_trong_Excel_voi_cau_lenh_AND\" title=\"IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e2u l\u1ec7nh AND\">IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e2u l\u1ec7nh AND<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#VLOOKUP_thay_vi_IF_long_nhau_trong_Excel\" title=\"VLOOKUP thay v\u00ec IF l\u1ed3ng nhau trong Excel\">VLOOKUP thay v\u00ec IF l\u1ed3ng nhau trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#Cau_lenh_IFS_thay_the_cho_ham_IF_long_nhau\" title=\"C\u00e2u l\u1ec7nh IFS thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau\">C\u00e2u l\u1ec7nh IFS thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#Ham_CHOOSE_thay_cho_cong_thuc_IF_long_nhau_trong_Excel\" title=\"H\u00e0m CHOOSE thay cho c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau trong Excel\">H\u00e0m CHOOSE thay cho c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#Ham_SWITCH_la_mot_dang_ngan_gon_cua_IF_long_nhau_trong_Excel\" title=\"H\u00e0m SWITCH l\u00e0 m\u1ed9t d\u1ea1ng ng\u1eafn g\u1ecdn c\u1ee7a IF l\u1ed3ng nhau trong Excel\">H\u00e0m SWITCH l\u00e0 m\u1ed9t d\u1ea1ng ng\u1eafn g\u1ecdn c\u1ee7a IF l\u1ed3ng nhau trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cau-lenh-if-long-nhau-trong-excel-va-cac-vi-du-thuc-te.html#Ghep_nhieu_ham_IF_trong_Excel\" title=\"Gh\u00e9p nhi\u1ec1u h\u00e0m IF trong Excel\">Gh\u00e9p nhi\u1ec1u h\u00e0m IF trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_lenh_IF_long_nhau\"><\/span><b>C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00f4ng th\u1ee9c IF c\u1ed5 \u0111i\u1ec3n l\u1ed3ng nhau trong m\u1ed9t d\u1ea1ng chung:<\/span><\/p>\n<p><strong>IF(<i>condition1<\/i>, <i>result1<\/i>, IF(<i>condition2<\/i>, <i>result2<\/i>, IF(<i>condition3<\/i>, <i>result3<\/i>, <i>result4<\/i>)))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng m\u1ed7i h\u00e0m IF ti\u1ebfp theo \u0111\u01b0\u1ee3c nh\u00fang v\u00e0o <\/span><strong><i>value_if_false<\/i><\/strong><span style=\"font-weight: 400\"> \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m tr\u01b0\u1edbc. M\u1ed7i h\u00e0m IF \u0111\u01b0\u1ee3c \u0111\u1eb7t trong t\u1eadp ngo\u1eb7c \u0111\u01a1n ri\u00eang c\u1ee7a n\u00f3 v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u1ea5u ngo\u1eb7c \u0111\u01a1n \u0111\u00f3ng \u1edf cu\u1ed1i c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau chung n\u00e0y \u0111\u00e1nh gi\u00e1 3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 4 k\u1ebft qu\u1ea3 kh\u00e1c nhau (k\u1ebft qu\u1ea3 4 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 n\u1ebfu kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o l\u00e0 TRUE). \u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n th\u00ec c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau n\u00e0y y\u00eau c\u1ea7u Excel th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau:<\/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-384.gif\" title=\"ex101_92019-nho-384\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">Ki\u1ec3m tra <\/span><i><span style=\"font-weight: 400\">\u0111i\u1ec1u ki\u1ec7n 1(decision1)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu TRUE \u2013 tr\u1ea3 l\u1ea1i <\/span><i><span style=\"font-weight: 400\">k\u1ebft qu\u1ea3 1(result1)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu SAI \u2014<\/span><\/p>\n<p><span style=\"font-weight: 400\">ki\u1ec3m tra <\/span><i><span style=\"font-weight: 400\">\u0111i\u1ec1u ki\u1ec7n 2(decision2)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu TRUE \u2013 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 2(r<\/span><i><span style=\"font-weight: 400\">esult2)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu SAI \u2013<\/span><\/p>\n<p><span style=\"font-weight: 400\">ki\u1ec3m tra <\/span><i><span style=\"font-weight: 400\">\u0111i\u1ec1u ki\u1ec7n 3(decision3)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu TRUE \u2013 tr\u1ea3 l\u1ea1i <\/span><i><span style=\"font-weight: 400\">k\u1ebft qu\u1ea3 3(result3)<\/span><\/i><span style=\"font-weight: 400\">, n\u1ebfu SAI \u2013<\/span><\/p>\n<p><span style=\"font-weight: 400\">tr\u1edf v\u1ec1 <\/span><i><span style=\"font-weight: 400\">k\u1ebft qu\u1ea34(result4)<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: h\u00e3y t\u00ecm hi\u1ec3u hoa h\u1ed3ng c\u1ee7a m\u1ed9t s\u1ed1 nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng d\u1ef1a tr\u00ean doanh s\u1ed1 c\u1ee7a h\u1ecd:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">U\u1ef7 ban<\/span><\/td>\n<td><span style=\"font-weight: 400\">B\u00e1n h\u00e0ng<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3%<\/span><\/td>\n<td><span style=\"font-weight: 400\">$ 1 \u2013 $ 50<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">5%<\/span><\/td>\n<td><span style=\"font-weight: 400\">$ 51 \u2013 $ 100<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">7%<\/span><\/td>\n<td><span style=\"font-weight: 400\">$ 101 \u2013 $ 150<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">10%<\/span><\/td>\n<td><span style=\"font-weight: 400\">H\u01a1n 150 \u0111\u00f4 la<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Trong to\u00e1n h\u1ecdc, vi\u1ec7c thay \u0111\u1ed5i th\u1ee9 t\u1ef1 b\u1ed5 sung kh\u00f4ng thay \u0111\u1ed5i t\u1ed5ng. Trong Excel, vi\u1ec7c thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c h\u00e0m IF s\u1ebd thay \u0111\u1ed5i k\u1ebft qu\u1ea3. T\u1ea1i sao? B\u1edfi v\u00ec c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n TRUE \u0111\u1ea7u ti\u00ean. Do \u0111\u00f3, trong c\u00e1c c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau c\u1ee7a b\u1ea1n, vi\u1ec7c s\u1eafp x\u1ebfp c\u00e1c \u0111i\u1ec1u ki\u1ec7n theo \u0111\u00fang h\u01b0\u1edbng \u2013 cao \u0111\u1ebfn th\u1ea5p ho\u1eb7c th\u1ea5p \u0111\u1ebfn cao l\u00e0 r\u1ea5t quan tr\u1ecdng. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n \u201ccao nh\u1ea5t\u201d tr\u01b0\u1edbc, sau \u0111\u00f3 l\u00e0 \u201ccao th\u1ee9 hai\u201d, v.v.<\/span><\/p>\n<p><strong>=IF(B2&gt;=150, 10%, IF(B2&gt;=101, 7%, IF(B2&gt;=51, 5%, IF(B2&gt;=1, 3%, \u201c\u201d))))<\/strong><\/p>\n<figure id=\"attachment_33377\" aria-describedby=\"caption-attachment-33377\" style=\"width: 538px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33377\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"1 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"538\" height=\"219\" title=\"1-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33377\" class=\"wp-caption-text\">1 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu ch\u00fang ta s\u1eafp x\u1ebfp c\u00e1c \u0111i\u1ec1u ki\u1ec7n theo th\u1ee9 t\u1ef1 ng\u01b0\u1ee3c l\u1ea1i, t\u1eeb d\u01b0\u1edbi l\u00ean, k\u1ebft qu\u1ea3 s\u1ebd sai v\u00ec c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta s\u1ebd d\u1eebng sau th\u1eed nghi\u1ec7m logic \u0111\u1ea7u ti\u00ean cho b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o l\u1edbn h\u01a1n 1. Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 doanh thu 100 \u0111\u00f4 la \u2013 l\u1edbn h\u01a1n 1, ngay l\u1eadp t\u1ee9c c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c v\u00e0 tr\u1ea3 l\u1ea1i 3% nh\u01b0 k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n th\u1ea5y \u0111\u1ea5y, ph\u1ea3i m\u1ea5t kh\u00e1 nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 x\u00e2y d\u1ef1ng logic c\u1ee7a m\u1ed9t c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau cho \u0111\u1ebfn h\u1ebft. V\u00e0 m\u1eb7c d\u00f9 Microsoft Excel cho ph\u00e9p l\u1ed3ng t\u1ed1i \u0111a 64 h\u00e0m IF trong m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0ng \u0111\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 \u0111i\u1ec1u b\u1ea1n th\u1ef1c s\u1ef1 mu\u1ed1n l\u00e0m trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. V\u00ec v\u1eady, n\u1ebfu b\u1ea1n (ho\u1eb7c ai \u0111\u00f3) \u0111ang nh\u00ecn ch\u1eb1m ch\u1eb1m v\u00e0o c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u1ee7a Excel v\u00e0 c\u1ed1 g\u1eafng t\u00ecm hi\u1ec3u xem n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m g\u00ec, \u0111\u00e3 \u0111\u1ebfn l\u00fac xem x\u00e9t l\u1ea1i chi\u1ebfn l\u01b0\u1ee3c c\u1ee7a b\u1ea1n v\u00e0 c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1c trong kho v\u0169 kh\u00ed c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"IF_long_nhau_voi_dieu_kien_OR_AND\"><\/span><b>IF l\u1ed3ng nhau v\u1edbi \u0111i\u1ec1u ki\u1ec7n OR \/ AND<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u00e1nh gi\u00e1 m\u1ed9t v\u00e0i t\u1eadp h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 bi\u1ec3u th\u1ecb c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00f3 b\u1eb1ng h\u00e0m OR c\u0169ng nh\u01b0 h\u00e0m AND, l\u1ed3ng c\u00e1c h\u00e0m b\u00ean trong c\u00e1c c\u00e2u l\u1ec7nh IF v\u00e0 sau \u0111\u00f3 l\u1ed3ng c\u00e1c c\u00e2u l\u1ec7nh IF v\u00e0o nhau, kh\u00e1 d\u1ec5 hi\u1ec3u \u0111\u00fang kh\u00f4ng?<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"IF_long_nhau_trong_Excel_voi_cac_cau_lenh_OR\"><\/span><b>IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e1c c\u00e2u l\u1ec7nh OR<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OR b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra hai ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau trong ki\u1ec3m tra logic c\u1ee7a t\u1eebng h\u00e0m IF v\u00e0 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00f3 (\u00edt nh\u1ea5t m\u1ed9t) \u0111\u1ed1i s\u1ed1 OR \u01b0\u1edbc t\u00ednh th\u00e0nh TRUE. \u0110\u1ec3 d\u1ec5 hi\u1ec3u h\u01a1n th\u00ec ch\u00fang ta c\u00f9ng l\u00e0m v\u00ed d\u1ee5 sau nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 hai c\u1ed9t b\u00e1n h\u00e0ng, doanh s\u1ed1 th\u00e1ng 1 \u1edf c\u1ed9t B v\u00e0 doanh s\u1ed1 th\u00e1ng 2 \u1edf c\u1ed9t C. B\u1ea1n mu\u1ed1n ki\u1ec3m tra c\u00e1c s\u1ed1 trong c\u1ea3 hai c\u1ed9t v\u00e0 t\u00ednh to\u00e1n hoa h\u1ed3ng d\u1ef1a tr\u00ean s\u1ed1 cao h\u01a1n. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n x\u00e2y d\u1ef1ng m\u1ed9t c\u00f4ng th\u1ee9c v\u1edbi logic sau: n\u1ebfu doanh s\u1ed1 th\u00e1ng 1 ho\u1eb7c th\u00e1ng 2 l\u1edbn h\u01a1n 150 \u0111\u00f4 la, ng\u01b0\u1eddi b\u00e1n nh\u1eadn \u0111\u01b0\u1ee3c 10% hoa h\u1ed3ng, n\u1ebfu doanh s\u1ed1 th\u00e1ng 1 ho\u1eb7c th\u00e1ng 2 l\u1edbn h\u01a1n 100 \u0111\u00f4 la, th\u00ec ng\u01b0\u1eddi b\u00e1n nh\u1eadn \u0111\u01b0\u1ee3c 7% hoa h\u1ed3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 l\u00e0m b\u00e0i n\u00e0y, h\u00e3y vi\u1ebft m\u1ed9t v\u00e0i c\u00e2u l\u1ec7nh OF nh\u01b0 OR (B2&gt; = 150, C2&gt; = 150) v\u00e0 l\u1ed3ng ch\u00fang v\u00e0o c\u00e1c h\u00e0m IF \u0111\u00e3 th\u1ea3o lu\u1eadn \u1edf tr\u00ean. K\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<p><strong>=IF(OR(B2&gt;=150, C2&gt;=150), 10%, IF(OR(B2&gt;=101, C2&gt;=101),7%, IF(OR(B2&gt;=51, C2&gt;=51), 5%, IF(OR(B2&gt;=11, C2&gt;=1), 3%, \u201c\u201d))))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">V\u00e0 ta \u0111\u00e3 c\u00f3 hoa h\u1ed3ng c\u1ea7n t\u00ecm d\u1ef1a tr\u00ean s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng cao h\u01a1n:<\/span><\/p>\n<figure id=\"attachment_33378\" aria-describedby=\"caption-attachment-33378\" style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33378\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"2 C\u00e2u l\u1ec7nh IF l\u1ed3ng nahau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"602\" height=\"239\" title=\"2-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33378\" class=\"wp-caption-text\">2 C\u00e2u l\u1ec7nh IF l\u1ed3ng nahau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c, vui l\u00f2ng xem c\u00e2u l\u1ec7nh IF OR trong Excel<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"IF_long_nhau_trong_Excel_voi_cau_lenh_AND\"><\/span><b>IF l\u1ed3ng nhau trong Excel v\u1edbi c\u00e2u l\u1ec7nh AND<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 bao g\u1ed3m nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e3y th\u1ec3 hi\u1ec7n ch\u00fang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m AND.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: \u0111\u1ec3 bi\u1ebft hoa h\u1ed3ng d\u1ef1a tr\u00ean s\u1ed1 l\u01b0\u1ee3ng b\u00e1n h\u00e0ng th\u1ea5p h\u01a1n, h\u00e3y th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c tr\u00ean v\u00e0 thay th\u1ebf c\u00e2u l\u1ec7nh OR b\u1eb1ng c\u00e2u l\u1ec7nh AND. N\u00f3i c\u00e1ch kh\u00e1c, b\u1ea1n y\u00eau c\u1ea7u Excel ch\u1ec9 tr\u1ea3 l\u1ea1i 10% n\u1ebfu doanh s\u1ed1 th\u00e1ng 1 v\u00e0 th\u00e1ng 2 l\u1edbn h\u01a1n 150 \u0111\u00f4 la, 7% n\u1ebfu doanh s\u1ed1 th\u00e1ng 1 v\u00e0 th\u00e1ng 2 l\u1edbn h\u01a1n 100 \u0111\u00f4 la, v.v.<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=150, C2&gt;=150), 10%, IF(AND(B2&gt;=101, C2&gt;=101), 7%, IF(AND(B2&gt;=51, C2&gt;=51), 5%, IF(AND(B2&gt;=11, C2&gt;=1), 3%, \u201c\u201d))))<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c IF l\u1ed3ng nhau \u0111\u00e3 t\u00ednh to\u00e1n hoa h\u1ed3ng d\u1ef1a tr\u00ean s\u1ed1 th\u1ea5p h\u01a1n trong c\u00e1c c\u1ed9t B v\u00e0 C. N\u1ebfu m\u1ed9t trong hai c\u1ed9t tr\u1ed1ng, kh\u00f4ng c\u00f3 hoa h\u1ed3ng n\u00e0o c\u1ea3 v\u00ec kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n AND n\u00e0o \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng:<\/span><\/p>\n<figure id=\"attachment_33379\" aria-describedby=\"caption-attachment-33379\" style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33379\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"3 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"602\" height=\"237\" title=\"3-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33379\" class=\"wp-caption-text\">3 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 0% thay v\u00ec c\u00e1c \u00f4 tr\u1ed1ng, h\u00e3y thay th\u1ebf m\u1ed9t chu\u1ed7i tr\u1ed1ng (\u201d \u201c) trong \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng b\u1eb1ng 0%:<\/span><\/p>\n<p><strong>=IF(AND(B2&gt;=150, C2&gt;=150), 10%, IF(AND(B2&gt;=101, C2&gt;=101), 7%, IF(AND(B2&gt;=51, C2&gt;=51), 5%, IF(AND(B2&gt;=11, C2&gt;=1), 3%, 0%))))<\/strong><\/p>\n<figure id=\"attachment_33380\" aria-describedby=\"caption-attachment-33380\" style=\"width: 601px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"4 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"601\" height=\"238\" title=\"4-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33380\" class=\"wp-caption-text\">4 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">T\u00ecm th\u00eam th\u00f4ng tin t\u1ea1i \u0111\u00e2y: Excel IF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND \/ OR.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_thay_vi_IF_long_nhau_trong_Excel\"><\/span><b>VLOOKUP thay v\u00ec IF l\u1ed3ng nhau trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n \u0111ang x\u1eed l\u00fd \u201cthang \u0111o\u201d, t\u1ee9c l\u00e0 c\u00e1c ph\u1ea1m vi gi\u00e1 tr\u1ecb s\u1ed1 li\u00ean t\u1ee5c c\u00f9ng nhau bao tr\u00f9m to\u00e0n b\u1ed9 ph\u1ea1m vi, trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Ch\u1ee9c n\u0103ng VLOOKUP thay v\u00ec c\u00e1c h\u00e0m IF l\u1ed3ng nhau.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, b\u1ea1n h\u00e3y t\u1ea1o m\u1ed9t b\u1ea3ng tham chi\u1ebfu nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi. Sau \u0111\u00f3, x\u00e2y d\u1ef1ng m\u1ed9t c\u00f4ng th\u1ee9c Vlookup v\u1edbi \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang, t\u1ee9c l\u00e0 v\u1edbi <\/span><i><span style=\"font-weight: 400\">range_lookup<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh TRUE.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3 s\u1eed gi\u00e1 tr\u1ecb tra c\u1ee9u l\u00e0 B2 v\u00e0 b\u1ea3ng tham chi\u1ebfu l\u00e0 F2: G5, ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><strong>=VLOOKUP(B2,$F$2:$G$5,2,TRUE)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd r\u1eb1ng h\u00e3y s\u1eeda <\/span><i><span style=\"font-weight: 400\">table_array<\/span><\/i><span style=\"font-weight: 400\"> v\u1edbi c\u00e1c tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ($F$2:$G$5) \u0111\u1ec3 sao ch\u00e9p ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 kh\u00e1c:<\/span><\/p>\n<figure id=\"attachment_33381\" aria-describedby=\"caption-attachment-33381\" style=\"width: 546px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"5 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"546\" height=\"219\" title=\"5-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33381\" class=\"wp-caption-text\">5 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1eb1ng c\u00e1ch \u0111\u1eb7t \u0111\u1ed1i s\u1ed1 cu\u1ed1i c\u00f9ng c\u1ee7a c\u00f4ng th\u1ee9c Vlookup th\u00e0nh TRUE, ngh\u0129a l\u00e0 b\u1ea1n \u0111ang\u00a0 n\u00f3i v\u1edbi Excel r\u1eb1ng n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c th\u00ec h\u00e3y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ti\u1ebfp theo nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb tra c\u1ee9u. N\u00f3i m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u h\u01a1n l\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng ch\u1ec9 kh\u1edbp v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c trong b\u1ea3ng tra c\u1ee9u m\u00e0 c\u00f2n b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o n\u1eb1m \u1edf g\u1ea7n n\u00f3 nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: gi\u00e1 tr\u1ecb tra c\u1ee9u trong B3 l\u00e0 $95. S\u1ed1 n\u00e0y kh\u00f4ng t\u1ed3n t\u1ea1i trong b\u1ea3ng tra c\u1ee9u, l\u00fac n\u00e0y\u00a0 Vlookup v\u1edbi k\u1ebft qu\u1ea3 kh\u1edbp ch\u00ednh x\u00e1c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A, nh\u01b0ng Vlookup v\u1edbi k\u1ebft qu\u1ea3 g\u1ea7n \u0111\u00fang s\u1ebd ti\u1ebfp t\u1ee5c t\u00ecm ki\u1ebfm cho \u0111\u1ebfn khi t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb g\u1ea7n nh\u1ea5t nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb tra c\u1ee9u (trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta l\u00e0 $50) v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t th\u1ee9 hai trong c\u00f9ng h\u00e0ng (l\u00e0 5%).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0ng n\u1ebfu gi\u00e1 tr\u1ecb tra c\u1ee9u nh\u1ecf h\u01a1n s\u1ed1 nh\u1ecf nh\u1ea5t trong b\u1ea3ng tra c\u1ee9u ho\u1eb7c \u00f4 tra c\u1ee9u th\u00ec sao? Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, c\u00f4ng th\u1ee9c Vlookup s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A, n\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch\u00a0 th\u00ec h\u00e3y l\u1ed3ng VLOOKUP v\u00e0o b\u00ean trong IFERROR v\u00e0 cung c\u1ea5p gi\u00e1 tr\u1ecb cho \u0111\u1ea7u ra khi kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tra c\u1ee9u. V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=IFERROR(VLOOKUP(B2, $F$2:$G$5, 2, TRUE), \u201cOutside range\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed9t l\u01b0u \u00fd quan tr\u1ecdng b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1edb l\u00e0 \u0111\u1ec3 c\u00f4ng th\u1ee9c Vlookup c\u00f3 k\u1ebft qu\u1ea3 g\u1ea7n \u0111\u00fang nh\u1ea5t, c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng tra c\u1ee9u ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, b\u1ea1n c\u00f3 th\u1ec3 xem: \u0110\u1ed1i s\u00e1nh ch\u00ednh x\u00e1c VLOOKUP so v\u1edbi \u0111\u1ed1i s\u00e1nh g\u1ea7n \u0111\u00fang VLOOKUP<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cau_lenh_IFS_thay_the_cho_ham_IF_long_nhau\"><\/span><b>C\u00e2u l\u1ec7nh IFS thay th\u1ebf cho h\u00e0m IF l\u1ed3ng nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Trong Excel 2016 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n, Microsoft \u0111\u00e3 gi\u1edbi thi\u1ec7u m\u1ed9t ch\u1ee9c n\u0103ng \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u2013 c\u00f4ng th\u1ee9c IFS.<\/span><\/p>\n<p><span style=\"font-weight: 400\">M\u1ed9t c\u00f4ng th\u1ee9c IFS c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1edbi 127 <\/span><i><span style=\"font-weight: 400\">ki\u1ec3m tra logic<\/span><\/i><span style=\"font-weight: 400\">\/<\/span><i><span style=\"font-weight: 400\">value_if_true<\/span><\/i><span style=\"font-weight: 400\"> c\u00e1c c\u1eb7p v\u00e0 b\u00e0i ki\u1ec3m tra logic \u0111\u1ea7u ti\u00ean \u0111\u00e1nh gi\u00e1 TRUE \u201cwins\u201d:<\/span><\/p>\n<p><strong>IFS (logic_test1, value_if_true1, [logical_test2, value_if_true2]\u2026)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">V\u1edbi c\u00fa ph\u00e1p tr\u00ean, c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng l\u1ea1i theo c\u00e1ch n\u00e0y:<\/span><\/p>\n<p><strong>=IFS(B2&gt;=150, 10%, B2&gt;=101, 7%, B2&gt;=51, 5%, B2&gt;0, 3%)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n l\u01b0u \u00fd r\u1eb1ng h\u00e0m IFS s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A n\u1ebfu kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t <\/span><i><span style=\"font-weight: 400\">\u00a0logic<\/span><\/i><span style=\"font-weight: 400\">\/<\/span><i><span style=\"font-weight: 400\">value_if_true<\/span><\/i><span style=\"font-weight: 400\"> \u0111\u1ebfn cu\u1ed1i c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 0 ho\u1eb7c chu\u1ed7i r\u1ed7ng (\u201c\u201d) ho\u1eb7c b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o b\u1ea1n mu\u1ed1n n\u1ebfu kh\u00f4ng c\u00f3 ph\u00e9p th\u1eed logic n\u00e0o tr\u01b0\u1edbc \u0111\u00f3 l\u00e0 TRUE:<\/span><\/p>\n<p><strong>=IFS(B2&gt;=150, 10%, B2&gt;=101, 7%, B2&gt;=51, 5%, B2&gt;0, 3%, TRUE, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">C\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t \u00f4 tr\u1ed1ng thay v\u00ec l\u1ed7i #N\/A n\u1ebfu m\u1ed9t \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t B tr\u1ed1ng ho\u1eb7c ch\u1ee9a v\u0103n b\u1ea3n hay l\u00e0 s\u1ed1 \u00e2m.<\/span><\/p>\n<figure id=\"attachment_33382\" aria-describedby=\"caption-attachment-33382\" style=\"width: 538px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33382\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"6 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"538\" height=\"219\" title=\"6-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33382\" class=\"wp-caption-text\">6 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: Gi\u1ed1ng nh\u01b0 IF l\u1ed3ng nhau, h\u00e0m IFS c\u1ee7a Excel s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u01b0\u1edbc t\u00ednh th\u00e0nh TRUE, \u0111\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao th\u1ee9 t\u1ef1 ki\u1ec3m tra logic trong c\u00f4ng th\u1ee9c IFS c\u00f3 v\u1ea5n \u0111\u1ec1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, xin vui l\u00f2ng xem H\u00e0m IFS c\u1ee7a Excel thay v\u00ec IF l\u1ed3ng nhau.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_CHOOSE_thay_cho_cong_thuc_IF_long_nhau_trong_Excel\"><\/span><b>H\u00e0m CHOOSE thay cho c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel l\u00e0 s\u1eed d\u1ee5ng h\u00e0m CHOOSE, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch d\u1ef1a tr\u00ean v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00c1p d\u1ee5ng cho t\u1eadp d\u1eef li\u1ec7u m\u1eabu, ta c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/span><\/p>\n<p><strong>=CHOOSE((B2&gt;=1) + (B2&gt;=51) + (B2&gt;=101) + (B2&gt;=150), 3%, 5%, 7%, 10%)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean (<\/span><i><span style=\"font-weight: 400\">index_num<\/span><\/i><span style=\"font-weight: 400\">), b\u1ea1n \u0111\u00e1nh gi\u00e1 t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n v\u00e0 th\u00eam k\u1ebft qu\u1ea3. Cho r\u1eb1ng TRUE t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi 1 v\u00e0 FALSE th\u00e0nh 0, theo c\u00e1ch n\u00e0y b\u1ea1n t\u00ednh \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb s\u1ebd tr\u1ea3 v\u1ec1.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: gi\u00e1 tr\u1ecb trong B2 l\u00e0 $150. \u0110\u1ed1i v\u1edbi gi\u00e1 tr\u1ecb n\u00e0y, c\u1ea3 4 \u0111i\u1ec1u ki\u1ec7n l\u00e0 TRUE, ngh\u0129a l\u00e0 <\/span><i><span style=\"font-weight: 400\">index_num <\/span><\/i><span style=\"font-weight: 400\">b\u1eb1ng 4, ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 t\u01b0 \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i, l\u00e0 10%.<\/span><\/p>\n<figure id=\"attachment_33383\" aria-describedby=\"caption-attachment-33383\" style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33383\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"7 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"602\" height=\"218\" title=\"7-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33383\" class=\"wp-caption-text\">7 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 n\u00e0o l\u00e0 TRUE, <\/span><i><span style=\"font-weight: 400\">index_num<\/span><\/i><span style=\"font-weight: 400\"> b\u1eb1ng 0 v\u00e0 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 #VALUE! l\u1ed7i. \u0110\u1eebng r\u1ed1i, h\u00e3y g\u00f3i CHOOSE trong H\u00e0m IFERROR nh\u01b0 th\u1ebf n\u00e0y:<\/span><\/p>\n<p><strong>=IFERROR(CHOOSE((B2&gt;=1) + (B2&gt;=51) + (B2&gt;=101) + (B2&gt;=150), 3%, 5%, 7%, 10%), \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, xin vui l\u00f2ng xem H\u00e0m CHOOSE trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_SWITCH_la_mot_dang_ngan_gon_cua_IF_long_nhau_trong_Excel\"><\/span><b>H\u00e0m SWITCH l\u00e0 m\u1ed9t d\u1ea1ng ng\u1eafn g\u1ecdn c\u1ee7a IF l\u1ed3ng nhau trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n \u0111ang x\u1eed l\u00fd m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc c\u1ed1 \u0111\u1ecbnh, kh\u00f4ng ph\u1ea3i t\u1ef7 l\u1ec7, thay v\u00ec c\u00e1c c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau ph\u1ee9c t\u1ea1p, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SWITCH nh\u01b0 sau:<\/span><\/p>\n<p><strong>SWITCH(expression, value1, result1, value2, result2, \u2026, [default])<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh hoa h\u1ed3ng d\u1ef1a tr\u00ean c\u00e1c l\u1edbp A B C D, thay v\u00ec s\u1ed1 ti\u1ec1n b\u00e1n h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n nh\u1ecf g\u1ecdn n\u00e0y c\u1ee7a c\u00f4ng th\u1ee9c IF l\u1ed3ng nhau trong Excel:<\/span><\/p>\n<p><strong>=SWITCH(C2, \u201cA\u201d, 10%, \u201cB\u201d, 7%, \u201cC\u201d, 5%, \u201cD\u201d, 3%, \u201c\u201d)<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng tham chi\u1ebfu nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi v\u00e0 s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 thay v\u00ec c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a c\u1ee9ng:<\/span><\/p>\n<p><strong>=SWITCH(C2, $F$2, $G$2, $F$3, $G$3, $F$4, $G$4, $F$5, $G$5, \u201c\u201d)<\/strong><\/p>\n<figure id=\"attachment_33375\" aria-describedby=\"caption-attachment-33375\" style=\"width: 548px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33375\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"H\u00e0m SWITCH l\u00e0 m\u1ed9t d\u1ea1ng ng\u1eafn g\u1ecdn c\u1ee7a IF l\u1ed3ng nhau trong Excel\" width=\"548\" height=\"218\" title=\"8-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33375\" class=\"wp-caption-text\">H\u00e0m SWITCH l\u00e0 m\u1ed9t d\u1ea1ng ng\u1eafn g\u1ecdn c\u1ee7a IF l\u1ed3ng nhau trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: b\u1ea1n h\u00e3y kh\u00f3a t\u1ea5t c\u1ea3 c\u00e1c tham chi\u1ebfu ngo\u1ea1i tr\u1eeb tham chi\u1ebfu \u0111\u1ea7u ti\u00ean b\u1eb1ng d\u1ea5u $ \u0111\u1ec3 ng\u0103n ch\u00fang thay \u0111\u1ed5i khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c nh\u00e9.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ch\u00fa \u00fd: H\u00e0m SWITCH ch\u1ec9 kh\u1ea3 d\u1ee5ng trong Excel 2016 tr\u1edf l\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin, b\u1ea1n c\u00f3 th\u1ec3 xem H\u00e0m SWITCH \u2013 d\u1ea1ng r\u00fat g\u1ecdn c\u1ee7a c\u00e2u l\u1ec7nh IF l\u1ed3ng nhau.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ghep_nhieu_ham_IF_trong_Excel\"><\/span><b>Gh\u00e9p nhi\u1ec1u h\u00e0m IF trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Nh\u01b0 m\u00ecnh \u0111\u00e3 \u0111\u1ec1 c\u1eadp trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, h\u00e0m SWITCH ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel 2016. C\u00f2n n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Excel phi\u00ean b\u1ea3n c\u0169 h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p hai ho\u1eb7c nhi\u1ec1u c\u00e2u l\u1ec7nh IF b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng to\u00e1n t\u1eed Concatenate (&amp;) ho\u1eb7c h\u00e0m CONCATENATE nh\u00e9!<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><strong>=(IF(C2=\u201da\u201d, 10%, \u201c\u201d) &amp; IF(C2=\u201db\u201d, 7%, \u201c\u201d) &amp; IF(C2=\u201dc\u201d, 5%, \u201c\u201d) &amp; IF(C2=\u201dd\u201d, 3%, \u201c\u201d))*1<\/strong><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c l\u00e0<\/span><\/p>\n<p><strong>=CONCATENATE(IF(C2=\u201da\u201d, 10%, \u201c\u201d), IF(C2=\u201db\u201d, 7%, \u201c\u201d), IF(C2=\u201dc\u201d, 5%, \u201c\u201d) &amp; IF(C2=\u201dd\u201d, 3%, \u201c\u201d))*1<\/strong><\/p>\n<figure id=\"attachment_33376\" aria-describedby=\"caption-attachment-33376\" style=\"width: 571px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-33376\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf.png\" alt=\"9 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\" width=\"571\" height=\"218\" title=\"9-cc3a2u-le1bb87nh-if-le1bb93ng-nhau-trong-excel-vc3a0-cc3a1c-vc3ad-de1bba5-the1bbb1c-te1babf\"><figcaption id=\"caption-attachment-33376\" class=\"wp-caption-text\">9 C\u00e2u l\u1ec7nh IF l\u1ed3ng nhau trong Excel v\u00e0 c\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y, ch\u00fang ta nh\u1eadn k\u1ebft qu\u1ea3 v\u1edbi 1 trong c\u1ea3 hai c\u00f4ng th\u1ee9c, sau \u0111\u00f3 n\u00f3 s\u1ebd chuy\u1ec3n \u0111\u1ed5i m\u1ed9t chu\u1ed7i \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\"><strong>c\u00f4ng th\u1ee9c Concatenate<\/strong><\/a> th\u00e0nh m\u1ed9t s\u1ed1. N\u1ebfu \u0111\u1ea7u ra d\u1ef1 ki\u1ebfn \u200b\u200bc\u1ee7a b\u1ea1n l\u00e0 v\u0103n b\u1ea3n th\u00ec b\u1ea1n kh\u00f4ng c\u1ea7n b\u01b0\u1edbc nh\u00e2n n\u00e0y nh\u00e9!<\/span><\/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-384.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4721,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4720","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\/4720","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=4720"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4721"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}