{"id":15284,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/bin2hex\/"},"modified":"2021-02-25T16:23:02","modified_gmt":"2021-02-25T16:23:02","slug":"bin2hex","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/bin2hex\/","title":{"rendered":"BIN2HEX"},"content":{"rendered":"<h2>BIN2HEX \u0130\u015flevi Nedir?<\/h2>\n<p>BIN2HEX i\u015flevi, ikilik tabandan (binary) onalt\u0131l\u0131k tabana (hexadecimal) d\u00f6n\u00fc\u015f\u00fcm yapar. Bu fonksiyon, \u00f6zellikle say\u0131sal sistemler aras\u0131nda veri d\u00f6n\u00fc\u015f\u00fcm\u00fc gerektiren durumlarda olduk\u00e7a faydal\u0131d\u0131r. Microsoft Excel ve Google E-Tablolar&#8217;da benzer \u015fekilde kullan\u0131l\u0131r ancak s\u00f6zdiziminde k\u00fc\u00e7\u00fck farkl\u0131l\u0131klar olabilir.<\/p>\n<h2>S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n<p>BIN2HEX i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n<pre><code>BIN2HEX(say\u0131, [basamak_say\u0131s\u0131])<\/code><\/pre>\n<p>Burada <code>say\u0131<\/code> ikilik sistemdeki say\u0131d\u0131r ve zorunlu bir arg\u00fcmand\u0131r. Opsiyonel olarak, <code>basamak_say\u0131s\u0131<\/code> arg\u00fcman\u0131 ile d\u00f6n\u00fc\u015ft\u00fcr\u00fclen onalt\u0131l\u0131k say\u0131n\u0131n ka\u00e7 karakter olaca\u011f\u0131n\u0131 belirleyebilirsiniz.<\/p>\n<p><strong>\u00d6rnek Kullan\u0131m 1:<\/strong> 1011010 ikilik say\u0131s\u0131n\u0131n onalt\u0131l\u0131k sisteme d\u00f6n\u00fc\u015f\u00fcm\u00fc<\/p>\n<pre><code>=BIN2HEX(\"1011010\")<\/code><\/pre>\n<p>Bu form\u00fcl sonucunda elde edilen de\u011fer <code>5A<\/code> olacakt\u0131r.<\/p>\n<p><strong>\u00d6rnek Kullan\u0131m 2:<\/strong> 1110000111 ikilik say\u0131s\u0131n\u0131n 5 karakterlik onalt\u0131l\u0131k say\u0131ya d\u00f6n\u00fc\u015f\u00fcm\u00fc<\/p>\n<pre><code>=BIN2HEX(\"1110000111\", 5)<\/code><\/pre>\n<p>Bu \u00f6rnekte, sonu\u00e7 <code>00387<\/code> olarak \u00e7\u0131kar, burada sonu\u00e7 5 karakter uzunlu\u011funda onalt\u0131l\u0131k say\u0131 i\u00e7erir.<\/p>\n<h2>Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n<p>Diyelim ki, bir a\u011f teknolojisi problemi \u00fczerinde \u00e7al\u0131\u015f\u0131yorsunuz ve IP adreslerini ikilik sistemden onalt\u0131l\u0131k sisteme d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekiyor. Bu t\u00fcr bir d\u00f6n\u00fc\u015f\u00fcm i\u00e7in BIN2HEX i\u015flevi idealdir.<\/p>\n<h3>Pratik G\u00f6rev 1: A\u011f Adreslerinin D\u00f6n\u00fc\u015f\u00fcm\u00fc<\/h3>\n<p><strong>G\u00f6rev:<\/strong> \u0130kilik IP adresi &#8220;11000000101010000000000100000001&#8221; &#8216;nin onalt\u0131l\u0131k sisteme d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi gerekmektedir.<\/p>\n<p><strong>\u00c7\u00f6z\u00fcm:<\/strong><\/p>\n<pre><code>=BIN2HEX(\"11000000101010000000000100000001\")<\/code><\/pre>\n<p>Bu form\u00fcl sonucunda, &#8220;C0A80001&#8221; de\u011feri elde edilir, bu da IPv4 adresinin onalt\u0131l\u0131 bi\u00e7imidir.<\/p>\n<h3>Pratik G\u00f6rev 2: Veri Do\u011frulama<\/h3>\n<p><strong>G\u00f6rev:<\/strong> Bir g\u00fcvenlik sisteminden gelen ikilik \u015fifrelenmi\u015f verinin onalt\u0131l\u0131k sisteme d\u00f6n\u00fc\u015ft\u00fcr\u00fclerek do\u011frulanmas\u0131 gerekiyor.<\/p>\n<p><strong>\u00c7\u00f6z\u00fcm:<\/strong><\/p>\n<pre><code>=BIN2HEX(\"100110111001101\", 4)<\/code><\/pre>\n<p>Bu form\u00fcl\u00fcn \u00e7\u0131kt\u0131s\u0131 &#8220;26E7&#8221; olacak. Veri, bu onalt\u0131l\u0131k formatta daha kolay bir \u015fekilde kar\u015f\u0131 sistemle k\u0131yaslanabilir hale geliyor.<\/p>\n<h2>Yorum ve \u00d6neriler<\/h2>\n<p>BIN2HEX i\u015flevi, bilgisayar bilimleri ve a\u011f teknolojileri gibi teknik alanlarda \u00e7al\u0131\u015fanlar i\u00e7in olduk\u00e7a yararl\u0131d\u0131r. Bu i\u015flev sayesinde farkl\u0131 say\u0131 sistemleri aras\u0131nda kolayca d\u00f6n\u00fc\u015f\u00fcm yap\u0131labilmektedir. Kullan\u0131c\u0131lar, d\u00f6n\u00fc\u015f\u00fcm i\u015flemlerini daha esnek yapabilmek i\u00e7in <code>basamak_say\u0131s\u0131<\/code> arg\u00fcman\u0131n\u0131 ak\u0131ll\u0131ca kullanabilirler. E\u011fer sonucun belirli bir uzunlukta olmas\u0131n\u0131 istiyorsan\u0131z, bu opsiyonel parametreyi mutlaka de\u011ferlendirin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130kili bir say\u0131y\u0131 onalt\u0131l\u0131k 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-15284","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de BIN2HEX Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da BIN2HEX 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\/bin2hex\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de BIN2HEX Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da BIN2HEX 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\/bin2hex\/\" \/>\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:23:02+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de BIN2HEX 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\/bin2hex\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bin2hex\/\",\"name\":\"Excel'de BIN2HEX 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:23:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BIN2HEX 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\/bin2hex\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bin2hex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bin2hex\/#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\":\"BIN2HEX\"}]},{\"@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 BIN2HEX Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BIN2HEX 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\/bin2hex\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BIN2HEX Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BIN2HEX 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\/bin2hex\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BIN2HEX 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\/bin2hex\/","url":"https:\/\/functiontranslator.com\/tr\/bin2hex\/","name":"Excel'de BIN2HEX 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:23:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BIN2HEX 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\/bin2hex\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bin2hex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bin2hex\/#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":"BIN2HEX"}]},{"@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\/15284","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=15284"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15284\/revisions"}],"predecessor-version":[{"id":26552,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15284\/revisions\/26552"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}