{"id":13116,"date":"2024-03-03T19:05:37","date_gmt":"2024-03-03T12:05:37","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13116"},"modified":"2024-03-04T13:57:53","modified_gmt":"2024-03-04T06:57:53","slug":"phep-nhan-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/","title":{"rendered":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t"},"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;13116&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;8&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.6&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;4.6\\\/5 - (8 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t&quot;,&quot;width&quot;:&quot;130.9&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: 130.9px;\">\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            4.6\/5 - (8 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><strong>Ph\u00e9p nh\u00e2n trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. Th\u1ebf nh\u01b0ng trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00f3 qu\u00e1 nhi\u1ec1u s\u1ed1 li\u1ec7u th\u00ec ph\u00e9p t\u00ednh n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0u th\u1ebf n\u00e0o? N\u1ebfu b\u1ea1n c\u0169ng \u0111ang b\u0103n kho\u0103n v\u1ea5n \u0111\u1ec1 n\u00e0y th\u00ec \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch trong b\u00e0i vi\u1ebft sau sau. TEKY s\u1ebd t\u1ed5ng h\u1ee3p t\u1edbi b\u1ea1n 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n nhanh ch\u00f3ng, d\u1ec5 hi\u1ec3u nh\u1ea5t trong Excel. \u0110\u1ed3ng h\u00e0nh ngay th\u00f4i n\u00e0o!<\/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\/phep-nhan-trong-excel\/#Dung_phep_toan_tu_nhan\" >D\u00f9ng ph\u00e9p to\u00e1n t\u1eed nh\u00e2n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#Cong_thuc_trien_khai\" >C\u00f4ng th\u1ee9c tri\u1ec3n khai<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#Vi_du_minh_hoa\" >V\u00ed d\u1ee5 minh h\u1ecda<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#Dung_ham_PRODUCT_de_lam_phep_nhan_trong_Excel\" >D\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 l\u00e0m ph\u00e9p nh\u00e2n trong Excel<\/a><\/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\/phep-nhan-trong-excel\/#Dung_ham_SUMPRODUCT_de_thuc_hien_cac_phep_tinh_toan_trong_excel\" >D\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n trong excel<\/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\/phep-nhan-trong-excel\/#Ket_hop_ham_IF_va_ham_PRODUCT_de_thuc_hien_tinh_toan\" >K\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m PRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_phep_toan_tu_nhan\"><\/span>D\u00f9ng ph\u00e9p to\u00e1n t\u1eed nh\u00e2n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Ph\u00e9p nh\u00e2n trong excel \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u l\u00e0 g\u00ec. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00e2u h\u1ecfi r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi khi m\u1edbi h\u1ecdc Excel quan t\u00e2m. Ph\u00e9p nh\u00e2n trong excel s\u1ebd \u0111\u01b0\u1ee3c k\u00fd hi\u1ec7u l\u00e0 d\u1ea5u * (sao).<\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_trien_khai\"><\/span><strong>C\u00f4ng th\u1ee9c tri\u1ec3n khai<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 ph\u00e9p nh\u00e2n trong th\u1ef1c t\u1ebf, ph\u00e9p nh\u00e2n trong excel c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p=Number1*Number2*Number3*&#8230;&#8230;*NumberN<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3: Number1, Number2, Number3, NumberN&#8230; l\u00e0 c\u00e1c s\u1ed1. Ho\u1eb7c c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ecba ch\u1ec9 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh t\u00edch.<\/p>\n<figure id=\"attachment_13118\" aria-describedby=\"caption-attachment-13118\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13118 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-1.jpg\" alt=\"D\u00f9ng ph\u00e9p to\u00e1n t\u1eed nh\u00e2n\" width=\"600\" height=\"324\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-1-400x216.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13118\" class=\"wp-caption-text\">D\u00f9ng ph\u00e9p to\u00e1n t\u1eed nh\u00e2n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">V\u1edbi c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c nh\u00e2n c\u00e1c s\u1ed1 tr\u1ef1c ti\u1ebfp. Ho\u1eb7c nh\u1eadp \u0111\u1ecba ch\u1ec9 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n. C\u00f9ng th\u1ef1c hi\u1ec7n v\u00ed d\u1ee5 \u0111\u1ec3 d\u1ec5 h\u00ecnh dung h\u01a1n nh\u00e9.<\/p>\n<p><iframe loading=\"lazy\" title=\"h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng l\u1ec7nh c\u1ed9ng tr\u1eeb nh\u00e2n chia l\u1ec7nh sum tr\u00ean Excel r\u1ec5 nh\u1ea5t cho ng\u01b0\u1eddi m\u1edbi\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/opymDCuQWOk?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<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Vi_du_minh_hoa\"><\/span><strong>V\u00ed d\u1ee5 minh h\u1ecda<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5 1: Th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh th\u1ec3 t\u00edch c\u1ee7a h\u1ed9p ch\u1eef nh\u1eadt. Trong \u0111\u00f3 c\u00e1c k\u00edch th\u01b0\u1edbc \u0111\u01b0\u1ee3c cho tr\u01b0\u1edbc l\u1ea7n l\u01b0\u1ee3t l\u00e0 60, 15, 2.4. C\u00f3 2 c\u00e1ch t\u00ednh nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><strong>C\u00e1ch 1: Nh\u1eadp =60*15*2.4 \u21d2 Sau \u0111\u00f3 nh\u1ea5n Enter, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2160.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">C\u00e1ch t\u00ednh n\u00e0y th\u00edch h\u1ee3p v\u1edbi nh\u1eefng ph\u00e9p t\u00ednh ng\u1eafn, \u0111\u01a1n gi\u1ea3n. V\u1edbi nh\u1eefng ph\u00e9p t\u00ednh nh\u00e2n trong excel d\u00e0i, vi\u1ec7c nh\u1eadp s\u1ed1 li\u1ec7u c\u00f3 th\u1ec3 c\u00f3 nh\u1eefng sai s\u00f3t. B\u00ean c\u1ea1nh \u0111\u00f3, m\u1ed9t nh\u01b0\u1ee3c \u0111i\u1ec3m n\u1eefa l\u00e0 khi mu\u1ed1n l\u00e0m c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c th\u00ec ph\u1ea3i th\u1ef1c hi\u1ec7n l\u1ea1i t\u1eeb \u0111\u1ea7u.<\/p>\n<p>&gt;&gt;&gt; Xem th\u00eam :\u00a0<a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-cong-tru-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m c\u1ed9ng tr\u1eeb trong Excel | H\u01b0\u1edbng d\u1eabn c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng<\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><strong>C\u00e1ch 2: T\u00ednh k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean \u0111\u1ecba ch\u1ec9 \u00f4<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><i>B\u01b0\u1edbc 1:<\/i> Nh\u1eadp =B2*C2*D2 \u21d2 Nh\u1ea5n Enter. K\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p t\u00ednh l\u00e0 2160.<\/p>\n<p style=\"text-align: justify;\"><i>B\u01b0\u1edbc 2:<\/i> Nh\u1ea5p chu\u1ed9t \u1edf \u00f4 k\u1ebft qu\u1ea3. Ti\u1ebfp \u0111\u00f3 \u0111\u01b0a con tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4. Sao cho con tr\u1ecf chu\u1ed9t chuy\u1ec3n sang d\u1ea5u + nh\u01b0 h\u00ecnh d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify;\"><i>B\u01b0\u1edbc 3:<\/i> K\u00e9o th\u1ea3 chu\u1ed9t \u0111\u1ebfn t\u1eadn h\u00e0ng cu\u1ed1i c\u00f9ng c\u1ee7a danh s\u00e1ch. Khi \u0111\u00f3, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh th\u1ec3 t\u00edch c\u1ee7a c\u00e1c h\u00ecnh h\u1ed9p ch\u1eef nh\u1eadt c\u00f2n l\u1ea1i. Kh\u00f4ng c\u1ea7n ph\u1ea3i l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc qu\u00e1 nhi\u1ec1u l\u1ea7n.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_PRODUCT_de_lam_phep_nhan_trong_Excel\"><\/span><strong>D\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 l\u00e0m ph\u00e9p nh\u00e2n trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">\u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m t\u00ednh ph\u00e9p nh\u00e2n trong excel r\u1ea5t th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p =PRODUCT(No.1, No.2, No.3&#8230;No.N)<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3: N0.1, No.2, No.N,&#8230; l\u00e0 gi\u00e1 tr\u1ecb c\u00e1c s\u1ed1 ho\u1eb7c \u0111\u1ecba ch\u1ec9 c\u00f3 \u00f4 ch\u1ee9a s\u1ed1 m\u00e0 b\u1ea1n c\u1ea7n t\u00ednh t\u00edch.<\/p>\n<figure id=\"attachment_13120\" aria-describedby=\"caption-attachment-13120\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13120 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-2-1.jpg\" alt=\"D\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 l\u00e0m ph\u00e9p nh\u00e2n trong Excel\" width=\"600\" height=\"377\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-2-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-2-1-400x251.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13120\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 l\u00e0m ph\u00e9p nh\u00e2n trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">\u0110\u1ed1i v\u1edbi h\u00e0m PRODUCT, c\u00e1c gi\u00e1 tr\u1ecb Number1, Number2,\u2026 b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e0 s\u1ed1. H\u00e0m n\u00e0y cho ph\u00e9p nh\u1eadp t\u1ed1i \u0111a 255 gi\u00e1 tr\u1ecb. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m PRODUCT kh\u00e1 gi\u1ed1ng v\u1edbi h\u00e0m t\u1eed nh\u00e2n. Tuy nhi\u00ean n\u00f3 s\u1ebd ti\u1ec7n l\u1ee3i h\u01a1n r\u1ea5t nhi\u1ec1u trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ednh ph\u00e9p nh\u00e2n trong excel c\u1ee7a gi\u00e1 tr\u1ecb \u1edf nhi\u1ec1u \u00f4.<\/p>\n<p>&gt;&gt;&gt; xem th\u00eam :\u00a0<a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\" target=\"_blank\" rel=\"noopener\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n si\u00eau \u0111\u01a1n gi\u1ea3n trong Excel\u00a0<\/a><\/p>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5: D\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 t\u00ednh ti\u1ec1n nguy\u00ean v\u1eadt li\u1ec7u d\u00f9ng cho vi\u1ec7c s\u1ea3n xu\u1ea5t m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u00ecnh kh\u1ed1i ch\u1eef nh\u1eadt.<\/p>\n<p style=\"text-align: justify;\">B\u1ea1n s\u1ebd c\u1ea7n t\u00ednh th\u1ec3 t\u00edch h\u00ecnh h\u1ed9p sau \u0111\u00f3 d\u00f9ng gi\u00e1 tr\u1ecb \u0111\u00f3 nh\u00e2n v\u1edbi gi\u00e1 nguy\u00ean v\u1eadt li\u1ec7u. T\u1ebfp \u0111\u00f3 nh\u00e2n v\u1edbi s\u1ed1 l\u01b0\u1ee3ng th\u00ec s\u1ebd ra k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng. Thay v\u00ec nh\u1eadp c\u00f4ng th\u1ee9c =B2*C2*D2*E2*F2 theo nh\u01b0 ph\u00e9p to\u00e1n t\u1eed nh\u00e2n trong excel. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp h\u00e0m =PRODUCT(B2:F2) l\u00e0 \u0111\u00e3 \u0111c tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nhanh ch\u00f3ng.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dung_ham_SUMPRODUCT_de_thuc_hien_cac_phep_tinh_toan_trong_excel\"><\/span><strong>D\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n trong excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">H\u00e0m SUMPRODUCT l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eef 2 h\u00e0m l\u00e0 h\u00e0m SUM (\u0111\u1ec3 t\u00ednh t\u1ed5ng) v\u00e0 h\u00e0m PRODUCT (\u0111\u1ec3 t\u00ednh t\u00edch). H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn khi t\u00ednh t\u1ed5ng. Bao g\u1ed3m c\u1ea3 t\u1ed5ng doanh thu, t\u1ed5ng l\u01b0\u01a1ng hay t\u1ed5ng v\u1ed1n \u0111\u1ea7u t\u01b0, t\u1ed5ng gi\u00e1 tr\u1ecb nguy\u00ean v\u1eadt li\u1ec7u c\u1ee7a m\u1ed9t doanh nghi\u1ec7p, t\u1ed5 ch\u1ee9c. H\u00e0m SUMPRODUCT c\u0169ng cho ph\u00e9p nh\u1eadp t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1 cho m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh:<\/p>\n<figure id=\"attachment_13121\" aria-describedby=\"caption-attachment-13121\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13121 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-3.png\" alt=\"D\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n trong excel\" width=\"600\" height=\"402\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-3-400x268.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-3-272x182.png 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13121\" class=\"wp-caption-text\">D\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n trong excel<\/figcaption><\/figure>\n<p>&gt;&gt;&gt; Xem th\u00eam :\u00a0<a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/tip-su-dung-ham-mu-trong-excel-sieu-don-gian\/\" target=\"_blank\" rel=\"noopener\">Tip s\u1eed d\u1ee5ng h\u00e0m m\u0169 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n<\/a><\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p h\u00e0m: =SUMPRODUCT(array1; [array2]; [array3]; \u2026)<\/p>\n<p style=\"text-align: justify;\">Trong \u0111\u00f3: Array1, array2,\u2026 ph\u1ea3i l\u00e0 b\u1eaft bu\u1ed9c l\u00e0 s\u1ed1 v\u00e0 c\u00f3 c\u00f9ng k\u00edch c\u1ee1.<\/p>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5: T\u00ednh t\u1ed5ng l\u01b0\u01a1ng c\u1ee7a to\u00e0n b\u1ed9 nh\u00e2n vi\u00ean m\u1ed9t c\u00f4ng ty trong th\u00e1ng.<\/p>\n<p style=\"text-align: justify;\">Th\u00f4ng th\u01b0\u1eddng, ch\u00fang ta s\u1ebd t\u00ednh ph\u00e9p nh\u00e2n trong excel c\u1ee7a c\u00e1c s\u1ed1 \u1edf c\u1ed9t C v\u00e0 c\u1ed9t D. Cho ra k\u1ebft qu\u1ea3 l\u00e0 l\u01b0\u01a1ng c\u1ee7a m\u1ed7i ng\u01b0\u1eddi \u1edf c\u1ed9t E. Sau \u0111\u00f3 ti\u1ebfp t\u1ee5c d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng ti\u1ec1n l\u01b0\u01a1ng \u1edf t\u1ea5t c\u1ea3 h\u00e0ng c\u1ed9t E. K\u1ebft qu\u1ea3 s\u1ebd cho ra cu\u1ed1i c\u00f9ng \u1edf E10.<\/p>\n<p style=\"text-align: justify;\">Tuy nhi\u00ean v\u1edbi h\u00e0m n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t c\u00fa ph\u00e1p SUMPRODUCT duy nh\u1ea5t.\u00a0C\u00e1ch n\u00e0y kh\u00f4ng nh\u1eefng ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n h\u1ea1n ch\u1ebf nh\u1eefng sai s\u00f3t trong vi\u1ec7c nh\u1eadp sai s\u1ed1 li\u1ec7u c\u1ee7a t\u1eebng \u00f4.<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ket_hop_ham_IF_va_ham_PRODUCT_de_thuc_hien_tinh_toan\"><\/span><strong>K\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m PRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">Vi\u1ec7c k\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 PRODUCT nh\u1eb1m m\u1ee5c \u0111\u00edch th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n trong excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p=IF(\u0110i\u1ec1u ki\u1ec7n, PRODUCT(M, N), PRODUCT(X, Y))<\/p>\n<p style=\"text-align: justify;\">C\u00fa ph\u00e1p n\u00e0y c\u00f3 ngh\u0129a l\u00e0: Trong tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m IF l\u00e0 \u0111\u00fang th\u00ec s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n M v\u1edbi N. Ng\u01b0\u1ee3c l\u1ea1i n\u1ebfu sai th\u00ec th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n X v\u1edbi Y. H\u00e3y th\u1eed xem qua v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 d\u1ec5 h\u00ecnh dung h\u01a1n.<\/p>\n<figure id=\"attachment_13122\" aria-describedby=\"caption-attachment-13122\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13122 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-4.jpg\" alt=\"K\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m PRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n\" width=\"600\" height=\"342\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-4-400x228.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13122\" class=\"wp-caption-text\">K\u1ebft h\u1ee3p h\u00e0m IF v\u00e0 h\u00e0m PRODUCT \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">V\u00ed d\u1ee5: T\u00ednh l\u01b0\u01a1ng tu\u1ea7n c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi 2 ca l\u00e0m, m\u1ed7i ca l\u00e0m l\u1ea1i c\u00f3 s\u1ed1 ti\u1ec1n l\u01b0\u01a1ng kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify;\">N\u1ebfu nh\u00e2n vi\u00ean l\u00e0m vi\u1ec7c \u1edf ca 1 th\u00ec s\u1ebd t\u00ednh theo s\u1ed1 ti\u1ec1n l\u01b0\u01a1ng l\u00e0m vi\u1ec7c c\u1ee7a ca 1. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu l\u00e0m theo ca 2 (t\u1ee9c \u0111i\u1ec1u ki\u1ec7n ca l\u00e0m vi\u1ec7c = 1 l\u00e0 sai) th\u00ec t\u00ednh l\u01b0\u01a1ng theo s\u1ed1 ti\u1ec1n l\u01b0\u01a1ng khi l\u00e0m ca 2. Ph\u00e9p t\u00ednh th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify;\">Nh\u1eadp =IF(C3=1,PRODUCT(D3,E3),PRODUCT(D3,F3)) \u21d2 Nh\u1ea5n Enter. \u1ede \u0111\u00e2y, gi\u00e1 tr\u1ecb C3=1(\u0111i\u1ec1u ki\u1ec7n \u0111\u00fang) th\u00ec excel s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 3,300,000 (k\u1ebft qu\u1ea3 ph\u00e9p nh\u00e2n 6 ng\u00e0y c\u00f4ng v\u1edbi ti\u1ec1n l\u01b0\u01a1ng ca 1 l\u00e0 550,000). Ti\u1ebfp \u0111\u00f3, th\u1ef1c hi\u1ec7n vi\u1ec7c k\u00e9o th\u1ea3 chu\u1ed9t t\u1edbi h\u00e0ng cu\u1ed1i c\u00f9ng trong danh s\u00e1ch. B\u1ea1n s\u1ebd t\u00ednh \u0111\u01b0\u1ee3c l\u01b0\u01a1ng c\u1ee7a nh\u00e2n vi\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c ca l\u00e0m vi\u1ec7c.<\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\"><strong>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/copy-cong-thuc-trong-excel\/\"><strong>Copy c\u00f4ng th\u1ee9c trong Excel nhanh ch\u00f3ng trong gi\u00e2y l\u00e1t<\/strong><\/a><\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p nh\u00e2n trong excel. V\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m n\u00e0y, vi\u1ec7c t\u00ednh to\u00e1n s\u1ebd kh\u00f4ng c\u00f2n l\u00e0 n\u1ed7i \u00e1m \u1ea3nh \u0111\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi. H\u00e3y tham kh\u1ea3o v\u00e0 \u00e1p d\u1ee5ng n\u1ebfu nh\u01b0 b\u1ea1n ph\u1ea3i ti\u1ebfn h\u00e0nh th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh nh\u00e2n nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ph\u00e9p nh\u00e2n trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. Th\u1ebf nh\u01b0ng trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p c\u00f3 qu\u00e1 nhi\u1ec1u s\u1ed1 li\u1ec7u th\u00ec ph\u00e9p t\u00ednh n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0u th\u1ebf n\u00e0o? N\u1ebfu b\u1ea1n c\u0169ng \u0111ang b\u0103n kho\u0103n v\u1ea5n \u0111\u1ec1 n\u00e0y th\u00ec \u0111\u1eebng b\u1ecf l\u1ee1 th\u00f4ng tin h\u1eefu \u00edch trong b\u00e0i vi\u1ebft sau sau. TEKY s\u1ebd t\u1ed5ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"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>4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft<\/title>\n<meta name=\"description\" content=\"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!\" \/>\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\/phep-nhan-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/phep-nhan-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=\"2024-03-03T12:05:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-04T06:57:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"8 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\/phep-nhan-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t\",\"datePublished\":\"2024-03-03T12:05:37+00:00\",\"dateModified\":\"2024-03-04T06:57:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\"},\"wordCount\":1903,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\",\"name\":\"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg\",\"datePublished\":\"2024-03-03T12:05:37+00:00\",\"dateModified\":\"2024-03-04T06:57:53+00:00\",\"description\":\"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg\",\"width\":600,\"height\":337,\"caption\":\"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/phep-nhan-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\":\"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t\"}]},{\"@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":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft","description":"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!","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\/phep-nhan-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft","og_description":"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/phep-nhan-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":"2024-03-03T12:05:37+00:00","article_modified_time":"2024-03-04T06:57:53+00:00","og_image":[{"width":600,"height":337,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg","type":"image\/jpeg"}],"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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t","datePublished":"2024-03-03T12:05:37+00:00","dateModified":"2024-03-04T06:57:53+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/"},"wordCount":1903,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/","name":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t b\u1ea1n n\u00ean bi\u1ebft","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg","datePublished":"2024-03-03T12:05:37+00:00","dateModified":"2024-03-04T06:57:53+00:00","description":"D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t m\u00e0 TEKY mu\u1ed1n gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n. Theo d\u00f5i ngay \u1edf b\u00e0i vi\u1ebft nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel.jpg","width":600,"height":337,"caption":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/phep-nhan-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":"4 c\u00e1ch t\u00ednh ph\u00e9p nh\u00e2n trong Excel d\u1ec5 hi\u1ec3u nh\u1ea5t"}]},{"@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\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Phep-nhan-trong-Excel-400x225.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13116","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=13116"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13116\/revisions"}],"predecessor-version":[{"id":24324,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13116\/revisions\/24324"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13117"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}