{"id":10487,"date":"2025-01-14T09:59:16","date_gmt":"2025-01-14T09:59:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-phan-biet-dang-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext\/"},"modified":"2025-01-14T09:59:16","modified_gmt":"2025-01-14T09:59:16","slug":"cach-phan-biet-dang-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-phan-biet-dang-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext\/","title":{"rendered":"C\u00e1ch ph\u00e2n bi\u1ec7t d\u1ea1ng d\u1eef li\u1ec7u trong Excel v\u1edbi nh\u00f3m h\u00e0m IsNumber, IsNonText, IsText"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel c\u00f3 2 d\u1ea1ng d\u1eef li\u1ec7u ch\u00ednh l\u00e0 d\u1ea1ng Chu\u1ed7i (Text) v\u00e0 d\u1ea1ng S\u1ed1 (Number), trong \u0111\u00f3 d\u1ea1ng S\u1ed1 bao g\u1ed3m nhi\u1ec1u d\u1ea1ng chi ti\u1ebft h\u01a1n nh\u01b0 d\u1ea1ng Ph\u1ea7n tr\u0103m (percentage), d\u1ea1ng K\u1ebf to\u00e1n (Accounting), d\u1ea1ng Ti\u1ec1n t\u1ec7 (Currency) v\u00e0 d\u1ea1ng Ng\u00e0y th\u00e1ng th\u1eddi gian (Date). Vi\u1ec7c ph\u00e2n bi\u1ec7t c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u r\u1ea5t quan tr\u1ecdng gi\u00fap ch\u00fang ta hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u, t\u1eeb \u0111\u00f3 tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng sai s\u00f3t trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng \u0111\u00fang c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel. M\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 t\u1ed1t nh\u1ea5t \u0111\u1ec3 gi\u00fap ch\u00fang ta ph\u00e2n bi\u1ec7t c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u trong Excel ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong nh\u00f3m h\u00e0m IS c\u1ee7a Excel, c\u1ee5 th\u1ec3 l\u00e0 h\u00e0m IsNumber, IsNonText, IsText.<\/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-678635732a335\" 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\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html#Ham_IsNumber\" title=\"H\u00e0m IsNumber\">H\u00e0m IsNumber<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html#Ham_ISTEXT\" title=\"H\u00e0m ISTEXT\">H\u00e0m ISTEXT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html#Ham_ISNONTEXT\" title=\"H\u00e0m ISNONTEXT\">H\u00e0m ISNONTEXT<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_IsNumber\"><\/span>H\u00e0m IsNumber<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m IsNumber gi\u00fap ch\u00fang ta ki\u1ec3m tra xem d\u1eef li\u1ec7u t\u1ea1i 1 \u00f4 c\u00f3 ph\u1ea3i l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 hay kh\u00f4ng. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m logic, do \u0111\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 TRUE (\u0111\u00fang) ho\u1eb7c FALSE (sai). H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u qua v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19412\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/isnumber-test-01.png\" width=\"425\" height=\"213\" title=\"isnumber-test-01\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean ch\u00fang ta th\u1ea5y:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 k\u00e8m theo k\u00fd t\u1ef1 text b\u1ea5t k\u1ef3 \u0111\u1ec1u \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 d\u1ea1ng Text (A2)<\/li>\n<li>D\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n ch\u1ec9 c\u00f3 1 k\u00fd hi\u1ec7u \u0111\u01b0\u1ee3c quy \u01b0\u1edbc s\u1eb5n trong m\u00e1y. N\u1ebfu quy \u01b0\u1edbc l\u00e0 d\u1ea5u\u00a0ch\u1ea5m\u00a0th\u00ec d\u1ea5u ph\u1ea9y s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 k\u00fd t\u1ef1 text nh\u01b0 v\u00ed d\u1ee5 \u00f4 A5 (thay \u0111\u1ed5i k\u00fd t\u1ef1 n\u00e0y trong Control Pannel \/ Region)<\/li>\n<li>Ng\u00e0y th\u00e1ng \u1edf \u00f4 A6 l\u00e0 d\u1ea1ng s\u1ed1 (d\u00f9 ghi l\u00e0 ch\u1eef 08-May v\u1eabn hi\u1ec3u l\u00e0 d\u1ea1ng s\u1ed1)<\/li>\n<li>\u00d4 A7 v\u00e0 A8 kh\u00f4ng ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 d\u00f9 vi\u1ebft g\u1ea7n gi\u1ed1ng d\u1ea1ng Ng\u00e0y. B\u1edfi: A7 sai nguy\u00ean t\u1eafc s\u1ed1 th\u00e1ng ph\u1ea3i &lt;13, A8 sai nguy\u00ean t\u1eafc ch\u1ec9 c\u00f3 1 d\u1ea5u ng\u0103n c\u00e1ch th\u1ed1ng nh\u1ea5t, n\u1ebfu d\u00f9ng 2 d\u1ea5u ng\u0103n c\u00e1ch c\u00f3 k\u00fd t\u1ef1 kh\u00e1c nhau th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 d\u1ea1ng Text<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p nghi ng\u1edd kh\u00f4ng r\u00f5 d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng s\u1ed1 hay kh\u00f4ng th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m ISNUMBER \u0111\u1ec3 ki\u1ec3m tra s\u1ebd r\u00f5.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_ISTEXT\"><\/span>H\u00e0m ISTEXT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m IsText gi\u00fap ki\u1ec3m tra xem d\u1eef li\u1ec7u c\u00f3 ph\u1ea3i d\u1ea1ng Text hay kh\u00f4ng. C\u00f3 nh\u1eefng l\u00fac kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng bi\u1ebft \u0111\u01b0\u1ee3c ch\u1eafc ch\u1eafn xem d\u1eef li\u1ec7u \u0111\u00f3 l\u00e0 d\u1ea1ng s\u1ed1 hay text. H\u00e3y xem v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19418\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/istext-test-01.png\" width=\"724\" height=\"208\" title=\"istext-test-01\"><\/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-177.gif\" title=\"ex101_92019-nho-177\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean ta th\u1ea5y:<\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u1ea5y b\u1edfi h\u00e0m Left, h\u00e0m Right d\u00f9 ch\u00fang ta nh\u00ecn th\u1ea5y l\u00e0 1 con s\u1ed1 nh\u01b0ng v\u1ec1 b\u1ea3n ch\u1ea5t \u0111\u00f3 l\u1ea1i l\u00e0 d\u1eef li\u1ec7u Text (\u00f4 B2, B3)<\/li>\n<li>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u00fang chu\u1ea9n d\u1ea1ng s\u1ed1 th\u00ec l\u00e0 d\u1ea1ng Text\u00a0(\u00f4 B5)<\/li>\n<li>D\u1eef li\u1ec7u t\u1ea1o b\u1edfi h\u00e0m Text d\u00f9 \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng ng\u00e0y nh\u01b0 \u00f4 B6 th\u00ec v\u1ec1 b\u1ea3n ch\u1ea5t v\u1eabn l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng Text<\/li>\n<li>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u00fang chu\u1ea9n Ng\u00e0y th\u00e1ng th\u00ec l\u00e0 d\u1ea1ng Text (\u00f4 B8)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady h\u00e0m IsText gi\u00fap cho ch\u00fang ta hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t c\u1ee7a d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c h\u00e0m. B\u1edfi n\u1ebfu ch\u00fang ta kh\u00f4ng hi\u1ec3u r\u00f5 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c h\u00e0m th\u00ec s\u1ebd r\u1ea5t d\u1ec5 \u0111\u1ec3 x\u1ea3y ra sai s\u00f3t khi d\u00f9ng c\u00e1c k\u1ebft qu\u1ea3 \u0111\u00f3 \u0111\u1ec3 l\u00e0m ti\u1ebfp c\u00e1c b\u01b0\u1edbc t\u00ednh to\u00e1n sau \u0111\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_ISNONTEXT\"><\/span>H\u00e0m ISNONTEXT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ng\u01b0\u1ee3c v\u1edbi h\u00e0m IsText, h\u00e0m IsNonText s\u1ebd gi\u00fap ki\u1ec3m tra nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i l\u00e0 d\u1ea1ng Text. Xem v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/isnontext-test-01.png\" width=\"726\" height=\"207\" title=\"isnontext-test-01\"><\/p>\n<p>Th\u1ef1c ch\u1ea5t h\u00e0m IsNonText kh\u00e1 gi\u1ed1ng v\u1edbi IsNumber, b\u1edfi trong Excel ch\u1ec9 c\u00f3 2 d\u1ea1ng d\u1eef li\u1ec7u ch\u00ednh l\u00e0 Number ho\u1eb7c Text. Tuy nhi\u00ean h\u00e0m n\u00e0y s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p ki\u1ec3m tra d\u1eef li\u1ec7u d\u1ea1ng text hay kh\u00f4ng ph\u1ea3i d\u1ea1ng Text. M\u1ee5c \u0111\u00edch r\u00f5 r\u00e0ng l\u00e0 ch\u1ec9 quan t\u00e2m c\u00f3 ph\u1ea3i d\u1ea1ng text hay kh\u00f4ng. C\u00f2n kh\u00f4ng quan t\u00e2m c\u00e1c d\u1ea1ng kh\u00e1c.<\/p>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta \u0111\u00e3 hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u trong Excel, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 ki\u1ec3m tra c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u n\u00e0y. Vi\u1ec7c ki\u1ec3m tra n\u00e0y gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u cho ch\u00fang ta trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel:\u00a0tr\u00e1nh \u0111\u01b0\u1ee3c sai s\u00f3t mang t\u00ednh ch\u1ee7 quan khi th\u01b0\u1eddng \u0111\u00e1nh gi\u00e1 d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1i ch\u00fang ta nh\u00ecn th\u1ea5y, m\u00e0 qu\u00ean \u0111i ki\u1ec3m tra b\u1ea3n ch\u1ea5t c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n<p>Tham kh\u1ea3o:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u1eadn bi\u1ebft lo\u1ea1i l\u1ed7i v\u00e0 c\u00e1ch b\u1eaby l\u1ed7i trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2JX45F3\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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-177.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10488,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10487","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\/10487","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=10487"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10487\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10488"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}