{"id":5588,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/formulatext\/"},"modified":"2021-02-26T09:55:49","modified_gmt":"2021-02-26T09:55:49","slug":"formulatext","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/formulatext\/","title":{"rendered":"FORMULATEXT"},"content":{"rendered":"

Popis a Syntaxe Funkce pro Zobrazen\u00ed Textu Formule<\/h2>\n

Funkce, kterou se budeme zab\u00fdvat, umo\u017e\u0148uje u\u017eivatel\u016fm zobrazit formuli pou\u017eitou v bu\u0148ce jako oby\u010dejn\u00fd text. Tato mo\u017enost je u\u017eite\u010dn\u00e1 pro dokumentaci, revizi nebo vzd\u011bl\u00e1vac\u00ed \u00fa\u010dely, kdy chceme rychle zjistit, jak\u00e9 formule jsou pou\u017eity pro v\u00fdpo\u010dty bez nutnosti klik\u00e1n\u00ed na ka\u017edou bu\u0148ku zvl\u00e1\u0161\u0165. <\/p>\n

Syntaxe t\u00e9to funkce je jednoduch\u00e1 a skl\u00e1d\u00e1 se z jedin\u00e9ho argumentu: <\/p>\n

(bu\u0148ka)<\/code><\/pre>\n
Kde „bu\u0148ka“ je odkaz na bu\u0148ku, jej\u00ed\u017e formuli chceme zobrazit jako text.<\/p>\n
P\u0159\u00edklady pou\u017eit\u00ed ve skute\u010dn\u00fdch \u00faloh\u00e1ch<\/h2>\n
\u00dakol 1: Sestaven\u00ed dokumentace k rozpo\u010dtu<\/h3>\n
 P\u0159edstavme si, \u017ee m\u00e1me rozpo\u010dtovou tabulku, kde ka\u017ed\u00e1 bu\u0148ka v ur\u010dit\u00e9m sloupci obsahuje slo\u017eit\u00e9 formule pro v\u00fdpo\u010det financ\u00ed. P\u0159i p\u0159ed\u00e1v\u00e1n\u00ed dokumentace mana\u017eer\u016fm nebo koleg\u016fm m\u016f\u017eeme k jednotliv\u00fdm bu\u0148k\u00e1m p\u0159idat koment\u00e1\u0159, kter\u00fd bude obsahovat formuli v textov\u00e9m form\u00e1tu, aby bylo mo\u017en\u00e9 rychle pochopit logiku v\u00fdpo\u010dt\u016f bez nutnosti zkoum\u00e1n\u00ed formul\u00ed. <\/p>\n
 P\u0159\u00edklad pou\u017eit\u00ed v praxi: <\/p>\n
    \n
  • M\u00e1me formuli =SUM(A1:A10)<\/code> v bu\u0148ce B1.<\/li>\n
  • Do bu\u0148ky C1 m\u016f\u017eeme vlo\u017eit n\u00e1sleduj\u00edc\u00ed: =FUNKCE(B1)<\/code>.<\/li>\n
  • V bu\u0148ce C1 se zobraz\u00ed text „=SUM(A1:A10)<\/code>„.<\/li>\n<\/ul>\n
    \u00dakol 2: Vzd\u011bl\u00e1vac\u00ed materi\u00e1ly pro nov\u00e9 u\u017eivatele<\/h3>\n
     Dal\u0161\u00edm skv\u011bl\u00fdm vyu\u017eit\u00edm je vytv\u00e1\u0159en\u00ed vzd\u011bl\u00e1vac\u00edch materi\u00e1l\u016f pro nov\u00e9 zam\u011bstnance nebo studenty, kte\u0159\u00ed se u\u010d\u00ed, jak pracovat s tabulkov\u00fdmi kalkul\u00e1tory. M\u016f\u017eeme vytvo\u0159it pracovn\u00ed list s r\u016fzn\u00fdmi formulemi a vedle ka\u017ed\u00e9 formule m\u00edt bu\u0148ku, kter\u00e1 formuli explicitn\u011b zobraz\u00ed a pop\u00ed\u0161e jej\u00ed funkci. <\/p>\n
     Postup vytvo\u0159en\u00ed: <\/p>\n
      \n
    • V bu\u0148ce A1 nastav\u00edme komplexn\u00ed formuli, nap\u0159\u00edklad =A2*A3+100<\/code>.<\/li>\n
    • Bu\u0148ka B1 pak m\u016f\u017ee obsahovat =FUNKCE(A1)<\/code> pro zobrazen\u00ed samotn\u00e9 formule.<\/li>\n
    • T\u00edm z\u00edsk\u00e1me v bu\u0148ce B1 text „=A2*A3+100<\/code>„, co\u017e nov\u00fdm u\u017eivatel\u016fm pom\u016f\u017ee pochopit, jak formule funguje.<\/li>\n<\/ul>\n
      Uveden\u00e9 p\u0159\u00edklady ukazuj\u00ed, jak m\u016f\u017ee b\u00fdt funkce pro zobrazen\u00ed textu formule u\u017eite\u010dn\u00e1 v r\u016fzn\u00fdch aplikac\u00edch, a\u0165 u\u017e pro intern\u00ed dokumentaci, \u0161kolen\u00ed nebo jin\u00e9 vzd\u011bl\u00e1vac\u00ed \u00fa\u010dely. Umo\u017e\u0148uje jednodu\u0161e sd\u00edlet a vysv\u011btlovat logiku za daty, co\u017e je kl\u00ed\u010dov\u00e9 pro spr\u00e1vn\u00e9 porozum\u011bn\u00ed a spolupr\u00e1ci v pracovn\u00edch t\u00fdmech.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Vr\u00e1t\u00ed funkci ze zadan\u00e9ho odkazu, zform\u00e1tovanou jako text<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[284],"tags":[],"class_list":["post-5588","post","type-post","status-publish","format-standard","hentry","category-vyhledavaci-a-pro-odkazy"],"acf":[],"yoast_head":"\nFunkce FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije FORMULATEXT 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\/formulatext\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije FORMULATEXT u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/formulatext\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:55:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce FORMULATEXT 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\/formulatext\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/formulatext\/\",\"name\":\"Funkce FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-26T09:55:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije FORMULATEXT u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/formulatext\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/formulatext\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/formulatext\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vyhled\u00e1vac\u00ed a pro odkazy\",\"item\":\"https:\/\/functiontranslator.com\/cs\/vyhledavaci-a-pro-odkazy\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"FORMULATEXT\"}]},{\"@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 FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije FORMULATEXT 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\/formulatext\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije FORMULATEXT u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/formulatext\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T09:55:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce FORMULATEXT 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\/formulatext\/","url":"https:\/\/functiontranslator.com\/cs\/formulatext\/","name":"Funkce FORMULATEXT v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-26T09:55:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije FORMULATEXT u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/formulatext\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/formulatext\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/formulatext\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Vyhled\u00e1vac\u00ed a pro odkazy","item":"https:\/\/functiontranslator.com\/cs\/vyhledavaci-a-pro-odkazy\/"},{"@type":"ListItem","position":3,"name":"FORMULATEXT"}]},{"@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\/5588","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=5588"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5588\/revisions"}],"predecessor-version":[{"id":30726,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5588\/revisions\/30726"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}