{"id":15567,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/oct2bin\/"},"modified":"2021-02-25T16:33:08","modified_gmt":"2021-02-25T16:33:08","slug":"oct2bin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/oct2bin\/","title":{"rendered":"OCT2BIN"},"content":{"rendered":"

Onluk Say\u0131 Sisteminden \u0130kilik Say\u0131 Sistemine D\u00f6n\u00fc\u015f\u00fcm<\/h2>\n

OCT2BIN i\u015flevi, sekizlik (oktal) say\u0131 sisteminden ikilik (binary) say\u0131 sistemine d\u00f6n\u00fc\u015f\u00fcm yapmak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, \u00f6zellikle bilgisayar a\u011flar\u0131 ve programlama gibi alanlarda sekizlik verilerle \u00e7al\u0131\u015fan profesyoneller taraf\u0131ndan s\u0131k\u00e7a tercih edilir. \u0130\u015flevin temel amac\u0131, sekizlik say\u0131 sisteminden al\u0131nan say\u0131lar\u0131, ikilik say\u0131 sistemine \u00e7evirmektir. Kullan\u0131m\u0131 olduk\u00e7a basittir ancak do\u011fru sonu\u00e7lar elde edebilmek i\u00e7in i\u015flevin s\u00f6zdizimini ve kullan\u0131m kurallar\u0131n\u0131 iyi anlamak gerekmektedir.<\/p>\n

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

MS Excel ve Google E-Tablolar’da OCT2BIN i\u015flevinin s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

OCT2BIN(say\u0131, [basamak_say\u0131s\u0131])<\/code><\/pre>\n
    \n
  • say\u0131<\/code>: Sekizlik tabanda d\u00f6n\u00fc\u015f\u00fcm\u00fc yap\u0131lacak olan say\u0131d\u0131r. Bu arg\u00fcman zorunludur.<\/li>\n
  • basamak_say\u0131s\u0131<\/code>: \u0130kili say\u0131 sisteminde g\u00f6sterilecek basamak say\u0131s\u0131. Bu arg\u00fcman opsiyoneldir.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, sekizlik say\u0131 ’17’ nin ikilik sistemde kar\u015f\u0131l\u0131\u011f\u0131n\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/p>\n
    =OCT2BIN(\"17\")<\/code><\/pre>\n
    Bu i\u015flem sonucunda elde edilen de\u011fer ‘1111’ olacakt\u0131r. \u00c7\u00fcnk\u00fc oktal (sekizlik) sistemin ’17’ de\u011feri, ikilik sistemde ‘1111’ e e\u015fittir.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    1. Bilgisayar M\u00fchendisli\u011fi ve Programlama<\/h2>\n
    Bilgisayar m\u00fchendisleri ve programc\u0131lar, \u00f6zellikle donan\u0131m d\u00fczeyinde programlama yaparken farkl\u0131 say\u0131 sistemleri aras\u0131nda d\u00f6n\u00fc\u015f\u00fcm yapmalar\u0131 gerekebilmektedir. OCT2BIN i\u015flevi, mikroi\u015flemci veya benzeri donan\u0131mla ili\u015fkili olacak \u015fekilde oktal verileri ikili kodlara \u00e7evirmek i\u00e7in kullan\u0131labilir. \u00d6rne\u011fin, bir bellek adresi oktal olarak ‘245’ ise ve bir mikroi\u015flemci \u00fczerinde i\u015flem yap\u0131lacaksa, bu adresin ikilik kar\u015f\u0131l\u0131\u011f\u0131 olan ‘10100101’ \u00e7evirisi i\u00e7in OCT2BIN kullan\u0131labilir:<\/p>\n
    =OCT2BIN(\"245\")<\/code><\/pre>\n
    Yukar\u0131daki i\u015flem sonucu elde edilen ‘10100101’ ikil say\u0131, bellek adresinin mikroi\u015flemci taraf\u0131ndan do\u011fru \u015fekilde i\u015flenmesini sa\u011flar.<\/p>\n
    2. Veri Analizi ve Raporlama<\/h2>\n
    Veri analistleri, \u00f6zellikle b\u00fcy\u00fck \u00f6l\u00e7ekli veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken, farkl\u0131 say\u0131 sistemlerinde sa\u011flanan verileri analiz etmek zorunda kalabilirler. OCT2BIN i\u015flevi, oktal olarak verilen bir veri serisinin ikilik sistemde analizini ve i\u015flenmesini kolayla\u015ft\u0131r\u0131r. \u00d6rne\u011fin, bir a\u011f cihaz\u0131ndan al\u0131nan veri trafi\u011fi bilgileri oktal formatta ise ve bunun ikilik sistemde i\u015flenmesi gerekiyorsa, bu i\u015flev devreye girer:<\/p>\n
    =OCT2BIN(\"1234567\")<\/code><\/pre>\n
    Bu kullan\u0131m, numerik oktal verinin ikilik sistemdeki kar\u015f\u0131l\u0131\u011f\u0131n\u0131 vererek veri setinin daha anla\u015f\u0131l\u0131r ve i\u015flenebilir hale gelmesini sa\u011flar.<\/p>\n
    Sonu\u00e7 olarak, OCT2BIN i\u015flevi, sekizlikten ikilike d\u00f6n\u00fc\u015f\u00fcm yaparak bilgi i\u015flem ve veri y\u00f6netimi konular\u0131nda olduk\u00e7a etkili bir ara\u00e7t\u0131r. MS Excel ve Google E-Tablolar’da kolayl\u0131kla kullan\u0131labilir bu i\u015flev, farkl\u0131 say\u0131 sistemlerinde rahatl\u0131kla hareket edebilmenizi sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sekizli say\u0131y\u0131 ikiliye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/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-15567","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:33:08+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 OCT2BIN 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\/oct2bin\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/oct2bin\/\",\"name\":\"Excel'de OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:33:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/oct2bin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/oct2bin\/#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\":\"OCT2BIN\"}]},{\"@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 OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de OCT2BIN 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\/oct2bin\/","url":"https:\/\/functiontranslator.com\/tr\/oct2bin\/","name":"Excel'de OCT2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:33:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da OCT2BIN 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\/oct2bin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/oct2bin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/oct2bin\/#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":"OCT2BIN"}]},{"@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\/15567","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=15567"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15567\/revisions"}],"predecessor-version":[{"id":26835,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15567\/revisions\/26835"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}