{"id":15492,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ehata\/"},"modified":"2021-02-25T16:29:50","modified_gmt":"2021-02-25T16:29:50","slug":"iserr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/iserr\/","title":{"rendered":"EHATA"},"content":{"rendered":"

Hata Kontrol \u0130\u015flevi Olarak Etkili Kullan\u0131mlar<\/h2>\n

Hem Microsoft Excel hem de Google E-Tablolar, kullan\u0131c\u0131lara veri analizi ve hesaplama konusunda g\u00fc\u00e7l\u00fc ara\u00e7lar sunar. Bu ara\u00e7lar aras\u0131nda, hata tespiti ve y\u00f6netimi i\u00e7in kullan\u0131lan ISERR<\/code> (Excel’de) ve EHATA<\/code> (Google E-Tablolar’da) fonksiyonlar\u0131 bulunmaktad\u0131r. Bu rehber, bu i\u015flevlerin kullan\u0131m\u0131n\u0131, syntax’\u0131n\u0131 ve pratik uygulamalar\u0131n\u0131 detayl\u0131 bir \u015fekilde ele almaktad\u0131r. <\/p>\n

\u0130\u015flevin Syntax A\u00e7\u0131klamas\u0131 ve Temel Kullan\u0131m\u0131<\/h2>\n

ISERR<\/code> ve EHATA<\/code> i\u015flevleri, belirli bir h\u00fccredeki de\u011ferin ba\u015far\u0131s\u0131z bir hata d\u0131\u015f\u0131nda bir hatay\u0131 (yani #N\/A<\/code> hari\u00e7) i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek i\u00e7in kullan\u0131l\u0131r. E\u011fer hata varsa, bu fonksiyonlar TRUE<\/code> de\u011ferini d\u00f6nd\u00fcr\u00fcr, aksi takdirde FALSE<\/code> d\u00f6nd\u00fcr\u00fcr. <\/p>\n

 Syntax:<\/code> Excel i\u00e7in: =ISERR(de\u011fer) Google E-Tablolar i\u00e7in: =EHATA(de\u011fer) <\/pre>\n
\u00d6rnek Kullan\u0131m:<\/b><\/p>\n
 A1 h\u00fccresinde de\u011fer: #DIV\/0! Excel'de: =ISERR(A1) - Sonu\u00e7: TRUE Google E-Tablolar'da: =EHATA(A1) - Sonu\u00e7: TRUE <\/pre>\n
Pratik G\u00f6revler ve Ayr\u0131nt\u0131l\u0131 \u00c7\u00f6z\u00fcmleri<\/h2>\n
    \n
  • \n
    G\u00f6rev:<\/b> \u00c7ok say\u0131da h\u00fccre i\u00e7indeki hatalar\u0131 tespit etme ve liste halinde g\u00f6sterme.<\/p>\n
    \u00c7\u00f6z\u00fcm:<\/b> T\u00fcm h\u00fccreleri kontrol etmek i\u00e7in bir aral\u0131k belirtin ve dizilerle \u00e7al\u0131\u015f\u0131n. Excel'deki \u00f6rnek bir form\u00fcl;<\/p>\n
    =IF(ISERR(B2:B100), \"Hata Bulundu\", \"Hata Yok\")<\/code><\/pre>\n
    Google E-Tablolar'da ise;<\/p>\n
    =ARRAYFORMULA(IF(EHATA(B2:B100), \"Hata Bulundu\", \"Hata Yok\"))<\/code><\/pre>\n<\/li>\n
  • \n
    G\u00f6rev:<\/b> Finansal raporda hesaplama hatalar\u0131n\u0131 d\u00fczeltmek i\u00e7in bir \u00f6nc\u00fcl olarak hata kontrol\u00fc yap\u0131lmas\u0131.<\/p>\n
    \u00c7\u00f6z\u00fcm:<\/b> \u00d6ncelikle t\u00fcm form\u00fcllerdeki hatalar\u0131 ISERR<\/code> veya EHATA<\/code> ile kontrol edin, ard\u0131ndan hata i\u00e7eren h\u00fccrelerdeki form\u00fclleri d\u00fczeltebilirsiniz.<\/p>\n
    A1 h\u00fccresi: =100\/0 B1 h\u00fccresi: =ISERR(A1) Sonu\u00e7: TRUE (Hata var, d\u00fczeltme gerekiyor)<\/code><\/pre>\n
    Form\u00fcl yanl\u0131\u015f veya s\u0131f\u0131ra b\u00f6lme gibi hatalar olabilir. Kendi verilerinize uygun d\u00fczeltmeleri yaparak ilerleyin.<\/p>\n<\/li>\n<\/ul>\n
    Sonu\u00e7<\/h2>\n
     ISERR<\/code> ve EHATA<\/code> i\u015flevleri, Excel ve Google E-Tablolar'daki verileri analiz ederken s\u0131k kar\u015f\u0131la\u015f\u0131lan hatalar\u0131 tespit etmek i\u00e7in vazge\u00e7ilmez ara\u00e7lard\u0131r. Kullan\u0131m kolayl\u0131\u011f\u0131 ve verimlili\u011fi sayesinde, \u00e7e\u015fitli uygulamalar ve senaryolar i\u00e7in idealdirler. Bu fonksiyonlar\u0131 d\u00fczenli olarak kullanarak veri setlerinizdeki hatalar\u0131 minimize edebilirsiniz. <\/p>\n","protected":false},"excerpt":{"rendered":"
    De\u011fer #YOK d\u0131\u015f\u0131ndaki 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-15492","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ISERR (EHATA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ISERR (EHATA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/\" \/>\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:50+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 ISERR (EHATA) 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\/iserr\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/iserr\/\",\"name\":\"Excel'de ISERR (EHATA) 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:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/iserr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/iserr\/#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\":\"EHATA\"}]},{\"@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 ISERR (EHATA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ISERR (EHATA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ISERR (EHATA) 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\/iserr\/","url":"https:\/\/functiontranslator.com\/tr\/iserr\/","name":"Excel'de ISERR (EHATA) 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:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ISERR (EHATA) 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\/iserr\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/iserr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/iserr\/#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":"EHATA"}]},{"@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\/15492","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=15492"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15492\/revisions"}],"predecessor-version":[{"id":26760,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15492\/revisions\/26760"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}