{"id":5541,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/dollarfr\/"},"modified":"2021-02-26T09:54:16","modified_gmt":"2021-02-26T09:54:16","slug":"dollarfr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/dollarfr\/","title":{"rendered":"DOLLARFR"},"content":{"rendered":"

Syntaxe a popis funkce pro finan\u010dn\u00ed form\u00e1tov\u00e1n\u00ed<\/h2>\n

Funkce DOLLARFR v MS Excelu a Google Tabulk\u00e1ch je u\u017eite\u010dn\u00e1 pro p\u0159evod \u010d\u00edsel z desetinn\u00e9 formy na frakcion\u00e1ln\u00ed formu, kter\u00e1 je \u010dasto pou\u017e\u00edv\u00e1na ve finan\u010dn\u00edm sv\u011bt\u011b, zejm\u00e9na pro \u00fa\u010detn\u00ed a dluhopisov\u00e9 v\u00fdpo\u010dty. Tato funkce bere dva argumenty: desetinn\u00e9 \u010d\u00edslo, kter\u00e9 chcete p\u0159ev\u00e9st, a cel\u00e9 \u010d\u00edslo, kter\u00e9 specifikuje po\u010det d\u00edl\u016f frakce v c\u00edlov\u00e9m form\u00e1tu.<\/p>\n

Syntaxe funkce vypad\u00e1 n\u00e1sledovn\u011b:<\/p>\n

DOLLARFR(desetinn\u00e9_\u010d\u00edslo, frakce)<\/code><\/pre>\n
    \n
  • desetinn\u00e9_\u010d\u00edslo<\/code> – Hodnota, kterou chcete p\u0159ev\u00e9st. M\u016f\u017ee to b\u00fdt jak\u00fdkoli numerick\u00fd \u00fadaj expresov\u00e1n jako desetinn\u00e9 \u010d\u00edslo.<\/li>\n
  • frakce<\/code> – Po\u010det d\u00edl\u016f frakce, na kter\u00e9 chcete \u010d\u00edslo rozd\u011blit ve fin\u00e1ln\u00edm v\u00fdsledku. Nap\u0159\u00edklad pro \u010dtvrtiny pou\u017eijete hodnotu 4.<\/li>\n<\/ul>\n
    Pou\u017eit\u00ed v praktick\u00fdch sc\u00e9n\u00e1\u0159\u00edch<\/h2>\n
    Tato funkce je obzvl\u00e1\u0161t\u011b u\u017eite\u010dn\u00e1 ve dvou kl\u00ed\u010dov\u00fdch oblastech:<\/p>\n
    1. P\u0159evod desetinn\u00fdch \u010d\u00edsel na frakce v dluhopisech<\/h3>\n
    P\u0159i obchodov\u00e1n\u00ed s dluhopisy se \u010dasto setk\u00e1v\u00e1me s pot\u0159ebou vyj\u00e1d\u0159it \u00farokov\u00e9 m\u00edry nebo n\u00e1kupn\u00ed a prodejn\u00ed ceny v zlomc\u00edch, kter\u00e9 jsou tradi\u010dn\u011b ve finan\u010dn\u00edm sv\u011bt\u011b b\u011b\u017en\u011b pou\u017e\u00edv\u00e1ny. P\u0159evod pomoc\u00ed funkce DOLLARFR m\u016f\u017ee vypadat n\u00e1sledovn\u011b:<\/p>\n
    DOLLARFR(100.125, 8)<\/code><\/pre>\n
    V tomto p\u0159\u00edpadu funkce p\u0159evede desetinn\u00e9 \u010d\u00edslo 100.125 na frak\u010dn\u00ed formu, kde \u010d\u00e1st za desetinnou te\u010dkou bude vyj\u00e1d\u0159ena jako osmina. V\u00fdsledek bude 100+1\/8.<\/p>\n
    2. \u00da\u010detn\u00ed aplikace<\/h3>\n
    V \u00fa\u010detnictv\u00ed je n\u011bkdy nutn\u00e9 p\u0159ev\u00e1d\u011bt desetinn\u00e1 \u010d\u00edsla na frakce pro standardizaci reporting\u016f nebo pro specifick\u00e9 v\u00fdpo\u010dty, jako jsou amortizace nebo kapitalizace \u00farok\u016f. Nap\u0159\u00edklad p\u0159i amortizaci dluhopisu m\u016f\u017eete pot\u0159ebovat p\u0159ev\u00e9st desetinn\u00e9 \u010d\u00edsla na frakce, aby odpov\u00eddaly obchodn\u00edm podm\u00ednk\u00e1m. P\u0159\u00edklad pou\u017eit\u00ed funkce je:<\/p>\n
    DOLLARFR(150.75, 4)<\/code><\/pre>\n
    Zde 150.75 bude p\u0159evedeno na 150+3\/4. Funkce tedy rozd\u011bl\u00ed 0.75 na \u010dty\u0159i \u010d\u00e1sti a v\u00fdsledek bude reprezentovat t\u0159i z t\u011bchto \u010d\u00e1st\u00ed.<\/p>\n
    Z\u00e1v\u011bre\u010dn\u00e9 pozn\u00e1mky<\/h2>\n
    Funkce DOLLARFR je extr\u00e9mn\u011b u\u017eite\u010dn\u00fd n\u00e1stroj ve finan\u010dn\u00ed anal\u00fdze a \u00fa\u010detnictv\u00ed pro pr\u00e1ci se specifick\u00fdmi frak\u010dn\u00edmi hodnotami, je\u017e jsou b\u011b\u017en\u011b pou\u017e\u00edv\u00e1ny v n\u011bkter\u00fdch odv\u011btv\u00edch. Spr\u00e1vn\u00e9 pochopen\u00ed a aplikace t\u00e9to funkce m\u016f\u017ee v\u00e9st k p\u0159esn\u011bj\u0161\u00edmu a efektivn\u011bj\u0161\u00edmu zpracov\u00e1n\u00ed finan\u010dn\u00edch dat.<\/p>\n","protected":false},"excerpt":{"rendered":"
    P\u0159evede \u010d\u00e1stku v\u00a0korun\u00e1ch vyj\u00e1d\u0159enou desetinn\u00fdm \u010d\u00edslem na\u00a0\u010d\u00e1stku v\u00a0korun\u00e1ch vyj\u00e1d\u0159enou zlomkem<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[283],"tags":[],"class_list":["post-5541","post","type-post","status-publish","format-standard","hentry","category-financni"],"acf":[],"yoast_head":"\nFunkce DOLLARFR v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije DOLLARFR 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\/dollarfr\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce DOLLARFR v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije DOLLARFR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/dollarfr\/\" \/>\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:54:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce DOLLARFR 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\/dollarfr\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/dollarfr\/\",\"name\":\"Funkce DOLLARFR 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:54:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije DOLLARFR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/dollarfr\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/dollarfr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/dollarfr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finan\u010dn\u00ed\",\"item\":\"https:\/\/functiontranslator.com\/cs\/financni\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DOLLARFR\"}]},{\"@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 DOLLARFR v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije DOLLARFR 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\/dollarfr\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce DOLLARFR v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije DOLLARFR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/dollarfr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:54:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce DOLLARFR 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\/dollarfr\/","url":"https:\/\/functiontranslator.com\/cs\/dollarfr\/","name":"Funkce DOLLARFR 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:54:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije DOLLARFR u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/dollarfr\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/dollarfr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/dollarfr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Finan\u010dn\u00ed","item":"https:\/\/functiontranslator.com\/cs\/financni\/"},{"@type":"ListItem","position":3,"name":"DOLLARFR"}]},{"@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\/5541","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=5541"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5541\/revisions"}],"predecessor-version":[{"id":30680,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5541\/revisions\/30680"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}