{"id":130,"date":"2016-05-15T17:31:02","date_gmt":"2016-05-15T16:31:02","guid":{"rendered":"http:\/\/www.ict.mazuch.net\/subdom\/ict\/?page_id=130"},"modified":"2016-05-15T17:31:54","modified_gmt":"2016-05-15T16:31:54","slug":"89-2","status":"publish","type":"page","link":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/89-2\/","title":{"rendered":"(8)(9) Tabulkov\u00fd editor II. (vzorce, t\u0159\u00edd\u011bn\u00ed)"},"content":{"rendered":"<div class=\"pdfprnt-buttons pdfprnt-buttons-page pdfprnt-top-right\"><a href=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages\/130?print=pdf\" class=\"pdfprnt-button pdfprnt-button-pdf\" target=\"_blank\"><img src=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/plugins\/pdf-print\/images\/pdf.png\" alt=\"image_pdf\" title=\"View PDF\" \/><\/a><a href=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages\/130?print=print\" class=\"pdfprnt-button pdfprnt-button-print\" target=\"_blank\"><img src=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/plugins\/pdf-print\/images\/print.png\" alt=\"image_print\" title=\"Print Content\" \/><\/a><\/div><h2><strong>Tabulkov\u00fd editor II. (vzorce, t\u0159\u00edd\u011bn\u00ed)<\/strong><\/h2>\n<ul>\n<li><strong>ZAOKR.DOL\u016e(\u010d\u00edslo, v\u00fdznamnost)<\/strong>\n<ul>\n<li>\u010d\u00edslo = \u010d\u00edslo, kter\u00e9 se m\u00e1 zaokrouhlit<\/li>\n<li>v\u00fdznamnost = n\u00e1sobek, na kter\u00fd se m\u00e1 \u010d\u00edslo zaokrouhlit<\/li>\n<li>p\u0159.: ZAOKR.DOL\u016e(2,5;2) \u21d2 2<\/li>\n<\/ul>\n<\/li>\n<li><strong>ZAOKR.NAHORU(\u010d\u00edslo, v\u00fdznamnost)<\/strong><\/li>\n<li><strong>ZAOKROUHLIT(\u010d\u00edslo, po\u010det \u010d\u00edslic na kter\u00e9 chci zaokrouhlit)<\/strong><\/li>\n<li><strong>MAX(oblast)<\/strong>\n<ul>\n<li>najde nejv\u011bt\u0161\u00ed hodnotu v zadan\u00e9 oblasti<\/li>\n<\/ul>\n<\/li>\n<li><strong>MIN(oblast)<\/strong>\n<ul>\n<li>najde nejmen\u0161\u00ed hodnotu v zadan\u00e9 oblasti<\/li>\n<\/ul>\n<\/li>\n<li><strong>SOU\u010cIN(hodnota1, hodnota2)<\/strong><\/li>\n<li><strong>PR\u016eM\u011aR(oblast)<\/strong><\/li>\n<li><strong>SUMA(pole)<\/strong>\n<ul>\n<li>se\u010dte hodnoty v dan\u00e9m poli<\/li>\n<\/ul>\n<\/li>\n<li><strong>SUMIF(oblast, krit\u00e9rium, sou\u010det)<\/strong>\n<ul>\n<li>oblast = co s\u010d\u00edt\u00e1me<\/li>\n<li>krit\u00e9rium = nap\u0159.: se\u010dti bu\u0148ky &gt; 100<\/li>\n<li>sou\u010det = nepovinn\u00e9<\/li>\n<\/ul>\n<\/li>\n<li><strong>SUMIFS(oblast, oblast krit\u00e9ri\u00ed 1, krit\u00e9rium 1, oblast krit\u00e9ri\u00ed 2, krit\u00e9rium 2)<\/strong>\n<ul>\n<li>oblast = oblast bun\u011bk k se\u010dten\u00ed<\/li>\n<li>oblast krit\u00e9ri\u00ed 1 = oblast testovan\u00e1 pomoc\u00ed krit\u00e9ria jedna<\/li>\n<\/ul>\n<\/li>\n<li><strong>DATUM(rok, m\u011bs\u00edc, den)<\/strong>\n<ul>\n<li>slou\u010d\u00ed \u010d\u00edsla z bun\u011bk do jednoho data<\/li>\n<\/ul>\n<\/li>\n<li><strong>DEC2BIN(\u010d\u00edslo, m\u00edsta)<\/strong>\n<ul>\n<li>p\u0159evede \u010d\u00edslo z des\u00edtkov\u00e9 soustavy do bin\u00e1rn\u00ed<\/li>\n<li>\u010d\u00edslo = \u010d\u00edslo kter\u00e9 chci p\u0159ev\u00e9st<\/li>\n<li>m\u00edsta = nepovinn\u00e9, po\u017eadovn\u00fd po\u010det m\u00edst<\/li>\n<li>funguje i z hex do oct, hex do bin, oct do hex, atd.<\/li>\n<\/ul>\n<\/li>\n<li><strong>KDY\u017d(je n\u011bco pravda; ud\u011blej n\u011bco; jinak ud\u011blej n\u011bco jin\u00e9ho)<\/strong><\/li>\n<li><strong>IFERROR(hodnota, hodnota p\u0159i chyb\u011b)<\/strong>\n<ul>\n<li>hodnota = argument ve kter\u00e9m testujeme v\u00fdskyt chyby, nap\u0159.: n\u00e1soben\u00ed dvou bun\u011bk, d\u011blen\u00ed dvou bun\u011bk, atd.<\/li>\n<li>hodnota p\u0159i chyb\u011b = hodnota vr\u00e1cen\u00ed p\u0159i v\u00fdskytu chyby, nap\u0159.:<br \/>\nIFERROR(12\/0; \u201cChyba ve v\u00fdpo\u010dtu\u201d) \u21d2 Chyba ve v\u00fdpo\u010dtu<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-131\" src=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/uploads\/2016\/05\/excel.png\" alt=\"excel\" width=\"694\" height=\"224\" srcset=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/uploads\/2016\/05\/excel.png 694w, https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/uploads\/2016\/05\/excel-300x97.png 300w, https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-content\/uploads\/2016\/05\/excel-50x16.png 50w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/p>\n<ul>\n<li><strong>SVYHLEDAT(co, kde, sloupec, pravda\/nepravda)<\/strong>\n<ul>\n<li>co = kter\u00e9 \u010d\u00edslo hled\u00e1m<\/li>\n<li>kde = tabulka, <em>v\u011bt\u0161inou zamknout!<\/em><\/li>\n<li>sloupec = v jak\u00e9m sloupci<\/li>\n<li>hled\u00e1me kolik bude da\u0148 pro p\u0159\u00edjem 21 566 K\u010d \u21d2 prvn\u00ed parametr toto \u010d\u00edslo \u21d2 druh\u00fd parametr tabulka kde to hled\u00e1me \u21d2 t\u0159et\u00ed parametr sloupec kde to hled\u00e1me (sazba dan\u011b) \u21d2 pravda\/nepravda (ano\/ne)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>POZVYHLEDAT(co, kde, shoda)<\/strong>\n<ul>\n<li>hled\u00e1 pozici!<\/li>\n<li>shoda \u21d2 &gt; 1 = men\u0161\u00ed ne\u017e; 0 = p\u0159esn\u00e1 shoda, -1 = v\u011bt\u0161\u00ed ne\u017e<\/li>\n<\/ul>\n<\/li>\n<li><strong>VYHLEDAT(co, kde, pravda\/nepravda)<\/strong><\/li>\n<li><strong>EQ(\u010d\u00edslo, pole, typ po\u0159ad\u00ed)<\/strong>\n<ul>\n<li>pole = kde hled\u00e1m \u010d\u00edslo<\/li>\n<li>typ po\u0159ad\u00ed \u21d2 1 vzestupn\u011b, 0 sestupn\u011b<\/li>\n<\/ul>\n<\/li>\n<li><strong>INDEX(pole, \u0159\u00e1dek, sloupec)<\/strong>\n<ul>\n<li>sloupec = nepovinn\u00fd<\/li>\n<li>vr\u00e1t\u00ed hodnotu na tomto m\u00edst\u011b!<\/li>\n<\/ul>\n<\/li>\n<li><strong>POWER(\u010d\u00edslo, mocnina)<\/strong> &#8211; <em>stejn\u00e9 jako v php<\/em><\/li>\n<li><strong>COUNTIF(oblast, krit\u00e9rium)<\/strong>\n<ul>\n<li>spo\u010d\u00edt\u00e1 bu\u0148ky, kter\u00e9 odpov\u00eddaj\u00ed zadan\u00fdm krit\u00e9ri\u00edm<\/li>\n<\/ul>\n<\/li>\n<li><strong>COUNTIFS(oblast, oblast krit\u00e9ri\u00ed 1, krit\u00e9rium 1, oblast krit\u00e9ri\u00ed 2, krit\u00e9rium 2)<\/strong>\n<ul>\n<li>pou\u017eije krit\u00e9ria u bun\u011bk ve v\u00edc oblastech a spo\u010d\u00edt\u00e1, kolikr\u00e1t jsou spln\u011bn\u00e1 v\u0161echna krit\u00e9ria<\/li>\n<li>oblast = oblast bun\u011bk k se\u010dten\u00ed<\/li>\n<li>oblast krit\u00e9ri\u00ed 1 = oblast testovan\u00e1 pomoc\u00ed krit\u00e9ria jedna<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tabulkov\u00fd editor II. (vzorce, t\u0159\u00edd\u011bn\u00ed) ZAOKR.DOL\u016e(\u010d\u00edslo, v\u00fdznamnost) \u010d\u00edslo = \u010d\u00edslo, kter\u00e9 se m\u00e1 zaokrouhlit v\u00fdznamnost = n\u00e1sobek, na kter\u00fd se m\u00e1 \u010d\u00edslo zaokrouhlit p\u0159.: ZAOKR.DOL\u016e(2,5;2) \u21d2 2 ZAOKR.NAHORU(\u010d\u00edslo, v\u00fdznamnost) ZAOKROUHLIT(\u010d\u00edslo, po\u010det \u010d\u00edslic na kter\u00e9 chci zaokrouhlit) MAX(oblast) najde nejv\u011bt\u0161\u00ed hodnotu v zadan\u00e9 oblasti MIN(oblast) najde nejmen\u0161\u00ed hodnotu v zadan\u00e9 oblasti SOU\u010cIN(hodnota1, hodnota2) PR\u016eM\u011aR(oblast) SUMA(pole) se\u010dte <a class=\"read-more\" href=\"https:\/\/www.ict.mazuch.net\/subdom\/ict\/89-2\/\">[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"wppr_data":[],"_links":{"self":[{"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages\/130"}],"collection":[{"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":3,"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages\/130\/revisions"}],"predecessor-version":[{"id":134,"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/pages\/130\/revisions\/134"}],"wp:attachment":[{"href":"https:\/\/www.ict.mazuch.net\/subdom\/ict\/wp-json\/wp\/v2\/media?parent=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}