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

Microsoft Excel ve Google Sheets’te bulunan DEC2BIN fonksiyonu, ondal\u0131k say\u0131lar\u0131 ikilik say\u0131 sistemine \u00e7evirmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle bilgisayar bilimi ve elektronik gibi alanlarda \u00e7al\u0131\u015fanlar i\u00e7in ikilik say\u0131 sistemini daha etkili bir \u015fekilde anlamalar\u0131na yard\u0131mc\u0131 olur.<\/p>\n

Ondal\u0131ktan \u0130kilik Say\u0131 Sistemine D\u00f6n\u00fc\u015f\u00fcm Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

Fonksiyonun yap\u0131s\u0131n\u0131 ve i\u015fleyi\u015fini anlamak i\u00e7in kullan\u0131m\u0131na dair bilgiler \u015fu \u015fekildedir:<\/p>\n

 DEC2BIN(say\u0131, [basamak_say\u0131s\u0131])<\/code> <\/pre>\n
    \n
  • say\u0131:<\/strong> \u0130kilik sistemde g\u00f6sterilmesi istenen ondal\u0131k say\u0131d\u0131r.<\/li>\n
  • basamak_say\u0131s\u0131:<\/strong> (iste\u011fe ba\u011fl\u0131) \u0130kilik say\u0131n\u0131n ka\u00e7 basamakl\u0131 olaca\u011f\u0131n\u0131 belirler. Bu arg\u00fcman belirtilmezse, Excel ve Google Sheets sonucu en k\u0131sa formatta verecektir.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, ondal\u0131k 30 say\u0131s\u0131n\u0131n ikilik sisteme d\u00f6n\u00fc\u015f\u00fcm\u00fcn\u00fc inceleyelim:<\/p>\n
     =DEC2BIN(30) \/\/ Bu form\u00fcl '11110' sonucunu \u00fcretir.<\/code> <\/pre>\n
    Pratik Uygulama Senaryolar\u0131<\/h2>\n
    Elektronik Devre Tasar\u0131m\u0131nda Kullan\u0131m<\/h2>\n
    Bir m\u00fchendis, elektronik bir devre tasarlarken ve mikrokontrol\u00f6r programlarken \u00e7e\u015fitli giri\u015f kombinasyonlar\u0131n\u0131 test etmek amac\u0131yla ikilik say\u0131lar\u0131 kullanabilir:<\/p>\n
     DEC2BIN(127) \/\/ Sonu\u00e7 '1111111' olur. DEC2BIN(128) \/\/ Sonu\u00e7 '10000000' olur.<\/code> <\/pre>\n
    Bu \u00f6rnekler, mikrokontrol\u00f6rdeki pin yap\u0131land\u0131rmalar\u0131n\u0131 do\u011fru bir \u015fekilde ayarlamak i\u00e7in ikilik say\u0131lar kullanmaktad\u0131r.<\/p>\n
    E\u011fitim Ama\u00e7l\u0131 Kullan\u0131m<\/h2>\n
    Bir \u00f6\u011fretmen, \u00f6\u011frencilerine say\u0131 sistemlerini \u00f6\u011fretirken DEC2BIN fonksiyonundan yararlanabilir. \u00d6\u011frencilere ondal\u0131k say\u0131lar\u0131n ikilik sistemdeki kar\u015f\u0131l\u0131klar\u0131n\u0131 hesaplatmak i\u00e7in bu fonksiyon tavsiye edilir:<\/p>\n
     =DEC2BIN(45) \/\/ Sonu\u00e7 '101101' olacak. =DEC2BIN(31, 8) \/\/ Sonu\u00e7 '00011111' olacak. (8 basamak olarak ayarland\u0131)<\/code> <\/pre>\n
    Bu kullan\u0131m \u00f6rnekleri, say\u0131 sistemlerinin temellerini kavramay\u0131 ve pratik uygulamalarla \u00f6\u011frenmeyi kolayla\u015ft\u0131r\u0131r.<\/p>\n
    \u00d6zetlemek gerekirse, DEC2BIN fonksiyonu, Excel ve Google Sheets kullan\u0131c\u0131lar\u0131 i\u00e7in ondal\u0131k say\u0131lar\u0131 ikilik sistemde analiz etmeyi ve kullanmay\u0131 basitle\u015ftirir, elektronik, bilgisayar bilimleri ve e\u011fitim gibi \u00e7e\u015fitli alanlarda de\u011ferli bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Ondal\u0131k bir 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-15366","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de DEC2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DEC2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/\" \/>\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:25:36+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 DEC2BIN 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\/dec2bin\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dec2bin\/\",\"name\":\"Excel'de DEC2BIN 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:25:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dec2bin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dec2bin\/#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\":\"DEC2BIN\"}]},{\"@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 DEC2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DEC2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DEC2BIN 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\/dec2bin\/","url":"https:\/\/functiontranslator.com\/tr\/dec2bin\/","name":"Excel'de DEC2BIN 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:25:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DEC2BIN 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\/dec2bin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dec2bin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dec2bin\/#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":"DEC2BIN"}]},{"@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\/15366","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=15366"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15366\/revisions"}],"predecessor-version":[{"id":26634,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15366\/revisions\/26634"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}