{"id":43631,"date":"2022-04-12T15:01:47","date_gmt":"2022-04-12T08:01:47","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=43631"},"modified":"2022-04-12T15:01:47","modified_gmt":"2022-04-12T08:01:47","slug":"ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/","title":{"rendered":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng t\u00ednh to\u00e1n th\u01b0\u1eddng s\u1ebd s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra nh\u1eefng \u0111i\u1ec1u ki\u1ec7n li\u1ec7u c\u00f3 ch\u00ednh x\u00e1c hay kh\u00f4ng? C\u00f9ng xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y v\u1edbi Divine Shop \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n b\u1ea1n nh\u00e9.<\/strong><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Ham_AND_trong_Excel_la_gi_Su_dung_ham_AND_de_lam_gi\"><\/span><span id=\"Ham_AND_trong_Excel_la_gi_Su_dung_ham_AND_de_lam_gi\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">H\u00e0m AND trong Excel l\u00e0 g\u00ec? S\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 l\u00e0m g\u00ec?<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m AND l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra xem li\u1ec7u t\u1ea5t c\u1ea3 nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n c\u1ee7a m\u1ed9t t\u1eadp h\u1ee3p d\u1eef li\u1ec7u \u0111\u00fang hay kh\u00f4ng. B\u00ean c\u1ea1nh vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m AND m\u1ed9t c\u00e1ch \u0111\u1ed9c l\u1eadp th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m IF, OR,\u2026 \u0111\u1ec3 ki\u1ec3m tra nh\u1eefng gi\u00e1 tr\u1ecb logic kh\u00e1c.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-522724\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4eae62c.jpeg\" alt=\"H\u00e0m AND trong Excel\" width=\"1000\" height=\"544\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_AND_de_lam_gi\"><\/span><span id=\"Su_dung_ham_AND_de_lam_gi\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">S\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 l\u00e0m g\u00ec?<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>H\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u00e3 t\u00ednh \u0111\u00fang hay ch\u01b0a.<\/li>\n<li>Gi\u00fap ng\u01b0\u1eddi d\u00f9ng tr\u1edf n\u00ean chuy\u00ean nghi\u1ec7p h\u01a1n khi d\u00f9ng Excel.<\/li>\n<li>S\u1eed d\u1ee5ng chung v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c nh\u01b0 IF, IFS ho\u1eb7c OR \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed1t h\u01a1n.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_AND_trong_Excel\"><\/span><span id=\"Cu_phap_cua_ham_AND_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m AND trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m AND trong Excel c\u00f3 c\u00fa ph\u00e1p sau: <strong>=AND(logical1,[logical2],\u2026)<\/strong><\/p>\n<p><strong>Trong \u0111\u00f3:\u00a0<\/strong><\/p>\n<ul>\n<li><strong>Logical1, Logical2,<\/strong>\u2026: L\u00e0 nh\u1eefng m\u1ec7nh \u0111\u1ec1 logic.<\/li>\n<\/ul>\n<p><strong>K\u1ebft qu\u1ea3 khi s\u1eed d\u1ee5ng h\u00e0m AND l\u00e0:<\/strong><\/p>\n<ul>\n<li><strong>TRUE:<\/strong> N\u1ebfu nh\u01b0 nh\u1eefng m\u1ec7nh \u0111\u1ec1 logic trong b\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec1u \u0111\u00fang.<\/li>\n<li><strong>FALSE:<\/strong> N\u1ebfu nh\u01b0 c\u00e1c m\u1ec7nh \u0111\u1ec1 trong b\u1ea3ng logic c\u00f3 m\u1ed9t m\u1ec7nh \u0111\u1ec1 b\u1ea5t k\u1ef3 sai.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_AND_trong_Excel\"><\/span><span id=\"Cach_su_dung_ham_AND_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <\/span><\/strong><strong><span style=\"font-size: 18pt\">AND <\/span><\/strong><strong><span style=\"font-size: 18pt\">trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Cho v\u00ed d\u1ee5 sau:<\/strong> S\u1eed d\u1ee5ng H\u00e0m AND \u0111\u1ec3 th\u1ef1c hi\u1ec7n ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 c\u00e1c h\u1ecdc sinh trong l\u1edbp \u0111\u1ea1t h\u1ecdc sinh gi\u1ecfi.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf b\u1ea3ng d\u1eef li\u1ec7u b\u1ea1n c\u1ea7n ki\u1ec3m tra d\u1eef li\u1ec7u logic trong Excel &gt; \u1ede \u00f4 K\u1ebft qu\u1ea3 b\u1ea1n<strong> nh\u1eadp c\u00fa ph\u00e1p h\u00e0m AND:<\/strong> <strong>=AND(C2&gt;=8, D2&gt;=8, E2&gt;=8)<\/strong> v\u00e0o \u00f4 k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-522720 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4f4b547.jpeg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel b\u01b0\u1edbc 1\" width=\"1029\" height=\"669\" \/><\/p>\n<p><strong>Trong \u0111\u00f3:\u00a0<\/strong><\/p>\n<ul>\n<li><strong>AND:<\/strong> L\u00e0 l\u1ec7nh h\u00e0m.<\/li>\n<li><strong>C2&gt;=8, D2&gt;=8, E2&gt;=8:<\/strong> \u0110\u00e2y l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n m\u00e0 m\u00f4n To\u00e1n, V\u0103n, Anh ph\u1ea3i l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8 th\u00ec h\u1ecd m\u1edbi x\u00e9t duy\u1ec7t h\u1ecdc sinh gi\u1ecfi. Ba \u0111i\u1ec1u ki\u1ec7n tr\u00ean ph\u1ea3i c\u00f9ng \u0111\u1ea1t c\u00f9ng nhau n\u00ean ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m AND.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, <strong>nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t nh\u1eadp h\u00e0m<\/strong> v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-522721 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a502bc2c.jpeg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel b\u01b0\u1edbc 2\" width=\"1030\" height=\"670\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3, b\u1ea1n<strong> b\u1ea5m v\u00e0o g\u00f3c ph\u1ea3i d\u01b0\u1edbi c\u1ee7a k\u1ebft qu\u1ea3<\/strong> v\u00e0 k\u00e9o gi\u1eef cho \u0111\u1ebfn h\u1ebft d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-522722 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a51b00e2.jpeg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel b\u01b0\u1edbc 3\" width=\"1032\" height=\"670\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea3ng sau khi s\u1eed d\u1ee5ng h\u00e0m AND nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-522723 size-full\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a530064d.jpeg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel b\u01b0\u1edbc 4\" width=\"1031\" height=\"668\" \/><\/p>\n<p><strong>Gi\u1ea3i th\u00edch:<\/strong> B\u1ea1n \u0110\u1ea1t v\u00e0 B\u1ea3o cho ra<strong> k\u1ebft qu\u1ea3 l\u00e0 FALSE<\/strong> t\u1ee9c l\u00e0 2 b\u1ea1n kh\u00f4ng \u0111\u1ea1t \u0111\u01b0\u1ee3c h\u1ecdc sinh gi\u1ecfi do kh\u00f4ng th\u1ecfa \u0111i\u1ec1u ki\u1ec7n 3 m\u00f4n \u0111\u1ec1u \u0111\u1ea1t \u0111i\u1ec3m 8.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m AND trong Excel \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00fang hay sai r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. Hy v\u1ecdng b\u00e0i h\u01b0\u1edbng d\u1eabn c\u1ee7a ch\u00fang t\u00f4i s\u1ebd gi\u00fap \u00edch \u0111\u01b0\u1ee3c cho b\u1ea1n trong l\u00fac th\u1ef1c hi\u1ec7n. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?tag=microsoft\" href=\"https:\/\/divineshop.vn\/search?tag=microsoft\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?tag=microsoft noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png\" alt=\"\" class=\"wp-image-276759\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-container-69e55d607aeee wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?q=windows\" href=\"https:\/\/divineshop.vn\/search?q=windows\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?q=windows noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png\" alt=\"\" class=\"wp-image-256838\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng t\u00ednh to\u00e1n th\u01b0\u1eddng s\u1ebd s\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra nh\u1eefng \u0111i\u1ec1u ki\u1ec7n li\u1ec7u c\u00f3 ch\u00ednh x\u00e1c hay kh\u00f4ng? C\u00f9ng xem b\u00e0i vi\u1ebft [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":43632,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[238],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-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 l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel\" \/>\n<meta property=\"og:description\" content=\"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T08:01:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg\",\"width\":1600,\"height\":900},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/\",\"name\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage\"},\"datePublished\":\"2022-04-12T08:01:47+00:00\",\"dateModified\":\"2022-04-12T08:01:47+00:00\",\"description\":\"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel\",\"datePublished\":\"2022-04-12T08:01:47+00:00\",\"dateModified\":\"2022-04-12T08:01:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage\"},\"wordCount\":782,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg\",\"keywords\":[\"Microsoft Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng","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:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel","og_description":"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng","og_url":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T08:01:47+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"4 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg","width":1600,"height":900},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/","name":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage"},"datePublished":"2022-04-12T08:01:47+00:00","dateModified":"2022-04-12T08:01:47+00:00","description":"\u0110\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean t\u1ea1o b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n, ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u00ec ch\u1eafc h\u1eb3n c\u00f4ng c\u1ee5 Excel kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1. Th\u00f4ng th\u01b0\u1eddng, trong c\u00e1c b\u1ea3ng","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"H\u00e0m AND trong Excel l\u00e0 g\u00ec? Chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AND trong Excel","datePublished":"2022-04-12T08:01:47+00:00","dateModified":"2022-04-12T08:01:47+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#webpage"},"wordCount":782,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/ham-and-trong-excel-la-gi-chi-tiet-cach-su-dung-ham-and-trong-excel_623d4a4c98b8b.jpeg","keywords":["Microsoft Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/43631"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=43631"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/43631\/revisions"}],"predecessor-version":[{"id":72647,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/43631\/revisions\/72647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/43632"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=43631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=43631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=43631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}