{"id":15448,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/hex2oct\/"},"modified":"2021-02-25T16:28:11","modified_gmt":"2021-02-25T16:28:11","slug":"hex2oct","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hex2oct\/","title":{"rendered":"HEX2OCT"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri i\u015fleme konusunda kullan\u0131c\u0131lara b\u00fcy\u00fck kolayl\u0131klar sa\u011flayan iki \u00f6nemli elektronik tablo uygulamas\u0131d\u0131r. Her iki platform da \u00e7ok \u00e7e\u015fitli fonksiyonlar sunar; \u00f6rne\u011fin, say\u0131sal de\u011ferleri onalt\u0131l\u0131k formattan sekizlik formata d\u00f6n\u00fc\u015ft\u00fcrme yetene\u011fi, bilgi i\u015flem ve veri analizi s\u00fcre\u00e7lerinde kritik bir \u00f6neme sahiptir. Bu makalede, Excel ve Google Sheets’de kullan\u0131lan HEX2OCT fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 a\u00e7\u0131klayacak ve bu fonksiyonun kullan\u0131m\u0131na dair \u00f6rnekler sunaca\u011f\u0131z.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n

HEX2OCT fonksiyonunun temel yap\u0131s\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

HEX2OCT(say\u0131, [basamak_say\u0131s\u0131]) <\/code><\/pre>\n
Bu fonksiyonda kullan\u0131lan parametreler \u015funlard\u0131r:<\/p>\n
    \n
  • say\u0131:<\/strong> Onalt\u0131l\u0131k sistemde bir say\u0131y\u0131 temsil eden bir metin. Say\u0131 “0x” veya “0X” ile ba\u015fl\u0131yorsa, bu \u00f6nek g\u00f6z ard\u0131 edilir.<\/li>\n
  • basamak_say\u0131s\u0131 (iste\u011fe ba\u011fl\u0131):<\/strong> D\u00f6n\u00fc\u015f\u00fcm sonucunda elde edilen sekizlik say\u0131n\u0131n istenilen basamak say\u0131s\u0131n\u0131 belirtir. Bu parametre belirtilmezse, sonu\u00e7 en k\u0131sa gerekli basamak say\u0131s\u0131yla d\u00f6ner.<\/li>\n<\/ul>\n
    Say\u0131 D\u00f6n\u00fc\u015f\u00fcm \u00d6rnekleri<\/h2>\n
    HEX2OCT(\"1A\") -> Sonu\u00e7: 32 HEX2OCT(\"1A\", 5) -> Sonu\u00e7: 00032 HEX2OCT(\"FF\", 2) -> Sonu\u00e7: 377 HEX2OCT(\"1FFFFFFFF\", 10) -> Sonu\u00e7: 7777777777 <\/code><\/pre>\n
    Bu \u00f6rnekler, HEX2OCT fonksiyonunun farkl\u0131 parametrelerle nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: Dosya \u0130zinlerinin G\u00f6sterimi<\/h2>\n
    Unix ve Linux i\u015fletim sistemlerinde dosya izinleri sekizlik say\u0131 sistemi ile ifade edilir. Bu senaryoda, bir sistem y\u00f6neticisi onalt\u0131l\u0131k sistemde saklanan izin kodlar\u0131n\u0131 sekizlik sisteme \u00e7evirmek isteyebilir:<\/p>\n
    HEX2OCT(\"1F4\") -> Sonu\u00e7: 764 <\/code><\/pre>\n
    Bu sonu\u00e7, dosya izinlerinin “764” olarak ayarland\u0131\u011f\u0131n\u0131 g\u00f6stermektedir. Burada, ilk rakam sahibinin izinlerini, ikinci rakam grup izinlerini, \u00fc\u00e7\u00fcnc\u00fc rakam ise di\u011fer kullan\u0131c\u0131lar\u0131n izinlerini temsil eder.<\/p>\n
    Senaryo 2: A\u011f Adres D\u00f6n\u00fc\u015f\u00fcmleri<\/h2>\n
    A\u011f ayarlar\u0131nda MAC adreslerinin tipik olarak onalt\u0131l\u0131k formatta g\u00f6sterildi\u011fi durumlar bulunur. Bu adresler, belirli yaz\u0131l\u0131mlar\u0131n veya ara\u00e7lar\u0131n ihtiya\u00e7lar\u0131na g\u00f6re sekizlik sisteme \u00e7evrilmelidir:<\/p>\n
    HEX2OCT(\"ABCDEF\") -> Sonu\u00e7: 52746757 <\/code><\/pre>\n
    Bu \u00f6rnek, MAC adresinin sekizlik formata do\u011fru \u015fekilde \u00e7evrildi\u011fini ve i\u015fleme veya analiz i\u00e7in kullan\u0131ma haz\u0131r oldu\u011funu g\u00f6sterir.<\/p>\n
    Bu d\u00f6n\u00fc\u015f\u00fcm fonksiyonu, teknik veri i\u015fleme, yaz\u0131l\u0131m geli\u015ftirme, sistem bak\u0131m\u0131 ve daha pek \u00e7ok alanda kullan\u0131labilir. Bilgi y\u00f6netimi s\u00fcre\u00e7lerini otomatikle\u015ftirmek ve hatalar\u0131 azaltmak i\u00e7in Excel ve Google Sheets\u2019deki bu t\u00fcr fonksiyonlar\u0131 kullanman\u0131z \u00f6nerilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Onalt\u0131l\u0131 bir say\u0131y\u0131 sekizlik tabana 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-15448","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de HEX2OCT Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de HEX2OCT Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/\" \/>\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:28: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 HEX2OCT 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\/hex2oct\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hex2oct\/\",\"name\":\"Excel'de HEX2OCT 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:28:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hex2oct\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hex2oct\/#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\":\"HEX2OCT\"}]},{\"@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 HEX2OCT Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HEX2OCT Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:28:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HEX2OCT 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\/hex2oct\/","url":"https:\/\/functiontranslator.com\/tr\/hex2oct\/","name":"Excel'de HEX2OCT 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:28:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HEX2OCT 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\/hex2oct\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hex2oct\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hex2oct\/#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":"HEX2OCT"}]},{"@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\/15448","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=15448"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15448\/revisions"}],"predecessor-version":[{"id":26716,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15448\/revisions\/26716"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}