{"id":18166,"date":"2026-04-17T14:57:50","date_gmt":"2026-04-17T07:57:50","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=18166"},"modified":"2026-05-07T16:22:51","modified_gmt":"2026-05-07T09:22:51","slug":"ham-or-trong-excel","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/goc-ky-nang\/ham-or-trong-excel","title":{"rendered":"H\u00e0m OR trong Excel: C\u00fa ph\u00e1p chi ti\u1ebft, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p IF hi\u1ec7u qu\u1ea3"},"content":{"rendered":"\n

Trong nh\u00f3m h\u00e0m logic c\u1ee7a Excel, h\u00e0m OR<\/strong> \u0111\u00f3ng vai tr\u00f2 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac v\u00e0 tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u s\u1eed d\u1ee5ng h\u00e0ng ng\u00e0y khi c\u1ea7n l\u1ecdc, ph\u00e2n lo\u1ea1i ho\u1eb7c \u0111\u00e1nh gi\u00e1 nhi\u1ec1u ti\u00eau ch\u00ed song song. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y h\u01b0\u1edbng d\u1eabn c\u00fa ph\u00e1p, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 c\u00e1c c\u00e1ch k\u1ebft h\u1ee3p ph\u1ed5 bi\u1ebfn \u0111\u1ec3 b\u1ea1n \u00e1p d\u1ee5ng ngay v\u00e0o c\u00f4ng vi\u1ec7c.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n

T\u1ed5ng quan nhanh v\u1ec1 h\u00e0m OR<\/strong><\/p>\n

<\/p>\n

\u2013 Ch\u1ee9c n\u0103ng: tr\u1ea3 v\u1ec1 TRUE n\u1ebfu B\u1ea4T K\u1ef2 \u0111i\u1ec1u ki\u1ec7n n\u00e0o trong danh s\u00e1ch l\u00e0 \u0111\u00fang, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 FALSE.<\/p>\n

<\/p>\n

\u2013 C\u00fa ph\u00e1p: =OR(logical1, logical2, \u2026)<\/p>\n

<\/p>\n

\u2013 S\u1ed1 \u0111i\u1ec1u ki\u1ec7n t\u1ed1i \u0111a: 255 (Excel 2007 tr\u1edf l\u00ean).<\/p>\n

<\/p>\n

\u2013 Th\u01b0\u1eddng d\u00f9ng k\u1ebft h\u1ee3p v\u1edbi IF, AND, NOT \u0111\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p.<\/p>\n<\/div>\n\n\n\n

1. C\u00fa ph\u00e1p h\u00e0m OR trong Excel<\/h2>\n\n\n\n

C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m OR r\u1ea5t \u0111\u01a1n gi\u1ea3n: `=OR(logical1, [logical2], \u2026)`. Trong \u0111\u00f3, `logical1` l\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1eaft bu\u1ed9c, c\u00e1c `logical2`, `logical3`\u2026 l\u00e0 t\u00f9y ch\u1ecdn. M\u1ed7i \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE.<\/p>\n\n\n\n

Khi th\u1ef1c thi, Excel s\u1ebd ki\u1ec3m tra t\u1eebng \u0111i\u1ec1u ki\u1ec7n theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00e1i sang ph\u1ea3i. N\u1ebfu g\u1eb7p b\u1ea5t k\u1ef3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o TRUE, h\u00e0m d\u1eebng l\u1ea1i v\u00e0 tr\u1ea3 TRUE ngay l\u1eadp t\u1ee9c (short-circuit evaluation). Ch\u1ec9 khi t\u1ea5t c\u1ea3 \u0111\u1ec1u FALSE, h\u00e0m m\u1edbi tr\u1ea3 FALSE. \u0110\u00e2y l\u00e0 \u0111i\u1ec3m kh\u00e1c bi\u1ec7t c\u1ed1t l\u00f5i so v\u1edbi h\u00e0m AND \u2013 v\u1ed1n y\u00eau c\u1ea7u T\u1ea4T C\u1ea2 \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i TRUE.<\/p>\n\n\n\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd k\u1ef9 thu\u1eadt: h\u00e0m OR kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa\/th\u01b0\u1eddng khi so s\u00e1nh chu\u1ed7i; gi\u00e1 tr\u1ecb s\u1ed1 0 \u0111\u01b0\u1ee3c coi l\u00e0 FALSE, m\u1ecdi s\u1ed1 kh\u00e1c 0 l\u00e0 TRUE; \u00f4 tr\u1ed1ng \u0111\u01b0\u1ee3c b\u1ecf qua, kh\u00f4ng g\u00e2y l\u1ed7i.<\/p>\n\n\n\n

\n

\u201cH\u00e0m OR gi\u1ed1ng nh\u01b0 \u2018ho\u1eb7c\u2019 trong ng\u00f4n ng\u1eef h\u00e0ng ng\u00e0y: n\u1ebfu m\u1ed9t trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang th\u00ec k\u1ebft lu\u1eadn \u0111\u00fang. \u0110\u01a1n gi\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch khi l\u1ecdc d\u1eef li\u1ec7u \u0111a ti\u00eau ch\u00ed.\u201d \u2013 Quan \u0111i\u1ec3m ph\u1ed5 bi\u1ebfn trong c\u1ed9ng \u0111\u1ed3ng Excel Vi\u1ec7t Nam.<\/p>\n<\/blockquote>\n\n\n\n

2. V\u00ed d\u1ee5 th\u1ef1c t\u1ebf h\u00e0m OR<\/h2>\n\n\n\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, \u00e1p d\u1ee5ng trong c\u00e1c t\u00ecnh hu\u1ed1ng v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n ph\u1ed5 bi\u1ebfn.<\/p>\n\n\n\n

T\u00ecnh hu\u1ed1ng<\/th>C\u00f4ng th\u1ee9c<\/th>Gi\u1ea3i th\u00edch<\/th><\/tr><\/thead>
Ki\u1ec3m tra nh\u00e2n vi\u00ean thu\u1ed9c ph\u00f2ng Marketing HO\u1eb6C Sales<\/td>=OR(B2=\u201dMarketing\u201d, B2=\u201dSales\u201d)<\/td>TRUE n\u1ebfu \u00f4 B2 l\u00e0 \u201cMarketing\u201d ho\u1eb7c \u201cSales\u201d<\/td><\/tr>
Ki\u1ec3m tra \u0111i\u1ec3m \u2265 8 HO\u1eb6C c\u00f3 ch\u1ee9ng ch\u1ec9<\/td>=OR(C2>=8, D2=\u201dC\u00f3\u201d)<\/td>TRUE n\u1ebfu \u0111i\u1ec3m \u2265 8 ho\u1eb7c c\u1ed9t D ghi \u201cC\u00f3\u201d<\/td><\/tr>
K\u1ebft h\u1ee3p IF: ph\u00e2n lo\u1ea1i \u201c\u0110\u1ea1t\u201d \/ \u201cCh\u01b0a \u0111\u1ea1t\u201d<\/td>=IF(OR(C2>=8, D2=\u201dC\u00f3\u201d), \u201c\u0110\u1ea1t\u201d, \u201cCh\u01b0a \u0111\u1ea1t\u201d)<\/td>N\u1ebfu \u00edt nh\u1ea5t 1 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u2192 \u201c\u0110\u1ea1t\u201d<\/td><\/tr>
K\u1ebft h\u1ee3p AND: c\u1ea7n \u00edt nh\u1ea5t 1 HO\u1eb6C + th\u00eam 1 \u0111i\u1ec1u ki\u1ec7n b\u1eaft bu\u1ed9c<\/td>=IF(AND(OR(B2=\u201dHN\u201d,B2=\u201dHCM\u201d), C2>=5), \u201cOK\u201d, \u201cKO\u201d)<\/td>(\u1edf HN ho\u1eb7c HCM) V\u00c0 (\u0111i\u1ec3m \u2265 5) \u2192 \u201cOK\u201d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

V\u00ed d\u1ee5 th\u1ee9 4 cho th\u1ea5y s\u1ee9c m\u1ea1nh th\u1ef1c s\u1ef1 c\u1ee7a OR khi l\u1ed3ng trong AND v\u00e0 IF: b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c b\u1ed9 l\u1ecdc \u0111a t\u1ea7ng m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng VBA hay Power Query. Trong th\u1ef1c t\u1ebf, ki\u1ec3u c\u00f4ng th\u1ee9c n\u00e0y th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean \u0111\u1ea1t KPI theo nhi\u1ec1u ti\u00eau ch\u00ed khu v\u1ef1c + hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n

L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m OR<\/h3>\n\n\n\n

\u2013 Qu\u00ean \u0111\u00f3ng ngo\u1eb7c khi l\u1ed3ng nhi\u1ec1u h\u00e0m \u2192 l\u1ed7i `#NAME?` ho\u1eb7c `#VALUE!`.<\/p>\n\n\n\n

\u2013 D\u00f9ng d\u1ea5u ph\u1ea9y (`,`) thay v\u00ec ch\u1ea5m ph\u1ea9y (`;`) tr\u00ean m\u00e1y c\u00e0i \u0111\u1eb7t ti\u1ebfng Vi\u1ec7t \u2192 sai c\u00fa ph\u00e1p.<\/p>\n\n\n\n

\u2013 So s\u00e1nh chu\u1ed7i c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba \u2192 d\u00f9ng TRIM tr\u01b0\u1edbc khi so s\u00e1nh.<\/p>\n\n\n\n

\u2013 Tr\u1ed9n ki\u1ec3u d\u1eef li\u1ec7u (s\u1ed1 vs text) trong c\u00f9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u2192 k\u1ebft qu\u1ea3 sai b\u1ea5t ng\u1edd.<\/p>\n\n\n\n

N\u1ebfu mu\u1ed1n luy\u1ec7n t\u1eadp th\u00eam c\u00e1c h\u00e0m Excel ph\u1ed5 bi\u1ebfn kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft c\u00e1c h\u00e0m trong Excel th\u00f4ng d\u1ee5ng d\u00e0nh cho nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng<\/a>.<\/p>\n\n\n\n

3. K\u1ebft h\u1ee3p h\u00e0m OR v\u1edbi IF, AND, NOT<\/h2>\n\n\n\n

H\u00e0m OR hi\u1ebfm khi \u0111\u1ee9ng m\u1ed9t m\u00ecnh \u2013 s\u1ee9c m\u1ea1nh th\u1eadt s\u1ef1 n\u1eb1m \u1edf c\u00e1ch k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m logic kh\u00e1c.<\/p>\n\n\n\n

\n

L\u01b0u \u00fd quan tr\u1ecdng khi l\u1ed3ng h\u00e0m<\/strong><\/p>\n

<\/p>\n

\u2013 Excel cho ph\u00e9p l\u1ed3ng t\u1ed1i \u0111a 64 c\u1ea5p h\u00e0m (t\u1eeb Excel 2007). N\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 ph\u1ee9c t\u1ea1p, n\u00ean t\u00e1ch th\u00e0nh c\u1ed9t ph\u1ee5 \u0111\u1ec3 d\u1ec5 b\u1ea3o tr\u00ec.<\/p>\n

<\/p>\n

\u2013 Khi k\u1ebft h\u1ee3p OR + AND, lu\u00f4n \u0111\u1eb7t OR b\u00ean trong AND (ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i) ch\u1ee9 kh\u00f4ng \u0111\u1eb7t ngang h\u00e0ng \u2013 s\u1ebd g\u00e2y hi\u1ec3u sai logic.<\/p>\n

<\/p>\n

\u2013 D\u00f9ng Evaluate Formula (Formulas \u2192 Evaluate Formula) \u0111\u1ec3 debug t\u1eebng b\u01b0\u1edbc khi k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang.<\/p>\n<\/div>\n\n\n\n

OR + IF<\/strong> l\u00e0 c\u1eb7p \u0111\u00f4i ph\u1ed5 bi\u1ebfn nh\u1ea5t: `=IF(OR(conditions), value_if_true, value_if_false)`. D\u00f9ng khi b\u1ea1n mu\u1ed1n g\u00e1n nh\u00e3n ho\u1eb7c t\u00ednh gi\u00e1 tr\u1ecb kh\u00e1c nhau d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u201cho\u1eb7c\u201d.<\/p>\n\n\n\n

OR + AND + IF<\/strong> t\u1ea1o logic ph\u1ee9c t\u1ea1p h\u01a1n: `=IF(AND(OR(A,B), C), X, Y)` \u2013 ngh\u0129a l\u00e0 \u201c(A ho\u1eb7c B) V\u00c0 C ph\u1ea3i \u0111\u00fang th\u00ec m\u1edbi X\u201d. R\u1ea5t ph\u1ed5 bi\u1ebfn trong b\u1ea3ng ch\u1ea5m c\u00f4ng, ph\u00e2n lo\u1ea1i KPI, x\u00e9t duy\u1ec7t h\u1ed3 s\u01a1.<\/p>\n\n\n\n

OR + NOT<\/strong> \u0111\u1ec3 \u0111\u1ea3o logic: `=NOT(OR(A,B))` tr\u1ea3 TRUE khi C\u1ea2 A L\u1eaaN B \u0111\u1ec1u FALSE \u2013 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng `=AND(NOT(A), NOT(B))`. D\u00f9ng khi c\u1ea7n lo\u1ea1i tr\u1eeb nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p c\u00f9ng l\u00fac.<\/p>\n\n\n\n

V\u1edbi Excel 365 v\u00e0 Excel 2021, b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf OR l\u1ed3ng ph\u1ee9c t\u1ea1p b\u1eb1ng h\u00e0m IFS, SWITCH ho\u1eb7c LAMBDA \u0111\u1ec3 code g\u1ecdn h\u01a1n. Tuy nhi\u00ean, OR v\u1eabn l\u00e0 h\u00e0m n\u1ec1n t\u1ea3ng m\u00e0 m\u1ecdi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng n\u00ean th\u00e0nh th\u1ea1o tr\u01b0\u1edbc khi h\u1ecdc c\u00e1c c\u00f4ng c\u1ee5 m\u1edbi.<\/p>\n\n\n\n

N\u1ebfu b\u1ea1n \u0111ang t\u00ecm vi\u1ec7c trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n \u2013 v\u0103n ph\u00f2ng \u0111\u00f2i h\u1ecfi k\u1ef9 n\u0103ng Excel, c\u00f3 th\u1ec3 xem chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \u2013 ki\u1ec3m to\u00e1n<\/a> \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu y\u00eau c\u1ea7u nh\u00e0 tuy\u1ec3n d\u1ee5ng.<\/p>\n\n\n\n

\n

L\u1eddi khuy\u00ean \u0111\u1ec3 th\u00e0nh th\u1ea1o h\u00e0m OR<\/strong><\/p>\n

<\/p>\n

\u2013 B\u1eaft \u0111\u1ea7u v\u1edbi c\u00f4ng th\u1ee9c OR \u0111\u01a1n gi\u1ea3n (2 \u0111i\u1ec1u ki\u1ec7n), sau \u0111\u00f3 n\u00e2ng d\u1ea7n l\u00ean 3\u20134 \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p IF.<\/p>\n

<\/p>\n

\u2013 T\u1eadp \u0111\u1ecdc c\u00f4ng th\u1ee9c t\u1eeb trong ra ngo\u00e0i: x\u00e1c \u0111\u1ecbnh OR tr\u01b0\u1edbc, r\u1ed3i IF b\u1ecdc ngo\u00e0i.<\/p>\n

<\/p>\n

\u2013 Lu\u00f4n test tr\u00ean 3\u20135 d\u00f2ng m\u1eabu tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<\/div>\n\n\n\n

4. \u1ee8ng d\u1ee5ng h\u00e0m OR trong th\u1ef1c t\u1ebf c\u00f4ng vi\u1ec7c<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

H\u00e0m OR kh\u00f4ng ch\u1ec9 xu\u1ea5t hi\u1ec7n trong b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n m\u00e0 c\u00f2n l\u00e0 c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng qu\u1ea3n l\u00fd d\u1eef li\u1ec7u th\u1ef1c t\u1ebf t\u1ea1i doanh nghi\u1ec7p.<\/p>\n\n\n\n

4.1 Ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean theo KPI \u0111a ti\u00eau ch\u00ed<\/h3>\n\n\n\n

Trong b\u1ea3ng \u0111\u00e1nh gi\u00e1 hi\u1ec7u su\u1ea5t cu\u1ed1i qu\u00fd, ph\u00f2ng nh\u00e2n s\u1ef1 th\u01b0\u1eddng c\u1ea7n ph\u00e2n lo\u1ea1i nh\u00e2n vi\u00ean th\u00e0nh c\u00e1c nh\u00f3m: xu\u1ea5t s\u1eafc, \u0111\u1ea1t y\u00eau c\u1ea7u, c\u1ea7n c\u1ea3i thi\u1ec7n. Thay v\u00ec \u0111\u00e1nh gi\u00e1 theo m\u1ed9t ch\u1ec9 s\u1ed1 duy nh\u1ea5t, doanh nghi\u1ec7p hi\u1ec7n \u0111\u1ea1i s\u1eed d\u1ee5ng \u0111a ti\u00eau ch\u00ed: doanh s\u1ed1, s\u1ed1 ng\u00e0y ngh\u1ec9, \u0111i\u1ec3m \u0111\u00e1nh gi\u00e1 360 \u0111\u1ed9, ho\u00e0n th\u00e0nh OKR. H\u00e0m OR k\u1ebft h\u1ee3p IF cho ph\u00e9p t\u1ea1o b\u1ed9 l\u1ecdc linh ho\u1ea1t, v\u00ed d\u1ee5: `=IF(OR(E2>=120%, F2>=9, G2=\u201dA+\u201d), \u201cXu\u1ea5t s\u1eafc\u201d, \u201cB\u00ecnh th\u01b0\u1eddng\u201d)` \u2013 nh\u00e2n vi\u00ean ch\u1ec9 c\u1ea7n \u0111\u1ea1t 1 trong 3 ti\u00eau ch\u00ed l\u00e0 \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i xu\u1ea5t s\u1eafc. C\u00e1ch ti\u1ebfp c\u1eadn n\u00e0y c\u00f4ng b\u1eb1ng h\u01a1n so v\u1edbi y\u00eau c\u1ea7u \u0111\u1ea1t t\u1ea5t c\u1ea3 ti\u00eau ch\u00ed (AND), ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c doanh nghi\u1ec7p khuy\u1ebfn kh\u00edch nh\u00e2n vi\u00ean ph\u00e1t huy th\u1ebf m\u1ea1nh ri\u00eang.<\/p>\n\n\n\n

4.2 Ki\u1ec3m tra d\u1eef li\u1ec7u nh\u1eadp li\u1ec7u h\u00e0ng lo\u1ea1t<\/h3>\n\n\n\n

Khi nh\u1eadp li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n (file CSV, Google Forms, ph\u1ea7n m\u1ec1m ERP), d\u1eef li\u1ec7u th\u01b0\u1eddng c\u00f3 l\u1ed7i format. H\u00e0m OR gi\u00fap t\u1ea1o c\u1ed9t ki\u1ec3m tra t\u1ef1 \u0111\u1ed9ng: `=IF(OR(LEN(A2)<>10, LEFT(A2,1)<>\u201d0\u2033, NOT(ISNUMBER(VALUE(A2)))), \u201cL\u1ed7i S\u0110T\u201d, \u201cOK\u201d)` \u2013 ki\u1ec3m tra s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ph\u1ea3i \u0111\u1ee7 10 k\u00fd t\u1ef1, b\u1eaft \u0111\u1ea7u b\u1eb1ng 0 v\u00e0 to\u00e0n s\u1ed1. N\u1ebfu B\u1ea4T K\u1ef2 \u0111i\u1ec1u ki\u1ec7n n\u00e0o sai \u2192 \u0111\u00e1nh d\u1ea5u \u201cL\u1ed7i S\u0110T\u201d. C\u00e1ch n\u00e0y ti\u1ebft ki\u1ec7m h\u00e0ng gi\u1edd ki\u1ec3m tra th\u1ee7 c\u00f4ng tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u h\u00e0ng ngh\u00ecn d\u00f2ng.<\/p>\n\n\n\n

4.3 T\u1ea1o b\u00e1o c\u00e1o c\u1ea3nh b\u00e1o t\u1ed3n kho<\/h3>\n\n\n\n

K\u1ebf to\u00e1n kho th\u01b0\u1eddng c\u1ea7n c\u1ea3nh b\u00e1o khi h\u00e0ng s\u1eafp h\u1ebft ho\u1eb7c h\u00e0ng t\u1ed3n qu\u00e1 l\u00e2u. C\u00f4ng th\u1ee9c: `=IF(OR(C2180), \u201cC\u1ea2NH B\u00c1O\u201d, \u201c\u201d)` \u2013 n\u1ebfu s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho d\u01b0\u1edbi 10% ng\u01b0\u1ee1ng an to\u00e0n HO\u1eb6C h\u00e0ng t\u1ed3n qu\u00e1 180 ng\u00e0y \u2192 t\u1ef1 \u0111\u1ed9ng hi\u1ec7n \u201cC\u1ea2NH B\u00c1O\u201d. Doanh nghi\u1ec7p c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng Conditional Formatting \u0111\u1ec3 t\u00f4 \u0111\u1ecf c\u00e1c d\u00f2ng c\u1ea3nh b\u00e1o, gi\u00fap qu\u1ea3n l\u00fd kho ra quy\u1ebft \u0111\u1ecbnh nh\u1eadp\/xu\u1ea5t nhanh h\u01a1n.<\/d2*0.1,><\/p>\n\n\n\n

4.4 So s\u00e1nh h\u00e0m OR v\u1edbi SWITCH v\u00e0 IFS trong Excel m\u1edbi<\/h3>\n\n\n\n

T\u1eeb Excel 2019 v\u00e0 Microsoft 365, hai h\u00e0m m\u1edbi IFS v\u00e0 SWITCH cung c\u1ea5p c\u00e1ch vi\u1ebft g\u1ecdn h\u01a1n cho m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p. Tuy nhi\u00ean, OR v\u1eabn kh\u00f4ng th\u1ec3 thay th\u1ebf ho\u00e0n to\u00e0n v\u00ec: IFS ki\u1ec3m tra tu\u1ea7n t\u1ef1 (t\u01b0\u01a1ng t\u1ef1 IF l\u1ed3ng), c\u00f2n OR ki\u1ec3m tra \u0111\u1ed3ng th\u1eddi v\u00e0 tr\u1ea3 TRUE\/FALSE \u2013 hai m\u1ee5c \u0111\u00edch kh\u00e1c nhau. SWITCH so s\u00e1nh m\u1ed9t gi\u00e1 tr\u1ecb v\u1edbi nhi\u1ec1u gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh (gi\u1ed1ng CASE trong SQL), kh\u00f4ng ph\u1ea3i ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n logic. V\u00ec v\u1eady, OR v\u1eabn l\u00e0 h\u00e0m logic c\u1ed1t l\u00f5i m\u00e0 m\u1ecdi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng c\u1ea7n th\u00e0nh th\u1ea1o b\u1ea5t k\u1ec3 phi\u00ean b\u1ea3n Excel \u0111ang d\u00f9ng.<\/p>\n\n\n\n

\n

B\u1ea3ng so s\u00e1nh OR vs AND vs IFS<\/strong><\/p>\n

<\/p>\n

\u2013 OR: TRUE n\u1ebfu \u00edt nh\u1ea5t 1 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u2192 d\u00f9ng khi c\u1ea7n \u201cho\u1eb7c\u201d.<\/p>\n

<\/p>\n

\u2013 AND: TRUE n\u1ebfu t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang \u2192 d\u00f9ng khi c\u1ea7n \u201cv\u00e0\u201d.<\/p>\n

<\/p>\n

\u2013 IFS: tr\u1ea3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u00fang \u2192 thay th\u1ebf IF l\u1ed3ng nhi\u1ec1u c\u1ea5p.<\/p>\n

<\/p>\n

\u2013 SWITCH: so s\u00e1nh 1 gi\u00e1 tr\u1ecb v\u1edbi danh s\u00e1ch gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh \u2192 thay th\u1ebf CHOOSE ho\u1eb7c IF l\u1ed3ng \u0111\u01a1n gi\u1ea3n.<\/p>\n<\/div>\n\n\n\n

Khi l\u1ef1a ch\u1ecdn gi\u1eefa c\u00e1c h\u00e0m, nguy\u00ean t\u1eafc \u0111\u01a1n gi\u1ea3n: n\u1ebfu c\u1ea7n k\u1ebft qu\u1ea3 TRUE\/FALSE cho b\u1ed9 l\u1ecdc \u2192 d\u00f9ng OR ho\u1eb7c AND. N\u1ebfu c\u1ea7n tr\u1ea3 gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 theo \u0111i\u1ec1u ki\u1ec7n \u2192 d\u00f9ng IFS ho\u1eb7c IF k\u1ebft h\u1ee3p OR b\u00ean trong. N\u1ebfu so s\u00e1nh gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb \u2192 d\u00f9ng SWITCH.<\/p>\n\n\n\n

Ngo\u00e0i c\u00e1c \u1ee9ng d\u1ee5ng \u0111\u00e3 n\u00eau, h\u00e0m OR c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong Conditional Formatting \u0111\u1ec3 t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng. V\u00ed d\u1ee5: ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u \u2192 Home \u2192 Conditional Formatting \u2192 New Rule \u2192 Use a formula \u2192 nh\u1eadp `=OR($C2>100, $D2=\u201dUrgent\u201d)` \u2192 ch\u1ecdn format t\u00f4 \u0111\u1ecf. K\u1ebft qu\u1ea3: m\u1ecdi d\u00f2ng c\u00f3 s\u1ed1 l\u01b0\u1ee3ng >100 HO\u1eb6C tr\u1ea1ng th\u00e1i \u201cUrgent\u201d s\u1ebd t\u1ef1 t\u00f4 \u0111\u1ecf, gi\u00fap qu\u1ea3n l\u00fd ph\u00e1t hi\u1ec7n nhanh m\u00e0 kh\u00f4ng c\u1ea7n l\u1ecdc th\u1ee7 c\u00f4ng.<\/p>\n\n\n\n

Khi k\u1ebft h\u1ee3p OR v\u1edbi Conditional Formatting, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o dashboard visual m\u1ea1nh m\u1ebd m\u00e0 kh\u00f4ng c\u1ea7n VBA hay Power BI.<\/p>\n\n\n\n

5. Th\u1ecb tr\u01b0\u1eddng ngh\u1ec1 nghi\u1ec7p Excel cho th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00ednh tr\u00ean CareerLink (Th\u00e1ng 5\/2026)<\/h2>\n\n\n\n

Theo d\u1eef li\u1ec7u c\u1eadp nh\u1eadt tr\u00ean CareerLink th\u00e1ng 5\/2026, v\u1ecb tr\u00ed th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00ednh<\/strong> lu\u00f4n n\u1eb1m trong nh\u00f3m c\u00f3 nhu c\u1ea7u tuy\u1ec3n d\u1ee5ng cao v\u00e0 Excel l\u00e0 k\u1ef9 n\u0103ng b\u1eaft bu\u1ed9c trong g\u1ea7n nh\u01b0 m\u1ecdi JD. H\u1ec7 th\u1ed1ng ghi nh\u1eadn kho\u1ea3ng 400\u2013550 tin tuy\u1ec3n d\u1ee5ng<\/strong> trong nh\u00f3m Th\u01b0 k\u00fd \u2013 H\u00e0nh ch\u00e1nh, trong \u0111\u00f3 h\u01a1n 90% JD y\u00eau c\u1ea7u th\u00e0nh th\u1ea1o Excel \u1edf m\u1ee9c t\u1eeb trung b\u00ecnh tr\u1edf l\u00ean (bao g\u1ed3m c\u00e1c h\u00e0m logic nh\u01b0 OR, IF, AND, NOT).<\/p>\n\n\n\n

\n

T\u1ed5ng quan d\u1eef li\u1ec7u ngh\u1ec1 Th\u01b0 k\u00fd \u2013 HC (CareerLink, T5\/2026)<\/strong><\/p>\n

\u2013 S\u1ed1 tin Th\u01b0 k\u00fd \u2013 H\u00e0nh ch\u00e1nh: 400\u2013550 tin.<\/p>\n

\u2013 M\u1ee9c l\u01b0\u01a1ng ph\u1ed5 bi\u1ebfn: 9\u201318 tri\u1ec7u\/th\u00e1ng (junior), 15\u201325 tri\u1ec7u (senior\/executive secretary).<\/p>\n

\u2013 Top khu v\u1ef1c: TP.HCM, H\u00e0 N\u1ed9i, B\u00ecnh D\u01b0\u01a1ng, \u0110\u1ed3ng Nai, B\u1eafc Ninh.<\/p>\n

\u2013 K\u1ef9 n\u0103ng Excel \u01b0u ti\u00ean: h\u00e0m IF\/OR\/AND, VLOOKUP, INDEX\/MATCH, PivotTable, Power Query.<\/p>\n<\/div>\n\n\n

H\u00e0m OR cho ph\u00e9p ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac v\u00e0 l\u00e0 c\u00f4ng c\u1ee5 quan tr\u1ecdng khi so\u1ea1n b\u00e1o c\u00e1o nh\u00e2n s\u1ef1, theo d\u00f5i h\u1ee3p \u0111\u1ed3ng, l\u1ecdc d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng. Theo B\u1ed9 lu\u1eadt Lao \u0111\u1ed9ng 45\/2019\/QH14, th\u01b0 k\u00fd h\u00e0nh ch\u00ednh th\u01b0\u1eddng k\u00fd H\u0110L\u0110 v\u00f4 th\u1eddi h\u1ea1n sau th\u1eed vi\u1ec7c 60 ng\u00e0y. C\u00e1c ch\u1ee9ng ch\u1ec9 \u01b0u ti\u00ean: MOS Excel Specialist\/Expert (Microsoft), Microsoft 365 Office Specialist, IELTS 5.5+\/TOEIC 600+ (v\u1ecb tr\u00ed FDI). Tools: Microsoft Excel 365, Google Sheets, Power BI, Outlook, Microsoft Teams.<\/p>\n\n\n\n\n\n\n
Vai tr\u00f2 Th\u01b0 k\u00fd \u2013 HC<\/th>\nM\u1ee9c l\u01b0\u01a1ng<\/th>\nY\u00eau c\u1ea7u Excel<\/th>\nTool\/Ch\u1ee9ng ch\u1ec9<\/th>\n<\/tr>\n<\/thead>\n
Th\u01b0 k\u00fd v\u0103n ph\u00f2ng (junior)<\/td>9\u201313 tri\u1ec7u\/th\u00e1ng<\/td>IF, OR, VLOOKUP, l\u1ecdc d\u1eef li\u1ec7u<\/td>MOS Excel Specialist<\/td><\/tr>\n
H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1 (HC-NS)<\/td>10\u201318 tri\u1ec7u\/th\u00e1ng<\/td>PivotTable, INDEX\/MATCH<\/td>MOS Excel, SAP HR c\u01a1 b\u1ea3n<\/td><\/tr>\n
Executive Secretary<\/td>15\u201325 tri\u1ec7u\/th\u00e1ng<\/td>Power Query, Macro\/VBA c\u01a1 b\u1ea3n<\/td>MOS Expert, IELTS 6.5+<\/td><\/tr>\n
Office Manager<\/td>18\u201332 tri\u1ec7u\/th\u00e1ng<\/td>Power BI, Dashboard, automation<\/td>MOS Expert, Power BI cert<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c v\u1ecb tr\u00ed \u0111ang tuy\u1ec3n t\u1ea1i chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00e1nh<\/a> \u0111\u1ec3 h\u00ecnh dung r\u00f5 h\u01a1n JD, m\u1ee9c l\u01b0\u01a1ng v\u00e0 y\u00eau c\u1ea7u Excel c\u1ee5 th\u1ec3 cho t\u1eebng c\u1ea5p b\u1eadc.<\/p>\n\n\n

\n

L\u1eddi khuy\u00ean cho ng\u01b0\u1eddi l\u00e0m th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00ednh mu\u1ed1n n\u00e2ng k\u1ef9 n\u0103ng Excel<\/strong><\/p>\n

\u2013 L\u1ea5y ch\u1ee9ng ch\u1ec9 MOS Excel Specialist (240 USD, thi t\u1ea1i Pearson VUE Vi\u1ec7t Nam) trong 6 th\u00e1ng \u0111\u1ea7u \u2013 \u0111\u00e2y l\u00e0 ch\u1ee9ng ch\u1ec9 Microsoft c\u00f4ng nh\u1eadn to\u00e0n c\u1ea7u, gi\u00fap t\u0103ng 10\u201315% m\u1ee9c l\u01b0\u01a1ng kh\u1edfi \u0111i\u1ec3m.<\/p>\n

\u2013 H\u1ecdc th\u00eam Power Query + PivotTable n\u00e2ng cao tr\u00ean Coursera (Excel Skills for Business c\u1ee7a Macquarie University) \u2013 k\u1ef9 n\u0103ng n\u00e0y ph\u00e2n bi\u1ec7t r\u00f5 junior v\u1edbi senior th\u01b0 k\u00fd.<\/p>\n

\u2013 Luy\u1ec7n k\u1ebft h\u1ee3p h\u00e0m OR v\u1edbi IF\/AND trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf (l\u1ecdc nh\u00e2n vi\u00ean \u0111\u1ee7 \u0111i\u1ec1u ki\u1ec7n th\u01b0\u1edfng, x\u00e1c \u0111\u1ecbnh h\u1ee3p \u0111\u1ed3ng s\u1eafp h\u1ebft h\u1ea1n) \u2013 \u0111\u00e2y l\u00e0 d\u1ea1ng c\u00e2u h\u1ecfi 60% nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111\u01b0a v\u00e0o b\u00e0i test Excel.<\/p>\n<\/div>\n\n\n\n

6. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 h\u00e0m OR<\/h2>\n\n\n\n

1. H\u00e0m OR kh\u00e1c h\u00e0m AND \u1edf \u0111i\u1ec3m n\u00e0o?<\/em><\/strong><\/p>\n\n\n\n

OR tr\u1ea3 TRUE khi B\u1ea4T K\u1ef2 \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00fang (ch\u1ec9 c\u1ea7n 1). AND tr\u1ea3 TRUE khi T\u1ea4T C\u1ea2 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang. Trong logic, OR l\u00e0 ph\u00e9p \u201cho\u1eb7c\u201d (disjunction), AND l\u00e0 ph\u00e9p \u201cv\u00e0\u201d (conjunction). Ch\u1ecdn h\u00e0m n\u00e0o t\u00f9y v\u00e0o y\u00eau c\u1ea7u b\u00e0i to\u00e1n: l\u1ecdc \u201c\u00edt nh\u1ea5t 1 ti\u00eau ch\u00ed\u201d \u2192 OR; l\u1ecdc \u201cph\u1ea3i \u0111\u1ee7 m\u1ecdi ti\u00eau ch\u00ed\u201d \u2192 AND.<\/p>\n\n\n\n

2. H\u00e0m OR c\u00f3 d\u00f9ng \u0111\u01b0\u1ee3c v\u1edbi m\u1ea3ng kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

C\u00f3, trong Excel 365\/2021. V\u00ed d\u1ee5: `=OR(A2:A100=\u201d\u0110\u1ea1t\u201d)` ki\u1ec3m tra n\u1ebfu B\u1ea4T K\u1ef2 \u00f4 n\u00e0o trong A2:A100 l\u00e0 \u201c\u0110\u1ea1t\u201d. Phi\u00ean b\u1ea3n c\u0169 h\u01a1n c\u1ea7n nh\u1eadp b\u1eb1ng Ctrl+Shift+Enter \u0111\u1ec3 d\u00f9ng d\u1ea1ng m\u1ea3ng.<\/p>\n\n\n\n

3. C\u00f3 gi\u1edbi h\u1ea1n s\u1ed1 \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m OR kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

T\u1ed1i \u0111a 255 \u0111i\u1ec1u ki\u1ec7n t\u1eeb Excel 2007 tr\u1edf l\u00ean (Excel 2003 ch\u1ec9 h\u1ed7 tr\u1ee3 30). Tuy nhi\u00ean, n\u1ebfu c\u1ea7n ki\u1ec3m tra h\u01a1n 10 \u0111i\u1ec1u ki\u1ec7n, n\u00ean c\u00e2n nh\u1eafc d\u00f9ng COUNTIF, MATCH ho\u1eb7c XLOOKUP k\u1ebft h\u1ee3p \u0111\u1ec3 code g\u1ecdn v\u00e0 d\u1ec5 b\u1ea3o tr\u00ec h\u01a1n.<\/p>\n\n\n\n

T\u00f3m l\u1ea1i, h\u00e0m OR trong Excel<\/strong> l\u00e0 c\u00f4ng c\u1ee5 logic n\u1ec1n t\u1ea3ng gi\u00fap ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ed3ng th\u1eddi \u2013 ch\u1ec9 c\u1ea7n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang l\u00e0 tr\u1ea3 TRUE. Khi k\u1ebft h\u1ee3p v\u1edbi IF, AND, NOT, h\u00e0m OR cho ph\u00e9p x\u00e2y d\u1ef1ng c\u00e1c b\u1ed9 l\u1ecdc v\u00e0 ph\u00e2n lo\u1ea1i \u0111a t\u1ea7ng ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n, nh\u00e2n s\u1ef1. H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n, luy\u1ec7n t\u1eadp tr\u00ean d\u1eef li\u1ec7u th\u1eadt v\u00e0 d\u1ea7n n\u00e2ng c\u1ea5p l\u00ean c\u00e1c t\u1ed5 h\u1ee3p ph\u1ee9c t\u1ea1p h\u01a1n \u2013 \u0111\u00e2y l\u00e0 con \u0111\u01b0\u1eddng ng\u1eafn nh\u1ea5t \u0111\u1ec3 th\u00e0nh th\u1ea1o Excel logic.<\/p>\n\n\n\n

Minh An<\/strong><\/p>\n\n\n\n

B\u00e0i vi\u1ebft mang t\u00ednh tham kh\u1ea3o, giao di\u1ec7n v\u00e0 ch\u1ee9c n\u0103ng h\u00e0m c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y phi\u00ean b\u1ea3n Excel v\u00e0 ng\u00f4n ng\u1eef c\u00e0i \u0111\u1eb7t tr\u00ean m\u00e1y t\u00ednh.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

T\u00ecm hi\u1ec3u h\u00e0m OR trong Excel v\u1edbi c\u00fa ph\u00e1p, v\u00ed d\u1ee5 minh h\u1ecda v\u00e0 c\u00e1ch k\u1ebft h\u1ee3p IF, AND. Xem ngay h\u01b0\u1edbng d\u1eabn chi ti\u1ebft \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng hi\u1ec7u qu\u1ea3.<\/p>\n","protected":false},"author":58,"featured_media":18257,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-18166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=18166"}],"version-history":[{"count":9,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18166\/revisions"}],"predecessor-version":[{"id":19536,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18166\/revisions\/19536"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/18257"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=18166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=18166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=18166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}