{"id":15294,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/bitozelveya\/"},"modified":"2021-02-25T16:23:17","modified_gmt":"2021-02-25T16:23:17","slug":"bitxor","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/bitxor\/","title":{"rendered":"B\u0130T\u00d6ZELVEYA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te yer alan “BITXOR” (T\u00fcrk\u00e7e’de “B\u0130T\u00d6ZELVEYA”) fonksiyonu, iki say\u0131n\u0131n bit d\u00fczeyinde \u00f6zel veya (XOR) i\u015flemini ger\u00e7ekle\u015ftirir. Bu fonksiyon, finans, m\u00fchendislik, bilgisayar bilimi ve veri analizi gibi bir\u00e7ok alanda kullan\u0131labilir. Genellikle \u015fifreleme, hata kontrol\u00fc ve veri i\u015fleme amac\u0131yla tercih edilir.<\/p>\n

S\u00f6zdizimi ve Kullan\u0131m<\/h2>\n

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

=BITXOR(say\u01311, say\u01312)<\/code><\/pre>\n
    \n
  • say\u01311:<\/strong> \u0130lk say\u0131 (tam say\u0131 olmal\u0131d\u0131r).<\/li>\n
  • say\u01312:<\/strong> \u0130kinci say\u0131 (tam say\u0131 olmal\u0131d\u0131r).<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, say\u0131lar\u0131n\u0131z 5 ve 3 ise:<\/p>\n
    =BITXOR(5, 3)<\/code><\/pre>\n
    Bu \u00f6rnekte, 5 (101 olarak ikili) ve 3’\u00fcn (011 olarak ikili) bit d\u00fczeyinde XOR uygulamas\u0131 sonucu 6 (110 olarak ikili) de\u011ferini verecektir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Basit \u015eifreleme<\/h2>\n
    B\u0130T\u00d6ZELVEYA i\u015flevini kullanarak basit metin \u015fifrelemesi yapabilirsiniz. A\u015fa\u011f\u0131da, her bir karakterin ASCII de\u011feri ile belirli bir anahtar\u0131n XOR i\u015flemini uygulayarak metin \u015fifrelemek amac\u0131yla kullan\u0131labilecek bir \u00f6rne\u011fi g\u00f6rebilirsiniz.<\/p>\n
    Ad\u0131m 1:<\/strong> \u015eifrelenecek metni ve anahtar de\u011ferini belirleyin.<\/p>\n
    Metin: \"Merhaba\" Anahtar: 2<\/code><\/pre>\n
    Ad\u0131m 2:<\/strong> Her bir karakter i\u00e7in ASCII de\u011ferini al\u0131n ve anahtarla XOR i\u015flemi yap\u0131n:<\/p>\n
    =CHAR(BITXOR(CODE(\"M\"), 2)) =CHAR(BITXOR(CODE(\"e\"), 2)) =CHAR(BITXOR(CODE(\"r\"), 2)) ...ve b\u00f6yle devam eder.<\/code><\/pre>\n
    Ad\u0131m 3:<\/strong> \u015eifrelenmi\u015f karakterleri bir araya getirerek son metni olu\u015fturun.<\/p>\n
    \u00d6rnek 2: Hata Tespit Kodlar\u0131<\/h2>\n
    Hata tespit kodlar\u0131, veri iletimi s\u0131ras\u0131nda verilerin do\u011frulu\u011funu kontrol etmek i\u00e7in kullan\u0131l\u0131r. B\u0130T\u00d6ZELVEYA fonksiyonu, bu t\u00fcr kontrol mekanizmalar\u0131 i\u00e7in olduk\u00e7a uygundur.<\/p>\n
    Ad\u0131m 1:<\/strong> \u0130letilecek say\u0131sal veriyi belirleyin.<\/p>\n
    Veri 1: 345 Veri 2: 129 Veri 3: 657<\/code><\/pre>\n
    Ad\u0131m 2:<\/strong> T\u00fcm veri birimlerinin XOR’\u0131n\u0131 al\u0131n:<\/p>\n
    =BITXOR(BITXOR(345, 129), 657)<\/code><\/pre>\n
    Ad\u0131m 3:<\/strong> Bu sonucu hata kontrol mekanizmas\u0131 olarak kullan\u0131n. E\u011fer iletim s\u0131ras\u0131nda bir hata meydana gelirse, al\u0131c\u0131 taraf bu kodu tekrar hesaplayarak olas\u0131 bir hata varl\u0131\u011f\u0131n\u0131 kontrol edebilir.<\/p>\n
    B\u0130T\u00d6ZELVEYA fonksiyonunun kullan\u0131m\u0131, Microsoft Excel ve Google Sheets gibi platformlarda veri i\u015flemenin ve analizin otomatize edilmesini ve kolayla\u015ft\u0131r\u0131lmas\u0131n\u0131 sa\u011flar. \u0130ster basit bir \u015fifreleme, isterse hata tespiti gibi daha karma\u015f\u0131k s\u00fcre\u00e7lerde B\u0130T\u00d6ZELVEYA fonksiyonu de\u011ferli bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki say\u0131n\u0131n bit tabanl\u0131 ‘\u00d6ZELVEYA’ sonucunu verir<\/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-15294","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de BITXOR (B\u0130T\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de BITXOR (B\u0130T\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/\" \/>\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:23:17+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 BITXOR (B\u0130T\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\/bitxor\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bitxor\/\",\"name\":\"Excel'de BITXOR (B\u0130T\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:23:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bitxor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bitxor\/#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\":\"B\u0130T\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 BITXOR (B\u0130T\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BITXOR (B\u0130T\u00d6ZELVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BITXOR (B\u0130T\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\/bitxor\/","url":"https:\/\/functiontranslator.com\/tr\/bitxor\/","name":"Excel'de BITXOR (B\u0130T\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:23:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BITXOR (B\u0130T\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\/bitxor\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bitxor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bitxor\/#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":"B\u0130T\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\/15294","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=15294"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15294\/revisions"}],"predecessor-version":[{"id":26562,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15294\/revisions\/26562"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}