{"id":5445,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/bin2dec-funkce\/"},"modified":"2021-02-26T09:50:29","modified_gmt":"2021-02-26T09:50:29","slug":"bin2dec","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/bin2dec\/","title":{"rendered":"BIN2DEC"},"content":{"rendered":"

\u00davod do p\u0159evodu bin\u00e1rn\u00edch \u010d\u00edsel<\/h2>\n

Funkce BIN2DEC umo\u017e\u0148uje p\u0159ev\u00e1d\u011bt bin\u00e1rn\u00ed \u010d\u00edsla na \u010d\u00edsla des\u00edtkov\u00e1. V tomto textu se pod\u00edv\u00e1me na jej\u00ed pou\u017eit\u00ed v aplikac\u00edch Microsoft Excel a Google Sheets, v\u010detn\u011b praktick\u00fdch p\u0159\u00edklad\u016f a aplikac\u00ed t\u00e9to funkce.<\/p>\n

Syntaxe a p\u0159\u00edklady<\/h2>\n

Funkce BIN2DEC p\u0159ij\u00edm\u00e1 jeden argument, kter\u00fdm je bin\u00e1rn\u00ed \u010d\u00edslo ve form\u011b textov\u00e9ho \u0159et\u011bzce. Toto bin\u00e1rn\u00ed \u010d\u00edslo m\u016f\u017ee b\u00fdt dlouh\u00e9 a\u017e 10 bit\u016f, p\u0159i\u010dem\u017e prvn\u00ed bit (nejv\u00edce vlevo) ur\u010duje znam\u00e9nko (0 zna\u010d\u00ed kladn\u00e9 \u010d\u00edslo, 1 z\u00e1porn\u00e9).<\/p>\n

 Syntaxe funkce je n\u00e1sleduj\u00edc\u00ed:  =BIN2DEC(bin\u00e1rn\u00ed_\u010d\u00edslo) <\/code> <\/pre>\n
P\u0159\u00edklad pou\u017eit\u00ed:<\/p>\n\n\n\n\n
Bin\u00e1rn\u00ed \u010d\u00edslo<\/th>\nDes\u00edtkov\u00e9 \u010d\u00edslo<\/th>\n<\/tr>\n
1101<\/td>\n=BIN2DEC(„1101“) \u2192 13<\/td>\n<\/tr>\n
10011<\/td>\n=BIN2DEC(„10011“) \u2192 19<\/td>\n<\/tr>\n<\/table>\n
Pou\u017eit\u00ed v praxi<\/h2>\n
P\u0159\u00edklad 1: P\u0159evod v\u00fdsledk\u016f test\u016f<\/h2>\n
Imagine m\u00e1te v\u00fdsledky hardwarov\u00fdch test\u016f ulo\u017een\u00e9 v bin\u00e1rn\u00edm k\u00f3dov\u00e1n\u00ed. Abyste tyto hodnoty mohli efektivn\u011b analyzovat, pot\u0159ebujete je p\u0159ev\u00e9st do des\u00edtkov\u00e9ho form\u00e1tu.<\/p>\n
 P\u0159\u00edklad dat:  A B 1 Bin\u00e1rn\u00ed \u0158et\u011bzec 2 1011001 3 1101110 4 1110 <\/code> <\/pre>\n
Pou\u017eit\u00ed:<\/p>\n
=BIN2DEC(A2) =BIN2DEC(A3) =BIN2DEC(A4)<\/code><\/pre>\n
Tato b\u011b\u017en\u00e1 praxe pom\u00e1h\u00e1 analytik\u016fm l\u00e9pe interpretovat testovac\u00ed v\u00fdsledky.<\/p>\n
P\u0159\u00edklad 2: Anal\u00fdza sign\u00e1lu<\/h2>\n
Pokud pracujete s digit\u00e1ln\u00edmi sign\u00e1ly reprezentovan\u00fdmi bin\u00e1rn\u00edmi k\u00f3dy, m\u016f\u017ee b\u00fdt funkce BIN2DEC nepostradateln\u00e1 pro analyzov\u00e1n\u00ed \u010d\u00edseln\u00fdch hodnot t\u011bchto sign\u00e1l\u016f.<\/p>\n
 Data:  A B 1 Bin\u00e1rn\u00ed Sign\u00e1l 2 101 3 1001 4 111000 <\/code> <\/pre>\n
Pou\u017eit\u00ed funkce BIN2DEC v\u00e1m pom\u016f\u017ee p\u0159ev\u00e9st tyto bin\u00e1rn\u00ed sign\u00e1ly na \u010d\u00edseln\u00e9 hodnoty, co\u017e usnad\u0148uje dal\u0161\u00ed anal\u00fdzu:<\/p>\n
=BIN2DEC(A2) \u2192 5 =BIN2DEC(A3) \u2192 9 =BIN2DEC(A4) \u2192 56<\/code><\/pre>\n
Tyto vypo\u010d\u00edtan\u00e9 hodnoty mohou b\u00fdt n\u00e1sledn\u011b uplatn\u011bny pro dal\u0161\u00ed zpracov\u00e1n\u00ed dat nebo statistick\u00e9 \u00fa\u010dely.<\/p>\n","protected":false},"excerpt":{"rendered":"
P\u0159evede bin\u00e1rn\u00ed \u010d\u00edslo na\u00a0des\u00edtkov\u00e9<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[288],"tags":[],"class_list":["post-5445","post","type-post","status-publish","format-standard","hentry","category-inzenyrske"],"acf":[],"yoast_head":"\nFunkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/bin2dec\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/bin2dec\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:50:29+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/bin2dec\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/bin2dec\/\",\"name\":\"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:50:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/bin2dec\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/bin2dec\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/bin2dec\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In\u017een\u00fdrsk\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/inzenyrske\/\"},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/bin2dec\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/bin2dec\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:50:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/bin2dec\/","url":"https:\/\/functiontranslator.com\/cs\/bin2dec\/","name":"Funkce BIN2DEC v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:50:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije BIN2DEC u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/bin2dec\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/bin2dec\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/bin2dec\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"In\u017een\u00fdrsk\u00e9","item":"https:\/\/functiontranslator.com\/cs\/inzenyrske\/"},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5445"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5445\/revisions"}],"predecessor-version":[{"id":30584,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5445\/revisions\/30584"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}