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

Popis a syntaxe<\/h2>\n

Funkce MINA v Excelu a Google Sheets se pou\u017e\u00edv\u00e1 k ur\u010den\u00ed nejmen\u0161\u00ed hodnoty v sad\u011b dat, kter\u00e1 m\u016f\u017ee zahrnovat \u010d\u00edsla, logick\u00e9 hodnoty a text reprezentovan\u00fd jako \u010d\u00edsla. P\u0159itom logick\u00e9 hodnoty TRUE a FALSE jsou pova\u017eov\u00e1ny za 1 a 0.<\/p>\n

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

MINA(hodnota1, [hodnota2], ...)<\/code><\/pre>\n
kde hodnota1<\/code>, hodnota2<\/code>, atd., jsou argumenty. Tyto argumenty mohou b\u00fdt jednotliv\u00e1 \u010d\u00edsla, n\u00e1zvy, pole nebo odkazy na bu\u0148ky, ze kter\u00fdch chcete z\u00edskat minim\u00e1ln\u00ed hodnotu.<\/p>\n
P\u0159\u00edklad:<\/strong> Kdy\u017e m\u00e1me v bu\u0148k\u00e1ch A1 do A5 hodnoty 3, 5, 1, TRUE a „9“ (jako text), funkce =MINA(A1:A5)<\/code> vr\u00e1t\u00ed hodnotu 0, proto\u017ee TRUE je hodnoceno jako 1 a text „9“ je konvertov\u00e1n na \u010d\u00edslo, zat\u00edmco ostatn\u00ed ne\u010d\u00edseln\u00e9 hodnoty jsou ignorov\u00e1ny.<\/p>\n
Pou\u017eit\u00ed v praxi<\/h2>\n
N\u00e1sleduj\u00ed dva praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed funkce MINA.<\/p>\n
P\u0159\u00edklad 1: Vyhodnocen\u00ed nejmen\u0161\u00ed hodnoty \u00fa\u010dasti na z\u00e1klad\u011b logick\u00fdch hodnot<\/h2>\n
P\u0159edstavme si situaci, kde \u00fa\u010dast student\u016f v kurzu je zaznamen\u00e1v\u00e1na s TRUE pro „P\u0159\u00edtomen“ a FALSE pro „Nep\u0159\u00edtomen“. Chceme zjistit minim\u00e1ln\u00ed hodnotu \u00fa\u010dasti, abychom ihned vid\u011bli, jestli byl alespo\u0148 jeden student nep\u0159\u00edtomen.<\/p>\n
Data: A1: TRUE, A2: TRUE, A3: FALSE, A4: TRUE Vzorec: =MINA(A1:A4) V\u00fdsledek: 0<\/code><\/pre>\n
Koment\u00e1\u0159: Vzhledem k tomu, \u017ee FALSE se vyhodnocuje jako 0 a TRUE jako 1, v\u00fdsledek 0 ukazuje, \u017ee alespo\u0148 jeden student nebyl p\u0159\u00edtomen.<\/p>\n
P\u0159\u00edklad 2: Srovn\u00e1n\u00ed skute\u010dn\u00fdch a o\u010dek\u00e1van\u00fdch prodej\u016f<\/h2>\n
P\u0159edpokl\u00e1dejme, \u017ee m\u00e1me seznam skute\u010dn\u00fdch a o\u010dek\u00e1van\u00fdch prodej\u016f a c\u00edlem je identifikovat nejni\u017e\u0161\u00ed skute\u010dn\u00fd prodej, kter\u00fd byl ni\u017e\u0161\u00ed ne\u017e o\u010dek\u00e1van\u00fd. Skute\u010dn\u00e9 prodeje mohou b\u00fdt uvedeny \u010d\u00edseln\u011b nebo jako textov\u00e9 \u0159et\u011bzce, o\u010dek\u00e1van\u00e9 prodeje jsou \u010d\u00edseln\u00e9.<\/p>\n
Data: Skute\u010dn\u00e9 (A1:A5): 100, \"200\", 150, \"180\", 120 O\u010dek\u00e1van\u00e9 (B1:B5): 90, 210, 160, 175, 130 Vzorec: =MINA(IF(A1:A5>B1:B5, HODNOTA(A1:A5), NA())) V\u00fdsledek: 150<\/code><\/pre>\n
Koment\u00e1\u0159: V tomto p\u0159\u00edkladu funkce HODNOTA konvertuje textov\u011b zaznamenan\u00e9 prodeje na \u010d\u00edseln\u00e9 hodnoty. Pot\u00e9 funkce MINA ur\u010duje nejni\u017e\u0161\u00ed hodnotu mezi t\u011bmi prodeji, kter\u00e9 byly ni\u017e\u0161\u00ed ne\u017e o\u010dek\u00e1van\u00e9. V\u00fdsledn\u00e1 nejni\u017e\u0161\u00ed hodnota, kde skute\u010dn\u00fd prodej neodpov\u00eddal o\u010dek\u00e1v\u00e1n\u00ed, je 150.<\/p>\n","protected":false},"excerpt":{"rendered":"
Vr\u00e1t\u00ed nejmen\u0161\u00ed hodnotu v\u00a0seznamu argument\u016f v\u010detn\u011b \u010d\u00edsel, textu a\u00a0logick\u00fdch hodnot<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5696","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce MINA v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije MINA 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\/mina\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce MINA v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije MINA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/mina\/\" \/>\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:59:34+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce MINA 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\/mina\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/mina\/\",\"name\":\"Funkce MINA 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:59:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije MINA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/mina\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/mina\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/mina\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/statisticke\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MINA\"}]},{\"@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 MINA v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije MINA 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\/mina\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce MINA v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije MINA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/mina\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T09:59:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce MINA 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\/mina\/","url":"https:\/\/functiontranslator.com\/cs\/mina\/","name":"Funkce MINA 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:59:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije MINA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/mina\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/mina\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/mina\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Statistick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/statisticke\/"},{"@type":"ListItem","position":3,"name":"MINA"}]},{"@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\/5696","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=5696"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5696\/revisions"}],"predecessor-version":[{"id":30834,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5696\/revisions\/30834"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}