{"id":15283,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/bin2dec\/"},"modified":"2021-02-25T16:23:00","modified_gmt":"2021-02-25T16:23:00","slug":"bin2dec","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/bin2dec\/","title":{"rendered":"BIN2DEC"},"content":{"rendered":"<h1>\u0130kili Say\u0131lar\u0131 Ondal\u0131k Say\u0131lara \u00c7evirme Rehberi<\/h1>\n<p>Excel ve Google E-Tablolar, veri i\u015fleme ve analizi konusunda olduk\u00e7a yetenekli ara\u00e7lard\u0131r. Bu rehberde, ikili say\u0131 sisteminden ondal\u0131k say\u0131 sistemine d\u00f6n\u00fc\u015f\u00fcm yapmay\u0131 sa\u011flayan \u201cBIN2DEC\u201d i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz. S\u00f6z konusu i\u015flev, hem Microsoft Excel hem de Google E-Tablolar&#8217;da bulunmaktad\u0131r ve kullan\u0131m\u0131 \u00e7o\u011fu kullan\u0131c\u0131 i\u00e7in hayati \u00f6nem ta\u015f\u0131yabilir.<\/p>\n<h2>\u0130\u015flevin Kullan\u0131m\u0131<\/h2>\n<p><code>BIN2DEC<\/code> i\u015flevi, bir ikili say\u0131y\u0131 ondal\u0131k say\u0131ya \u00e7evirir. \u0130kili say\u0131 sistemi, yaln\u0131zca 0 ve 1 olmak \u00fczere iki rakam kullan\u0131r. \u0130\u015flevin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n<pre><code>BIN2DEC(bi\u00e7imli_ikili_say\u0131)<\/code><\/pre>\n<p>Burada <code>bi\u00e7imli_ikili_say\u0131<\/code> arg\u00fcman\u0131, \u00e7evrilmek \u00fczere girilen ikili say\u0131d\u0131r.<\/p>\n<h2>\u00d6rnek Kullan\u0131mlar<\/h2>\n<p>Basit bir \u00f6rnekle i\u015flevin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6rebiliriz:<\/p>\n<pre><code>=BIN2DEC(\"1010\")<\/code><\/pre>\n<p>Bu form\u00fcl, ikili say\u0131 olan &#8220;1010&#8221;u ondal\u0131k say\u0131 sisteminde 10 de\u011ferine \u00e7evirir. \u0130kili sistemde sa\u011fdan sola do\u011fru her basama\u011f\u0131n, 2&#8217;nin kuvvetleriyle \u00e7arp\u0131lmas\u0131 ve sonu\u00e7lar\u0131n toplanmas\u0131yla d\u00f6n\u00fc\u015f\u00fcm sa\u011flan\u0131r.<\/p>\n<h2>Pratik Uygulamalar<\/h2>\n<ul>\n<li><strong>Raporda \u00c7e\u015fitlendirme:<\/strong> Bir teknoloji \u015firketinde \u00e7al\u0131\u015fan bir veri analisti, sunucular \u00fczerindeki veri trafiklerini ikili sistemde kaydetmektedir. Sunum s\u0131ras\u0131nda bu verilerin ondal\u0131k sistemde g\u00f6sterilmesi gerekmektedir. Bu durumda, <code>BIN2DEC<\/code> i\u015flevi kullan\u0131labilir.<\/li>\n<li><strong>Bilgisayar Bilimi E\u011fitimi:<\/strong> Bilgisayar bilimi \u00f6\u011frencilerine ikili say\u0131lar\u0131n ondal\u0131k sisteme \u00e7evrimi i\u015flemi anlat\u0131l\u0131rken, ger\u00e7ek zamanl\u0131 \u00f6rneklerle bu d\u00f6n\u00fc\u015f\u00fcm\u00fcn nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6stermek i\u00e7in <code>BIN2DEC<\/code> i\u015flevi faydal\u0131 bir ara\u00e7 olabilir.<\/li>\n<\/ul>\n<h2>Detayl\u0131 \u00c7\u00f6z\u00fcm ve Yorumlar<\/h2>\n<p>\u00d6rne\u011fin, bir sunucu log dosyas\u0131nda &#8220;101110&#8221; ikili kodu tespit edilmi\u015ftir ve bu verinin ondal\u0131k kar\u015f\u0131l\u0131\u011f\u0131n\u0131n hesaplanmas\u0131 gerekmektedir. Form\u00fcl a\u015fa\u011f\u0131daki gibi olacakt\u0131r:<\/p>\n<pre><code>=BIN2DEC(\"101110\")<\/code><\/pre>\n<p>Yukar\u0131daki i\u015flem, ikili say\u0131y\u0131 46 ondal\u0131k say\u0131s\u0131na d\u00f6n\u00fc\u015ft\u00fcrecektir. Bu \u015fekilde, raporda veriler daha anla\u015f\u0131l\u0131r bir formatta sunulmu\u015f olur.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130kili bir say\u0131y\u0131 ondal\u0131k say\u0131ya 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-15283","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 BIN2DEC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da BIN2DEC 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\/bin2dec\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de BIN2DEC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da BIN2DEC 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\/bin2dec\/\" \/>\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:00+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 BIN2DEC 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\/bin2dec\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/bin2dec\/\",\"name\":\"Excel'de BIN2DEC 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:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BIN2DEC 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\/bin2dec\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/bin2dec\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/bin2dec\/#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\":\"BIN2DEC\"}]},{\"@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 BIN2DEC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BIN2DEC 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\/bin2dec\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BIN2DEC Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BIN2DEC 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\/bin2dec\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:23:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BIN2DEC 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\/bin2dec\/","url":"https:\/\/functiontranslator.com\/tr\/bin2dec\/","name":"Excel'de BIN2DEC 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:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BIN2DEC 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\/bin2dec\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/bin2dec\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/bin2dec\/#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":"BIN2DEC"}]},{"@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\/15283","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=15283"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15283\/revisions"}],"predecessor-version":[{"id":26551,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15283\/revisions\/26551"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}