{"id":15398,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ozdes\/"},"modified":"2021-02-25T16:26:35","modified_gmt":"2021-02-25T16:26:35","slug":"exact","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/exact\/","title":{"rendered":"\u00d6ZDE\u015e"},"content":{"rendered":"

Metin Kar\u015f\u0131la\u015ft\u0131rma \u0130\u015flemleri Nas\u0131l Yap\u0131l\u0131r?<\/h2>\n

Hem Microsoft Excel hem de Google E-Tablolar’da metinler aras\u0131 tam e\u015fle\u015fme kontrol\u00fc yapman\u0131za olanak tan\u0131yan bir i\u015flev vard\u0131r. Bu i\u015flev EXACT, T\u00fcrk\u00e7ede ise \u00d6ZDE\u015e olarak bilinir. Bu i\u015flev, iki metin de\u011ferin birbirine tam olarak e\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r. <\/p>\n

\u0130\u015flev S\u00f6zdizimi ve \u00d6rnek Kullan\u0131m\u0131<\/h2>\n

EXACT i\u015flevinin temel s\u00f6zdizimi olduk\u00e7a basittir: <\/p>\n

  =\u00d6ZDE\u015e(metin1, metin2) <\/code> <\/pre>\n
 Burada “metin1” ve “metin2” kar\u015f\u0131la\u015ft\u0131r\u0131lacak olan iki metin de\u011ferleridir. \u0130\u015flev, bu iki de\u011ferin tamamen ayn\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve sonu\u00e7 olarak TRUE (Do\u011fru) veya FALSE (Yanl\u0131\u015f) de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p>\n
 \u00d6rnek kullan\u0131m: <\/p>\n
  =\u00d6ZDE\u015e(\"Merhaba\", \"merhaba\") <\/code> <\/pre>\n
 Bu \u00f6rnekte, “Merhaba” ile “merhaba” aras\u0131nda b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf fark\u0131 oldu\u011fu i\u00e7in sonu\u00e7 FALSE<\/strong> (Yanl\u0131\u015f) olarak d\u00f6necektir. <\/p>\n
Pratik Uygulamalar<\/h2>\n
 EXACT i\u015flevinin uygulanabilece\u011fi pratik durumlar\u0131 ve bu durumlar\u0131n \u00e7\u00f6z\u00fcmlerini a\u015fa\u011f\u0131da bulabilirsiniz: <\/p>\n
    \n
  •  Kullan\u0131c\u0131 Adlar\u0131n\u0131 Do\u011frulama:<\/strong>\n
     \u00d6zellikle duyarl\u0131 veri i\u015flemleri y\u00fcr\u00fcten sistemlerde, kullan\u0131c\u0131 adlar\u0131 b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 olabilir. EXACT i\u015flevi, kullan\u0131c\u0131 ad\u0131n\u0131n tam olarak do\u011fru girilip girilmedi\u011fini kontrol etmek i\u00e7in kullan\u0131labilir. <\/p>\n
      =\u00d6ZDE\u015e(A2, \"admin\") <\/code> <\/pre>\n
     Burada, A2 h\u00fccresindeki kullan\u0131c\u0131 ad\u0131n\u0131n “admin” olup olmad\u0131\u011f\u0131 tam olarak (b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131 ile) kontrol edilir. E\u011fer tam e\u015fle\u015fme varsa TRUE, yoksa FALSE de\u011feri d\u00f6ner. <\/p>\n<\/li>\n
  •  Form Verilerinin Do\u011frulu\u011funu Kontrol Etme:<\/strong>\n
     Formlardan al\u0131nan verilerin do\u011frulu\u011funu kontrol ederken EXACT i\u015flevi kullan\u0131labilir. \u00d6rne\u011fin, cinsiyet alan\u0131nda “Erkek” veya “Kad\u0131n” d\u0131\u015f\u0131nda bir giri\u015fin kabul edilmemesi gibi. <\/p>\n
      =\u00d6ZDE\u015e(B2, \"Erkek\") <\/code> <\/pre>\n
     Bu \u00f6rnekte, B2 h\u00fccresinde “Erkek” yaz\u0131p yazmad\u0131\u011f\u0131 kontrol edilir. E\u011fer B2 ‘Erkek’ ise TRUE, de\u011filse FALSE d\u00f6ner. <\/p>\n<\/li>\n<\/ul>\n
    Yorumlar ve Dikkat Edilmesi Gerekenler<\/h2>\n
     EXACT i\u015flevi olduk\u00e7a basit gibi g\u00f6r\u00fcnse de, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 olmas\u0131 nedeniyle bazen istenmeyen sonu\u00e7lar do\u011furabilir. Bu nedenle, kullan\u0131m amac\u0131na uygun oldu\u011fundan emin olmak \u00f6nemlidir. \u00d6zellikle otomatik form i\u015flemleri ve veri do\u011frulama senaryolar\u0131nda b\u00fcy\u00fck fayda sa\u011flar. <\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki metin de\u011ferinin \u00f6zde\u015f olup olmad\u0131\u011f\u0131n\u0131 anlamak i\u00e7in, de\u011ferleri denetler<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15398","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de EXACT (\u00d6ZDE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de EXACT (\u00d6ZDE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/\" \/>\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:35+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 EXACT (\u00d6ZDE\u015e) 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\/exact\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/exact\/\",\"name\":\"Excel'de EXACT (\u00d6ZDE\u015e) 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:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/exact\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/exact\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u00d6ZDE\u015e\"}]},{\"@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 EXACT (\u00d6ZDE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de EXACT (\u00d6ZDE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:26:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de EXACT (\u00d6ZDE\u015e) 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\/exact\/","url":"https:\/\/functiontranslator.com\/tr\/exact\/","name":"Excel'de EXACT (\u00d6ZDE\u015e) 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:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da EXACT (\u00d6ZDE\u015e) 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\/exact\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/exact\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/exact\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"\u00d6ZDE\u015e"}]},{"@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\/15398","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=15398"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15398\/revisions"}],"predecessor-version":[{"id":26666,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15398\/revisions\/26666"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}