{"id":5855,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/useknout\/"},"modified":"2021-02-26T10:05:09","modified_gmt":"2021-02-26T10:05:09","slug":"trunc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/trunc\/","title":{"rendered":"USEKNOUT"},"content":{"rendered":"

Funkce USEKNOUT<\/strong> (v anglick\u00e9 verzi zn\u00e1m\u00e1 jako TRUNC) je velice u\u017eite\u010dn\u00e1 pro pr\u00e1ci s \u010d\u00edsly v tabulkov\u00fdch aplikac\u00edch jako jsou Microsoft Excel a Google Sheets. Tato funkce odstran\u00ed desetinn\u00e1 m\u00edsta z \u010d\u00edsla, a t\u00edm ho zkr\u00e1t\u00ed na cel\u00e9 \u010d\u00edslo nebo na ur\u010den\u00fd po\u010det desetinn\u00fdch m\u00edst, ani\u017e by do\u0161lo k jak\u00e9mukoli zaokrouhlen\u00ed.<\/p>\n

Syntaxe a p\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n

Syntaxe funkce USEKNOUT<\/code> je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

=USEKNOUT(\u010d\u00edslo; po\u010det_desetinn\u00fdch_m\u00edst)<\/code><\/pre>\n
    \n
  • \u010d\u00edslo<\/strong> – Hodnota, kterou chcete upravit.<\/li>\n
  • po\u010det_desetinn\u00fdch_m\u00edst<\/strong> – Ud\u00e1v\u00e1, na kolik desetinn\u00fdch m\u00edst m\u00e1 b\u00fdt \u010d\u00edslo zkr\u00e1ceno. Pokud je tento argument vynech\u00e1n, funkce vr\u00e1t\u00ed cel\u00e9 \u010d\u00edslo.<\/li>\n<\/ul>\n
    P\u0159\u00edklady:<\/strong><\/p>\n\n\n\n\n
    =USEKNOUT(8.9; 0)<\/code><\/td>\nVr\u00e1t\u00ed 8.<\/td>\n<\/tr>\n
    =USEKNOUT(8.786; 2)<\/code><\/td>\nVr\u00e1t\u00ed 8.78.<\/td>\n<\/tr>\n
    =USEKNOUT(-3.14159; 3)<\/code><\/td>\nVr\u00e1t\u00ed -3.141.<\/td>\n<\/tr>\n<\/table>\n
    Praktick\u00e9 aplikace<\/h2>\n
    Zde jsou uvedeny dva konkr\u00e9tn\u00ed p\u0159\u00edklady pou\u017eit\u00ed funkce USEKNOUT ve va\u0161ich tabulk\u00e1ch.<\/p>\n
    1. P\u0159i finan\u010dn\u00edch v\u00fdpo\u010dtech<\/h2>\n
    P\u0159edstavte si, \u017ee pot\u0159ebujete spo\u010d\u00edtat ro\u010dn\u00ed \u00faroky z ur\u010dit\u00e9 sumy bez zaokrouhlov\u00e1n\u00ed na koruny. P\u0159\u00edklad: Z\u016fstatek 25,678 korun s ro\u010dn\u00ed \u00farokovou sazbou 3.5%.<\/p>\n
    =USEKNOUT(25678 * 0.035; 2)<\/code><\/pre>\n
    Tento v\u00fdpo\u010det vr\u00e1t\u00ed 898.73, co\u017e jsou \u00faroky p\u0159esn\u011b na dv\u011b desetinn\u00e1 m\u00edsta, bez zaokrouhlen\u00ed.<\/p>\n
    2. P\u0159i zpracov\u00e1n\u00ed dat s po\u017eadavky na specifickou p\u0159esnost<\/h2>\n
    V oblastech jako v\u011bda nebo technika, kde je pot\u0159eba zachovat specifick\u00fd po\u010det desetinn\u00fdch m\u00edst pro n\u00e1sledn\u00e9 v\u00fdpo\u010dty, m\u016f\u017ee b\u00fdt funkce USEKNOUT velmi u\u017eite\u010dn\u00e1. Nap\u0159\u00edklad p\u0159i v\u00fdpo\u010dtu objemu plynu, kdy pot\u0159ebujete \u010d\u00edslo 123.456789 zkr\u00e1tit na 4 desetinn\u00e1 m\u00edsta:<\/p>\n
    =USEKNOUT(123.456789; 4)<\/code><\/pre>\n
    V\u00fdsledek 123.4567 je p\u0159esn\u011b to, co pot\u0159ebujete pro dal\u0161\u00ed v\u00fdpo\u010dty.<\/p>\n
    Tyto p\u0159\u00edklady ilustruj\u00ed, jak m\u016f\u017ee b\u00fdt funkce USEKNOUT n\u00e1pomocn\u00e1 v r\u016fzn\u00fdch situac\u00edch, od finan\u010dn\u00edch anal\u00fdz po p\u0159esn\u00e9 v\u011bdeck\u00e9 v\u00fdpo\u010dty. Jedn\u00e1 se o jednoduch\u00fd n\u00e1stroj pro precizn\u00ed manipulaci s \u010d\u00edseln\u00fdmi daty, kter\u00fd by m\u011bl b\u00fdt sou\u010d\u00e1st\u00ed ka\u017ed\u00e9ho arsenalu kancel\u00e1\u0159sk\u00e9ho softwaru.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Zkr\u00e1t\u00ed \u010d\u00edslo na\u00a0cel\u00e9 \u010d\u00edslo<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[],"class_list":["post-5855","post","type-post","status-publish","format-standard","hentry","category-matematicke-a-trigonometricke"],"acf":[],"yoast_head":"\nFunkce TRUNC (USEKNOUT) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije TRUNC (USEKNOUT) 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\/trunc\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce TRUNC (USEKNOUT) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije TRUNC (USEKNOUT) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/trunc\/\" \/>\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-26T10:05:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce TRUNC (USEKNOUT) 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\/trunc\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/trunc\/\",\"name\":\"Funkce TRUNC (USEKNOUT) 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-26T10:05:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije TRUNC (USEKNOUT) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/trunc\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/trunc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/trunc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matematick\u00e9 a trigonometrick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/matematicke-a-trigonometricke\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"USEKNOUT\"}]},{\"@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 TRUNC (USEKNOUT) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije TRUNC (USEKNOUT) 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\/trunc\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce TRUNC (USEKNOUT) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije TRUNC (USEKNOUT) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/trunc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T10:05:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce TRUNC (USEKNOUT) 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\/trunc\/","url":"https:\/\/functiontranslator.com\/cs\/trunc\/","name":"Funkce TRUNC (USEKNOUT) 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-26T10:05:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije TRUNC (USEKNOUT) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/trunc\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/trunc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/trunc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Matematick\u00e9 a trigonometrick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/matematicke-a-trigonometricke\/"},{"@type":"ListItem","position":3,"name":"USEKNOUT"}]},{"@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\/5855","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=5855"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5855\/revisions"}],"predecessor-version":[{"id":30989,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5855\/revisions\/30989"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}