{"id":13316,"date":"2022-11-26T21:41:08","date_gmt":"2022-11-26T14:41:08","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13316"},"modified":"2022-12-07T15:14:44","modified_gmt":"2022-12-07T08:14:44","slug":"ham-and-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/","title":{"rendered":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;13316&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400; color: #000000;\"><strong>H\u00e0m And trong Excel<\/strong> c\u00f3 c\u00f4ng th\u1ee9c l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh to\u00e1n n\u00e0y ra sao? N\u1ebfu b\u1ea1n \u0111ang quan t\u00e2m t\u1edbi nh\u1eefng c\u00e2u h\u1ecfi tr\u00ean th\u00ec \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin sau. B\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi c\u1ee7a TEKY s\u1ebd c\u00f9ng b\u1ea1n kh\u00e1m ph\u00e1 chi ti\u1ebft h\u00e0m t\u00ednh to\u00e1n n\u00e0y. C\u00f9ng theo d\u00f5i ngay th\u00f4i n\u00e0o!<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#So_luoc_ve_ham_AND_trong_Excel\" >S\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m AND trong Excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Cach_su_dung_ham_AND_ket_hop_cung_ham_IF_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Cu_phap\" >C\u00fa ph\u00e1p<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Luu_y_khi_su_dung_ham_And_trogn_Excel_ket_hop_cung_ham_If\" >L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m And trogn Excel k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m If<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Cach_su_dung_ham_AND_khi_co_ket_hop_voi_ham_OR\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND khi c\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Ket_hop_ham_logic_AND_voi_cac_ham_IF_va_OR_trong_Excel\" >K\u1ebft h\u1ee3p h\u00e0m logic AND v\u1edbi c\u00e1c h\u00e0m IF v\u00e0 OR trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Cong_thuc_ham\" >C\u00f4ng th\u1ee9c h\u00e0m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#Luu_y_khi_su_dung\" >L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"So_luoc_ve_ham_AND_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>S\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m AND trong Excel\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong c\u00e1c h\u00e0m t\u00ednh to\u00e1n c\u1ee7a Excel, h\u00e0m AND l\u00e0 m\u1ed9t h\u00e0m v\u00f4 c\u00f9ng \u0111\u1eb7c bi\u1ec7t. Kh\u00e1c h\u1eb3n c\u00e1c h\u00e0m kh\u00e1c, h\u00e0m AND l\u00e0 m\u1ed9t ph\u00e9p logic. H\u00e0m n\u00e0y kh\u00f4ng d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n ra k\u1ebft qu\u1ea3 ph\u00e9p t\u00ednh m\u00e0 ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n xem \u0111\u00fang hay kh\u00f4ng \u0111\u00fang. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m AND c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed9c l\u1eadp. Ho\u1eb7c c\u0169ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n\u00a0 kh\u00e1c trong Excel \u0111\u1ec3 cho ra nh\u1eefng k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u1ea5t. C\u00e1c h\u00e0m k\u1ebft h\u1ee3p nh\u01b0 k\u1ebft h\u1ee3p v\u1edbi IF, k\u1ebft h\u1ee3p v\u1edbi OR,&#8230;<\/span><\/p>\n<figure id=\"attachment_13318\" aria-describedby=\"caption-attachment-13318\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13318 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-1.jpg\" alt=\"S\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m AND trong Excel\u00a0\" width=\"600\" height=\"321\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-1-400x214.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13318\" class=\"wp-caption-text\">S\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m AND trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m AND khi ho\u1ea1t \u0111\u1ed9ng \u0111\u01a1n l\u1ebb c\u00f3 c\u00fa ph\u00e1p v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=AND(logical1, logical2,&#8230;)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong c\u00fa ph\u00e1p n\u00e0y, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec3m \u0111\u1ec3 tr\u00e1nh vi\u1ebft sai c\u00f4ng th\u1ee9c nh\u01b0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u1ea7n vi\u1ebft d\u1ea5u \u201c=\u201d v\u00e0o ph\u00eda tr\u01b0\u1edbc ch\u1eef AND, nh\u01b0 v\u1eady, c\u00f4ng th\u1ee9c m\u1edbi c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Logical1, logical2 l\u00e0 \u0111i\u1ec1u ki\u1ec7n 1 v\u00e0 \u0111i\u1ec1u ki\u1ec7n 2. Ch\u00fang \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 nh\u1eefng m\u1ec7nh \u0111\u1ec1 logic. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u00eam nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c v\u00e0o ph\u00e9p to\u00e1n c\u1ee7a b\u1ea1n.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">V\u00ec m\u1ee5c \u0111\u00edch ph\u00e9p to\u00e1n kh\u00f4ng gi\u1ed1ng nhau n\u00ean k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m logic AND c\u0169ng kh\u00e1c h\u1eb3n nh\u1eefng h\u00e0m kh\u00e1c. H\u00e0m n\u00e0y ch\u1ec9 c\u00f3 hai k\u1ebft qu\u1ea3 l\u00e0 True ho\u1eb7c False. Khi c\u00e1c m\u1ec7nh \u0111\u1ec1 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec1u \u0111\u00fang th\u00ec h\u00e0m tr\u1ea3 v\u1ec1 True.\u00a0 Ng\u01b0\u1ee3c l\u1ea1i, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 False n\u1ebfu c\u00e1c m\u1ec7nh \u0111\u1ec1 \u0111\u1ec1u sai hay m\u1ed9t m\u1ec7nh \u0111\u1ec1 b\u1ea5t k\u1ef3 trong chu\u1ed7i c\u00e1c m\u1ec7nh \u0111\u1ec1 b\u1ecb sai.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch d\u00f9ng h\u00e0m AND trong Excel, c\u00e1ch d\u00f9ng h\u00e0m AND k\u1ebft h\u1ee3p h\u00e0m IF\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/_Fd09tyP760?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_AND_ket_hop_cung_ham_IF_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m IF v\u00e0 AND trong Excel th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng nhau trong c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o kh\u1ea3 n\u0103ng xem x\u00e9t m\u1ed9t l\u00fac nhi\u1ec1u m\u1ec7nh \u0111\u1ec1 \u0111\u00fang sai. Nh\u01b0 v\u1eady, c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n s\u1ebd tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span><span style=\"color: #000000;\">C\u00fa ph\u00e1p<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">S\u01a1 v\u1edbi h\u00e0m AND \u0111\u01a1n gi\u1ea3n, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m IF AND trong Excel c\u00f3 ph\u1ea7n h\u01a1i ph\u1ee9c t\u1ea1p. B\u1edfi n\u00f3 ch\u1ee9a m\u1ed9t l\u00fac c\u1ea3 2 h\u00e0m, v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=IF(AND(logical1, logical2,\u2026),\u201cValue_if_true\u201d,\u201cValue_if_False\u201d)<\/span><\/p>\n<figure id=\"attachment_13319\" aria-describedby=\"caption-attachment-13319\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13319 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-2.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF trong Excel\" width=\"600\" height=\"341\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-2-400x227.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13319\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m IF trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Luu_y_khi_su_dung_ham_And_trogn_Excel_ket_hop_cung_ham_If\"><\/span><strong><span style=\"color: #000000;\">L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m And trogn Excel k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m If<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Nh\u1eefng ch\u00fa \u00fd trong c\u00f4ng th\u1ee9c n\u00e0y c\u0169ng bao g\u1ed3m nh\u1eefng ch\u00fa \u00fd \u0111\u00e3 nh\u1eafc \u1edf c\u00fa ph\u00e1p h\u00e0m AND b\u00ean tr\u00ean v\u00e0 \u0111\u01b0\u1ee3c b\u1ed5 sung th\u00eam:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">T\u1ea1i v\u1ecb tr\u00ed \u201cValue_if_true\u201d, b\u1ea1n \u0111i\u1ec1n v\u00e0o \u0111\u00f3 gi\u00e1 tr\u1ecb \u0111\u01b0a ra n\u1ebfu to\u00e0n b\u1ed9 \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m AND l\u00e0 \u0111\u00fang.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Ng\u01b0\u1ee3c l\u1ea1i \u0111i\u1ec1n gi\u00e1 tr\u1ecb \u0111\u01b0a ra n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n hay ch\u1ec9 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t trong h\u00e0m AND l\u00e0 sai v\u00e0o v\u1ecb tr\u00ed \u201cValue_if_False\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Ch\u00fa \u00fd \u0111i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00fang, sai trong d\u1ea5u ngo\u1eb7c k\u00e9p. \u0110\u00f3 l\u00e0 c\u00fa ph\u00e1p chu\u1ea9n c\u1ee7a h\u00e0m IF AND.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u00fa ph\u00e1p s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n n\u00e0y l\u00e0 \u0111\u00fang hay sai. N\u1ebfu \u0111\u00fang th\u00ec \u0111\u01b0a ra gi\u00e1 tr\u1ecb \u0111\u00fang. Tr\u01b0\u1eddng h\u1ee3p k\u1ebft qu\u1ea3 sai th\u00ec xu\u1ea5t ra gi\u00e1 tr\u1ecb sai, kh\u00f4ng d\u00f9ng s\u1eed d\u1ee5ng c\u00e1c ph\u00e9p to\u00e1n c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1c \u0111i\u1ec1u ki\u1ec7n hay n\u1ed9i dung c\u00f3 m\u1ed1i quan h\u1ec7 \u201cv\u00e0\u201d v\u1edbi nhau th\u00ec \u0111\u01b0\u1ee3c \u0111\u1eb7t trong h\u00e0m AND, tr\u1edf th\u00e0nh c\u00e1c \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">V\u00ec c\u00fa ph\u00e1p n\u00e0y kh\u00e1 d\u00e0i n\u00ean \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c d\u1eef li\u1ec7u ph\u00eda d\u01b0\u1edbi, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn m\u1ed9t \u00f4 r\u1ed3i di chuy\u1ec3n chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 \u0111\u00f3 \u0111\u1ec3 xu\u1ea5t hi\u1ec7n d\u1ea5u \u201c+\u201d, nh\u1ea5n gi\u1eefu v\u00e0 k\u00e9o d\u1ea5u c\u1ed9ng n\u00e0y xu\u1ed1ng \u0111\u1ec3 copy c\u00fa ph\u00e1p.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_AND_khi_co_ket_hop_voi_ham_OR\"><\/span><span style=\"color: #000000;\"><b>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND khi c\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m AND v\u00e0 OR trong Excel l\u00e0 m\u1ed9t t\u1ed5 h\u1ee3p r\u1ea5t hay g\u1eb7p trong khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c ph\u00e9p to\u00e1n tr\u00ean d\u1eef li\u1ec7u c\u00e1c b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho. T\u1eeb \u0111\u00e2y gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u l\u1edbn v\u00e0 nhanh ch\u00f3ng h\u01a1n.\u00a0<\/span><\/p>\n<figure id=\"attachment_13320\" aria-describedby=\"caption-attachment-13320\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13320 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-3.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND khi c\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR\" width=\"600\" height=\"417\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-3-400x278.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13320\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND khi c\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m OR<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m AND v\u00e0 OR n\u00e0y \u0111\u01b0\u1ee3c t\u1ea1o th\u00e0nh b\u1eb1ng c\u00e1ch \u0111\u1eb7t h\u00e0m OR bao l\u1ea5y h\u00e0m AND \u1edf b\u00ean trong. V\u00ec v\u1eady, khi vi\u1ebft, b\u1ea1n h\u00e3y vi\u1ebft h\u00e0m OR tr\u01b0\u1edbc r\u1ed3i \u0111\u1ebfn h\u00e0m AND. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00fa ph\u00e1p h\u00e0m OR AND \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u1ea5t:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">= OR(AND(logical1, logical2,\u2026); logical,&#8230;)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y, c\u00e1c d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c xem x\u00e9t trong h\u00e0m AND. \u0110\u1ed3ng th\u1eddi \u0111\u1ed1i chi\u1ebfu v\u1edbi \u0111i\u1ec1u ki\u1ec7n d\u1eef li\u1ec7u \u1edf h\u00e0m OR \u0111\u1ec3 ki\u1ec3m tra v\u00e0 cho ra k\u1ebft qu\u1ea3 \u0111\u00fang hay sai c\u1ee7a d\u1eef li\u1ec7u. <\/span><span style=\"font-weight: 400;\">Tuy nhi\u00ean, AND v\u00e0 OR c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1eb1ng c\u00e1ch \u0111\u1ec3 h\u00e0m AND b\u00ean ngo\u00e0i h\u00e0m OR. Nh\u01b0ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y kh\u00f4ng th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00f3 \u00edt ng\u01b0\u1eddi s\u1eed d\u1ee5ng h\u01a1n.\u00a0<\/span><\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_ham_logic_AND_voi_cac_ham_IF_va_OR_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>K\u1ebft h\u1ee3p h\u00e0m logic AND v\u1edbi c\u00e1c h\u00e0m IF v\u00e0 OR trong Excel\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ngo\u00e0i c\u00e1c c\u00e1ch k\u1ebft h\u1ee3p tr\u00ean, h\u00e0m AND trong Excel c\u00f2n c\u00f3 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p c\u00f9ng l\u00fac v\u1edbi h\u00e0m IF v\u00e0 h\u00e0m OR. \u0110\u01b0\u01a1ng nhi\u00ean, c\u00fa ph\u00e1p k\u1ebft h\u1ee3p c\u1ea3 3 h\u00e0m s\u1ebd r\u1eafc r\u1ed1i, d\u1ec5 nh\u1ea7m l\u1eabn h\u01a1n. Tuy nhi\u00ean hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c s\u1ebd t\u0103ng cao, ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian h\u01a1n cho b\u1ea1n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_ham\"><\/span><strong>C\u00f4ng th\u1ee9c h\u00e0m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00f4ng th\u1ee9c c\u1ee7a s\u1ef1 k\u1ebft h\u1ee3p n\u00e0y l\u00e0:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">=IF(OR(&lt;\u0111i\u1ec1u ki\u1ec7n&gt;;AND(&lt;\u0111i\u1ec1u ki\u1ec7n&gt;,&#8230;));\u201cValue_if_true\u201d,\u201cValue_if_False\u201d)<\/span><\/p>\n<figure id=\"attachment_13321\" aria-describedby=\"caption-attachment-13321\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13321 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-4.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m logic AND v\u1edbi c\u00e1c h\u00e0m IF v\u00e0 OR trong Excel\u00a0\" width=\"600\" height=\"335\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel-4-400x223.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13321\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m logic AND v\u1edbi c\u00e1c h\u00e0m IF v\u00e0 OR trong Excel<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Luu_y_khi_su_dung\"><\/span><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00f4ng th\u1ee9c n\u00e0y c\u0169ng nh\u01b0 \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y d\u1ec5 d\u00e0ng h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc nh\u1eefng ch\u00fa \u00fd sau:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m IF c\u1ea7n bao h\u00e0m c\u1ea3 hai h\u00e0m OR v\u00e0 h\u00e0m AND \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ea1y d\u1eef li\u1ec7u v\u00e0 ki\u1ec3m tra c\u00e1c d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t: ki\u1ec3m tra logic c\u1ee7a ph\u00e9p to\u00e1n, ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u01b0a v\u1ec1 \u201ctrue\u201d hay v\u1ec1 \u201cfalse\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Ch\u00fa \u00fd c\u00e1c d\u1ea5u ngo\u1eb7c k\u00e9p, ngo\u1eb7c tr\u00f2n trong khi vi\u1ebft c\u00fa ph\u00e1p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m OR v\u00e0 h\u00e0m AND l\u1ed3ng b\u00ean trong ch\u00ednh l\u00e0 d\u1eef li\u1ec7u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 h\u00e0m IF ti\u1ebfn h\u00e0nh ki\u1ec3m tra logic.<\/span><\/li>\n<\/ul>\n<p><strong>XEM TH\u00caM: <\/strong><\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-dau-phay-thanh-dau-cham-trong-excel\/\"><strong>Top 3 c\u00e1ch \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel ti\u1ec7n l\u1ee3i<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/ham-tinh-thoi-gian-trong-excel\/\"><strong>Kh\u00e1m ph\u00e1 h\u00e0m t\u00ednh th\u1eddi gian trong Excel th\u00f4ng d\u1ee5ng nh\u1ea5t<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-if-nhieu-dieu-kien\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m If nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng trong Excel d\u1ec5 hi\u1ec3u<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-if-nhieu-dieu-kien-2\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m if nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1ch d\u00f9ng \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 ph\u00e9p to\u00e1n v\u1edbi h\u00e0m AND trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft. Hi\u1ec7n t\u1ea1i, h\u00e0m n\u00e0y \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i v\u00e0 c\u1ea7n thi\u1ebft trong c\u00e1c d\u1eef li\u1ec7u t\u1ea1i nhi\u1ec1u v\u0103n ph\u00f2ng. V\u00ec v\u1eady, d\u00f9 b\u1ea1n l\u00e0m vi\u1ec7c \u1edf \u0111\u00e2u, h\u00e3y ch\u1eafc r\u1eb1ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o h\u00e0m AND v\u00e0 c\u00e1c s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a n\u00f3.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m And trong Excel c\u00f3 c\u00f4ng th\u1ee9c l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u00ednh to\u00e1n n\u00e0y ra sao? N\u1ebfu b\u1ea1n \u0111ang quan t\u00e2m t\u1edbi nh\u1eefng c\u00e2u h\u1ecfi tr\u00ean th\u00ec \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin sau. B\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi c\u1ee7a TEKY s\u1ebd c\u00f9ng b\u1ea1n kh\u00e1m ph\u00e1 chi ti\u1ebft h\u00e0m t\u00ednh to\u00e1n n\u00e0y. C\u00f9ng theo d\u00f5i &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13317,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p<\/title>\n<meta name=\"description\" content=\"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-26T14:41:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T08:14:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"444\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p\",\"datePublished\":\"2022-11-26T14:41:08+00:00\",\"dateModified\":\"2022-12-07T08:14:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\"},\"wordCount\":1952,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\",\"name\":\"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png\",\"datePublished\":\"2022-11-26T14:41:08+00:00\",\"dateModified\":\"2022-12-07T08:14:44+00:00\",\"description\":\"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png\",\"width\":600,\"height\":444,\"caption\":\"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p","description":"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p","og_description":"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!","og_url":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-26T14:41:08+00:00","article_modified_time":"2022-12-07T08:14:44+00:00","og_image":[{"width":600,"height":444,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p","datePublished":"2022-11-26T14:41:08+00:00","dateModified":"2022-12-07T08:14:44+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/"},"wordCount":1952,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/","name":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png","datePublished":"2022-11-26T14:41:08+00:00","dateModified":"2022-12-07T08:14:44+00:00","description":"H\u00e0m And trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 h\u00e0m n\u00e0y th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft sau!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Ham-And-trong-Excel.png","width":600,"height":444,"caption":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-and-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m And trong Excel v\u00e0 nh\u1eefng c\u00e1ch d\u00f9ng th\u01b0\u1eddng g\u1eb7p"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13316"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13316\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13317"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}