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

Excel ve Google E-Tablolar’da Bitwise AND \u0130\u015flemleri<\/h1>\n

Microsoft Excel ve Google E-Tablolar, veri analizi ve hesaplama konular\u0131nda en \u00e7ok kullan\u0131lan programlardan ikisidir. Her iki platform da bir\u00e7ok matematiksel ve mant\u0131ksal i\u015flevi destekler. Bu yaz\u0131da, \u00f6zellikle ‘BITAND’ yani Bitwise AND i\u015flevinin hem Excel hem de Google Sheets \u00fczerinde nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, i\u015flevin s\u00f6zdizimi ve uygulanabilece\u011fi pratik senaryolar \u00fczerinden a\u00e7\u0131klayaca\u011f\u0131z.<\/p>\n

BITAND \u0130\u015flevi Nedir?<\/h2>\n

‘BITAND’ veya T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile ‘B\u0130TVE’, iki say\u0131n\u0131n bit d\u00fczeyinde (binary) AND i\u015flemini ger\u00e7ekle\u015ftiren bir i\u015flevdir. Yani iki say\u0131y\u0131 al\u0131r, onlar\u0131n ikili (binary) formunu kar\u015f\u0131la\u015ft\u0131r\u0131r ve yaln\u0131zca her iki say\u0131n\u0131n ilgili bitleri 1 ise sonu\u00e7ta o bit 1 olacak \u015fekilde bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/p>\n

S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

Bu i\u015flevin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 BITAND(number1, number2) <\/code><\/pre>\n
\u00d6rne\u011fin, BITAND(12, 25)<\/code> i\u015flemi ondal\u0131k sistemde \u015f\u00f6yle i\u015flenir:<\/p>\n
    \n
  • 12’nin ikili g\u00f6sterimi: 1100<\/li>\n
  • 25’in ikili g\u00f6sterimi: 11001<\/li>\n<\/ul>\n
    Ortak olan bit konumlar\u0131 (sa\u011fdan itibaren) ‘1100’ ve ‘11001’ oldu\u011funda, 1100 (bu bitlerde her iki say\u0131da da ‘1’ olan yerlerde AND i\u015flemi sonucunda ‘1’ \u00e7\u0131kar) olur. Bu durumda, ondal\u0131k olarak sonu\u00e7 8’dir.<\/p>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmler<\/h2>\n
    IP Adres Filtrasyonu<\/h3>\n
    IP adreslerinin a\u011f maskesi ile filtrelenmesi s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan bir durumdur. \u00d6rne\u011fin, bir cihaz\u0131n belirli bir a\u011fa ait olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in ‘BITAND’ i\u015flevi kullan\u0131labilir. Diyelim ki IP adresimiz ‘192.168.1.1’ ve a\u011f maskemiz ‘255.255.255.0’, bu durumda:<\/p>\n
     BITAND(192.168.1.1, 255.255.255.0) <\/code><\/pre>\n
    Bu i\u015flem, IP adresinin a\u011f adresini d\u00f6nd\u00fcr\u00fcr, ki bu \u00f6rnekte 192.168.1.0 olur.<\/p>\n
    Veri G\u00fcvenli\u011fi<\/h3>\n
    Verileri belirli bir maske ile saklamak veya s\u0131n\u0131rland\u0131rmak i\u00e7in de BITAND kullan\u0131labilir. \u00d6rne\u011fin, bir kullan\u0131c\u0131n\u0131n girilen son d\u00f6rt hanesini, ba\u015fka bir veriyle g\u00fcvenli bir \u015fekilde saklamak istiyorsan\u0131z:<\/p>\n
     BITAND(Kullan\u0131c\u0131Girdisi, 15) \/\/ Son iki biti saklamak i\u00e7in <\/code><\/pre>\n
    Bu kullan\u0131m, kullan\u0131c\u0131n\u0131n girdi\u011finin son iki hexadecimal basama\u011f\u0131n\u0131 koruyarak, di\u011fer bitleri s\u0131f\u0131ra ayarlar.<\/p>\n
    Yorumlar<\/h2>\n
    ‘BITAND’ i\u015flevi, hem Excel hem de Google Sheets’te veri manip\u00fclasyonu i\u00e7in \u00e7ok y\u00f6nl\u00fc bir ara\u00e7t\u0131r. \u00d6zellikle sistem y\u00f6netimi, a\u011f g\u00fcvenli\u011fi ve veri \u015fifreleme gibi i\u015flerde olduk\u00e7a faydal\u0131d\u0131r. Ancak, i\u015flevin do\u011fru sonu\u00e7lar vermesi i\u00e7in verilerin do\u011fru formatta oldu\u011fundan emin olunmas\u0131 gerekir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ki say\u0131n\u0131n bit tabanl\u0131 ‘Ve’ 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-15290","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de BITAND (B\u0130TVE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de BITAND (B\u0130TVE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/\" \/>\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:11+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 BITAND (B\u0130TVE) 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\/bitand\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bitand\/\",\"name\":\"Excel'de BITAND (B\u0130TVE) 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:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bitand\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bitand\/#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\u0130TVE\"}]},{\"@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 BITAND (B\u0130TVE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BITAND (B\u0130TVE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BITAND (B\u0130TVE) 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\/bitand\/","url":"https:\/\/functiontranslator.com\/tr\/bitand\/","name":"Excel'de BITAND (B\u0130TVE) 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:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BITAND (B\u0130TVE) 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\/bitand\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bitand\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bitand\/#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\u0130TVE"}]},{"@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\/15290","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=15290"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15290\/revisions"}],"predecessor-version":[{"id":26558,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15290\/revisions\/26558"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}