{"id":11795,"date":"2022-03-20T16:52:21","date_gmt":"2022-03-20T09:52:21","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11795"},"modified":"2022-03-20T16:54:59","modified_gmt":"2022-03-20T09:54:59","slug":"ham-isna-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft 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;11795&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 isna trong excel chi ti\u1ebft nh\u1ea5t&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><span style=\"font-weight: 400\">.Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel ch\u1eafc b\u1ea1n kh\u00f4ng c\u00f2n g\u00ec xa l\u1ea1 v\u1edbi h\u00e0m isna. <\/span><b>H\u00e0m isna <\/b><span style=\"font-weight: 400\">trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m \u0111i theo isna<\/span> <span style=\"font-weight: 400\">c\u00f3 c\u00f4ng d\u1ee5ng g\u00ec?,<\/span><b> h\u00e0m isna trong excel <\/b><span style=\"font-weight: 400\">l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0<\/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-isna-trong-excel\/#Khai_niem_cua_ham_isna_trong_excel\" >Kh\u00e1i ni\u1ec7m c\u1ee7a h\u00e0m isna trong excel<\/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-isna-trong-excel\/#Loi_ich_cua_ham_isna_mang_lai_voi_chung_ta\" >L\u1ee3i \u00edch c\u1ee7a h\u00e0m isna mang l\u1ea1i v\u1edbi ch\u00fang ta<\/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-isna-trong-excel\/#Cu_phap_dung_de_thuc_hien_ham_isna_trong_excel\" >C\u00fa ph\u00e1p d\u00f9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m isna trong excel<\/a><\/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\/ham-isna-trong-excel\/#Cach_su_dung_ham_Isna_trong_excel\" >C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Isna 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\/ham-isna-trong-excel\/#Cach_khac_phuc_loi_NA_bang_ham_isna_trong_excel\" >C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A b\u1eb1ng h\u00e0m isna 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\/ham-isna-trong-excel\/#Ung_dung_cua_ham_isna\" >\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m isna<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Khai_niem_cua_ham_isna_trong_excel\"><\/span><span style=\"font-weight: 400\">Kh\u00e1i ni\u1ec7m c\u1ee7a h\u00e0m isna trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>\u00a0H\u00e0m isna trong excel <\/b><span style=\"font-weight: 400\">l\u00e0 h\u00e0m c\u00f3 ch\u1ee9c n\u0103ng gi\u00fap ch\u00fang ta ki\u1ec3m \u0111\u1ecbnh c\u0169ng nh\u01b0 ki\u1ec3m tra xem x\u00e9t \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ef1a tr\u00ean \u0111\u00f3 m\u00e0 s\u1eeda \u0111\u01b0\u1ee3c nh\u1eefng l\u1ed7i sai nh\u01b0 <\/span><span style=\"font-weight: 400\">\u00a0#N\/A trong excel. L\u1ed7i n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 n\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n khi m\u00f4t trong c\u00e1c \u00f4 ch\u00fang ta \u0111\u01b0a v\u00e0o l\u00e0 nh\u1eefng c\u00f4ng th\u1ee9c. \u0110\u00e2y l\u00e0 nh\u1eefng \u00f4 ho\u00e0n to\u00e0n tr\u1ed1ng v\u00e0 kh\u00f4ng ch\u1ee9a b\u1ea5t c\u1ee9 m\u1ed9t lo\u1ea1i d\u1eef li\u1ec7u n\u00e0o kh\u00e1c. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00f3 l\u00e0 l\u00ed do c\u1ee7a s\u1ef1 xu\u1ea5t hi\u1ec7n<\/span><b> h\u00e0m<\/b> <b>isna <\/b><span style=\"font-weight: 400\">khi ch\u00fang ta nh\u1eadp c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c kh\u00e1c trong excel. <\/span><span style=\"font-weight: 400\">S\u1ef1 l\u1ed3ng gh\u00e9p v\u00e0 ph\u1ed1i h\u1ee3p nh\u1ecbp nh\u00e0ng c\u1ee7a <\/span><b>h\u00e0m isna trong excel<\/b><span style=\"font-weight: 400\"> v\u1edbi c\u00e1c h\u00e0m c\u00f4ng th\u1ee9c kh\u00e1c s\u1ebd lo\u1ea1i b\u1ecf ho\u1eb7c h\u1ea1n ch\u1ebf m\u1ee9c th\u1ea5p nh\u1ea5t vi\u1ec7c x\u1ea3y ra l\u1ed7i.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1ea3i th\u00edch v\u00e0i thu\u1eadt ng\u1eef nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">IS c\u00f3 \u00fd ngh\u0129a l\u00e0 mang ch\u1ee9c n\u0103ng ki\u1ec3m tra, d\u00f2 x\u00e9t v\u00e0 cu\u1ed1i c\u00f9ng \u0111\u01b0a ra k\u1ebft qu\u1ea3 \u0111\u00fang ho\u1eb7c sai. N\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ed3ng ngh\u0129a v\u1edbi c\u00e2u h\u1ecfi \u201c C\u00f3 ph\u00e1i l\u00e0\u201d.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">NA: \u0111\u00f3 kh\u00f4ng l\u00e0 g\u00ec kh\u00e1c ngo\u00e0i l\u1ed7i #N\/A.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ich_cua_ham_isna_mang_lai_voi_chung_ta\"><\/span><span style=\"font-weight: 400\">L\u1ee3i \u00edch c\u1ee7a h\u00e0m isna mang l\u1ea1i v\u1edbi ch\u00fang ta<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u00ec trong qu\u00e1 tr\u00ecnh thao t\u00e1c qu\u00e1 nhi\u1ec1u qu\u00e1 ph\u1ee9c t\u1ea1p. Th\u1ebf n\u00ean b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft l\u1ed7i sai d\u1ec5 d\u00e0ng h\u01a1n. Kh\u00f4ng nh\u1eefng th\u1ebf nh\u1eadn bi\u1ebft l\u1ed7i c\u00f2n di\u1ec5n ra v\u1edbi t\u1ed1c \u0111\u1ed9 nhanh kh\u00f4ng l\u00e3ng ph\u00ed th\u1eddi gian c\u1ee7a b\u1ea1n<\/span><\/p>\n<p><span style=\"font-weight: 400\">H\u00e0m <\/span><b>isna <\/b><span style=\"font-weight: 400\">kh\u00f4ng mang l\u1ea1i cho ch\u00fang ta c\u00e1i l\u1ed7i #N\/A m\u00e0 n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u01b0a ra k\u1ebft qu\u1ea3 nh\u01b0 ch\u00fang ta ho\u00e0n to\u00e0n mong \u0111\u1ee3i. V\u00ec th\u1ebf m\u00e0 b\u1ea1n kh\u00f4ng h\u1ec1 th\u1ea5t v\u1ecdng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng khai tri\u1ec3n th\u1ef1c hi\u1ec7n thao t\u00e1c c\u00f9ng nhi\u1ec1u lo\u1ea1i h\u00e0m c\u00f4ng th\u1ee9c kh\u00e1c m\u00e0 kh\u00f4ng h\u1ec1 b\u1ecb c\u00e1c l\u1ed7i sai l\u00e0m kh\u00f3.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11799 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cu_phap_dung_de_thuc_hien_ham_isna_trong_excel\"><\/span><span style=\"font-weight: 400\">C\u00fa ph\u00e1p d\u00f9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m isna trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c <\/span><b>h\u00e0m isna <\/b><span style=\"font-weight: 400\">b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng c\u00fa ph\u00e1p \u0111\u1ec3 qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c di\u1ec5n ra nhanh nh\u1ea5t.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">T\u00ean c\u1ee7a h\u00e0m s\u1ebd \u0111\u01b0\u1ee3c chia l\u00e0m hai ph\u1ea7n l\u00e0 IS v\u00e0 NA.<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00e1ch vi\u1ebft c\u00fa ph\u00e1p <\/span><b>h\u00e0m isna trong excel<\/b><span style=\"font-weight: 400\"> l\u00e0 nh\u01b0 sau: \u201c =ISNA(value)\u201d.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3, value c\u00f3 ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb, l\u00e0 tham s\u1ed1 \u1edf b\u00ean trong h\u00e0m isna. Gi\u00e1 tr\u1ecb value n\u00e0y c\u00f3 th\u1ec3 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed9t h\u00e0m n\u00e0o \u0111\u00f3 hay m\u1ed9t c\u00f4ng th\u1ee9c n\u00e0o \u0111\u00f3 c\u1ee5 th\u1ec3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau qu\u00e1 tr\u00ecnh thao t\u00e1c<\/span><b> h\u00e0m isna<\/b><span style=\"font-weight: 400\"> s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t trong hai k\u1ebft qu\u1ea3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400\">True: \u0110\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi \u00fd ngh\u0129a n\u1ebfu gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n. V\u00e0 \u0111ang ki\u1ec3m tra c\u00f3 k\u1ebft qu\u1ea3 \u0111\u00fang th\u1eadt s\u1ef1 l\u00e0 do l\u1ed7i c\u1ee7a #N\/A.<\/span><\/li>\n<li><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">Fale: \u0110\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u1edbi \u00fd ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n c\u1ea7n. V<\/span><\/span><span style=\"font-weight: 400\">\u00e0 \u0111ang ki\u1ec3m tra c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i \u0111\u00f3 ho\u00e0n to\u00e0n kh\u00f4ng ph\u1ea3i do l\u1ed7i c\u1ee7a #N\/A.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_Isna_trong_excel\"><\/span><span style=\"font-weight: 400\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Isna trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng<\/span><b> h\u00e0m isna <\/b><span style=\"font-weight: 400\">v\u00e0o excel, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n nh\u1eadn bi\u1ebft l\u1ed7i c\u1ee7a\u00a0 #N\/A. <\/span><span style=\"font-weight: 400\">\u0110i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 ph\u1ea3i xem nh\u1eefng l\u1ed7i c\u00f3 t\u1ea7n su\u1ea5t xu\u1ea5t hi\u1ec7n th\u01b0\u1eddng xuy\u00ean v\u00e0 c\u1ea7n t\u1edbi<\/span><b> h\u00e0m isna <\/b><span style=\"font-weight: 400\">\u0111\u1ec3 \u0111\u01b0\u1ee3c kh\u1eafc ph\u1ee5c l\u1ed7i sai \u0111\u00f3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 \u0111\u01b0\u1ee3c bi\u1ebft r\u00f5 h\u01a1n nh\u1eb1m cho ng\u01b0\u1eddi \u0111\u1ecdc n\u1eafm ch\u1eafc h\u01a1n, ch\u00fang t\u00f4i \u0111\u00e3 \u0111\u01b0a ra m\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh sau \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng h\u00e0m isna:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11803 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-5.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-5-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-5-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Theo nh\u01b0 \u0111\u1ec1 b\u00e0i tr\u00ean, ta c\u1ea7n t\u00ecm \u0111\u01b0\u1ee3c \u201cGi\u00e1 ng\u00e0y\u201d. V\u1eady th\u00ec ta c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng 2 c\u1ed9t l\u00e0 \u201cLo\u1ea1i ph\u00f2ng\u201d v\u00e0 \u201cB\u1ea3ng gi\u00e1 ph\u00f2ng\u201d \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Nh\u01b0 ta nh\u00ecn r\u00f5 qua h\u00ecnh \u1ea3nh tr\u00ean, \u0111\u1ec1 b\u00e0i ta c\u1ea7n t\u00ecm \u0111\u01b0\u1ee3c l\u00e0 gi\u00e1 c\u1ee7a ng\u00e0y. V\u1eady \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y b\u1ea1n c\u1ea7n ph\u1ea3i ph\u1ee5 thu\u1ed9c v\u00e0 d\u1ef1a v\u00e0o \u201clo\u1ea1i gi\u00e1\u201d v\u00e0 \u201cB\u1ea3ng gi\u00e1 ph\u00f2ng\u201d. C\u00f3 nh\u01b0 th\u1ebf, vi\u1ec7c t\u00ecm ki\u1ebfm m\u1edbi \u0111\u01b0\u1ee3c b\u1eaft \u0111\u1ea7u.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11804 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-3.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-3-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-3-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 1: Ta d\u1ef1a v\u00e0o h\u00e0m Vlookup \u0111\u1ec3 nhanh ch\u00f3ng l\u1ea5y ra ph\u1ea7n d\u1eef li\u1ec7u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. V\u1edbi c\u00f4ng th\u1ee9c sau: =Vlookup(C5;$I$6:$J$8;2;0).<\/span><\/p>\n<p><span style=\"font-weight: 400\">Theo gi\u1ea3i th\u00edch trong \u0111\u00f3, c\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Lookup_value: Gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n \u0111ang v\u00e0 s\u1ebd t\u00ecm ki\u1ebfm \u201cLo\u1ea1i ph\u00f2ng\u201d t\u1eeb c\u1ed9t C.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Table_array: V\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n tham chi\u1ebfu \u201cB\u1ea3ng gi\u00e1 ph\u00f2ng\u201d t\u1eeb J6:J8. Ch\u00fa \u00fd: B\u1ea1n kh\u00f4ng n\u00ean qu\u00e9t h\u1ebft c\u1ea3 ph\u1ea7n ti\u00eau \u0111\u1ec1. V\u00e0 b\u1eaft \u0111\u1ea7u kh\u00f3a d\u1eef li\u1ec7u l\u1ea1i sau thao t\u00e1c qu\u00e9t b\u1eb1ng vi\u1ec7c nh\u1ea5n F4 \u0111\u1ec3 th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Col_index_num: C\u1ed9t th\u1ee9 hai theo b\u1ea3ng v\u00ed d\u1ee5 l\u00e0 c\u1ed9t c\u1ee7a k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm, t\u1ee9c l\u00e0 c\u1ed9t gi\u00e1 ph\u00f2ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">[range_lookup]: S\u1eed d\u1ee5ng con s\u1ed1 0, l\u00e0 ph\u01b0\u01a1ng th\u1ee9c c\u1ee7a ch\u00ednh x\u00e1c sau khi t\u00ecm ki\u1ebfm theo m\u00e3 ph\u00f2ng nh\u01b0 v\u00ed d\u1ee5.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11801 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">B\u01b0\u1edbc 2: Sau vi\u1ec7c th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm, l\u1ed7i #N\/A b\u1eaft \u0111\u1ea7u xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e0n h\u00ecnh giao di\u1ec7n. B\u1edfi l\u00fd do c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u00e1c \u00f4 ho\u1eb7c d\u00f2ng tr\u1ed1ng nh\u01b0 h\u00ecnh \u1ea3nh \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i \u0111\u01b0a ra nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11802 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <em><span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/teky.edu.vn\/blog\/nhung-dieu-ban-can-biet-ve-ham-thong-ke-trong-excel\/\"><strong>H\u00e0m th\u1ed1ng k\u1ebf trong excel<\/strong><\/a><\/span><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khac_phuc_loi_NA_bang_ham_isna_trong_excel\"><\/span><span style=\"font-weight: 400\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #N\/A b\u1eb1ng h\u00e0m isna trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eeda ch\u1eefa \u0111\u01b0\u1ee3c l\u1ed7i n\u00e0y b\u1ea1n ph\u1ea3i k\u1ebft h\u1ee3p nh\u1ecbp nh\u00e0ng v\u1edbi nhau gi\u1eefa c\u00e1c h\u00e0m. Ch\u1eb3ng h\u1ea1n nh\u01b0 IF + ISNA + Vlookup \u0111\u1ec3 l\u1ed7i #N\/A. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Sau qu\u00e1 tr\u00ecnh \u0111\u00f3, nh\u1eefng d\u00f2ng ch\u1eef\u00a0 #N\/A s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf ho\u00e0n to\u00e0n b\u1eb1ng d\u00f2ng l\u00e0 \u201c ch\u01b0a \u0111\u1eb7t ph\u00f2ng \u201c. S\u1ef1 k\u1ebft h\u1ee3p \u0111\u01b0\u1ee3c vi\u1ebft ra nh\u01b0 sau theo d\u00f2ng l\u1ec7nh l\u00e0: =IF(ISNA(VLOOKUP(C5;$I$6:$J$8;2;0));&#8221; ch\u01b0a \u0111\u1eb7t ph\u00f2ng\u201d VLOOKUP(C5;$I$6:$J$8;2;0)).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11797 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_cua_ham_isna\"><\/span><span style=\"font-weight: 400\">\u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m isna<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft m\u1ecdi kh\u00f3 kh\u0103n khi m\u1eafc l\u1ed7i #N\/A trong excel v\u00e0 b\u1ea1n th\u1ef1c s\u1ef1 th\u1ea5y \u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 v\u00f4 c\u00f9ng c\u1ee7a <\/span><b>h\u00e0m isna <\/b><span style=\"font-weight: 400\">n\u00e0y. T\u1eeb #N\/A l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a ti\u1ebfng Anh b\u1edfi hai t\u1eeb Not Available. T\u1ee9c l\u00e0 kh\u00f4ng c\u00f3 s\u1ef1 t\u1ed3n t\u1ea1i, hi\u1ec7n h\u1eefu hay l\u00e0 kh\u00f4ng c\u00f3 s\u1eb5n t\u1ea1i \u0111\u00f3. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n c\u1ea7n t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb trong excel nh\u01b0ng vi\u1ec7c t\u00ecm ki\u1ebfm qu\u00e1 kh\u00f3 kh\u0103n th\u00ec n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb t\u1eeb \u0111\u00f3. V\u00ec th\u1ebf, s\u1ee9c quan tr\u1ecdng c\u1ee7a isna l\u00e0 v\u00f4 c\u00f9ng l\u1edbn s\u1ebd gi\u00fap b\u1ea1n t\u00ecm l\u1ed7i d\u1ec5 d\u00e0ng nh\u1ea5t. V\u00e0 \u0111\u00e2y c\u0169ng l\u00e0 \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c \u01b0a chu\u1ed9ng nh\u1ea5t.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11796 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-9.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Nh\u1eefng th\u00f4ng tin tr\u00ean l\u00e0 to\u00e0n b\u1ed9 kh\u00e1i qu\u00e1t v\u1ec1<\/span><b> h\u00e0m isna trong excel <\/b><span style=\"font-weight: 400\">bao g\u1ed3m <\/span><b>h\u00e0m isna l\u00e0 g\u00ec<\/b><span style=\"font-weight: 400\">, c\u00e1c l\u1ee3i \u00edch v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna. V\u1edbi nh\u1eefng \u0111i\u1ec1u \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i \u0111\u01b0a ra mong b\u1ea1n s\u1ebd c\u00f3 th\u00eam s\u1ef1 v\u1eefng ch\u1eafc trong k\u0129 n\u0103ng v\u0103n ph\u00f2ng. C\u0169ng nh\u01b0 c\u00f3 th\u00eam th\u00f4ng tin m\u1edbi \u0111\u1ec3 thu\u1eadn ti\u1ec7n trong qu\u00e1 tr\u00ecnh thao t\u00e1c s\u1eed d\u1ee5ng m\u00e1y t\u00ednh. Ch\u00fac b\u1ea1n m\u1ed9t ng\u00e0y t\u1ed1t l\u00e0nh!<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam:<span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/teky.edu.vn\/blog\/tach-chu-trong-excel\/\"><em><strong> C\u00e1ch t\u00e1ch ch\u1eef trong Excel<\/strong><\/em><\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>.Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel ch\u1eafc b\u1ea1n kh\u00f4ng c\u00f2n g\u00ec xa l\u1ea1 v\u1edbi h\u00e0m isna. H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m \u0111i theo isna c\u00f3 c\u00f4ng d\u1ee5ng g\u00ec?, h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y &hellip;<\/p>\n","protected":false},"author":26,"featured_media":11798,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11795","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 isna trong excel chi ti\u1ebft nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0\" \/>\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-isna-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 isna trong excel chi ti\u1ebft nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/ham-isna-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-03-20T09:52:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-20T09:54:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\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=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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-isna-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2022-03-20T09:52:21+00:00\",\"dateModified\":\"2022-03-20T09:54:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\"},\"wordCount\":1772,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg\",\"datePublished\":\"2022-03-20T09:52:21+00:00\",\"dateModified\":\"2022-03-20T09:54:59+00:00\",\"description\":\"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/ham-isna-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 isna trong excel chi ti\u1ebft 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\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t","description":"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0","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-isna-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t","og_description":"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0","og_url":"https:\/\/teky.edu.vn\/blog\/ham-isna-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-03-20T09:52:21+00:00","article_modified_time":"2022-03-20T09:54:59+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t","datePublished":"2022-03-20T09:52:21+00:00","dateModified":"2022-03-20T09:54:59+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/"},"wordCount":1772,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m isna trong excel chi ti\u1ebft nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg","datePublished":"2022-03-20T09:52:21+00:00","dateModified":"2022-03-20T09:54:59+00:00","description":"H\u00e0m isna trong excel s\u1ebd \u0111\u01b0\u1ee3c \u0111i k\u00e8m v\u1edbi c\u00e1c lo\u1ea1i h\u00e0m kh\u00e1c ch\u1eb3ng h\u1ea1n nh\u01b0 h\u00e0m Vlookup hay h\u00e0m if. V\u1eady nh\u1eefng h\u00e0m isna trong excel l\u00e0 g\u00ec?. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u1eefng \u0111i\u1ec1u \u0111\u00f3 trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y n\u00e0o.\u00a0","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-9.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/ham-isna-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 isna trong excel chi ti\u1ebft 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\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11795","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11795"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11798"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}