{"id":10280,"date":"2025-07-15T13:34:49","date_gmt":"2025-07-15T13:34:49","guid":{"rendered":"https:\/\/functiontranslator.com\/dwojk-na-osm\/"},"modified":"2021-02-26T05:04:00","modified_gmt":"2021-02-26T05:04:00","slug":"bin2oct","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pl\/bin2oct\/","title":{"rendered":"DW\u00d3JK.NA.\u00d3SM"},"content":{"rendered":"

Opis funkcji i jej zastosowanie<\/h2>\n

Funkcja BIN2OCT konwertuje liczby z systemu dw\u00f3jkowego (binarnego) na system \u00f3semkowy. Jest to narz\u0119dzie szczeg\u00f3lnie u\u017cyteczne w elektronice oraz informatyce, gdzie cz\u0119sto wyst\u0119puje potrzeba konwersji mi\u0119dzy r\u00f3\u017cnymi systemami liczbowymi.<\/p>\n

Sk\u0142adnia<\/h2>\n

Sk\u0142adnia funkcji BIN2OCT w Microsoft Excel oraz Arkuszach Google prezentuje si\u0119 nast\u0119puj\u0105co:<\/p>\n

=BIN2OCT(liczba_bin; [miejsca])<\/code><\/pre>\n
    \n
  • liczba_bin<\/strong> – Liczba w formacie binarnym, kt\u00f3r\u0105 chcemy przekszta\u0142ci\u0107 na format \u00f3semkowy. Nale\u017cy wprowadzi\u0107 j\u0105 jako ci\u0105g tekstowy.<\/li>\n
  • miejsca<\/strong> (opcjonalnie) – Okre\u015bla liczb\u0119 cyfr, na kt\u00f3re ma zosta\u0107 uzupe\u0142niony wynikowy ci\u0105g \u00f3semkowy. Je\u015bli wynikowa liczba jest kr\u00f3tsza ni\u017c okre\u015blona ilo\u015b\u0107 miejsc, zostanie uzupe\u0142niona zerami od lewej strony. Pomini\u0119cie tego argumentu spowoduje wy\u015bwietlenie rezultatu bez dodatkowego uzupe\u0142niania zer.<\/li>\n<\/ul>\n
    Przyk\u0142ad u\u017cycia<\/h2>\n
    Przyk\u0142adowo, chcemy przekonwertowa\u0107 liczb\u0119 binarn\u0105 101101 na system \u00f3semkowy przy u\u017cyciu funkcji BIN2OCT:<\/p>\n
    =BIN2OCT(\"101101\")<\/code><\/pre>\n
    Rezultatem tej operacji b\u0119dzie liczba 55, poniewa\u017c 1011012<\/sub> odpowiada 558<\/sub>.<\/p>\n\n\n\n
    Liczba binarna<\/th>\nLiczba \u00f3semkowa<\/th>\n<\/tr>\n
    101101<\/td>\n55<\/td>\n<\/tr>\n<\/table>\n
    Przyk\u0142adowe zadania<\/h2>\n
    Zadanie 1: Konwersja liczby binarnej na system \u00f3semkowy<\/h2>\n
    Rozwa\u017cmy przekonwertowanie liczby binarnej 11101010 na system \u00f3semkowy.<\/p>\n
    Rozwi\u0105zanie:<\/p>\n
    =BIN2OCT(\"11101010\")<\/code><\/pre>\n
    Wynik to 352, co sprawdzaj\u0105c, 111010102<\/sub> = 3528<\/sub>.<\/p>\n
    Zadanie 2: Formatowanie wyniku z okre\u015blon\u0105 liczb\u0105 cyfr<\/h2>\n
    Za\u0142\u00f3\u017cmy teraz, \u017ce chcemy przedstawi\u0107 liczb\u0119 binarn\u0105 10011001 w systemie \u00f3semkowym, ale z wyra\u017anie okre\u015blon\u0105 ilo\u015bci\u0105 czterech cyfr.<\/p>\n
    Rozwi\u0105zanie:<\/p>\n
    =BIN2OCT(\"10011001\", 4)<\/code><\/pre>\n
    Rezultatem tej funkcji to 0221. Liczba ta w systemie binarnym to 2218<\/sub>, ale z uwzgl\u0119dnionym formatowaniem wy\u015bwietlane s\u0105 cztery cyfry, czyli 0221.<\/p>\n
    Korzystanie z funkcji BIN2OCT mo\u017ce znacz\u0105co u\u0142atwi\u0107 prac\u0119 w r\u00f3\u017cnych dziedzinach technicznych, umo\u017cliwiaj\u0105c efektywne manipulowanie i analizowanie danych w r\u00f3\u017cnych systemach liczbowych.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Konwertuje liczb\u0119 w postaci dw\u00f3jkowej na liczb\u0119 w postaci \u00f3semkowej<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[429],"tags":[],"class_list":["post-10280","post","type-post","status-publish","format-standard","hentry","category-inzynierskie"],"acf":[],"yoast_head":"\nFunkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia<\/title>\n<meta name=\"description\" content=\"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\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\/pl\/bin2oct\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta property=\"og:description\" content=\"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pl\/bin2oct\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T05:04:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/bin2oct\/\",\"url\":\"https:\/\/functiontranslator.com\/pl\/bin2oct\/\",\"name\":\"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:49+00:00\",\"dateModified\":\"2021-02-26T05:04:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pl\/bin2oct\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pl\/bin2oct\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pl\/bin2oct\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkcje programu Excel\",\"item\":\"https:\/\/functiontranslator.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In\u017cynierskie\",\"item\":\"https:\/\/functiontranslator.com\/pl\/inzynierskie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DW\u00d3JK.NA.\u00d3SM\"}]},{\"@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\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@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\/pl\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","description":"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","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\/pl\/bin2oct\/","og_locale":"pl_PL","og_type":"article","og_title":"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","og_description":"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","og_url":"https:\/\/functiontranslator.com\/pl\/bin2oct\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:49+00:00","article_modified_time":"2021-02-26T05:04:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","twitter_misc":{"Napisane przez":"glavadmin","Szacowany czas czytania":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pl\/bin2oct\/","url":"https:\/\/functiontranslator.com\/pl\/bin2oct\/","name":"Funkcja BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu \u2013 jak dzia\u0142a, przyk\u0142ady u\u017cycia i sk\u0142adnia","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:49+00:00","dateModified":"2021-02-26T05:04:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcji BIN2OCT (DW\u00d3JK.NA.\u00d3SM) w Excelu. Poznaj sk\u0142adni\u0119, parametry oraz praktyczne przyk\u0142ady zastosowania.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pl\/bin2oct\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pl\/bin2oct\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pl\/bin2oct\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkcje programu Excel","item":"https:\/\/functiontranslator.com\/pl\/"},{"@type":"ListItem","position":2,"name":"In\u017cynierskie","item":"https:\/\/functiontranslator.com\/pl\/inzynierskie\/"},{"@type":"ListItem","position":3,"name":"DW\u00d3JK.NA.\u00d3SM"}]},{"@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":"pl-PL"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pl-PL","@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\/pl\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/comments?post=10280"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10280\/revisions"}],"predecessor-version":[{"id":27598,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/posts\/10280\/revisions\/27598"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/media?parent=10280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/categories?post=10280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pl\/wp-json\/wp\/v2\/tags?post=10280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}