{"id":10597,"date":"2025-01-14T16:30:23","date_gmt":"2025-01-14T16:30:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-loi-n-a-trong-excel-va-cach-khac-phuc\/"},"modified":"2025-01-14T16:30:23","modified_gmt":"2025-01-14T16:30:23","slug":"tim-hieu-ve-loi-n-a-trong-excel-va-cach-khac-phuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tim-hieu-ve-loi-n-a-trong-excel-va-cach-khac-phuc\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #N\/A trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Khi\u00a0l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u00f4i khi b\u1ea1n b\u1eaft g\u1eb7p l\u1ed7i #N\/A. V\u1eady l\u1ed7i n\u00e0y l\u00e0 g\u00ec, c\u00f3 \u00fd ngh\u0129a g\u00ec, nguy\u00ean nh\u00e2n t\u1ea1i sao l\u1ea1i ra l\u1ed7i n\u00e0y, c\u00e1ch kh\u1eafc ph\u1ee5c v\u00e0 s\u1eeda l\u1ed7i n\u00e0y th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #N\/A trong\u00a0Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u00e9.<\/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-6786911e43c5c\" 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\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html#1_Y_nghia_cua_loi_NA_trong_Excel\" title=\"1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i #N\/A trong\u00a0Excel\">1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i #N\/A trong\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html#2_Giai_thich_co_che_hoat_dong_cua_loi\" title=\"2. Gi\u1ea3i th\u00edch c\u01a1 ch\u1ebf ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a l\u1ed7i\">2. Gi\u1ea3i th\u00edch c\u01a1 ch\u1ebf ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a l\u1ed7i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html#3_Cach_khac_phuc_loi_NA_trong_Excel\" title=\"3. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i N\/A trong Excel\">3. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i N\/A trong Excel<\/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\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html#4_Mot_so_truong_hop_dac_biet\" title=\"4. M\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p\u00a0\u0111\u1eb7c bi\u1ec7t\">4. M\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p\u00a0\u0111\u1eb7c bi\u1ec7t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Y_nghia_cua_loi_NA_trong_Excel\"><\/span>1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i #N\/A trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17561\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-loi-na-excel-01.png\" width=\"944\" height=\"226\" title=\"heo-loi-na-excel-01\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean, ch\u00fang ta th\u1ea5y\u00a0\u00f4 F2 v\u00e0 F3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Vlookup v\u00e0 ra l\u1ed7i l\u00e0 #N\/A<\/p>\n<p>N\/A trong ti\u1ebfng anh\u00a0\u0111\u01b0\u1ee3c vi\u1ebft t\u1eaft l\u00e0 Not Available = Kh\u00f4ng t\u1ed3n t\u1ea1i, kh\u00f4ng c\u00f3 s\u1eb5n<\/p>\n<p>Do\u00a0\u0111\u00f3 l\u1ed7i n\u00e0y\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 trong c\u00f4ng th\u1ee9c b\u1ea1n s\u1eed d\u1ee5ng c\u00f3 ch\u1ee9a n\u1ed9i dung\u00a0kh\u00f4ng c\u00f3 s\u1eb5n trong v\u00f9ng d\u1eef li\u1ec7u, d\u1eabn t\u1edbi kh\u00f4ng th\u1ec3 t\u00ednh to\u00e1n, ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m d\u00f2 t\u00ecm, tham chi\u1ebfu.\u00a0\u0110\u1ed1i t\u01b0\u1ee3ng c\u1ea7n d\u00f2 t\u00ecm, tham chi\u1ebfu kh\u00f4ng c\u00f3 s\u1eb5n trong v\u00f9ng c\u1ea7n tra c\u1ee9u n\u00ean b\u00e1o l\u1ed7i #N\/A<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Giai_thich_co_che_hoat_dong_cua_loi\"><\/span>2. Gi\u1ea3i th\u00edch c\u01a1 ch\u1ebf ho\u1ea1t\u00a0\u0111\u1ed9ng c\u1ee7a l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta th\u1ea5y t\u1ea1i\u00a0\u00f4 F2 v\u00e0 F3\u00a0\u0111\u1ec1u tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A, trong\u00a0\u0111\u00f3:<\/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\/2025\/01\/ex101_92019-nho-195.gif\" title=\"ex101_92019-nho-195\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>H\u00e0m Vlookup t\u1ea1i\u00a0\u00f4 F2 c\u00f3\u00a0lookup_value l\u00e0 n\u1ed9i dung\u00a0\u1edf\u00a0\u00f4 E2, n\u1ed9i dung n\u00e0y kh\u00f4ng t\u1ed3n t\u1ea1i trong v\u00f9ng B2:B15<\/li>\n<li>H\u00e0m Vlookup t\u1ea1i\u00a0\u00f4 F3 t\u01b0\u01a1ng t\u1ef1n nh\u01b0 F2 v\u1ec1 lookup_value nh\u01b0ng col_index_num c\u0169ng sai. Trong\u00a0\u00f4 F3 n\u00e0y c\u00f3 t\u1edbi 2 l\u1ed7i #N\/A v\u00e0 #REF! nh\u01b0ng k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 #N\/A<\/li>\n<\/ul>\n<p>\u0110\u1ec3 ki\u1ec3m tra xem gi\u00e1 tr\u1ecb\u00a0\u1edf\u00a0\u00f4 E2 c\u00f3 n\u1eb1m trong v\u00f9ng B2:B15 kh\u00f4ng, ch\u00fang ta ki\u1ec3m tra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF t\u1ea1i\u00a0\u00f4 F4 th\u1ea5y k\u1ebft qu\u1ea3 = 0.\u00a0\u0110i\u1ec1u\u00a0\u0111\u00f3 ch\u1ee9ng t\u1ecf n\u1ed9i dung\u00a0\u1edf\u00a0\u00f4 E2 kh\u00f4ng c\u00f3 (kh\u00f4ng t\u1ed3n t\u1ea1i) trong danh s\u00e1ch c\u1ea7n t\u00ecm.<\/p>\n<p>C\u01a1 ch\u1ebf hi\u1ec3n th\u1ecb l\u1ed7i: Theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i sang. T\u1ea1i v\u1ecb tr\u00ed n\u00e0o ph\u00e1t hi\u1ec7n ra l\u1ed7i tr\u01b0\u1edbc th\u00ec s\u1ebd b\u00e1o theo l\u1ed7i\u00a0\u0111\u00f3.<\/p>\n<p>Khi s\u1eed d\u1ee5ng c\u00e1c h\u00e0m d\u00f2 t\u00ecm, tham chi\u1ebfu c\u00f3 ch\u1ee9a\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng lookup_value th\u00ec ch\u00fang ta l\u01b0u\u00a0\u00fd r\u1eb1ng c\u00f3 th\u1ec3 x\u1ea3y ra l\u1ed7i #N\/A. C\u00e1c h\u00e0m\u00a0\u0111\u00f3 l\u00e0: Lookup, Vlookup, Hlookup, Match<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_khac_phuc_loi_NA_trong_Excel\"><\/span>3. C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i N\/A trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1edfi v\u00ec l\u1ed7i #N\/A\u00a0kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i sai h\u00e0m, sai c\u00f4ng th\u1ee9c m\u00e0 ch\u1ec9 l\u00e0 kh\u00f4ng t\u00ecm th\u1ea5y\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm. Do\u00a0\u0111\u00f3 c\u00e1ch kh\u1eafc ph\u1ee5c th\u01b0\u1eddng d\u00f9ng l\u00e0\u00a0bi\u1ec7n lu\u1eadn tr\u01b0\u1edbc tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng t\u00ecm th\u1ea5y\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ecm. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y th\u00ec tr\u1ea3 v\u1ec1 r\u1ed7ng ch\u1ee9 kh\u00f4ng th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c.<\/p>\n<p><strong>C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu <strong>lookup_value<\/strong> kh\u00f4ng t\u1ed3n t\u1ea1i (l\u00e0 1\u00a0\u00f4 tr\u1ed1ng) th\u00ec tr\u1ea3 v\u1ec1 r\u1ed7ng ngay, kh\u00f4ng c\u1ea7n t\u1edbi c\u00f4ng th\u1ee9c (v\u00ed d\u1ee5: \u00f4 F8 s\u1ebd tr\u00e1nh \u0111\u01b0\u1ee3c l\u1ed7i)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-loi-na-excel-02.png\" width=\"1010\" height=\"454\" title=\"heo-loi-na-excel-02\"><\/p>\n<ul>\n<li>Ki\u1ec3m\u00a0tra xem n\u1ebfu <strong>lookup_value<\/strong> kh\u00f4ng t\u1ed3n t\u1ea1i th\u00ec s\u1ebd th\u00f4ng b\u00e1o ngay r\u1eb1ng Gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm kh\u00f4ng t\u1ed3n t\u1ea1i thay v\u00ec s\u1eed d\u1ee5ng ngay c\u00f4ng th\u1ee9c (\u00f4 F9 b\u00e1o k\u1ebft qu\u1ea3 l\u00e0 Kh\u00f4ng t\u1ed3n t\u1ea1i thay cho l\u1ed7i #N\/A)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17563\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-loi-na-excel-03.png\" width=\"1217\" height=\"452\" title=\"heo-loi-na-excel-03\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Mot_so_truong_hop_dac_biet\"><\/span>4. M\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p\u00a0\u0111\u1eb7c bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i ra c\u00f2n 1 v\u1ea5n\u00a0\u0111\u1ec1 n\u1eefa g\u00e2y l\u1ed7i #N\/A m\u00e0 ng\u01b0\u1eddi d\u00f9ng kh\u00f3 nh\u1eadn ra\u00a0\u0111\u00f3 l\u00e0: D\u1eef li\u1ec7u c\u1ea7n t\u00ecm tuy\u00a0nh\u00ecn b\u1eb1ng m\u1eaft th\u01b0\u1eddng gi\u1ed1ng nhau nh\u01b0ng th\u1ef1c ch\u1ea5t l\u1ea1i kh\u00e1c nhau v\u1ec1 d\u1ea1ng d\u1eef li\u1ec7u.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17564\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/heo-loi-na-excel-04.png\" width=\"747\" height=\"128\" title=\"heo-loi-na-excel-04\"><\/p>\n<p>V\u1edbi tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta kh\u00f4ng n\u00ean nh\u00ecn b\u1eb1ng m\u1eaft th\u01b0\u1eddng m\u00e0 ph\u1ea3i ki\u1ec3m tra l\u1ea1i v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u xem\u00a0\u0111\u00e3 c\u00f9ng lo\u1ea1i ch\u01b0a. N\u1ebfu d\u1eef li\u1ec7u\u00a0\u1edf Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (<strong>lookup_value<\/strong>) l\u00e0 d\u1ea1ng <strong>Text<\/strong> trong khi d\u1eef li\u1ec7u\u00a0\u1edf b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n tra c\u1ee9u l\u00e0 d\u1ea1ng <strong>Date<\/strong> th\u00ec s\u1ebd c\u00f3 l\u1ed7i <strong>#N\/A<\/strong><\/p>\n<p>Ki\u1ec3m tra l\u1ea1i xem c\u00f3 th\u1eeba k\u00fd t\u1ef1 kh\u00f4ng, b\u1edfi vi\u1ec7c th\u1eeba k\u00fd t\u1ef1 c\u0169ng d\u1eabn t\u1edbi l\u1ed7i kh\u00f4ng\u00a0\u0111\u1ed3ng nh\u1ea5t d\u1eef li\u1ec7u, g\u00e2y ra l\u1ed7i kh\u00f4ng t\u1ed3n t\u1ea1i d\u1eef li\u1ec7u c\u1ea7n t\u00ecm.<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c s\u1eeda l\u1ed7i #N\/A<\/strong><\/p>\n<ul>\n<li>Format d\u1eef li\u1ec7u v\u1ec1 c\u00f9ng 1 lo\u1ea1i, bao g\u1ed3m c\u1ea3\u00a0\u1edf b\u1ea3ng d\u1eef li\u1ec7u v\u00e0\u00a0\u1edf gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/li>\n<li>Ki\u1ec3m tra l\u1ea1i k\u00fd t\u1ef1\u00a0\u1edf v\u00f9ng gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm xem c\u00f3 k\u00fd t\u1ef1 th\u1eeba kh\u00f4ng<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m <strong>COUNTIF\u00a0<\/strong>\u0111\u1ec3 ki\u1ec3m tra s\u1ef1\u00a0t\u1ed3n t\u1ea1i c\u1ee7a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm trong v\u00f9ng t\u00ecm ki\u1ebfm<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 y\u00ean t\u00e2m l\u00e0m vi\u1ec7c v\u1edbi\u00a0Excel m\u00e0 kh\u00f4ng c\u00f2n s\u1ee3 l\u1ed7i #N\/A n\u1eefa r\u1ed3i<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam b\u00e0i<strong> <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loi-na-trong-excel.html\">h\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i #NA<\/a> <\/strong>th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 t\u1ea1i b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/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\/2025\/01\/ex101_92019-nho-195.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10598,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10597","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\/10597","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=10597"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10597\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10598"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}