{"id":15395,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/hata-tipi\/"},"modified":"2021-02-25T16:26:31","modified_gmt":"2021-02-25T16:26:31","slug":"error-type","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/error-type\/","title":{"rendered":"HATA.T\u0130P\u0130"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve d\u00fczenlemesi i\u00e7in olduk\u00e7a g\u00fc\u00e7l\u00fc ara\u00e7lar sunar. Her iki programda da bulunan “HATA.T\u0130P\u0130” fonksiyonu, h\u00fccrelerdeki hata de\u011ferlerinin t\u00fcr\u00fcn\u00fc belirlemenize olanak tan\u0131r. Bu fonksiyon, \u00f6zellikle b\u00fcy\u00fck veri setleriyle \u00e7al\u0131\u015f\u0131rken kar\u015f\u0131la\u015f\u0131lan hatalar\u0131 tespit etmek ve d\u00fczeltmek i\u00e7in olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n

HATA.T\u0130P\u0130 Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

Fonksiyon, bir h\u00fccredeki hata de\u011ferini say\u0131sal bir formatta d\u00f6nd\u00fcr\u00fcr. E\u011fer h\u00fccrede hata yoksa, #N\/A hatas\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr. Her hata tipi i\u00e7in farkl\u0131 bir numara atanm\u0131\u015ft\u0131r.<\/p>\n

HATA.T\u0130P\u0130(hata_de\u011feri)<\/code><\/pre>\n
\u00d6rnek kullan\u0131m:<\/p>\n
=HATA.T\u0130P\u0130(B2)<\/code><\/pre>\n
Bu form\u00fcl, B2 h\u00fccresinde bulunan de\u011ferin hata tipini say\u0131sal olarak d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, e\u011fer B2 h\u00fccresinde #DIV\/0! hatas\u0131 bulunuyorsa, form\u00fcl ‘2’ de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n
Potansiyel Hata Kodlar\u0131 ve Anlamlar\u0131<\/h2>\n\n\n\n\n\n\n\n\n\n
Hata Kodu<\/th>\nAnlam\u0131<\/th>\n<\/tr>\n
1<\/td>\n#NULL!<\/td>\n<\/tr>\n
2<\/td>\n#DIV\/0!<\/td>\n<\/tr>\n
3<\/td>\n#VALUE!<\/td>\n<\/tr>\n
4<\/td>\n#REF!<\/td>\n<\/tr>\n
5<\/td>\n#NAME?<\/td>\n<\/tr>\n
6<\/td>\n#NUM!<\/td>\n<\/tr>\n
7<\/td>\n#N\/A<\/td>\n<\/tr>\n<\/table>\n
Uygulamal\u0131 \u00d6rnekler<\/h2>\n
\u015eimdi, bir veri tablosunda hata de\u011ferlerini bulmak ve d\u00fczeltmek i\u00e7in birka\u00e7 senaryoya bakal\u0131m.<\/p>\n
\u00d6rnek Senaryo 1:<\/strong> Bir finans tablosunda, \u00e7e\u015fitli b\u00f6lme i\u015flemleri sonucunda ortaya \u00e7\u0131kan #DIV\/0! hatalar\u0131n\u0131 tespit etmek ve \u00e7\u00f6z\u00fcmleme yapmak.<\/p>\n
A B C 1 Gelir Gider Kar Marj\u0131 2 5000 0 =B2\/A2 3 7000 3500 =B3\/A3 <\/code><\/pre>\n
C2 h\u00fccresinde #DIV\/0! hatas\u0131 meydana gelmi\u015ftir. Bu h\u00fccredeki hatay\u0131 tespit etmek ve hata tipine g\u00f6re \u015fartl\u0131 form\u00fcl uygulamak i\u00e7in HATA.T\u0130P\u0130 fonksiyonunu kullanabiliriz:<\/p>\n
C2 H\u00fccresi i\u00e7in: =IF(HATA.T\u0130P\u0130(B2\/A2) = 2, \"Tan\u0131ms\u0131z\", B2\/A2)<\/code><\/pre>\n
Bu form\u00fcl, e\u011fer B2\/A2 hesaplamas\u0131 #DIV\/0! hatas\u0131 veriyorsa ‘Tan\u0131ms\u0131z’ sonucu d\u00f6ner. Aksi takdirde normal hesap sonucunu verir.<\/p>\n
\u00d6rnek Senaryo 2:<\/strong> Adres hatalar\u0131n\u0131 (#REF!) bulmak ve hatal\u0131 referanslar\u0131 i\u015faretlemek.<\/p>\n
A B C 1 \u00dcr\u00fcn Fiyat Stok 2 Elma =D2 30 3 Portakal =E3 45 <\/code><\/pre>\n
B ve C s\u00fctunlar\u0131ndaki form\u00fcllerde ge\u00e7ersiz referanslar (#REF! hatalar\u0131) bulunmaktad\u0131r. HATA.T\u0130P\u0130 fonksiyonunu kullanarak bu hatalar\u0131 belirleyebiliriz:<\/p>\n
IF(HATA.T\u0130P\u0130(B2) = 4, \"Hatal\u0131 Referans\", B2)<\/code><\/pre>\n
Bu form\u00fcl, e\u011fer B2 h\u00fccresinde bir #REF! hatas\u0131 varsa “Hatal\u0131 Referans” metnini d\u00f6nd\u00fcr\u00fcr; yoksa h\u00fccrenin normal de\u011ferini g\u00f6sterir.<\/p>\n
Bu \u00f6rnekler, HATA.T\u0130P\u0130 fonksiyonunun veri hatalar\u0131n\u0131 tan\u0131mlamada ve d\u00fczeltmede nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
Bir hata t\u00fcr\u00fcne kar\u015f\u0131l\u0131k gelen numaray\u0131 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-15395","post","type-post","status-publish","format-standard","hentry","category-bilgi"],"acf":[],"yoast_head":"\nExcel'de ERROR.TYPE (HATA.T\u0130P\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ERROR.TYPE (HATA.T\u0130P\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/\" \/>\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:26:31+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 ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/error-type\/\",\"name\":\"Excel'de ERROR.TYPE (HATA.T\u0130P\u0130) 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:26:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/error-type\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/error-type\/#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\":\"HATA.T\u0130P\u0130\"}]},{\"@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 ERROR.TYPE (HATA.T\u0130P\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ERROR.TYPE (HATA.T\u0130P\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:26:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/","url":"https:\/\/functiontranslator.com\/tr\/error-type\/","name":"Excel'de ERROR.TYPE (HATA.T\u0130P\u0130) 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:26:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ERROR.TYPE (HATA.T\u0130P\u0130) 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\/error-type\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/error-type\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/error-type\/#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":"HATA.T\u0130P\u0130"}]},{"@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\/15395","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=15395"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15395\/revisions"}],"predecessor-version":[{"id":26663,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15395\/revisions\/26663"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}