{"id":12681,"date":"2022-11-29T10:00:22","date_gmt":"2022-11-29T03:00:22","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12681"},"modified":"2022-12-06T14:50:45","modified_gmt":"2022-12-06T07:50:45","slug":"ham-nhan-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n"},"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;12681&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;C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n&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;\"><span style=\"font-weight: 400;\">Kh\u00f4ng \u00edt ng\u01b0\u1eddi khi thao t\u00e1c v\u1edbi Excel v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\"> nh\u01b0 th\u1ebf n\u00e0o m\u1edbi \u0111\u00fang. \u0110\u1eb7c bi\u1ec7t l\u00e0 khi g\u1eb7p ph\u1ea3i c\u00e1c l\u1ed7i trong qu\u00e1 tr\u00ecnh \u00e1p d\u1ee5ng h\u00e0m ph\u1ea3i x\u1eed l\u00fd nh\u01b0 th\u1ebf n\u00e0o. <a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a> s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/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-nhan-trong-excel\/#Ham_nhan_trong_Excel_la_ham_nao\" >H\u00e0m nh\u00e2n trong Excel l\u00e0 h\u00e0m n\u00e0o?<\/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-nhan-trong-excel\/#Ham_nhan_trong_Excel_su_dung_nhu_the_nao\" >H\u00e0m nh\u00e2n trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Cac_cach_tinh_ham_nhan_trong_Excel\" >C\u00e1c c\u00e1ch t\u00ednh h\u00e0m nh\u00e2n 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-4\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Tinh_tich_cho_tung_so\" >T\u00ednh t\u00edch cho t\u1eebng s\u1ed1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Cach_tinh_ham_nhan_2_cot_trong_Excel\" >C\u00e1ch t\u00ednh h\u00e0m nh\u00e2n 2 c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Cach_tinh_tich_tren_nhieu_cot\" >C\u00e1ch t\u00ednh t\u00edch tr\u00ean nhi\u1ec1u c\u1ed9t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Cach_tinh_tich_bang_ham_nhan_trong_Excel_ket_hop_cac_ham_khac\" >C\u00e1ch t\u00ednh t\u00edch b\u1eb1ng h\u00e0m nh\u00e2n trong Excel k\u1ebft h\u1ee3p c\u00e1c h\u00e0m kh\u00e1c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Huong_dan_cach_khac_phuc_mot_so_loi_khi_ap_dung_ham_nhan_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c m\u1ed9t s\u1ed1 l\u1ed7i khi \u00e1p d\u1ee5ng h\u00e0m nh\u00e2n 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-9\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Loi_DIV0\" >L\u1ed7i #DIV\/0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#Loi_hien_thi_so_0\" >L\u1ed7i hi\u1ec3n th\u1ecb s\u1ed1 0<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_nhan_trong_Excel_la_ham_nao\"><\/span><b>H\u00e0m nh\u00e2n trong Excel l\u00e0 h\u00e0m n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><b>H\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m PRODUCT. H\u00e0m n\u00e0y c\u00f3 th\u1ec3 nh\u00e2n \u0111\u01b0\u1ee3c c\u00e1c \u0111\u1ed1i s\u1ed1 v\u1edbi nhau v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ph\u00e9p t\u00ednh l\u00e0 t\u00edch. V\u00ed nh\u01b0, n\u1ebfu b\u1ea1n mu\u1ed1n nh\u00e2n k\u1ebft qu\u1ea3 c\u1ee7a \u00f4 A1 v\u1edbi \u00f4 A2 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y theo c\u00f4ng th\u1ee9c: =PRODUCT(A1,A2).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, c\u00f3 \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd khi \u00e1p d\u1ee5ng h\u00e0m nh\u00e2n n\u00e0y \u0111\u00f3 l\u00e0 c\u00f3 m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m nh\u00e2n m\u1ed9t c\u00e1ch ti\u1ec7n l\u1ee3i nh\u01b0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng c\u1ea7n ch\u1ecdn t\u1eebng s\u1ed1 nh\u01b0ng b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 nh\u00e2n \u0111\u01b0\u1ee3c nhi\u1ec1u s\u1ed1 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m nh\u00e2n v\u1edbi c\u00e1c h\u00e0m kh\u00e1c d\u1ec5 d\u00e0ng<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i thao t\u00e1c c\u00f3 th\u1ec3 nh\u00e2n s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 r\u1ea5t l\u1edbn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12682\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"315\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1-400x210.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_nhan_trong_Excel_su_dung_nhu_the_nao\"><\/span><b>H\u00e0m nh\u00e2n trong Excel s\u1eed d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Mu\u1ed1n s\u1eed d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\">, b\u1ea1n c\u1ea7n ph\u1ea3i nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p sau:\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">=PRODUCT(number1, [number2]\u2026, [numbern])<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, Number ch\u00ednh l\u00e0 nh\u1eefng s\u1ed1 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 nh\u00e2n v\u1edbi nhau. V\u1edbi vi\u1ec7c d\u00f9ng h\u00e0m PRODUCT \u0111\u1ec3 nh\u00e2n th\u00ec ch\u1ec9 \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi t\u1ed1i \u0111a l\u00e0 255 \u0111\u1ed1i s\u1ed1. V\u1edbi c\u00e1c \u00f4 tr\u1ed1ng th\u00ec h\u00e0m n\u00e0y s\u1ebd t\u00ednh m\u1eb7c \u0111\u1ecbnh b\u1eb1ng 0.<\/span><\/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<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_cach_tinh_ham_nhan_trong_Excel\"><\/span><b>C\u00e1c c\u00e1ch t\u00ednh h\u00e0m nh\u00e2n trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n <\/span><b><i>c\u00e1ch t\u00ednh h\u00e0m nh\u00e2n trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 c\u00e1ch sau:<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_tich_cho_tung_so\"><\/span><b><i>T\u00ednh t\u00edch cho t\u1eebng s\u1ed1<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch t\u00ednh <\/span><b>h\u00e0m nh\u00e2n trong <\/b><span style=\"font-weight: 400;\">n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00ed d\u1ee5 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12683\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-2.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-2-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n ti\u1ebfn h\u00e0nh t\u00ednh theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n ch\u1ecdn v\u00e0o \u00f4 c\u1ea7n t\u00ednh t\u00edch v\u00e0 nh\u1eadp v\u00e0o \u00f4 h\u00e0m theo c\u00f4ng th\u1ee9c: =Product(2;4;3;5;3;9;1). Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng m\u1eb9o t\u00ednh t\u00edch cho c\u00e1c s\u1ed1 b\u1eb1ng c\u00e1ch b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a s\u1ed1 v\u00e0 nh\u1eadp h\u00e0m nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12684\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-3.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-3-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, b\u1ea1n nh\u1ea5n n\u00fat Enter \u0111\u1ec3 h\u00e0m hi\u1ec7n ra k\u1ebft qu\u1ea3 t\u00edch c\u1ea7n t\u00ecm<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12685\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-4.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-4-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_tinh_ham_nhan_2_cot_trong_Excel\"><\/span><b><i>C\u00e1ch t\u00ednh h\u00e0m nh\u00e2n 2 c\u1ed9t trong Excel<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Mu\u1ed1n t\u00ednh <\/span><b><i>h\u00e0m nh\u00e2n 2 c\u1ed9t trong Excel<\/i><\/b><span style=\"font-weight: 400;\">, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i v\u00ed d\u1ee5 sau c\u1ee7a ch\u00fang t\u00f4i.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12686\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-5.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-5-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, b\u1ea1n s\u1ebd click chu\u1ed9t v\u00e0o \u00f4 c\u1ea7n t\u00ednh t\u00edch. T\u1ea1i \u0111\u00e2y, b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c: =PRODUCT(D2:D8). B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1ch t\u00ednh t\u00edch cho c\u1ed9t b\u1eb1ng c\u00e1ch qu\u00e9t chu\u1ed9t v\u00e0o nh\u1eefng c\u1ed9t c\u1ea7n t\u00ednh t\u00edch. L\u01b0u \u00fd, n\u1ebfu ch\u1ecdn c\u00e1ch n\u00e0y th\u00ec ph\u1ea3i b\u1ecf ph\u1ea7n ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 t\u00ednh \u0111\u00fang nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12687\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-6.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-6-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 cho ra k\u1ebft qu\u1ea3 t\u00edch c\u1ee7a c\u1ed9t, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n Enter l\u00e0 xong<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12688\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-7.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-7-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_tinh_tich_tren_nhieu_cot\"><\/span><b><i>C\u00e1ch t\u00ednh t\u00edch tr\u00ean nhi\u1ec1u c\u1ed9t<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\"> cho vi\u1ec7c t\u00ednh t\u00edch \u1edf nhi\u1ec1u c\u1ed9t th\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng 2 c\u00e1ch. Th\u1ee9 nh\u1ea5t l\u00e0 d\u00f9ng d\u1ea5u * v\u00e0 th\u1ee9 2 l\u00e0 d\u00f9ng h\u00e0m PRODUCT. N\u1ebfu ch\u1ecdn d\u00f9ng d\u1ea5u sao th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n thao t\u00e1c theo h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12689\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-8.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-8-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng h\u00e0m PRODUCT \u0111\u1ec3 t\u00ednh t\u00edch nhi\u1ec1u c\u1ed9t th\u00ec ch\u1ec9 c\u1ea7n ch\u1ecdn v\u00e0o v\u1ecb tr\u00ed c\u1ee7a \u00f4 c\u1ea7n t\u00ednh v\u00e0 nh\u1eadp v\u00e0o \u0111\u00f3 c\u00f4ng th\u1ee9c sau: =PRODUCT(C2:D2). L\u01b0u \u00fd, v\u1edbi c\u00e1ch n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n qu\u00e9t ch\u1ecdn \u0111\u00fang 2 \u00f4 \u0111\u1ea7u ti\u00ean t\u1ea1i 2 c\u1ed9t c\u00f9ng 1 l\u00fac m\u1edbi cho ra k\u1ebft qu\u1ea3 t\u00ednh t\u00edch ch\u00ednh x\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12690\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-9.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-9-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft th\u00fac b\u1eb1ng c\u00e1ch nh\u1ea5n Enter \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 t\u00edch c\u1ea7n t\u00ecm<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12691\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-10.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-10-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_tinh_tich_bang_ham_nhan_trong_Excel_ket_hop_cac_ham_khac\"><\/span><b><i>C\u00e1ch t\u00ednh t\u00edch b\u1eb1ng h\u00e0m nh\u00e2n trong Excel k\u1ebft h\u1ee3p c\u00e1c h\u00e0m kh\u00e1c<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u0169ng nh\u01b0 vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m c\u1ed9ng, <\/span><b><i>h\u00e0m tr\u1eeb trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> th\u00ec vi\u1ec7c \u00e1p d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n<\/b><span style=\"font-weight: 400;\">\u00a0nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng th\u00eam c\u00e1c h\u00e0m kh\u00e1c. \u0110i\u1ec3n h\u00ecnh nh\u01b0 h\u00e0m SUM ch\u1eb3ng h\u1ea1n. \u0110\u00e2y th\u01b0\u1eddng l\u00e0 c\u00e1ch \u00e1p d\u1ee5ng kh\u00e1 kh\u00f3 kh\u0103n nh\u01b0ng n\u00f3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00e1c y\u00eau c\u1ea7u t\u00ednh t\u00edch ph\u1ee9c t\u1ea1p khi thao t\u00e1c v\u1edbi b\u1ea3ng t\u00ednh n\u00e0y. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00ecnh d\u01b0\u1edbi l\u00e0 v\u00ed d\u1ee5 \u0111\u1ed1i v\u1edbi y\u00eau c\u1ea7u t\u00ednh t\u00edch gi\u1eefa 3 c\u1ed9t trong b\u1ea3ng Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12692\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-11.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-11.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-11-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi y\u00eau c\u1ea7u n\u00e0y, \u0111\u1ea7u ti\u00ean b\u1ea1n click chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed \u00f4 c\u1ea7n ph\u1ea3i t\u00ednh t\u00edch. Sau \u0111\u00f3, t\u1ea1i \u0111\u00e2y b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c h\u00e0m t\u00ednh theo c\u00fa ph\u00e1p: =<\/span> <span style=\"font-weight: 400;\">PRODUCT(SUM(C2:D2);E2).<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12693\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-12.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-12-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">K\u1ebft th\u00fac b\u1eb1ng n\u00fat Enter b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u00ednh t\u00edch nh\u01b0 mong mu\u1ed1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12694\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-13.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"338\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-13.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-13-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_khac_phuc_mot_so_loi_khi_ap_dung_ham_nhan_trong_Excel\"><\/span><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c m\u1ed9t s\u1ed1 l\u1ed7i khi \u00e1p d\u1ee5ng h\u00e0m nh\u00e2n trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh \u00e1p d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 h\u00e0m PRODUCT, s\u1ebd c\u00f3 m\u1ed9t s\u1ed1 l\u1ed7i xu\u1ea5t hi\u1ec7n. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng am hi\u1ec3u c\u00e1c thao t\u00e1c tr\u00ean b\u1ea3ng t\u00ednh Excel g\u1eb7p kh\u00f3 kh\u0103n. Teky s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i \u0111\u00e1p c\u00e1ch x\u1eed l\u00fd m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p ngay d\u01b0\u1edbi \u0111\u00e2y. N\u00f3 c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ch\u1ee7 \u0111\u1ed9ng h\u01a1n khi x\u1eed l\u00fd s\u1ef1 c\u1ed1.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_DIV0\"><\/span><b><i>L\u1ed7i #DIV\/0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Kh\u00f4ng ri\u00eang g\u00ec s\u1eed d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n trong Excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 khi \u00e1p d\u1ee5ng nhi\u1ec1u h\u00e0m t\u00ednh kh\u00e1c c\u0169ng th\u01b0\u1eddng b\u1ecb tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ed7i n\u00e0y. Nguy\u00ean nh\u00e2n c\u1ee7a n\u00f3 th\u01b0\u1eddng l\u00e0 do \u1edf c\u1ed9t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ec3 t\u00ednh to\u00e1n xu\u1ea5t hi\u1ec7n d\u1eef li\u1ec7u l\u00e0 k\u00fd t\u1ef1 hay ch\u1eef.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12695\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-14.jpg\" alt=\"h\u00e0m nh\u00e2n trong Excel\" width=\"600\" height=\"345\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-14.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-14-400x230.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i th\u00f4ng tin d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. N\u1ebfu xu\u1ea5t hi\u1ec7n ch\u1eef hay k\u00fd t\u1ef1 th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i thay n\u00f3 b\u1eb1ng con s\u1ed1. Nh\u01b0 v\u1eady, vi\u1ec7c \u00e1p d\u1ee5ng h\u00e0m t\u00ednh m\u1edbi hi\u1ec3n th\u1ecb th\u00f4ng tin ch\u00ednh x\u00e1c \u0111\u01b0\u1ee3c.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loi_hien_thi_so_0\"><\/span><b><i>L\u1ed7i hi\u1ec3n th\u1ecb s\u1ed1 0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p khi th\u1ef1c hi\u1ec7n <\/span><b><i>c\u00e1ch t\u00ednh h\u00e0m nh\u00e2n trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> th\u00ec t\u1ea1i \u00f4 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ed1 0. \u0110\u00e2y l\u00e0 do trong d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f3 \u00f4 tr\u1ed1ng hay xen k\u1ebd gi\u1eefa c\u00e1c d\u00e3y s\u1ed1 li\u1ec7u xu\u1ea5t hi\u1ec7n m\u1ed9t s\u1ed1 \u00f4 l\u00e0 ch\u1eef hay k\u00fd t\u1ef1. Khi \u0111\u00f3, \u0111i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0m ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 gi\u1eef nguy\u00ean th\u00f4ng tin t\u00ednh. B\u1edfi th\u1ef1c t\u1ebf, vi\u1ec7c xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3 0 \u1edf tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u01b0\u1eddng kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn \u0111\u1ed9 ch\u00ednh x\u00e1c \u1edf k\u1ebft qu\u1ea3 ph\u00e9p t\u00ednh. Tuy nhi\u00ean, \u1edf m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i ti\u1ebfn h\u00e0nh ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u cho ph\u00f9 h\u1ee3p v\u1edbi y\u00eau c\u1ea7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 t\u01b0 v\u1ea5n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m nh\u00e2n \u1edf Excel<\/b><span style=\"font-weight: 400;\"> hi\u1ec7u qu\u1ea3 nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 li\u00ean h\u1ec7 \u0111\u1ebfn Teky. Ch\u00fang t\u00f4i \u0111\u1ea3m b\u1ea3o gi\u1ea3i \u0111\u00e1p c\u00e1c th\u00f4ng tin li\u00ean quan v\u00e0 gi\u00fap b\u1ea1n ch\u1ecdn \u0111\u01b0\u1ee3c c\u00e1c kh\u00f3a \u0111\u00e0o t\u1ea1o v\u1ec1 tin h\u1ecdc v\u0103n ph\u00f2ng ch\u1ea5t l\u01b0\u1ee3ng. Khi \u0111\u00f3, kh\u00f4ng ch\u1ec9 vi\u1ec7c d\u00f9ng h\u00e0m nh\u00e2n, h\u00e0m c\u1ed9ng hay <\/span><b><i>h\u00e0m tr\u1eeb trong Excel<\/i><\/b><span style=\"font-weight: 400;\"> m\u00e0 b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 th\u00e0nh th\u1ea1o nhi\u1ec1u k\u1ef9 n\u0103ng thao t\u00e1c v\u1edbi Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng nh\u1ea5t.<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-khoa-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed c\u00e1ch kh\u00f3a c\u1ed9t trong Excel ch\u1ec9 trong m\u1ed9t n\u1ed1t nh\u1ea1c<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Kh\u00e1m ph\u00e1 ngay 3 c\u00e1ch \u0111\u1ed5i c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch th\u00eam c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Kh\u00f4ng \u00edt ng\u01b0\u1eddi khi thao t\u00e1c v\u1edbi Excel v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel nh\u01b0 th\u1ebf n\u00e0o m\u1edbi \u0111\u00fang. \u0110\u1eb7c bi\u1ec7t l\u00e0 khi g\u1eb7p ph\u1ea3i c\u00e1c l\u1ed7i trong qu\u00e1 tr\u00ecnh \u00e1p d\u1ee5ng h\u00e0m ph\u1ea3i x\u1eed l\u00fd nh\u01b0 th\u1ebf n\u00e0o. Teky s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 qua b\u00e0i vi\u1ebft d\u01b0\u1edbi &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12682,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12681","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>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/title>\n<meta name=\"description\" content=\"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.\" \/>\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-nhan-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n\" \/>\n<meta property=\"og:description\" content=\"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-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=\"2022-11-29T03:00:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T07:50:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\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=\"9 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-nhan-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n\",\"datePublished\":\"2022-11-29T03:00:22+00:00\",\"dateModified\":\"2022-12-06T07:50:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\"},\"wordCount\":1910,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\",\"datePublished\":\"2022-11-29T03:00:22+00:00\",\"dateModified\":\"2022-12-06T07:50:45+00:00\",\"description\":\"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg\",\"width\":600,\"height\":315,\"caption\":\"h\u00e0m nh\u00e2n trong Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-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\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n\"}]},{\"@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":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n","description":"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.","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-nhan-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n","og_description":"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.","og_url":"https:\/\/teky.edu.vn\/blog\/ham-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":"2022-11-29T03:00:22+00:00","article_modified_time":"2022-12-06T07:50:45+00:00","og_image":[{"width":600,"height":315,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.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":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n","datePublished":"2022-11-29T03:00:22+00:00","dateModified":"2022-12-06T07:50:45+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/"},"wordCount":1910,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg","datePublished":"2022-11-29T03:00:22+00:00","dateModified":"2022-12-06T07:50:45+00:00","description":"S\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n t\u00f9y theo y\u00eau c\u1ea7u t\u00ednh to\u00e1n kh\u00e1c nhau trong b\u1ea3ng t\u00ednh gi\u00fap x\u1eed l\u00fd c\u00f4ng vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng nh\u1ea5t.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-nhan-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/15-ham-nhan-trong-Excel-1.jpg","width":600,"height":315,"caption":"h\u00e0m nh\u00e2n trong Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-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":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u00e2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n"}]},{"@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\/12681","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=12681"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12681\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12682"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}