{"id":15720,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/ozelveya\/"},"modified":"2021-02-25T16:39:16","modified_gmt":"2021-02-25T16:39:16","slug":"xor","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/xor\/","title":{"rendered":"\u00d6ZELVEYA"},"content":{"rendered":"

MS Excel ve Google Sheets, \u00e7ok \u00e7e\u015fitli fonksiyonlar sunar, bunlardan biri de XOR i\u015flevi olan “\u00d6ZELVEYA” fonksiyonudur. “\u00d6ZELVEYA”, \u00f6zg\u00fcn bir mant\u0131k fonksiyonu olarak, veri analizinde \u00e7e\u015fitli senaryolar\u0131n test edilmesinde kullan\u0131labilir. Bu i\u015flev, iki veya daha fazla mant\u0131ksal ifadeyi kar\u015f\u0131la\u015ft\u0131r\u0131r ve yaln\u0131zca bir tanesi do\u011fru ise TRUE (DO\u011eRU), di\u011fer durumlarda ise FALSE (YANLI\u015e) de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p>\n

\u00d6ZELVEYA Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m \u00d6rnekleri<\/h2>\n

\u00d6ZELVEYA fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=\u00d6ZELVEYA(logical1, [logical2], ...)<\/code><\/pre>\n
    \n
  • logical1, logical2, …<\/strong> – De\u011ferlendirilecek iki veya daha fazla mant\u0131ksal de\u011fer, ya da bu de\u011ferlerin bulundu\u011fu h\u00fccreler veya aral\u0131klar. En az bir mant\u0131ksal arg\u00fcman gereklidir.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m:<\/strong><\/p>\n
    =\u00d6ZELVEYA(A1, B1)<\/code><\/pre>\n
    Bu form\u00fcl, A1 ve B1 h\u00fccrelerindeki de\u011ferlerden yaln\u0131zca biri DO\u011eRU oldu\u011funda TRUE (DO\u011eRU) de\u011ferini d\u00f6nd\u00fcr\u00fcr. E\u011fer her iki h\u00fccre de DO\u011eRU veya her iki h\u00fccre de YANLI\u015e ise, form\u00fcl FALSE (YANLI\u015e) d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: M\u00fc\u015fteri \u0130ndirimi Uygulama Ko\u015fullar\u0131<\/strong><\/p>\n
    Bir ma\u011fazada, \u00f6zel bir promosyon dahilinde, m\u00fc\u015fterilerden biri ya 60 ya\u015f ve \u00fczeri olmal\u0131 ya da \u00f6\u011frenci kimli\u011fi g\u00f6stermeli, fakat her iki ko\u015fulu birden sa\u011flamamal\u0131d\u0131r.<\/p>\n
    =\u00d6ZELVEYA(A1>=60, B1=DO\u011eRU)<\/code><\/pre>\n
    Bu durumda, A1 h\u00fccresi m\u00fc\u015fterinin ya\u015f\u0131n\u0131, B1 h\u00fccresi ise \u00f6\u011frenci kimli\u011finin olup olmad\u0131\u011f\u0131n\u0131 (DO\u011eRU\/YANLI\u015e) g\u00f6sterir. Form\u00fcl, indirimin, ya\u015f\u0131 60 veya \u00fczeri olan veya \u00f6\u011frenci kimli\u011fi bulunan fakat her iki durumu birden ta\u015f\u0131mayan m\u00fc\u015fterilere uygulanmas\u0131n\u0131 sa\u011flar.<\/p>\n
    Senaryo 2: \u00c7al\u0131\u015fanlar\u0131n Mesai \u00dczerindeki Kontrolleri<\/strong><\/p>\n
    Bir \u015firkette, \u00e7al\u0131\u015fanlar\u0131n fazla mesai yapmalar\u0131 genelde uygun de\u011fildir. Ancak, \u00f6zel durumlar i\u00e7in ya y\u00f6netici onay\u0131 gerekmekte ya da belirli projelerde \u00e7al\u0131\u015f\u0131yor olmalar\u0131 \u015fartt\u0131r. \u00c7al\u0131\u015fan\u0131n fazla mesaiye kalabilmesi i\u00e7in sadece bir ko\u015fulun sa\u011flanmas\u0131 yeterlidir, ancak her iki ko\u015fulun bir arada olmas\u0131 kabul edilmez.<\/p>\n
    =\u00d6ZELVEYA(C1=DO\u011eRU, D1=DO\u011eRU)<\/code><\/pre>\n
    Burada, C1 h\u00fccresi y\u00f6netici onay\u0131n\u0131 (DO\u011eRU\/YANLI\u015e), D1 h\u00fccresi ise \u00f6zel bir projede \u00e7al\u0131\u015f\u0131l\u0131p \u00e7al\u0131\u015f\u0131lmad\u0131\u011f\u0131n\u0131 (DO\u011eRU\/YANLI\u015e) g\u00f6sterir. Bu form\u00fcl, yaln\u0131zca y\u00f6netici onay\u0131 alan veya \u00f6zel bir projede \u00e7al\u0131\u015fan fakat her iki \u015fart\u0131 da ta\u015f\u0131mayan personelin fazla mesai yapmas\u0131na imkan tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    T\u00fcm ba\u011f\u0131ms\u0131z de\u011fi\u015fkenlerin mant\u0131ksal \u00f6zel durum YADA de\u011ferini verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[580],"tags":[],"class_list":["post-15720","post","type-post","status-publish","format-standard","hentry","category-mantiksal"],"acf":[],"yoast_head":"\nExcel'de XOR (\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de XOR (\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/\" \/>\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:39:16+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 XOR (\u00d6ZELVEYA) 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\/xor\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/xor\/\",\"name\":\"Excel'de XOR (\u00d6ZELVEYA) 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:39:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/xor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/xor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mant\u0131ksal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/mantiksal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u00d6ZELVEYA\"}]},{\"@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 XOR (\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de XOR (\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de XOR (\u00d6ZELVEYA) 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\/xor\/","url":"https:\/\/functiontranslator.com\/tr\/xor\/","name":"Excel'de XOR (\u00d6ZELVEYA) 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:39:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da XOR (\u00d6ZELVEYA) 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\/xor\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/xor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/xor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Mant\u0131ksal","item":"https:\/\/functiontranslator.com\/tr\/mantiksal\/"},{"@type":"ListItem","position":3,"name":"\u00d6ZELVEYA"}]},{"@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\/15720","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=15720"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15720\/revisions"}],"predecessor-version":[{"id":26988,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15720\/revisions\/26988"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}