{"id":15371,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/delta\/"},"modified":"2021-02-25T16:25:48","modified_gmt":"2021-02-25T16:25:48","slug":"delta","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/delta\/","title":{"rendered":"DELTA"},"content":{"rendered":"

Microsoft Excel ve Google Tablolar, verileri analiz etmek ve i\u015flemek i\u00e7in pek \u00e7ok farkl\u0131 fonksiyon sunar. Bu rehberde, say\u0131sal de\u011ferlerin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmeye yarayan ve sonucu olarak 0 veya 1 de\u011ferini veren ‘DELTA’ fonksiyonuna dair detayl\u0131 bilgi sunaca\u011f\u0131z.<\/p>\n

Fonksiyonun Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

DELTA<\/b> fonksiyonu, iki say\u0131n\u0131n birbirine e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer say\u0131lar birbirine e\u015fitse 1, de\u011filse 0 d\u00f6ner. Bu fonksiyon, say\u0131sal kar\u015f\u0131la\u015ft\u0131rmalar ve hata kontrol\u00fc yapmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

Excel’de kullan\u0131m\u0131:<\/p>\n

=DELTA(number1, [number2]) <\/code><\/pre>\n
Google Tablolar’da kullan\u0131m\u0131:<\/p>\n
=DELTA(number1, number2) <\/code><\/pre>\n
    \n
  • number1<\/b>: Kar\u015f\u0131la\u015ft\u0131r\u0131lacak ilk say\u0131.<\/li>\n
  • number2<\/b> (iste\u011fe ba\u011fl\u0131, Excel’de): Kar\u015f\u0131la\u015ft\u0131r\u0131lacak ikinci say\u0131. Bu arg\u00fcman verilmezse, varsay\u0131lan olarak s\u0131f\u0131r (0) al\u0131n\u0131r.<\/li>\n<\/ul>\n
    Kullan\u0131m Senaryolar\u0131 ve Detayl\u0131 \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: Basit E\u015fitlik Testi<\/b><\/p>\n
    Hesaplamak istedi\u011finiz iki say\u0131n\u0131n e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in DELTA fonksiyonunu kullanabilirsiniz. \u00d6rne\u011fin, A1 h\u00fccresinde 5, B1 h\u00fccresinde 5 de\u011feri var diyelim:<\/p>\n
    =DELTA(A1, B1) <\/code><\/pre>\n
    Bu form\u00fcl, e\u011fer A1 ve B1 h\u00fccreleri ayn\u0131 say\u0131y\u0131 i\u00e7eriyorsa 1, aksi halde 0 sonucunu d\u00f6nd\u00fcrecektir. Verilen \u00f6rnek i\u00e7in sonu\u00e7 1 olacakt\u0131r. E\u011fer B1 h\u00fccresi 3 gibi farkl\u0131 bir de\u011fer i\u00e7erseydi sonu\u00e7 0 olacakt\u0131.<\/p>\n
    \u00d6rnek 2: Otomatik Hata Mesaj\u0131<\/b><\/p>\n
    Bir veri giri\u015fi do\u011frulama sistemi kurmak istiyorsunuz ve kullan\u0131c\u0131 girdi\u011finde belirli bir de\u011fere e\u015fit olmas\u0131 gerekti\u011fini d\u00fc\u015f\u00fcnelim. \u00d6rne\u011fin, A2 h\u00fccresine kullan\u0131c\u0131lar\u0131n 100 de\u011ferini girmesi gerekti\u011fini varsayal\u0131m:<\/p>\n
    =IF(DELTA(A2, 100) = 1, \"Do\u011fru Giri\u015f\", \"Hatal\u0131 Giri\u015f\") <\/code><\/pre>\n
    Kullan\u0131c\u0131 A2 h\u00fccresine 100 de\u011ferini girerse “Do\u011fru Giri\u015f” mesaj\u0131n\u0131, farkl\u0131 bir de\u011fer girerse “Hatal\u0131 Giri\u015f” uyar\u0131s\u0131n\u0131 alacak. Bu, form hatalar\u0131n\u0131 azaltmak ve veri tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamak i\u00e7in faydal\u0131d\u0131r.<\/p>\n
    Bu fonksiyonlar, Excel ve Google Tablolar’da veri analizi yaparken kar\u015f\u0131la\u015f\u0131lan sorunlar\u0131 \u00e7\u00f6zmede ve veri do\u011frulu\u011funu sa\u011flamada \u00e7ok i\u015flevsel ara\u00e7lar sunar. Kullan\u0131ld\u0131\u011f\u0131 yer ve \u015fekle g\u00f6ra i\u015f ak\u0131\u015flar\u0131n\u0131 b\u00fcy\u00fck \u00f6l\u00e7\u00fcde optimize etmeye yard\u0131mc\u0131 olabilirler.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 s\u0131nar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[583],"tags":[],"class_list":["post-15371","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DELTA 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\/delta\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DELTA 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\/delta\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:25:48+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 DELTA 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\/delta\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/delta\/\",\"name\":\"Excel'de DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:25:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DELTA 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\/delta\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/delta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/delta\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00fchendislik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/muhendislik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DELTA\"}]},{\"@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 DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DELTA 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\/delta\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DELTA 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\/delta\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DELTA 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\/delta\/","url":"https:\/\/functiontranslator.com\/tr\/delta\/","name":"Excel'de DELTA Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:25:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DELTA 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\/delta\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/delta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/delta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"M\u00fchendislik","item":"https:\/\/functiontranslator.com\/tr\/muhendislik\/"},{"@type":"ListItem","position":3,"name":"DELTA"}]},{"@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\/15371","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=15371"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15371\/revisions"}],"predecessor-version":[{"id":26639,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15371\/revisions\/26639"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}