{"id":1808,"date":"2023-11-03T03:25:57","date_gmt":"2023-11-03T03:25:57","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/"},"modified":"2023-12-10T05:58:29","modified_gmt":"2023-12-10T05:58:29","slug":"deger-hatasi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/","title":{"rendered":"#de\u011fer! nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1124714037\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;de #DE\u011eER! Hata, giri\u015f de\u011ferinin t\u00fcr\u00fc do\u011fru olmad\u0131\u011f\u0131nda ortaya \u00e7\u0131kar. \u0130ki h\u00fccreden iki say\u0131y\u0131 eklemek istedi\u011finizi, ancak ikinci h\u00fccredeki de\u011ferin metin oldu\u011funu varsayal\u0131m. Yani burada say\u0131 veya yaz\u0131 ekleyemeyece\u011finiz i\u00e7in bu hesaplamay\u0131 yapman\u0131z m\u00fcmk\u00fcn de\u011fil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70013\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011fer hatas\u0131n\u0131 d\u00fczeltme\" width=\"503\" height=\"282\"><\/figure><\/div><h2 class=\"wp-block-heading\"> #VALUE&#8217;yu D\u00fczeltme Ad\u0131mlar\u0131! Excel&#8217;de hata<\/h2><ol type=\"1\"><li> #DE\u011eER ayarlaman\u0131n ilk ad\u0131m\u0131! hata, form\u00fclde belirtti\u011finiz de\u011ferlerin do\u011fru t\u00fcrde oldu\u011funu do\u011frulamakt\u0131r.<\/li><li> Bir ba\u011f\u0131ms\u0131z de\u011fi\u015fkende belirtti\u011finiz de\u011ferin ge\u00e7erli olup olmad\u0131\u011f\u0131n\u0131 kontrol edin. Mesela bir metinden <sup>25.<\/sup> karakteri \u00e7\u0131karmak istiyorum ama bu metinde sadece 20 karakter var.<\/li><li> Daha sonra bahsetti\u011finiz tablolar\u0131n \u00f6l\u00e7\u00fclerini mutlaka kontrol edin. \u00d6rne\u011fin, bir sat\u0131rda 10 h\u00fccreniz var, ikinci h\u00fccrede ise 12 h\u00fccreniz var. Bu ayn\u0131 zamanda #DE\u011eER! hata.<\/li><li> Giri\u015f verilerinizdeki bir de\u011ferin #DE\u011eER olup olmad\u0131\u011f\u0131n\u0131 kontrol edin! hata zaten. Bu ayn\u0131 zamanda #DE\u011eER! sonu\u00e7 hatas\u0131.<\/li><\/ol><p> Yukar\u0131da hatay\u0131 d\u00fczeltmek i\u00e7in yapabilece\u011finiz ilk kontrollerden baz\u0131lar\u0131 verilmi\u015ftir. \u015eimdi daha iyi anlamak i\u00e7in ger\u00e7ek d\u00fcnyadan baz\u0131 \u00f6rneklere bakaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> #DE\u011eER! SUMproduct hatas\u0131<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte SUMproduct fonksiyonunu kulland\u0131k ve ikinci tabloda 10 h\u00fccrelik aral\u0131ktan bahsettik, ikinci aral\u0131kta ise yanl\u0131\u015fl\u0131kla 9 h\u00fccreli B1:B9&#8217;dan bahsettik. Bu da #DE\u011eER! <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70014\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-erreur-de-valeur-avec-sumproduct.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam-\u00fcr\u00fcnle-hata-de\u011feri\" width=\"512\" height=\"374\"><\/figure><\/div><p> Bu ayn\u0131 zamanda ETOPLA, SUMIFS, AVERAGEIF ve AVERAGEIFS gibi di\u011fer i\u015flevlerde de meydana gelebilir.<\/p><h2 class=\"wp-block-heading\"> #DE\u011eER! \u00c7al\u0131\u015fma tarihlerinde hata<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1 h\u00fccresinde metin olarak saklanan ve yanl\u0131\u015f formatta bir tarih var. \u015eimdi bu tarihi bir hesaplamada kullanmaya \u00e7al\u0131\u015f\u0131rsak #DE\u011eER! <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70015\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-erreur-de-valeur-pendant-les-dates-de-travail.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7al\u0131\u015fma-tarihleri s\u0131ras\u0131nda de\u011fer-hatas\u0131\" width=\"508\" height=\"266\"><\/figure><\/div><p> Bunun nedeni, bir hesaplama yapmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ve o tarih bir test oldu\u011funda, o tarih format\u0131 insan taraf\u0131ndan okunabilir olsa bile o fonksiyon, hatta o form\u00fcl o tarihi tan\u0131mlayam\u0131yor.<\/p><h2 class=\"wp-block-heading\"> #DE\u011eER! Bir hesaplamaya bo\u015fluk de\u011feri eklerken<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1 ve A2 h\u00fccrelerini eklemeye \u00e7al\u0131\u015ft\u0131\u011f\u0131mda #DE\u011eER! hata. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70016\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-valeur-quand-inclure-la-valeur-de-lespace.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011fer-dahil edildi\u011finde-bo\u015fluk-de\u011fer\" width=\"422\" height=\"329\"><\/figure><\/div><p> Sebebi \u015fu: A1 h\u00fccresinde hi\u00e7bir kullan\u0131c\u0131n\u0131n g\u00f6remeyece\u011fi bir alan\u0131m\u0131z var. Ve hesaplamada bundan bahsetti\u011fimde bana #DE\u011eER verdi!<\/p><p> \u0130\u015fte #DE\u011eER ile kar\u015f\u0131 kar\u015f\u0131ya kalman\u0131z\u0131n nedenlerinden baz\u0131lar\u0131: Excel&#8217;de hata. Ancak bu hatay\u0131 gidermenin en iyi yolu form\u00fclde bahsetti\u011finiz de\u011ferlere bakmakt\u0131r. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/corriger-lerreur-de-valeur.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bolme-hatasi\/\">Hata #DIV\/0<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dokulme-hatasi\/\">#YAYILMAK! Hata<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hatalari-gormezden-gel\/\">Excel&#8217;deki t\u00fcm hatalar\u0131 yoksay<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-yok\/\">#YOK Excel&#8217;de Hata<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/\">#REF! Excel&#8217;de hata<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1808","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#039;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\",\"name\":\"#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\",\"datePublished\":\"2023-11-03T03:25:57+00:00\",\"dateModified\":\"2023-12-10T05:58:29+00:00\",\"description\":\"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"#de\u011fer! nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131","description":"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?","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:\/\/exceladvisor.org\/tr\/deger-hatasi\/","og_locale":"tr_TR","og_type":"article","og_title":"#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131","og_description":"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?","og_url":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/","url":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/","name":"#DE\u011eER! nas\u0131l d\u00fczeltilir? Excel&#39;de hata m\u0131 var? - Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png","datePublished":"2023-11-03T03:25:57+00:00","dateModified":"2023-12-10T05:58:29+00:00","description":"Bu form\u00fcl e\u011fitiminde #DE\u011eER! hatayla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131zda, bunu d\u00fczeltmenin yollar\u0131 nelerdir?","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/deger-hatasi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-valeur-de-fixation.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/deger-hatasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"#de\u011fer! nas\u0131l d\u00fczeltilir? excel&#39;de hata m\u0131 var?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1808"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1808\/revisions"}],"predecessor-version":[{"id":2248,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1808\/revisions\/2248"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}