{"id":7202,"date":"2024-12-21T17:06:41","date_gmt":"2024-12-21T17:06:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel\/"},"modified":"2024-12-21T17:06:41","modified_gmt":"2024-12-21T17:06:41","slug":"cach-ket-hop-ham-vlookup-va-ham-if-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel\/","title":{"rendered":"C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel.html\"><strong>VLOOKUP k\u1ebft h\u1ee3p IF<\/strong><\/a> trong Excel. Ngo\u00e0i ra b\u1ea1n c\u0169ng t\u00ecm th\u1ea5y c\u00e1ch thay l\u1ed7i #N\/A b\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n t\u1ef1 \u0111\u1ecbnh ngh\u0129a.<\/em><\/p>\n<p><em>Trong c\u00e1c ph\u1ea7n tr\u01b0\u1edbc c\u1ee7a lo\u1ea1t b\u00e0i vi\u1ebft v\u1ec1 VLOOKUP, ch\u00fang ta \u0111\u00e3 h\u1ecdc 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\"><strong>h\u00e0m VLOOKUP<\/strong><\/a> c\u01a1 b\u1ea3n v\u00e0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-bi-loi-na-loi-name-loi-value-va-cach-khac-phuc.html\">c\u00e1ch s\u1eeda l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP trong Excel<\/a><\/strong> trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m VLOOKUP v\u1edbi h\u00e0m IF v\u00e0 nh\u1eefng v\u00ed d\u1ee5.<\/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-6766f5a1121f7\" 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\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel.html#Ket_hop_VLOOKUP_va_ham_IF_de_tra_ve_gia_tri_TRUEFALSE_hoac_1_va_0\" title=\"K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0\">K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0<\/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\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel.html#Su_dung_ket_hop_ham_VLOOKUP_va_ham_IF_de_tinh_toan_theo_dieu_kien\" title=\"S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n<\/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\/cach-ket-hop-ham-vlookup-va-ham-if-trong-excel.html#Xu_ly_loi_NA_khi_VLOOKUP_khong_tim_thay_gia_tri_trong_bang\" title=\"X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng\">X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_VLOOKUP_va_ham_IF_de_tra_ve_gia_tri_TRUEFALSE_hoac_1_va_0\"><\/span>K\u1ebft h\u1ee3p VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb TRUE\/FALSE ho\u1eb7c 1 v\u00e0 0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5 1: Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 1 danh s\u00e1ch h\u00e0ng ho\u00e1 trong kho v\u00e0 s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c lo\u1ea1i h\u00e0ng ho\u00e1 n\u00e0y, n\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t ph\u00e2n t\u00edch \u0111\u01a1n gi\u1ea3n b\u1eb1ng vi\u1ec7c \u0111i\u1ec1n v\u00e0o d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng b\u1eb1ng 0 l\u00e0 \u201ch\u1ebft h\u00e0ng\u201d, \u0111i\u1ec1n v\u00e0o d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn h\u01a1n 0 l\u00e0 \u201cc\u00f2n h\u00e0ng\u201d th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft h\u00e0m VLOOKUP k\u1ebft h\u1ee3p v\u1edbi h\u00e0m IF nh\u01b0 sau:<\/p>\n<figure id=\"attachment_31548\" aria-describedby=\"caption-attachment-31548\" style=\"width: 1702px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-ham-if-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-hop-vlookup-va-ham-if-trong-excel.png\" alt=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF trong Excel\" width=\"1702\" height=\"550\" title=\"ket-hop-vlookup-va-ham-if-trong-excel\"><\/a><figcaption id=\"caption-attachment-31548\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF trong Excel<\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c tr\u00ean tra c\u1ee9u s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a s\u1ea3n ph\u1ea9m Nho, sau \u0111\u00f3 so s\u00e1nh k\u1ebft qu\u1ea3 n\u00e0y n\u1ebfu l\u1edbn h\u01a1n 0 th\u00ec h\u00e0m IF s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 \u201cC\u00f2n h\u00e0ng\u201d, n\u1ebfu kh\u00f4ng k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 \u201cH\u1ebft h\u00e0ng\u201d<\/p>\n<p>Xem th\u00eam: <strong>S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/vlookup-nhieu-cot-nhieu-dieu-kien.html\">h\u00e0m vlookup c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a> trong Excel<\/strong><\/p>\n<p>V\u00ed d\u1ee5 2: Trong t\u00ecnh h\u00ecnh th\u1ecb tr\u01b0\u1eddng c\u00f3 bi\u1ebfn \u0111\u1ed9ng, ch\u00fang ta s\u1ebd c\u1ea7n c\u00f3 m\u1ee9c thi\u1ebft l\u1eadp t\u1ed3n kho an to\u00e0n kh\u00e1c nhau tu\u1ef3 theo t\u1eebng th\u1eddi \u0111i\u1ec3m, gi\u1ea3 s\u1eed trong th\u1eddi \u0111i\u1ec3m \u0111\u1ea7u n\u0103m, m\u1ee9c t\u1ed3n kho an to\u00e0n c\u1ee7a ch\u00fang ta \u0111\u01b0\u1ee3c l\u01b0u trong \u00f4 G1 l\u00e0 15 \u0111\u01a1n v\u1ecb s\u1ea3n ph\u1ea9m. Ch\u00fang ta mu\u1ed1n ki\u1ec3m tra s\u1ea3n ph\u1ea9m \u201cT\u00e1o\u201d c\u1ee7a ch\u00fang ta c\u00f3 tr\u1ea1ng th\u00e1i t\u1ed3n kho nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 trong h\u00ecnh minh ho\u1ea1.<\/p>\n<figure id=\"attachment_31549\" aria-describedby=\"caption-attachment-31549\" style=\"width: 1810px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-if-kiem-tra-ton-kho.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-hop-vlookup-va-if-kiem-tra-ton-kho.png\" alt=\"Ki\u1ec3m tra t\u1ed3n kho an to\u00e0n v\u1edbi VLOOKUP v\u00e0 h\u00e0m IF\" width=\"1810\" height=\"548\" title=\"ket-hop-vlookup-va-if-kiem-tra-ton-kho\"><\/a><figcaption id=\"caption-attachment-31549\" class=\"wp-caption-text\">Ki\u1ec3m tra t\u1ed3n kho an to\u00e0n v\u1edbi VLOOKUP v\u00e0 h\u00e0m IF<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5 3: Ch\u00fang ta c\u00f3 2 danh s\u00e1ch: danh s\u00e1ch h\u00e0ng ho\u00e1 trong kho v\u00e0 danh s\u00e1ch h\u00e0ng \u0111\u1ee7 ti\u00eau chu\u1ea9n xu\u1ea5t kh\u1ea9u, v\u1eady l\u00e0m sao \u0111\u1ec3 so s\u00e1nh 2 danh s\u00e1ch n\u00e0y v\u1edbi nhau v\u00e0 \u0111\u00e1nh d\u1ea5u m\u1eb7t h\u00e0ng n\u00e0o trong kho \u0111\u1ee7 ti\u00eau chu\u1ea9n xu\u1ea5t kh\u1ea9u? Ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u1edbi h\u00e0m IF v\u00e0 h\u00e0m ISNA nh\u01b0 trong h\u00ecnh minh ho\u1ea1 nh\u01b0 sau<\/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-651.gif\" title=\"ex101_92019-nho-651\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_31551\" aria-describedby=\"caption-attachment-31551\" style=\"width: 1876px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-ham-if-isna-vlookup-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31551\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-hop-ham-if-isna-vlookup-trong-excel.png\" alt=\"K\u1ebft h\u1ee3p h\u00e0m VLOOKUP, IF, ISNA\" width=\"1876\" height=\"548\" title=\"ket-hop-ham-if-isna-vlookup-trong-excel\"><\/a><figcaption id=\"caption-attachment-31551\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m VLOOKUP, IF, ISNA<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ket_hop_ham_VLOOKUP_va_ham_IF_de_tinh_toan_theo_dieu_kien\"><\/span>S\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IF \u0111\u1ec3 t\u00ednh to\u00e1n theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u00ed d\u1ee5 4: Gi\u1ea3 s\u1eed b\u1ea1n qu\u1ea3n l\u00fd 1 \u0111\u1ed9i nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng, c\u01a1 c\u1ea5u hoa h\u1ed3ng cho nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng c\u1ee7a b\u1ea1n r\u1ea5t \u0111\u01a1n gi\u1ea3n: n\u1ebfu doanh thu \u0111\u1ea1t \u0111\u01b0\u1ee3c &gt; 200 th\u00ec hoa h\u1ed3ng l\u00e0 10% c\u1ee7a doanh thu, n\u1ebfu doanh thu \u0111\u1ea1t \u0111\u01b0\u1ee3c &lt;= 200 th\u00ec hoa h\u1ed3ng l\u00e0 5% c\u1ee7a doanh thu \u0111\u00f3. B\u00e0i to\u00e1n n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch l\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 h\u00e0m VLOOKUP nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<figure id=\"attachment_31553\" aria-describedby=\"caption-attachment-31553\" style=\"width: 1308px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/long-ghep-ham-if-va-ham-vlookup.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31553\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/long-ghep-ham-if-va-ham-vlookup.png\" alt=\"L\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 VLOOKUP \u0111\u1ec3 t\u00ednh hoa h\u1ed3ng\" width=\"1308\" height=\"792\" title=\"long-ghep-ham-if-va-ham-vlookup\"><\/a><figcaption id=\"caption-attachment-31553\" class=\"wp-caption-text\">L\u1ed3ng gh\u00e9p h\u00e0m IF v\u00e0 VLOOKUP \u0111\u1ec3 t\u00ednh hoa h\u1ed3ng<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Xu_ly_loi_NA_khi_VLOOKUP_khong_tim_thay_gia_tri_trong_bang\"><\/span>X\u1eed l\u00fd l\u1ed7i #NA khi VLOOKUP kh\u00f4ng t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb trong b\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm ki\u1ebfm kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y khi s\u1eed d\u1ee5ng h\u00e0m VLOOKUP th\u00ec ch\u00fang ta s\u1ebd nh\u1eadn l\u1ea1i k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i #N\/A. \u0110\u1ec3 \u0111\u01b0a ra m\u1ed9t th\u00f4ng b\u00e1o c\u00f3 \u00fd ngh\u0129a h\u01a1n cho ng\u01b0\u1eddi d\u00f9ng, ch\u00fang ta c\u00f3 c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m VLOOKUP v\u00e0 h\u00e0m IFNA th\u1ec3 x\u1eed l\u00fd l\u1ed7i #N\/A b\u1eb1ng c\u00e1ch \u0111\u01b0a ra gi\u00e1 tr\u1ecb thay th\u1ebf nh\u01b0 sau.<\/p>\n<p><code class=\"excel-formula\">=IFNA(value, value_if_na)<\/code><\/p>\n<ul style=\"list-style-type: square\">\n<li>tham s\u1ed1 <em>value<\/em> c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c, m\u1ed9t s\u1ed1, m\u1ed9t \u0111\u1ecba ch\u1ec9 \u00f4 trong Excel<\/li>\n<li>tham s\u1ed1\u00a0<em>value_if_na\u00a0<\/em>l\u00e0 gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 l\u1ed7i #N\/A<\/li>\n<\/ul>\n<figure id=\"attachment_31555\" aria-describedby=\"caption-attachment-31555\" style=\"width: 1310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/ket-hop-vlookup-va-ifna-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31555\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-hop-vlookup-va-ifna-1.png\" alt=\"C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m vlookup v\u00e0 ifna\" width=\"1310\" height=\"736\" title=\"ket-hop-vlookup-va-ifna-1\"><\/a><figcaption id=\"caption-attachment-31555\" class=\"wp-caption-text\">C\u00e1ch k\u1ebft h\u1ee3p h\u00e0m vlookup v\u00e0 ifna<\/figcaption><\/figure>\n<p><em>B\u00e0i h\u01b0\u1edbng d\u1eabn h\u00e0m <strong>Vlookup k\u1ebft h\u1ee3p If<\/strong> \u0111\u00e3 kh\u00e9p l\u1ea1i bu\u1ed5i chia s\u1ebb h\u00f4m nay. T\u1ea1m bi\u1ec7t v\u00e0 ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.\u00a0<\/em><\/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-651.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7203,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7202","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\/7202","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=7202"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7202\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7203"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}