{"id":1637,"date":"2024-12-02T05:38:10","date_gmt":"2024-12-02T05:38:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon\/"},"modified":"2024-12-02T05:38:10","modified_gmt":"2024-12-02T05:38:10","slug":"cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon\/","title":{"rendered":"C\u00e1c to\u00e1n t\u1eed logic c\u1ee7a Excel: b\u1eb1ng, kh\u00f4ng b\u1eb1ng, l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Nhi\u1ec1u t\u00e1c v\u1ee5 b\u1ea1n th\u1ef1c hi\u1ec7n trong Excel li\u00ean quan \u0111\u1ebfn vi\u1ec7c so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c \u00f4 kh\u00e1c nhau.\u00a0\u0110\u1ed1i v\u1edbi v\u1ea5n \u0111\u1ec1 n\u00e0y, Microsoft Excel cung c\u1ea5p s\u00e1u to\u00e1n t\u1eed logic, \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 to\u00e1n t\u1eed so s\u00e1nh.\u00a0H\u01b0\u1edbng d\u1eabn n\u00e0y nh\u1eb1m m\u1ee5c \u0111\u00edch gi\u00fap b\u1ea1n hi\u1ec3u s\u00e2u s\u1eafc v\u1ec1 c\u00e1c <strong>to\u00e1n t\u1eed logic Excel<\/strong> v\u00e0 vi\u1ebft c\u00e1c c\u00f4ng th\u1ee9c hi\u1ec7u qu\u1ea3 nh\u1ea5t cho vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/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-674d47c11c9ce\" 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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Tong_quan_cac_toan_tu_logic_trong_Excel\" title=\"T\u1ed5ng quan c\u00e1c to\u00e1n t\u1eed logic trong Excel:\">T\u1ed5ng quan c\u00e1c to\u00e1n t\u1eed logic trong Excel:<\/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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Su_dung_toan_tu_logic_%E2%80%9CEqual_to%E2%80%9D_trong_Excel\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cEqual to\u201d trong Excel:\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cEqual to\u201d trong Excel:<\/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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Vi_du_1_Su_dung_toan_tu_%E2%80%9CEqual_to%E2%80%9D_voi_ngay_thang\" title=\"V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi ng\u00e0y th\u00e1ng\">V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi ng\u00e0y th\u00e1ng<\/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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Vi_du_2_Su_dung_toan_tu_%E2%80%9CEqual_to%E2%80%9D_voi_cac_gia_tri_van_ban\" title=\"V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n\">V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Vi_du_3_So_sanh_gia_tri_va_so_Boolean\" title=\"V\u00ed d\u1ee5 3. So s\u00e1nh gi\u00e1 tr\u1ecb v\u00e0 s\u1ed1 Boolean\">V\u00ed d\u1ee5 3. So s\u00e1nh gi\u00e1 tr\u1ecb v\u00e0 s\u1ed1 Boolean<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Su_dung_toan_tu_logic_%E2%80%9CNot_equal_to%E2%80%9D_trong_Excel\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cNot equal to\u201d trong Excel\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cNot equal to\u201d trong Excel<\/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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Lon_hon_nho_hon_lon_hon_hoac_bang_nho_hon_hoac_bang\" title=\"L\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:\">L\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<\/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\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Su_dung_toan_tu_so_sanh_Excel_voi_cac_gia_tri_van_ban\" title=\"S\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n:\">S\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n:<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#Su_dung_chung_cua_cac_toan_tu_logic_trong_Excel\" title=\"S\u1eed d\u1ee5ng chung c\u1ee7a c\u00e1c to\u00e1n t\u1eed logic trong Excel\">S\u1eed d\u1ee5ng chung c\u1ee7a c\u00e1c to\u00e1n t\u1eed logic trong Excel<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#1_Su_dung_cac_toan_tu_logic_trong_cac_doi_so_cua_cac_ham_Excel\" title=\"1. S\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed logic trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00e1c h\u00e0m Excel\">1. S\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed logic trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00e1c h\u00e0m Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#2_Su_dung_toan_tu_logic_Excel_trong_tinh_toan_toan_hoc\" title=\"2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic Excel trong t\u00ednh to\u00e1n to\u00e1n h\u1ecdc\">2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic Excel trong t\u00ednh to\u00e1n to\u00e1n h\u1ecdc<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cac-toan-tu-logic-cua-excel-bang-khong-bang-lon-hon-nho-hon.html#3_Cac_toan_tu_logic_dinh_dang_co_dieu_kien_trong_Excel\" title=\"3. C\u00e1c to\u00e1n t\u1eed logic \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel\">3. C\u00e1c to\u00e1n t\u1eed logic \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tong_quan_cac_toan_tu_logic_trong_Excel\"><\/span>T\u1ed5ng quan c\u00e1c to\u00e1n t\u1eed logic trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t to\u00e1n t\u1eed logic \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel \u0111\u1ec3 so s\u00e1nh hai gi\u00e1 tr\u1ecb. V\u00ed d\u1ee5 nh\u01b0 l\u00e0 l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng, kh\u00f4ng b\u1eb1ng,\u2026C\u00e1c to\u00e1n t\u1eed logic \u0111\u00f4i khi \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 to\u00e1n t\u1eed Boolean v\u00ec k\u1ebft qu\u1ea3 so s\u00e1nh trong b\u1ea5t k\u1ef3 tr\u01b0\u1eddng h\u1ee3p n\u00e0o ch\u1ec9 c\u00f3 th\u1ec3 l\u00e0 TRUE ho\u1eb7c FALSE.<\/p>\n<p style=\"text-align: justify\">C\u00f3 s\u00e1u to\u00e1n t\u1eed logic c\u00f3 s\u1eb5n trong Excel.\u00a0B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y gi\u1ea3i th\u00edch t\u1eebng \u0111i\u1ec3m v\u00e0 minh h\u1ecda l\u00fd thuy\u1ebft b\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5.<\/p>\n<table width=\"642\">\n<tbody>\n<tr>\n<td style=\"width: 84px\"><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td style=\"width: 56px\"><strong>To\u00e1n t\u1eed<\/strong><\/td>\n<td style=\"width: 91px\"><strong>c\u00f4ng th\u1ee9c<\/strong><\/td>\n<td style=\"width: 383px\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">T\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi<\/td>\n<td style=\"width: 56px\">=<\/td>\n<td style=\"width: 91px\">= A1 = B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 b\u1eb1ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 B1;\u00a0FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">Kh\u00f4ng b\u1eb1ng<\/td>\n<td style=\"width: 56px\">&lt;&gt;<\/td>\n<td style=\"width: 91px\">=A1&lt;&gt; B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 kh\u00f4ng b\u1eb1ng gi\u00e1 tr\u1ecb trong \u00f4 B1;\u00a0FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">L\u1edbn h\u01a1n<\/td>\n<td style=\"width: 56px\">&gt;<\/td>\n<td style=\"width: 91px\">= A1&gt; B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B1;\u00a0N\u1ebfu kh\u00f4ng n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 FALSE.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">Nh\u1ecf h\u01a1n<\/td>\n<td style=\"width: 56px\">&lt;<\/td>\n<td style=\"width: 91px\">= A1 &lt;B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 nh\u1ecf h\u01a1n \u00f4 B1;\u00a0FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td style=\"width: 56px\">&gt; =<\/td>\n<td style=\"width: 91px\">=A1&gt;= B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 B1;\u00a0FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 84px\">Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/td>\n<td style=\"width: 56px\">&lt;=<\/td>\n<td style=\"width: 91px\">= A1 &lt;= B1<\/td>\n<td style=\"width: 383px\">C\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 B1;\u00a0FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c to\u00e1n t\u1eed\u00a0<em>T\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng<\/em>\u00a0,\u00a0<em>Kh\u00f4ng b\u1eb1ng<\/em>\u00a0,\u00a0<em>L\u1edbn <\/em>v\u00e0<em> Nh\u1ecf<\/em>:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-logical-operators.png\" alt=\"Using Equal to, Not equal to, Greater than and Less than in Excel\" title=\"excel-logical-operators\"><\/p>\n<p style=\"text-align: justify\">C\u00f3 v\u1ebb nh\u01b0 b\u1ea3ng tr\u00ean bao g\u1ed3m t\u1ea5t c\u1ea3 v\u00e0 kh\u00f4ng c\u00f2n g\u00ec ph\u1ea3i n\u00f3i th\u00eam.\u00a0Nh\u01b0ng tr\u00ean th\u1ef1c t\u1ebf, m\u1ed7i to\u00e1n t\u1eed logic c\u00f3 c\u00e1c \u0111\u1eb7c tr\u01b0ng ri\u00eang v\u00e0 n\u1eafm b\u1eaft ch\u00fang c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n khai th\u00e1c s\u1ee9c m\u1ea1nh th\u1ef1c s\u1ef1 c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c Excel.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: Kho\u0301a ho\u0323c Excel n\u00e2ng cao Online<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_logic_%E2%80%9CEqual_to%E2%80%9D_trong_Excel\"><\/span>S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cEqual to\u201d trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">To\u00e1n t\u1eed\u00a0logic <em>Equal to<\/em>\u00a0 (=) c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u \u2013 s\u1ed1, ng\u00e0y th\u00e1ng, gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, Booleans, c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i c\u0169ng nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c Excel kh\u00e1c.\u00a0V\u00ed d\u1ee5:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-48.gif\" title=\"vba101_92019-nho-48\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-118.gif\" title=\"ex101_92019-nho-118\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<table>\n<tbody>\n<tr>\n<td width=\"132\">= A1 = B1<\/td>\n<td width=\"513\">Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 A1 v\u00e0 B1 l\u00e0 gi\u1ed1ng nhau, FALSE n\u1ebfu kh\u00f4ng.<\/td>\n<\/tr>\n<tr>\n<td>= A1 = \u201cOranges\u201d<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00e1c \u00f4 A1 ch\u1ee9a t\u1eeb \u201cOranges\u201d, FALSE n\u1ebfu kh\u00f4ng.<\/td>\n<\/tr>\n<tr>\n<td>= A1 = TRUE<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00f4 A1 ch\u1ee9a gi\u00e1 tr\u1ecb Boolean TRUE, n\u1ebfu kh\u00f4ng n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 FALSE.<\/td>\n<\/tr>\n<tr>\n<td>= A1 = (B1 \/ 2)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t \u00f4 trong \u00f4 A1 b\u1eb1ng s\u1ed1 chia c\u1ee7a B1 b\u1eb1ng 2, FALSE n\u1ebfu kh\u00f4ng.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Su_dung_toan_tu_%E2%80%9CEqual_to%E2%80%9D_voi_ngay_thang\"><\/span>V\u00ed d\u1ee5 1. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 ng\u1ea1c nhi\u00ean khi bi\u1ebft r\u1eb1ng\u00a0to\u00e1n t\u1eed logic\u00a0<em>Equal to<\/em> kh\u00f4ng th\u1ec3 so s\u00e1nh ng\u00e0y d\u1ec5 d\u00e0ng nh\u01b0 s\u1ed1.\u00a0V\u00ed d\u1ee5: n\u1ebfu c\u00e1c \u00f4 A1 v\u00e0 A2 ch\u1ee9a ng\u00e0y \u201c12\/1\/2014\u201d, c\u00f4ng th\u1ee9c = A1 = A2 s\u1ebd tr\u1ea3 TRUE ch\u00ednh x\u00e1c nh\u01b0 mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, n\u1ebfu b\u1ea1n th\u1eed m\u1ed9t trong hai\u00a0<strong>=A1=12\/1\/2014 <\/strong>ho\u1eb7c\u00a0<strong>=A1=\u201d12\/1\/2014\u2033<\/strong>b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 FALSE.\u00a0B\u1ea5t ng\u1edd nh\u1ec9!<\/p>\n<p style=\"text-align: justify\">V\u1ea5n \u0111\u1ec1 l\u00e0 Excel l\u01b0u tr\u1eef c\u00e1c ng\u00e0y nh\u01b0 l\u00e0 c\u00e1c s\u1ed1 b\u1eaft \u0111\u1ea7u t\u1eeb ng\u00e0y 1 th\u00e1ng 1 n\u0103m 1900, \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 l\u00e0 1. Ng\u00e0y 12\/1\/2014 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 l\u00e0 41974. Trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, Microsoft Excel hi\u1ec3u \u201c12\/1\/2014\u201d Nh\u01b0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n th\u00f4ng th\u01b0\u1eddng, v\u00e0 v\u00ec \u201c12\/1\/2014\u201d kh\u00f4ng b\u1eb1ng 41974, n\u00f3 tr\u1ea3 v\u1ec1 FALSE.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c, b\u1ea1n lu\u00f4n lu\u00f4n ph\u1ea3i g\u00f3i m\u1ed9t ng\u00e0y trong h\u00e0m DATEVALUE, nh\u01b0 th\u1ebf n\u00e0y\u00a0<strong>=A1=DATEVALUE(\u201c12\/1\/2014\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/equal-to-dates.png\" alt=\"Using Excel's equal to operator with dates\" title=\"equal-to-dates\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00dd.\u00a0<\/strong>H\u00e0m DATEVALUE c\u0169ng c\u1ea7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00e1c to\u00e1n t\u1eed logic kh\u00e1c, nh\u01b0 trong c\u00e1c v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Su_dung_toan_tu_%E2%80%9CEqual_to%E2%80%9D_voi_cac_gia_tri_van_ban\"><\/span>V\u00ed d\u1ee5 2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed \u201cEqual to\u201d v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng\u00a0to\u00e1n t\u1eed\u00a0<em>Equal to<\/em>\u00a0c\u1ee7a Excel\u00a0v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00f4ng c\u1ea7n ph\u1ea3i th\u00eam g\u00ec c\u1ea3 .\u00a0\u0110i\u1ec1u duy nh\u1ea5t b\u1ea1n c\u1ea7n l\u01b0u \u00fd l\u00e0\u00a0to\u00e1n t\u1eed\u00a0<em>Equal to<\/em>\u00a0 trong Excel kh\u00f4ng\u00a0<strong>ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng<\/strong>\u00a0, c\u00f3 ngh\u0129a l\u00e0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c bi\u1ec7t s\u1ebd b\u1ecb b\u1ecf qua khi so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu \u00f4 A1 ch\u1ee9a t\u1eeb \u201cOranges\u00a0\u201d v\u00e0 \u00f4 B1 c\u00f3 ch\u1ee9a \u201cOranges\u201d, c\u00f4ng th\u1ee9c = A1 = B1 s\u1ebd tr\u1ea3 v\u1ec1 TRUE.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee5 th\u1ec3, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng h\u00e0m EXACT thay v\u00ec\u00a0to\u00e1n t\u1eed\u00a0<em>Equal to<\/em>.\u00a0C\u00fa ph\u00e1p c\u1ee7a h\u00e0m EXACT \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>EXACT(text1, text2)<\/strong><\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p v\u0103n b\u1ea3n 1 v\u00e0 v\u0103n b\u1ea3n 2 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n so s\u00e1nh.\u00a0N\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c nh\u01b0 nhau bao g\u1ed3m c\u1ea3 ch\u1eef in hoa v\u00e0 th\u01b0\u1eddng, Excel tr\u1ea3 v\u1ec1 TRUE;\u00a0N\u1ebfu kh\u00f4ng, n\u00f3 tr\u1ea3 v\u1ec1 FALSE.\u00a0B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0h\u00e0m Exact trong c\u00e1c c\u00f4ng th\u1ee9c IF\u00a0khi b\u1ea1n c\u1ea7n so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n v\u1edbi s\u1ef1 ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, nh\u01b0 th\u1ec3 hi\u1ec7n trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/equal-to-case-sensitive.png\" alt=\"Using the EXACT function for case-sensitive comparison of text values\" title=\"equal-to-case-sensitive\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00dd.\u00a0<\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n so s\u00e1nh \u0111\u1ed9 d\u00e0i c\u1ee7a hai gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m LEN thay th\u1ebf, v\u00ed d\u1ee5\u00a0<strong>=LEN(A2)=LEN(B2) <\/strong>ho\u1eb7c\u00a0<strong>=LEN(A2)&gt;=LEN(B2)<\/strong>.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_So_sanh_gia_tri_va_so_Boolean\"><\/span>V\u00ed d\u1ee5 3. So s\u00e1nh gi\u00e1 tr\u1ecb v\u00e0 s\u1ed1 Boolean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00f3 nhi\u1ec1u \u00fd ki\u1ebfn cho r\u1eb1ng trong Microsoft Excel gi\u00e1 tr\u1ecb Boolean c\u1ee7a TRUE lu\u00f4n b\u1eb1ng 1 v\u00e0 FALSE th\u00e0nh 0. Tuy nhi\u00ean, \u0111i\u1ec1u n\u00e0y ch\u1ec9 \u0111\u00fang m\u1ed9t ph\u1ea7n, v\u00e0 t\u1eeb kh\u00f3a \u1edf \u0111\u00e2y l\u00e0 \u201clu\u00f4n lu\u00f4n\u201d ho\u1eb7c ch\u00ednh x\u00e1c h\u01a1n l\u00e0 \u201ckh\u00f4ng ph\u1ea3i lu\u00f4n lu\u00f4n\u201d.<\/p>\n<p style=\"text-align: justify\">Khi vi\u1ebft m\u1ed9t bi\u1ec3u th\u1ee9c logic \u2018equal to\u2019\u00a0 so s\u00e1nh m\u1ed9t gi\u00e1 tr\u1ecb Boolean v\u00e0 m\u1ed9t s\u1ed1, b\u1ea1n c\u1ea7n ch\u1ec9 ra c\u1ee5 th\u1ec3 cho Excel bi\u1ebft r\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb Boolean kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 ph\u1ea3i \u0111\u01b0\u1ee3c coi nh\u01b0 m\u1ed9t s\u1ed1.\u00a0B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch th\u00eam hai d\u1ea5u tr\u1eeb ph\u00eda tr\u01b0\u1edbc gi\u00e1 tr\u1ecb Boolean ho\u1eb7c tham chi\u1ebfu \u00f4, v\u00ed d\u1ee5\u00a0<strong>=A2=\u2013TRUE <\/strong>ho\u1eb7c\u00a0<strong>=A2=\u2013B2<\/strong>.<\/p>\n<p style=\"text-align: justify\">D\u1ea5u tr\u1eeb th\u1ee9 nh\u1ea5t\u00a0, \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 to\u00e1n t\u1eed unary, l\u1ea7n l\u01b0\u1ee3t \u00e9p TRUE \/ FALSE th\u00e0nh -1\/0, v\u00e0 unary th\u1ee9 hai lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb \u00e2m bi\u1ebfn ch\u00fang th\u00e0nh +1 v\u00e0 0. \u0110i\u1ec1u n\u00e0y s\u1ebd d\u1ec5 hi\u1ec3u h\u01a1n khi nh\u00ecn v\u00e0o h\u00ecnh sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-number-boolean.png\" alt=\"Comparing Boolean values and numbers\" title=\"compare-number-boolean\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_logic_%E2%80%9CNot_equal_to%E2%80%9D_trong_Excel\"><\/span>S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic \u201cNot equal to\u201d trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng\u00a0to\u00e1n t\u1eed\u00a0<em>Not equal to\u00a0 <\/em>c\u1ee7a Excel (&lt;&gt;) \u2013 d\u1ea5u kh\u00f4ng b\u1eb1ng, khi b\u1ea1n mu\u1ed1n ch\u1eafc ch\u1eafn r\u1eb1ng gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 kh\u00f4ng b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. Vi\u1ec7c s\u1eed d\u1ee5ng <em>Not equal to\u00a0<\/em> r\u1ea5t gi\u1ed1ng v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng\u00a0<em>Equal to<\/em>\u00a0m\u00e0 ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn m\u1ed9t l\u00fac n\u00e3y.<\/p>\n<p style=\"text-align: justify\">C\u00e1c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi\u00a0to\u00e1n t\u1eed\u00a0<em>Not equal to <\/em>c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1edfi h\u00e0m Excel NOT l\u00e0m \u0111\u1ea3o ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ee7a \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3.\u00a0B\u1ea3ng sau \u0111\u00e2y cung c\u1ea5p m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c v\u00ed d\u1ee5.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"208\"><strong>To\u00e1n t\u1eed <\/strong><strong><em>Not equal to<\/em><\/strong><\/td>\n<td width=\"136\"><strong>H\u00e0m NOT<\/strong><\/td>\n<td width=\"302\"><strong>M\u00f4 T\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;&gt; B1<\/td>\n<td>= NOT (A1 = B1)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu c\u00e1c gi\u00e1 tr\u1ecb trong \u00f4 A1 v\u00e0 B1 kh\u00f4ng gi\u1ed1ng nhau, FALSE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;&gt; \u201cOranges\u201d<\/td>\n<td>= NOT (A1 = \u201cOranges\u201d)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00f4 A1 ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c v\u1edbi \u201cOranges\u201d, FALSE n\u1ebfu ch\u1ee9a \u201cOranges\u201d ho\u1eb7c \u201cORANGES\u201d ho\u1eb7c \u201cOranges\u201d, v.v \u2026<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;&gt; TRUE<\/td>\n<td>= NOT (A1 = TRUE)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00f4 A1 ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c v\u1edbi TRUE, FALSE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;&gt; (B1 \/ 2)<\/td>\n<td>= NOT (A1 = B1 \/ 2)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu s\u1ed1 trong \u00f4 A1 kh\u00f4ng b\u1eb1ng s\u1ed1 chia c\u1ee7a B1 cho 2, FALSE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;&gt; DATEVALUE (\u201c12\/1\/2014\u201d)<\/td>\n<td>= NOT (A1 = DATEVALUE (\u201c12\/1\/2014\u201d))<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu A1 ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c v\u1edbi ng\u00e0y 1 th\u00e1ng 12 n\u0103m 2014, b\u1ea5t k\u1ec3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y, FALSE n\u1ebfu ng\u01b0\u1ee3c l\u1ea1i.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lon_hon_nho_hon_lon_hon_hoac_bang_nho_hon_hoac_bang\"><\/span>L\u1edbn h\u01a1n, nh\u1ecf h\u01a1n, l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed logic n\u00e0y trong Excel \u0111\u1ec3 ki\u1ec3m tra c\u00e1ch so s\u00e1nh m\u1ed9t s\u1ed1 so v\u1edbi m\u1ed9t s\u1ed1 kh\u00e1c.\u00a0Microsoft Excel cung c\u1ea5p 4 ho\u1ea1t \u0111\u1ed9ng so s\u00e1nh c\u00f3 t\u00ean tr\u00f9ng v\u1edbi \u00fd ngh\u0129a:<\/p>\n<ul style=\"text-align: justify\">\n<li>L\u1edbn h\u01a1n (&gt;)<\/li>\n<li>L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng (&gt; =)<\/li>\n<li>Nh\u1ecf h\u01a1n (&lt;)<\/li>\n<li>Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (&lt;=)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, c\u00e1c to\u00e1n t\u1eed so s\u00e1nh Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1, ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian.\u00a0V\u00ed d\u1ee5:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"132\">= A1&gt; 20<\/td>\n<td width=\"513\">Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t \u00f4 trong \u00f4 A1 l\u1edbn h\u01a1n 20, FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td>= A1&gt; = (B1 \/ 2)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t \u00f4 trong \u00f4 A1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 chia c\u1ee7a B1 cho 2, FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;DATEVALUE (\u201c12\/1\/2014\u201d)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t ng\u00e0y trong \u00f4 A1 nh\u1ecf h\u01a1n 1 th\u00e1ng 12 n\u0103m 2014, FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<tr>\n<td>= A1 &lt;= SUM (B1: D1)<\/td>\n<td>Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t \u00f4 trong \u00f4 A1 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 B1: D1, FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_toan_tu_so_sanh_Excel_voi_cac_gia_tri_van_ban\"><\/span>S\u1eed d\u1ee5ng to\u00e1n t\u1eed so s\u00e1nh Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">V\u1ec1 l\u00fd thuy\u1ebft, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed\u00a0<em>l\u1edbn h\u01a1n<\/em>,\u00a0<em>l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng <\/em>c\u0169ng nh\u01b0 nh\u1ecf<em> h\u01a1n<\/em>\u00a0\u0111\u1ed1i v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n.\u00a0V\u00ed d\u1ee5: n\u1ebfu \u00f4 A1 ch\u1ee9a \u201d\u00a0<em>apples <\/em>\u201d v\u00e0 B1 ch\u1ee9a \u201d\u00a0<em>bananas <\/em>\u201c, h\u00e3y \u0111o\u00e1n c\u00f4ng th\u1ee9c = A1&gt; B1 s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 nh\u01b0 th\u1ebf n\u00e0o?\u00a0Ch\u00fac m\u1eebng nh\u1eefng ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1eb7t c\u01b0\u1ee3c v\u00e0o FALSE:)<\/p>\n<p style=\"text-align: justify\">Khi so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, Microsoft Excel s\u1ebd b\u1ecf qua ki\u1ec3u ch\u1eef v\u00e0 so s\u00e1nh gi\u00e1 tr\u1ecb k\u00fd hi\u1ec7u b\u1eb1ng k\u00fd hi\u1ec7u, \u201ca\u201d \u0111\u01b0\u1ee3c coi l\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n th\u1ea5p nh\u1ea5t v\u00e0 \u201cz\u201d \u2013 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n cao nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, khi so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a \u201d\u00a0<em>apples <\/em>\u201d (A1) v\u00e0 \u201d\u00a0<em>bananas <\/em>\u201d (B1), Excel b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean \u201ca\u201d v\u00e0 \u201cb\u201d, t\u01b0\u01a1ng \u1ee9ng, v\u00e0 v\u00ec \u201cb\u201d l\u1edbn h\u01a1n \u201ca\u201d, C\u00f4ng th\u1ee9c\u00a0<strong>=A1&gt;B1 <\/strong>tr\u1ea3 v\u1ec1 FALSE.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00e1c ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean \u0111\u1ec1u gi\u1ed1ng nhau, th\u00ec c\u00e1c\u00a0ch\u1eef c\u00e1i th\u1ee9 hai \u0111\u01b0\u1ee3c so s\u00e1nh, n\u1ebfu ch\u00fang c\u0169ng gi\u1ed1ng nhau, th\u00ec Excel s\u1ebd \u0111\u1ebfn ch\u1eef th\u1ee9 ba, t\u01b0,.. .\u00a0V\u00ed d\u1ee5, n\u1ebfu A1 ch\u1ee9a \u201d\u00a0<em>apples <\/em>\u201d v\u00e0 B1 ch\u1ee9a \u201d\u00a0<em>agave<\/em>\u00a0\u201c, c\u00f4ng th\u1ee9c = A1&gt; B1 s\u1ebd tr\u1ea3 v\u1ec1 TRUE v\u00ec \u201cp\u201d l\u1edbn h\u01a1n \u201cg\u201d.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/comparison-operators-text.png\" alt=\"Using Excel comparison operators with text values\" title=\"comparison-operators-text\"><\/p>\n<p style=\"text-align: justify\">Ngay t\u1eeb \u0111\u1ea7u, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed so s\u00e1nh v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n d\u01b0\u1eddng nh\u01b0 c\u00f3 r\u1ea5t \u00edt \u00fd ngh\u0129a th\u1ef1c ti\u1ec5n nh\u01b0ng b\u1ea1n kh\u00f4ng bao gi\u1edd bi\u1ebft m\u00ecnh c\u1ea7n g\u00ec trong t\u01b0\u01a1ng lai, v\u00ec v\u1eady c\u00f3 l\u1ebd ki\u1ebfn \u200b\u200bth\u1ee9c n\u00e0y s\u1ebd h\u1eefu \u00edch cho ai \u0111\u00f3.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_chung_cua_cac_toan_tu_logic_trong_Excel\"><\/span>S\u1eed d\u1ee5ng chung c\u1ee7a c\u00e1c to\u00e1n t\u1eed logic trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf, c\u00e1c to\u00e1n t\u1eed logic Excel hi\u1ebfm khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ri\u00eang.\u00a0\u0110\u1ed3ng \u00fd l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb Boolean TRUE v\u00e0 FALSE tr\u1ea3 l\u1ea1i, m\u1eb7c d\u00f9 r\u1ea5t \u201ctrue\u201d (kh\u00f4ng ph\u1ea3i ch\u01a1i ch\u1eef), nh\u01b0ng kh\u00f4ng c\u00f3 \u00fd ngh\u0129a l\u1eafm.\u00a0\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 h\u1ee3p l\u00fd h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng to\u00e1n t\u1eed logic nh\u01b0 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a c\u00e1c h\u00e0m Excel ho\u1eb7c c\u00e1c quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, nh\u01b0 \u00a0trong c\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Su_dung_cac_toan_tu_logic_trong_cac_doi_so_cua_cac_ham_Excel\"><\/span>1. S\u1eed d\u1ee5ng c\u00e1c to\u00e1n t\u1eed logic trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a c\u00e1c h\u00e0m Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Khi n\u00f3i \u0111\u1ebfn c\u00e1c to\u00e1n t\u1eed logic, Excel r\u1ea5t d\u1ec5 d\u00e3i v\u00e0 cho ph\u00e9p s\u1eed d\u1ee5ng ch\u00fang trong c\u00e1c tham s\u1ed1 c\u1ee7a nhi\u1ec1u h\u00e0m.\u00a0M\u1ed9t trong nh\u1eefng c\u00e1ch s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 trong h\u00e0m IF m\u00e0 c\u00e1c to\u00e1n t\u1eed so s\u00e1nh c\u00f3 th\u1ec3 gi\u00fap x\u00e2y d\u1ef1ng m\u1ed9t b\u00e0i ki\u1ec3m tra logic, v\u00e0 c\u00f4ng th\u1ee9c IF s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t k\u1ebft qu\u1ea3 th\u00edch h\u1ee3p t\u00f9y thu\u1ed9c v\u00e0o vi\u1ec7c ki\u1ec3m tra \u0111\u00e1nh gi\u00e1 l\u00e0 TRUE hay FALSE.\u00a0V\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(A1&gt;=B1, \u201cOK\u201d, \u201cNot OK\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c IF \u0111\u01a1n gi\u1ea3n n\u00e0y tr\u1ea3 v\u1ec1 OK n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A1 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B1, \u201cNot OK\u201d n\u1ebfu kh\u00f4ng.<\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 kh\u00e1c:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(A1&lt;&gt;B1, SUM(A1:C1), \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 A1 v\u00e0 B1, v\u00e0 n\u1ebfu A1 kh\u00f4ng b\u1eb1ng B1, t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 A1: C1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1, ho\u1eb7c tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i r\u1ed7ng n\u1ebfu kh\u00f4ng ph\u1ea3i.<\/p>\n<p style=\"text-align: justify\">C\u00e1c to\u00e1n t\u1eed logic c\u1ee7a Excel c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong c\u00e1c h\u00e0m IF \u0111\u1eb7c bi\u1ec7t nh\u01b0 SUMIF, COUNTIF, AVERAGEIF v\u00e0 ch\u00fang tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Su_dung_toan_tu_logic_Excel_trong_tinh_toan_toan_hoc\"><\/span>2. S\u1eed d\u1ee5ng to\u00e1n t\u1eed logic Excel trong t\u00ednh to\u00e1n to\u00e1n h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">T\u1ea5t nhi\u00ean, c\u00e1c h\u00e0m trong Excel r\u1ea5t m\u1ea1nh m\u1ebd, nh\u01b0ng b\u1ea1n kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.\u00a0V\u00ed d\u1ee5, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1edfi hai c\u00f4ng th\u1ee9c sau \u0111\u00e2y l\u00e0 gi\u1ed1ng nhau:<\/p>\n<p style=\"text-align: justify\">H\u00e0m IF:\u00a0<strong>=IF(B2&gt;C2, B2*10, B2*5)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c v\u1edbi to\u00e1n t\u1eed logic:\u00a0<strong>=(B2&gt;C2)*(B2*10)+(B2&lt;=C2)*(B2*5)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/logical-operators-formulas.png\" alt=\"Using Excel logical operators in mathematical calculations\" title=\"logical-operators-formulas\"><\/strong><\/p>\n<p style=\"text-align: justify\">T\u00f4i \u0111o\u00e1n c\u00f4ng th\u1ee9c IF d\u1ec5 \u0111\u1ec3 gi\u1ea3i th\u00edch h\u01a1n ph\u1ea3i kh\u00f4ng?\u00a0N\u00f3 cho Excel nh\u00e2n m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B2 b\u1eb1ng 10 n\u1ebfu B2 l\u1edbn h\u01a1n C2, n\u1ebfu kh\u00f4ng gi\u00e1 tr\u1ecb trong B1 \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi 5.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, h\u00e3y ph\u00e2n t\u00edch\u00a0c\u00f4ng th\u1ee9c th\u1ee9 hai v\u1edbi to\u00e1n t\u1eed\u00a0logic\u00a0<em>l\u1edbn h\u01a1n<\/em>\u00a0v\u00e0\u00a0<em>nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/em>.\u00a0N\u00f3 gi\u00fap ta bi\u1ebft trong t\u00ednh to\u00e1n to\u00e1n h\u1ecdc Excel t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi gi\u00e1 tr\u1ecb Boolean TRUE l\u00e0 1, v\u00e0 FALSE l\u00e0 0. L\u01b0u \u00fd \u0111i\u1ec1u n\u00e0y, ch\u00fang ta h\u00e3y c\u00f9ng xem nh\u1eefng bi\u1ec3u th\u1ee9c logic n\u00e0o th\u1ef1c s\u1ef1 tr\u1ea3 v\u1ec1.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B2 l\u1edbn h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb trong C2 th\u00ec bi\u1ec3u th\u1ee9c B2&gt; C2 l\u00e0 TRUE, v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 b\u1eb1ng 1. M\u1eb7t kh\u00e1c, B2 &lt;= C2 l\u00e0 FALSE v\u00e0 b\u1eb1ng 0. V\u00ec v\u1eady B2 &gt; C2, c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta tr\u1ea3i qua qu\u00e1 tr\u00ecnh chuy\u1ec3n \u0111\u1ed5i sau:<\/p>\n<p style=\"text-align: justify\">V\u00ec b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o nh\u00e2n v\u1edbi s\u1ed1 kh\u00f4ng c\u0169ng b\u1eb1ng kh\u00f4ng, ch\u00fang ta c\u00f3 th\u1ec3 b\u1ecf ph\u1ea7n th\u1ee9 hai c\u1ee7a c\u00f4ng th\u1ee9c sau d\u1ea5u c\u1ed9ng.\u00a0V\u00e0 b\u1edfi v\u00ec b\u1ea5t k\u1ef3 s\u1ed1 n\u00e0o nh\u00e2n v\u1edbi 1 c\u0169ng b\u1eb1ng s\u1ed1 \u0111\u00f3, c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p c\u1ee7a ch\u00fang bi\u1ebfn th\u00e0nh \u0111\u01a1n gi\u1ea3n = B2 * 10 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u00e2n B2 cho 10, c\u0169ng ch\u00ednh x\u00e1c l\u00e0 c\u00f4ng th\u1ee9c IF \u1edf tr\u00ean:<\/p>\n<p style=\"text-align: justify\">R\u00f5 r\u00e0ng, n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B2 nh\u1ecf h\u01a1n C2, th\u00ec bi\u1ec3u th\u1ee9c B2&gt; C2 \u0111\u00e1nh gi\u00e1 l\u00e0 FALSE (0) v\u00e0 B2 &lt;= C2 t\u1edbi TRUE (1), c\u00f3 ngh\u0129a l\u00e0 s\u1ef1 ng\u01b0\u1ee3c l\u1ea1i c\u1ee7a m\u00f4 t\u1ea3 \u1edf tr\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Cac_toan_tu_logic_dinh_dang_co_dieu_kien_trong_Excel\"><\/span>3. C\u00e1c to\u00e1n t\u1eed logic \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn kh\u00e1c c\u1ee7a to\u00e1n t\u1eed logic\u00a0 trong Excel l\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng \u0111\u00e1nh d\u1ea5u c\u00e1c th\u00f4ng tin quan tr\u1ecdng nh\u1ea5t trong m\u1ed9t b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: c\u00e1c quy t\u1eafc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e1nh d\u1ea5u \u00f4 \u0111\u00e3 ch\u1ecdn ho\u1eb7c to\u00e0n b\u1ed9 h\u00e0ng trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n t\u00f9y thu\u1ed9c v\u00e0o gi\u00e1 tr\u1ecb trong c\u1ed9t A:<\/p>\n<p style=\"text-align: justify\">Nh\u1ecf h\u01a1n (m\u00e0u cam):\u00a0=A1&lt;5<\/p>\n<p style=\"text-align: justify\">L\u1edbn h\u01a1n (m\u00e0u xanh l\u00e1 c\u00e2y):\u00a0=A1&gt;20<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6382\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-175.png\" width=\"600\" height=\"322\" title=\"excel-dialog-box-launcher-1-175\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u00e2\u0323y v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> \u0111a\u0303 chia se\u0309 cho ca\u0301c ba\u0323n <strong>ca\u0301c toa\u0301n t\u01b0\u0300 logic cu\u0309a Excel<\/strong> m\u00f4\u0323t ca\u0301c chi ti\u00ea\u0301t nh\u00e2\u0301t cu\u0300ng ca\u0301c vi\u0301 du\u0323. N\u00ea\u0301u co\u0301 b\u00e2\u0301t ky\u0300 th\u0103\u0301c m\u0103\u0301c na\u0300o ha\u0303y comment ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 chu\u0301ng t\u00f4i co\u0301 th\u00ea\u0309 gia\u0309i quy\u00ea\u0301t mo\u0323i th\u0103\u0301c cu\u0309a ba\u0323n m\u00f4\u0323t ca\u0301ch nhanh nh\u00e2\u0301t.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-48.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1637","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=1637"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1638"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}