{"id":9025,"date":"2024-12-31T13:46:21","date_gmt":"2024-12-31T13:46:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2\/"},"modified":"2024-12-31T13:46:21","modified_gmt":"2024-12-31T13:46:21","slug":"19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2\/","title":{"rendered":"19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau (Ph\u1ea7n 2)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Ti\u1ebfp theo b\u00e0i vi\u1ebft v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/19-tips-huu-hieu-cho-ham-if-long-nhau.html\">19 tips h\u1eefu hi\u1ec7u cho h\u00e0m IF l\u1ed3ng nhau<\/a> ph\u1ea7n 1, <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n c\u00e1c tips c\u00f2n l\u1ea1i trong ph\u1ea7n 2 sau \u0111\u00e2y:<\/em><\/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-6773f5ad17e21\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Su_dung_cac_cong_thuc_khac_thay_the_IF_long_nhau\" title=\"S\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c thay th\u1ebf IF l\u1ed3ng nhau\">S\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c thay th\u1ebf IF l\u1ed3ng nhau<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#AND_hoac_OR_thay_the_IF_long_nhau\" title=\"AND ho\u1eb7c OR thay th\u1ebf IF l\u1ed3ng nhau\">AND ho\u1eb7c OR thay th\u1ebf IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Thay_the_ham_IF_long_nhau_bang_VLOOKUP\" title=\"Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau b\u1eb1ng VLOOKUP\">Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau b\u1eb1ng VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Su_dung_CHOOSE\" title=\"S\u1eed d\u1ee5ng CHOOSE\">S\u1eed d\u1ee5ng CHOOSE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Su_dung_IFS_thay_cho_IF\" title=\"S\u1eed d\u1ee5ng IFS thay cho IF\">S\u1eed d\u1ee5ng IFS thay cho IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Su_dung_MIN_MAX_thay_cho_IF_long_nhau\" title=\"S\u1eed d\u1ee5ng MIN MAX thay cho IF l\u1ed3ng nhau\">S\u1eed d\u1ee5ng MIN MAX thay cho IF l\u1ed3ng nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Bay_loi_bang_IFERROR\" title=\"B\u1eaby l\u1ed7i b\u1eb1ng IFERROR\">B\u1eaby l\u1ed7i b\u1eb1ng IFERROR<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/19-tips-huu-hieu-cho-ham-if-long-nhau-phan-2.html#Su_dung_logic_boolen_%E2%80%93_thuat_toan_TRUEFALSE\" title=\"S\u1eed d\u1ee5ng logic boolen \u2013 thu\u1eadt to\u00e1n TRUE\/FALSE\">S\u1eed d\u1ee5ng logic boolen \u2013 thu\u1eadt to\u00e1n TRUE\/FALSE<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cac_cong_thuc_khac_thay_the_IF_long_nhau\"><\/span>S\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c thay th\u1ebf IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"AND_hoac_OR_thay_the_IF_long_nhau\"><\/span>AND ho\u1eb7c OR thay th\u1ebf IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Khi b\u1ea1n th\u00eam nh\u1eefng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\"><em><strong>h\u00e0m IF<\/strong><\/em><\/a> l\u1ed3ng nhau, c\u00f4ng th\u1ee9c s\u1ebd tr\u1edf n\u00ean r\u1ea5t ph\u1ee9c t\u1ea1p v\u00e0 d\u00e0i d\u00f2ng. M\u1ed9t trong nh\u1eefng c\u00e1ch tr\u00e1nh \u0111i\u1ec1u \u0111\u00f3, \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-trong-excel-co-vi-du-minh-hoa.html\"><em><strong>h\u00e0m AND<\/strong><\/em><\/a> ho\u1eb7c<em><strong> h\u00e0m OR<\/strong><\/em> thay th\u1ebf v\u00e0 m\u1edf r\u1ed9ng cho logic c\u1ee7a IF.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><em>C\u00e1c \u1ee9ng d\u1ee5ng v\u1edbi b\u1ea3o m\u1eadt 2 l\u1edbp s\u1ebd ki\u1ec3m tra \u0111\u1ed3ng th\u1eddi c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n, ch\u1ec9 khi th\u1ecfa m\u00e3n m\u1edbi hi\u1ec3n th\u1ecb \u201c\u0111\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng\u201d<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25965\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-12.png\" width=\"803\" height=\"266\" title=\"19-tips-if-12\"><\/p>\n<p>Thay v\u00ec s\u1eed d\u1ee5ng IF, ta c\u00f3 th\u1ec3 d\u00f9ng AND \u0111\u1ec3 di\u1ec5n gi\u1ea3i logic nh\u01b0 sau:<\/p>\n<p><em><strong>=IF(AND(A2=1,B2=1),\u201d\u0111\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng\u201d,\u201d\u0111\u0103ng nh\u1eadp th\u1ea5t b\u1ea1i\u201d)<\/strong><\/em><\/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-850.gif\" title=\"ex101_92019-nho-850\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>M\u1edf r\u1ed9ng h\u01a1n, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OR \u0111\u1ec3 m\u1edf r\u1ed9ng \u0111i\u1ec1u ki\u1ec7n:\u00a0<strong>c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u, ch\u1ec9 c\u1ea7n m\u00e3 \u0111\u0103ng nh\u1eadp = 1<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c ta s\u1eed d\u1ee5ng s\u1ebd l\u00e0:<\/p>\n<p><em><strong>=IF(AND(OR(A2=1,A2=0),B2=1),\u201d\u0111\u0103ng nh\u1eadp th\u00e0nh c\u00f4ng\u201d,\u201d\u0111\u0103ng nh\u1eadp th\u1ea5t b\u1ea1i\u201d)<\/strong><\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thay_the_ham_IF_long_nhau_bang_VLOOKUP\"><\/span>Thay th\u1ebf h\u00e0m IF l\u1ed3ng nhau b\u1eb1ng VLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Khi h\u00e0m IF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tham chi\u1ebfu, ta c\u00f3 th\u1ec3 thay th\u1ebf b\u1eb1ng VLOOKUP<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-25966\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-13-1024x365-1.png\" width=\"1024\" height=\"365\" title=\"19-tips-if-13-1024x365-1\"><\/strong><\/p>\n<p>T\u1eeb b\u1ea3ng tr\u00ean, ta c\u00f3 th\u1ec3 thay th\u1ebf th\u00e0nh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25967\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-14.png\" width=\"989\" height=\"366\" title=\"19-tips-if-14\"><\/p>\n<p>\u00a0<\/p>\n<p><em><strong>\u0110\u1ecdc th\u00eam v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">h\u00e0m VLOOKUP<\/a>\u00a0<\/strong><\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_CHOOSE\"><\/span>S\u1eed d\u1ee5ng CHOOSE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u01b0\u01a1ng t\u1ef1 VLOOKUP, trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p ta c\u00f3 th\u1ec3 thay th\u1ebf IF l\u1ed3ng nhau b\u1eb1ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">h\u00e0m CHOOSE<\/a>.<\/strong><\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p ch\u1ecdn ng\u00e0y trong tu\u1ea7n, ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m CHOOSE thay th\u1ebf IF nh\u01b0 sau:<\/p>\n<figure id=\"attachment_25970\" aria-describedby=\"caption-attachment-25970\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25970\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-15.png\" width=\"640\" height=\"327\" title=\"19-tips-if-15\"><figcaption id=\"caption-attachment-25970\" class=\"wp-caption-text\">H\u00e0m IF l\u1ed3ng nhau<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_25971\" aria-describedby=\"caption-attachment-25971\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25971\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-16.png\" width=\"653\" height=\"327\" title=\"19-tips-if-16\"><figcaption id=\"caption-attachment-25971\" class=\"wp-caption-text\">V\u00e0 h\u00e0m CHOOSE<\/figcaption><\/figure>\n<p>D\u00f9ng h\u00e0m n\u00e0o ng\u1eafn h\u01a1n, b\u1ea1n c\u0169ng th\u1ea5y r\u1ed3i \u0111\u1ea5y.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_IFS_thay_cho_IF\"><\/span>S\u1eed d\u1ee5ng IFS thay cho IF<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Excel 2016 ho\u1eb7c 365, h\u00e3y d\u00f9ng IFS. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1edbi \u0111\u01b0\u1ee3c b\u1ed5 sung v\u00e0o gi\u00fap cho vi\u1ec7c \u0111\u1ecdc c\u00f4ng th\u1ee9c trong Excel d\u1ec5 d\u00e0ng h\u01a1n nhi\u1ec1u.<\/p>\n<p><em>Xem t\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-ifs-trong-excel.html\"><strong>h\u00e0m IFS\u00a0<\/strong><\/a><\/em><\/p>\n<figure id=\"attachment_25974\" aria-describedby=\"caption-attachment-25974\" style=\"width: 656px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25974\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-17.png\" width=\"656\" height=\"329\" title=\"19-tips-if-17\"><figcaption id=\"caption-attachment-25974\" class=\"wp-caption-text\">V\u1eabn \u0111\u00fang, v\u00e0 quan tr\u1ecdng l\u00e0: Ch\u1ec9 m\u1ed9t l\u1ea7n m\u1edf \u0111\u00f3ng ngo\u1eb7c t\u1ed5ng.<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_MIN_MAX_thay_cho_IF_long_nhau\"><\/span>S\u1eed d\u1ee5ng MIN MAX thay cho IF l\u1ed3ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng MIN v\u00e0 MAX \u0111\u1ec3 thay th\u1ec3 cho h\u00e0m IF, ho\u1eb7c IF l\u1ed3ng nhau. \u0110\u00f3 l\u00e0 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p nh\u01b0 so s\u00e1nh doanh s\u1ed1, \u0111i\u1ec1u ki\u1ec7n s\u1ed1 l\u01b0\u1ee3ng\u2026<\/p>\n<p>C\u1ee5 th\u1ec3, h\u00e3y \u0111\u1ecdc <strong><a href=\"http:\/\/blog.ezworkapp.com\/dung-ham-max-thay-cho-if.html\">b\u00e0i vi\u1ebft n\u00e0y<\/a>.<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Bay_loi_bang_IFERROR\"><\/span>B\u1eaby l\u1ed7i b\u1eb1ng IFERROR<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1eeb Excel 2007, thay v\u00ec k\u1ebft h\u1ee3p IF v\u1edbi ISERROR \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 n\u1ebfu x\u1ea3y ra l\u1ed7i, gi\u1edd ta \u0111\u00e3 c\u00f3 IFERROR. C\u00f4ng th\u1ee9c n\u00e0y cho ph\u00e9p tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 n\u1ebfu x\u1ea3y ra r\u1ed7i:<\/p>\n<p><em><strong>=IFERROR(c\u00f4ng th\u1ee9c, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu l\u1ed7i)<\/strong><\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_logic_boolen_%E2%80%93_thuat_toan_TRUEFALSE\"><\/span>S\u1eed d\u1ee5ng logic boolen \u2013 thu\u1eadt to\u00e1n TRUE\/FALSE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 tr\u00e1nh vi\u1ec7c s\u1eed d\u1ee5ng IF l\u1ed3ng nhau b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb TRUE\/FALSE thay th\u1ebf. Excel quy \u0111\u1ecbnh TRUE l\u00e0 1, v\u00e0 FALSE l\u00e0 0. V\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_25977\" aria-describedby=\"caption-attachment-25977\" style=\"width: 578px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25977\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-18.png\" width=\"578\" height=\"151\" title=\"19-tips-if-18\"><figcaption id=\"caption-attachment-25977\" class=\"wp-caption-text\">H\u00e0m IF l\u1ed3ng nhau<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25979\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-tips-if-19.png\" width=\"596\" height=\"148\" title=\"19-tips-if-19\"><\/p>\n<p>\u00a0<\/p>\n<h3><\/h3>\n<p>Tuy v\u1eady, kh\u00f4ng th\u1ec3 ph\u1ee7 nh\u1eadn \u0111\u01b0\u1ee3c vai tr\u00f2 c\u1ee7a h\u00e0m IF l\u1ed3ng nhau trong c\u00f4ng vi\u1ec7c b\u1edfi t\u00ednh \u0111\u01a1n gi\u1ea3n, ti\u1ec7n d\u1ee5ng c\u0169ng nh\u01b0 d\u1ec5 d\u00e0ng theo d\u00f5i hay ch\u1ec9nh s\u1eeda c\u1ee7a n\u00f3.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\">H\u00e0m IF l\u1ed3ng gh\u00e9p<\/a>, k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/strong><\/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-850.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9026,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9025","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\/9025","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=9025"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9025\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9026"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}