{"id":15493,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ehataliysa\/"},"modified":"2021-02-25T16:29:51","modified_gmt":"2021-02-25T16:29:51","slug":"iserror","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/iserror\/","title":{"rendered":"EHATALIYSA"},"content":{"rendered":"

Excel ve Google E-Tablolar\u2019da Hata Kontrol\u00fc: EHATALIYSA \u0130\u015flevinin Kullan\u0131m\u0131<\/h1>\n

Microsoft Excel ve Google E-Tablolar, veri analizi ve i\u015flem yapma konusunda geni\u015f fonksiyonlar sunar. Bunlar\u0131n i\u00e7inde, veri setlerindeki hatalar\u0131 y\u00f6netmek i\u00e7in olduk\u00e7a yararl\u0131 olan EHATALIYSA (ISERROR) i\u015flevi bulunmaktad\u0131r. Bu i\u015flev, form\u00fcllerden kaynaklanan hatalar\u0131 yakalamak ve bu hatalar\u0131 i\u015flerken kullan\u0131c\u0131lar\u0131n daha temiz veri setleri ile \u00e7al\u0131\u015fmalar\u0131n\u0131 sa\u011flamak i\u00e7in tasarlanm\u0131\u015ft\u0131r.<\/p>\n

EHATALIYSA \u0130\u015flevinin S\u00f6zdizimi ve Temel Kullan\u0131m\u0131<\/h2>\n

I\u015flevin temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=EHATALIYSA(de\u011fer)<\/code><\/pre>\n
Bu i\u015flev, tek bir arg\u00fcman al\u0131r:<\/p>\n
    \n
  • de\u011fer<\/strong>: Bu arg\u00fcman, hata kontrol\u00fc yap\u0131lacak olan form\u00fcl ya da ifade. E\u011fer bu ifade hata i\u00e7eriyorsa, EHATALIYSA i\u015flevi TRUE (do\u011fru), aksi takdirde FALSE (yanl\u0131\u015f) de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/p>\n<\/ul>\n
    Pratik Uygulamalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n
    EHATALIYSA i\u015flevi genellikle veriler \u00fczerinden yap\u0131lan hesaplamalarda hata olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r. \u0130ki pratik \u00f6rnek \u00fczerinden bu i\u015flevin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterece\u011fiz.<\/p>\n
    \u00d6rnek 1: B\u00f6lme \u0130\u015flemini Hata Kontrol\u00fc ile Yapmak<\/h3>\n
    Bir say\u0131y\u0131 s\u0131f\u0131ra b\u00f6lme i\u015flemi matematikte tan\u0131ms\u0131zd\u0131r ve Excel veya Google E-Tablolar\u2019da bu t\u00fcr bir i\u015flem yap\u0131ld\u0131\u011f\u0131nda hata mesaj\u0131 al\u0131rs\u0131n\u0131z. EHATALIYSA i\u015flevini kullanarak bu durumu kontrol edebilir ve hata mesaj\u0131n\u0131n yerine anla\u015f\u0131l\u0131r bir metin g\u00f6sterebiliriz. \u00d6rne\u011fin:<\/p>\n
    =IF(ISERROR(A2\/B2), \"Tan\u0131ms\u0131z\", A2\/B2)<\/code><\/pre>\n
    Bu form\u00fcl, E\u011fer A2 h\u00fccresi B2 h\u00fccresine b\u00f6l\u00fcnd\u00fc\u011f\u00fcnde herhangi bir hata mesaj\u0131 verirse, “Tan\u0131ms\u0131z” yaz\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr; aksi halde b\u00f6lme i\u015fleminin sonucunu g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Hatal\u0131 Veri Giri\u015flerini Filtrelemek<\/h3>\n
    Diyelim ki, bir excel kolonunda logaritma hesaplamas\u0131 yap\u0131yorsunuz ve baz\u0131 h\u00fccre de\u011ferleri s\u0131f\u0131r ya da negatif. Logaritma fonksiyonu sadece pozitif say\u0131lar i\u00e7in tan\u0131ml\u0131d\u0131r ve bu de\u011ferler hata \u00fcretecektir. EHATALIYSA i\u015flevini kullanarak bu hatalar\u0131 tespit edebilirsiniz:<\/p>\n
    =IF(ISERROR(LOG(A2)), \"Hatal\u0131 giri\u015f\", LOG(A2))<\/code><\/pre>\n
    Bu form\u00fcl, A2 h\u00fccresindeki de\u011fer logaritma fonksiyonu i\u00e7in uygun olmayan bir de\u011ferse “Hatal\u0131 giri\u015f” d\u00f6nd\u00fcr\u00fcr, de\u011filse hesaplanan logaritmay\u0131 g\u00f6sterir.<\/p>\n
    Sonu\u00e7<\/h2>\n
    EHATALIYSA i\u015flevi, Excel ve Google E-Tablolar’da hatalar\u0131 y\u00f6netmek i\u00e7in olduk\u00e7a faydal\u0131 bir ara\u00e7t\u0131r. Form\u00fcllerinizde kar\u015f\u0131la\u015faca\u011f\u0131n\u0131z hatalar\u0131 \u00f6ng\u00f6rerek, veri analizlerinizde daha do\u011fru ve temiz sonu\u00e7lar elde etmenize olanak tan\u0131r. Bu i\u015flev sayesinde, kullan\u0131c\u0131lar potansiyel hatalar\u0131 \u00f6nceden tespit edebilir ve bunlar\u0131 uygun \u015fekillerde i\u015fleyebilirler.<\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011fer herhangi bir 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-15493","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISERROR (EHATALIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISERROR (EHATALIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/\" \/>\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:51+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 ISERROR (EHATALIYSA) 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\/iserror\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/iserror\/\",\"name\":\"Excel'de ISERROR (EHATALIYSA) 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:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/iserror\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/iserror\/#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\":\"EHATALIYSA\"}]},{\"@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 ISERROR (EHATALIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISERROR (EHATALIYSA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISERROR (EHATALIYSA) 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\/iserror\/","url":"https:\/\/functiontranslator.com\/tr\/iserror\/","name":"Excel'de ISERROR (EHATALIYSA) 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:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISERROR (EHATALIYSA) 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\/iserror\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/iserror\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/iserror\/#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":"EHATALIYSA"}]},{"@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\/15493","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=15493"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15493\/revisions"}],"predecessor-version":[{"id":26761,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15493\/revisions\/26761"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}