{"id":9344,"date":"2025-01-02T01:41:19","date_gmt":"2025-01-02T01:41:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-n-trong-excel\/"},"modified":"2025-01-02T01:41:19","modified_gmt":"2025-01-02T01:41:19","slug":"huong-dan-su-dung-ham-n-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-su-dung-ham-n-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m N trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>N<\/strong> trong Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775eebeccbc5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#Ham_N_cong_dung_va_cu_phap\" title=\"H\u00e0m N, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m N, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#Cong_dung\" title=\"C\u00f4ng d\u1ee5ng\">C\u00f4ng d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#Ung_dung_thuc_te\" title=\"\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#1_Chinh_sua_ngay_bi_sai\" title=\"1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai\">1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#2_Dung_lam_comment_chu_thich_khi_ban_viet_ham_qua_dai\" title=\"2. D\u00f9ng l\u00e0m comment ch\u00fa th\u00edch, khi b\u1ea1n vi\u1ebft h\u00e0m qu\u00e1 d\u00e0i.\">2. D\u00f9ng l\u00e0m comment ch\u00fa th\u00edch, khi b\u1ea1n vi\u1ebft h\u00e0m qu\u00e1 d\u00e0i.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-ham-n-trong-excel.html#3_Thong_nhat_du_lieu_TextNumber\" title=\"3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number\">3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_N_cong_dung_va_cu_phap\"><\/span>H\u00e0m N, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung\"><\/span>C\u00f4ng d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m N \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 <em>tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1<\/em><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m N nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=N(value)<\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>Value<\/strong> l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i th\u00e0nh s\u1ed1 theo quy t\u1eafc:<\/p>\n<p>N\u1ebfu gi\u00e1 tr\u1ecb l\u00e0\u00a0<strong>s\u1ed1<\/strong>, h\u00e0m N tr\u1ea3 v\u1ec1\u00a0<strong>s\u1ed1 \u0111\u00f3.<\/strong><\/p>\n<p>Gi\u00e1 tr\u1ecb l\u00e0 ng\u00e0y th\u00e1ng n\u0103m, h\u00e0m N tr\u1ea3 v\u1ec1\u00a0<strong>ng\u00e0y \u0111\u00f3<\/strong><strong> d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 series (general).<\/strong><\/p>\n<p>N\u1ebfu gi\u00e1 tr\u1ecb l\u00e0\u00a0<strong>TRUE\/FALSE<\/strong>, h\u00e0m N tr\u1ea3 v\u1ec1 t\u01b0\u01a1ng \u1ee9ng\u00a0<strong>1\/0<\/strong>.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-41.gif\" title=\"ex101_92019-nho-41\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Gi\u00e1 tr\u1ecb\u00a0<strong>l\u1ed7i,\u00a0<\/strong>h\u00e0m N tr\u1ea3 v\u1ec1\u00a0<strong>l\u1ed7i.<\/strong><\/p>\n<p>Ngo\u00e0i ra, t\u1ea5t c\u1ea3 nh\u1eefng th\u1ee9 c\u00f2n l\u1ea1i, bao g\u1ed3m\u00a0<strong>Text<\/strong>, tr\u1ea3 v\u1ec1 0.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ung_dung_thuc_te\"><\/span>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Nh\u00ecn chung, \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 h\u00e0m qu\u00e1 c\u1ea7n thi\u1ebft trong c\u00f4ng th\u1ee9c b\u1edfi n\u00f3 ch\u1ec9 gi\u00fap chuy\u1ec3n \u0111\u1ed5i c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng th\u00edch b\u1ea3ng t\u00ednh khi c\u1ea7n thi\u1ebft. Tuy nhi\u00ean, ta v\u1eabn c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng h\u00e0m n\u00e0y hi\u1ec7u qu\u1ea3 khi tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u ph\u00e2n bi\u1ec7t \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Text\u00a0<\/strong>v\u00e0\u00a0<strong>Number.<\/strong><\/p>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<h5><span class=\"ez-toc-section\" id=\"1_Chinh_sua_ngay_bi_sai\"><\/span>1. Ch\u1ec9nh s\u1eeda ng\u00e0y b\u1ecb sai<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Ng\u00e0y sai \u1edf \u0111\u00e2y bao g\u1ed3m nh\u1eefng ng\u00e0y sai \u0111\u1ecbnh d\u1ea1ng (th\u00e1ng\/ng\u00e0y\/n\u0103m) trong khi \u0111\u1ecbnh d\u1ea1ng m\u00e1y t\u00ednh l\u00e0 (ng\u00e0y\/th\u00e1ng\/n\u0103m), ho\u1eb7c ng\u00e0y l\u01b0u tr\u1eef \u1edf \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Text<\/strong>.<\/p>\n<p>Ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb sai:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24836\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-n-1.png\" width=\"392\" height=\"203\" title=\"ham-n-1\"><\/p>\n<p>\u00a0<\/p>\n<h5><span class=\"ez-toc-section\" id=\"2_Dung_lam_comment_chu_thich_khi_ban_viet_ham_qua_dai\"><\/span>2. D\u00f9ng l\u00e0m comment ch\u00fa th\u00edch, khi b\u1ea1n vi\u1ebft h\u00e0m qu\u00e1 d\u00e0i.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>V\u00ed d\u1ee5 nh\u01b0 h\u00e0m khi b\u1ea1n vi\u1ebft qu\u00e1 d\u00e0i, v\u00e0 c\u1ea7n ng\u1eafn \u0111o\u1ea1n ra \u0111\u1ec3 tham kh\u1ea3o, th\u00ec l\u00fac n\u00e0y h\u00e0m N c\u00f3 t\u00e1c d\u1ee5ng n\u1ebfu th\u1ef1c hi\u1ec7n ph\u00e9p c\u1ed9ng 1 s\u1ed1 v\u1edbi 0, th\u00ec gi\u00e1 tr\u1ecb kh\u00f4ng \u0111\u1ed5i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/12\/N-formula-comment.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24988\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/n-formula-comment.jpg\" width=\"853\" height=\"352\" title=\"n-formula-comment\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"3_Thong_nhat_du_lieu_TextNumber\"><\/span>3. Th\u1ed1ng nh\u1ea5t d\u1eef li\u1ec7u Text\/Number<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng\u00a0<strong>VLOOKUP\/HLOOKUP<\/strong>: T\u1ea1i sao lookup \u0111\u00fang nh\u01b0ng kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3? \u0110\u00f3 l\u00e0 v\u00ec d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u01b0u tr\u1eef d\u01b0\u1edbi d\u1ea1ng Text, c\u1ea7n \u0111\u01b0a v\u1ec1 Number.<\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m t\u00ecm ra \u0111\u00e2u l\u00e0 Number, \u0111\u00e2u l\u00e0 Text:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24837\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-n-2.png\" width=\"330\" height=\"154\" title=\"ham-n-2\"><\/p>\n<p>Th\u1eadt d\u1ec5 nh\u1edb ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">Ph\u00e2n bi\u1ec7t d\u1eef li\u1ec7u v\u1edbi ISTEXT, ISNUMBER, ISNONTEXT<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu.html\"><strong>Chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-sua-dinh-dang-thoi-gian-bi-loi-ve-dang-chuan-ca-gio-phut-giay.html\"><strong>S\u1eeda \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-41.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9345,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9344"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9345"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}