http://wiki.openoffice.cz/w/index.php?title=Matematick%C3%A1_funkcia_-_COUNTBLANK&feed=atom&action=history
Matematická funkcia - COUNTBLANK - Historie editací
2024-03-29T07:01:49Z
Historie editací této stránky
MediaWiki 1.13.1
http://wiki.openoffice.cz/w/index.php?title=Matematick%C3%A1_funkcia_-_COUNTBLANK&diff=2173&oldid=prev
Roman Toman v 5. 1. 2010, 00:29
2010-01-05T00:29:17Z
<p></p>
<table style="background-color: white; color:black;">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Starší verze</td>
<td colspan='2' style="background-color: white; color:black;">Verze z 5. 1. 2010, 00:29</td>
</tr>
<tr><td colspan="2" class="diff-lineno">Řádka 8:</td>
<td colspan="2" class="diff-lineno">Řádka 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h4><font color="tomato">Syntax</font></h4></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h4><font color="tomato">Syntax</font></h4></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p><font color="teal" size=4><b></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p><font color="teal" size=4><b></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>=COUNTBLANK(Oblasť)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>=COUNTBLANK(Oblasť)<ins class="diffchange diffchange-inline"></b></font></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><hr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><hr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2" class="diff-lineno">Řádka 29:</td>
<td colspan="2" class="diff-lineno">Řádka 29:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">2</td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">2</td></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> <td align="right"><ins class="diffchange diffchange-inline">1</ins></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Řádka 37:</td>
<td colspan="2" class="diff-lineno">Řádka 37:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">3</td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">3</td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <td></td></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> <td <ins class="diffchange diffchange-inline">align="right"</ins>><ins class="diffchange diffchange-inline">3</ins></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Řádka 44:</td>
<td colspan="2" class="diff-lineno">Řádka 44:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">4</td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">4</td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <td></td></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> <td <ins class="diffchange diffchange-inline">align="right"</ins>><ins class="diffchange diffchange-inline">4</ins></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Řádka 50:</td>
<td colspan="2" class="diff-lineno">Řádka 50:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">5</td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="center" bgcolor="lightgrey">5</td></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> <td align="right"><ins class="diffchange diffchange-inline">4</ins></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right"></td></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Řádka 60:</td>
<td colspan="2" class="diff-lineno">Řádka 60:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right">=COUNTBLANK(A2:B11)</td></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <td align="right">=COUNTBLANK(A2:B11)</td></div></td></tr>
<tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div> <td align="right"><del class="diffchange diffchange-inline">20</del></td></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> <td align="right"><ins class="diffchange diffchange-inline">16</ins></td></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> </tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> </tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div> <tr></div></td></tr>
<!-- diff generator: internal 2024-03-29 07:01:49 -->
</table>
Roman Toman
http://wiki.openoffice.cz/w/index.php?title=Matematick%C3%A1_funkcia_-_COUNTBLANK&diff=2172&oldid=prev
Roman Toman: Vytvorenie stránky
2010-01-04T17:06:28Z
<p>Vytvorenie stránky</p>
<p><b>Nová stránka</b></p><div><font color="blue" size=5><b>Funkcia COUNTBLANK(Oblasť)</b></font><br><br><br />
<hr><br />
<br />
<h4><font color="tomato">Účel v programe CALC</font></h4><br />
<p>Vráti počet prázdných buniek v blasti.</p><br />
<hr><br />
<br />
<h4><font color="tomato">Syntax</font></h4><br />
<p><font color="teal" size=4><b><br />
=COUNTBLANK(Oblasť)<br />
<hr><br />
<br />
<h4><font color="tomato">Príklad</font></h4><br />
<table border=1><br />
<tr align="center"><br />
<td></td><br />
<td bgcolor="lightgrey">A</td><br />
<td bgcolor="lightgrey">B</td><br />
<td bgcolor="lightgrey">C</td><br />
<td bgcolor="lightgrey">D</td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">1</td><br />
<td width=60 align="center" bgcolor="aquamarine"><b></b></td><br />
<td width=120 align="center" bgcolor="aquamarine"><b></b></td><br />
<td width=60 align="center" bgcolor="aquamarine"><b>Vzorec</b></td><br />
<td width=60 align="center" bgcolor="aquamarine"><b>Výsledok</b></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">2</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">3</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">4</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">5</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">6</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right">=COUNTBLANK(A2:B11)</td><br />
<td align="right">20</td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">7</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">8</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">9</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">10</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
<tr><br />
<td align="center" bgcolor="lightgrey">11</td><br />
<td align="right"></td><br />
<td></td><br />
<td align="right"></td><br />
<td align="right"></td><br />
</tr><br />
</table><br />
<br><br />
<hr><br />
<h4><font color="tomato">Odkazy</font></h4><br />
* [[Súhrn - Matematické funkcie|Matematické funkcie - Súhrn]]<br><br />
<hr><br />
[[kategorie:Calc]]<br />
[[kategorie:Funkce]]</div>
Roman Toman