{"id":15497,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/eyoksa\/"},"modified":"2021-02-25T16:29:57","modified_gmt":"2021-02-25T16:29:57","slug":"isna","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/isna\/","title":{"rendered":"EYOKSA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets\u2019te “ISNA” (veya “E\u011eERYOKSA”) fonksiyonu, bir h\u00fccredeki de\u011ferin NA (Yok) hata de\u011feri olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in kullan\u0131l\u0131r. E\u011fer de\u011fer NA ise TRUE, de\u011filse FALSE de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr. Bu fonksiyon, veri setlerinde eksik veya hatal\u0131 verilerin tespit edilmesinde yayg\u0131n olarak kullan\u0131l\u0131r.<\/p>\n

S\u00f6zdizimi ve Temel Kullan\u0131m<\/h2>\n

ISNA fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=ISNA(de\u011fer)<\/code><\/pre>\n
Burada “de\u011fer”, NA olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek istedi\u011finiz h\u00fccre veya ifadeyi temsil eder.<\/p>\n
\u00d6rnek Kullan\u0131m:<\/p>\n
=ISNA(A1)<\/code><\/pre>\n
Bu form\u00fcl, A1 h\u00fccresindeki de\u011fer NA ise TRUE, de\u011filse FALSE de\u011feri d\u00f6ner.<\/p>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \n
  • Veri Temizleme:<\/strong> B\u00fcy\u00fck veri setlerinde eksik verilerin tespiti ve temizlenmesi i\u00e7in kullan\u0131l\u0131r.<\/li>\n
  • Hata Raporlama:<\/strong> Hesaplamalar s\u0131ras\u0131nda meydana gelen NA hatalar\u0131n\u0131n takibi ve raporlanmas\u0131 i\u00e7in i\u015flevseldir.<\/li>\n<\/ul>\n
    Detayl\u0131 Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Eksik Veri Tespiti<\/strong><\/p>\n
    Bir \u015firketin sat\u0131\u015f verilerinde baz\u0131 h\u00fccrelerin eksik oldu\u011funu ve bu h\u00fccrelerin NA hata de\u011feriyle dolduruldu\u011funu varsayal\u0131m. Eksik verileri tespit etmek i\u00e7in ISNA fonksiyonunu \u015fu \u015fekilde kullanabiliriz:<\/p>\n
    =ISNA(B2:B100)<\/code><\/pre>\n
    Bu form\u00fcl, B s\u00fctununun 2 ile 100 aras\u0131ndaki h\u00fccrelerdeki her bir de\u011feri NA olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. De\u011fer NA ise, ilgili h\u00fccre i\u00e7in TRUE d\u00f6ner.<\/p>\n
    Eksik verileri i\u00e7eren h\u00fccreleri belirlemek i\u00e7in bu sonu\u00e7lardan yararlanabilirsiniz.<\/p>\n
    \u00d6rnek 2: Form\u00fcl Hatalar\u0131n\u0131 Raporlama<\/strong><\/p>\n
    Bir hesaplama tablosunda \u00e7e\u015fitli form\u00fcller kullan\u0131l\u0131rken, NA t\u00fcr\u00fcndeki hatalar\u0131n izlenmesi gerekebilir. \u00d6rne\u011fin, sat\u0131\u015f tahminlerinde beklenmedik NA hatalar\u0131 meydana gelirse, bu hatalar\u0131 h\u0131zla tespit etmek ad\u0131na ISNA fonksiyonu \u015fu \u015fekilde kullan\u0131labilir:<\/p>\n
    =IF(ISNA(C2), \"Hata - Veri Yok\", C2)<\/code><\/pre>\n
    Bu form\u00fcl, C2 h\u00fccresindeki de\u011fer NA ise “Hata – Veri Yok” mesaj\u0131n\u0131 g\u00f6sterir; de\u011filse, C2’deki de\u011feri d\u00f6nd\u00fcr\u00fcr. Bu y\u00f6ntem, verileri analiz ederken ve raporlar haz\u0131rlarken hatalar\u0131 belirlemek i\u00e7in olduk\u00e7a etkilidir.<\/p>\n
    ISNA fonksiyonu, Excel ve Google Sheets\u2019te veri hatalar\u0131n\u0131 y\u00f6netmek ve \u00f6zellikle NA t\u00fcr\u00fcndeki hatalar\u0131 ele almak i\u00e7in temel bir ara\u00e7t\u0131r. K\u00fc\u00e7\u00fckten b\u00fcy\u00fc\u011fe her \u00f6l\u00e7ekteki veri setleriyle \u00e7al\u0131\u015f\u0131rken, bu tarz fonksiyonlar\u0131n etkin kullan\u0131lmas\u0131 veri do\u011frulu\u011funu ve g\u00fcvenilirli\u011fini art\u0131r\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011fer #YOK hata de\u011feriyse, DO\u011eRU verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[586],"tags":[],"class_list":["post-15497","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/isna\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/isna\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isna\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/isna\/\",\"name\":\"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:29:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/isna\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/isna\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/isna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bilgi\",\"item\":\"https:\/\/functiontranslator.com\/tr\/bilgi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EYOKSA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/isna\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/isna\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/isna\/","url":"https:\/\/functiontranslator.com\/tr\/isna\/","name":"Excel'de ISNA (EYOKSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:29:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISNA (EYOKSA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/isna\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/isna\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/isna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Bilgi","item":"https:\/\/functiontranslator.com\/tr\/bilgi\/"},{"@type":"ListItem","position":3,"name":"EYOKSA"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15497"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15497\/revisions"}],"predecessor-version":[{"id":26765,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15497\/revisions\/26765"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}