{"id":15292,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/bitveya\/"},"modified":"2021-02-25T16:23:13","modified_gmt":"2021-02-25T16:23:13","slug":"bitor","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/bitor\/","title":{"rendered":"B\u0130TVEYA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analizlerden veri manip\u00fclasyonuna kadar \u00e7e\u015fitli alanlarda kullan\u0131lan pop\u00fcler elektronik tablo uygulamalar\u0131d\u0131r. Bu platformlarda bulunan pek \u00e7ok kullan\u0131\u015fl\u0131 fonksiyondan biri de “BITOR” (B\u0130TVEYA) fonksiyonudur. BITOR fonksiyonu, iki say\u0131n\u0131n bit d\u00fczeyinde (ikili) OR operasyonunu ger\u00e7ekle\u015ftirir. Bu fonksiyon, bilgisayar bilimi ve a\u011f g\u00fcvenli\u011fi gibi alanlarda veri i\u015fleme s\u00fcrecinde \u00f6nemli bir rol oynar.<\/p>\n

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

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

=BITOR(say\u01311, say\u01312)<\/code><\/pre>\n
    \n
  • say\u01311<\/b>: \u0130lk non-negatif tam say\u0131.<\/li>\n
  • say\u01312<\/b>: \u0130kinci non-negatif tam say\u0131.<\/li>\n<\/ul>\n
    \u00d6rnek:<\/b> E\u011fer A1 h\u00fccresi 23 (ikili 10111) ve B1 h\u00fccresi 17 (ikili 10001) de\u011ferlerini i\u00e7eriyorsa, =BITOR(A1, B1) form\u00fcl\u00fc uyguland\u0131\u011f\u0131nda sonu\u00e7 10111 (ikili) ya da 31 (ondal\u0131k) olarak hesaplan\u0131r; zira her iki say\u0131n\u0131n ikili formattaki kar\u015f\u0131l\u0131klar\u0131 \u00fczerinde bit d\u00fczeyinde OR operasyonu yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    BITOR fonksiyonu, \u00e7e\u015fitli pratik durumlarda kullan\u0131labilir. \u0130ki olas\u0131 kullan\u0131m \u00f6rne\u011fi a\u015fa\u011f\u0131da detayland\u0131r\u0131lm\u0131\u015ft\u0131r:<\/p>\n
    1. A\u011f Maskesi Hesaplamalar\u0131<\/h2>\n
    A\u011f y\u00f6neticileri ve sistem m\u00fchendisleri, a\u011f adreslerini belirlerken ve alt a\u011f (subnet) maskelerini hesaplarken BITOR fonksiyonunu kullanabilirler. \u00d6rne\u011fin, iki farkl\u0131 subnet maskesinin birle\u015ftirilmesi i\u00e7in BITOR fonksiyonu kullan\u0131labilir.<\/p>\n\n\n\n
    Subnet 1<\/th>\nSubnet 2<\/th>\nToplam Subnet<\/th>\n<\/tr>\n
    255.255.255.0 (11111111.11111111.11111111.00000000)<\/td>\n255.255.254.0 (11111111.11111111.11111110.00000000)<\/td>\n=BITOR(A1, A2) -> 255.255.255.0<\/td>\n<\/tr>\n<\/table>\n
    Bu \u00f6rnekte, BITOR iki subnet maskesini birle\u015ftirerek daha b\u00fcy\u00fck bir a\u011f adresi yap\u0131s\u0131n\u0131 temsil eder.<\/p>\n
    2. Dijital Hak Y\u00f6netimi (DRM) Kontrolleri<\/h2>\n
    Yaz\u0131l\u0131m lisans y\u00f6netimi veya dijital i\u00e7erik eri\u015fim kontrollerinde, BITOR fonksiyonu farkl\u0131 yetki seviyelerini tek bir yetki kodunda birle\u015ftirmek i\u00e7in kullan\u0131labilir.<\/p>\n
    =BITOR(2, 4) \/\/ 2 (ikili 10), 4 (ikili 100) => Sonu\u00e7: 6 (ikili 110)<\/code><\/pre>\n
    Bu \u00f6rnekte, 2 ve 4 de\u011ferleri belirli kullan\u0131m haklar\u0131n\u0131 temsil eder ve BITOR fonksiyonu bu haklar\u0131 birle\u015ftirerek geni\u015f bir yetki seti olu\u015fturur.<\/p>\n
    BITOR fonksiyonunun etkin kullan\u0131m\u0131, teknik ve m\u00fchendislik problemlerine y\u00f6nelik \u00e7\u00f6z\u00fcmlerde verimlili\u011fi art\u0131rabilir ve \u00e7ok \u00e7e\u015fitli uygulamalar i\u00e7in esnek \u00e7\u00f6z\u00fcmler sunar. Excel ve Google Sheets’teki bu gibi fonksiyonlar, g\u00fcnl\u00fck i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 optimize etmenize ve verilerle daha etkin bir \u015fekilde \u00e7al\u0131\u015fman\u0131za olanak tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    2 say\u0131n\u0131n bit tabanl\u0131 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":[583],"tags":[],"class_list":["post-15292","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de BITOR (B\u0130TVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de BITOR (B\u0130TVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/\" \/>\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:13+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 BITOR (B\u0130TVEYA) 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\/bitor\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bitor\/\",\"name\":\"Excel'de BITOR (B\u0130TVEYA) 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:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bitor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bitor\/#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\u0130TVEYA\"}]},{\"@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 BITOR (B\u0130TVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BITOR (B\u0130TVEYA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BITOR (B\u0130TVEYA) 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\/bitor\/","url":"https:\/\/functiontranslator.com\/tr\/bitor\/","name":"Excel'de BITOR (B\u0130TVEYA) 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:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BITOR (B\u0130TVEYA) 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\/bitor\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bitor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bitor\/#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\u0130TVEYA"}]},{"@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\/15292","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=15292"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15292\/revisions"}],"predecessor-version":[{"id":26560,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15292\/revisions\/26560"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}