http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2FMINA1
Manuals/calci/MINA1 - Revision history
2026-06-25T14:48:08Z
Revision history for this page on the wiki
MediaWiki 1.35.2
http://wiki.zcubes.com/index.php?title=Manuals/calci/MINA1&diff=502&oldid=prev
MassBot1: Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MINA(n1,n2,n3.........) MINA(R1,R2,external R1............) There is no limit to how many parameters pass to MI..."
2013-10-25T02:40:15Z
<p>Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MINA(n1,n2,n3.........) MINA(R1,R2,external R1............) There is no limit to how many parameters pass to MI..."</p>
<p><b>New page</b></p><div><div id="6SpaceContent" class="zcontent" align="left"><br />
<br />
MINA(n1,n2,n3.........)<br />
<br />
MINA(R1,R2,external R1............)<br />
<br />
There is no limit to how many parameters pass to MINA.<br />
<br />
</div><br />
----<br />
<div id="1SpaceContent" class="zcontent" align="left"><br />
<br />
This function returns the smallest value from set of numbers.<br />
<br />
</div><br />
----<br />
<div id="7SpaceContent" class="zcontent" align="left"><br />
<br />
Parameters can be numbers,array,logical values.<br />
<br />
TRUE counted as 1 and 0 counted as FALSE<br />
<br />
Parameters have no numbers, MINA shows 0.<br />
<br />
</div><br />
----<br />
<div id="9SpaceContent" class="zcontent" align="left"><br />
<br />
{| id="TABLE3" class="SpreadSheet blue"<br />
|- class="even"<br />
| class=" " |<br />
| Column1<br />
| class=" " | Column2<br />
| class=" " | Column3<br />
| class=" " | Column4<br />
|- class="odd"<br />
| class=" " | Row1<br />
| class="sshl_f" | 3<br />
| class="sshl_f " | 0<br />
| class="sshl_f" | 5<br />
| class="sshl_f" | 1<br />
|- class="even"<br />
| class=" " | Row2<br />
| class="sshl_f" | 5<br />
| class="sshl_f " |<br />
| class="sshl_f" | 2<br />
| class=" " |<br />
|- class="odd"<br />
| Row3<br />
| class="sshl_f " | 0<br />
| class=" " |<br />
| class=" " | TRUE<br />
|<br />
|- class="even"<br />
| Row4<br />
| class="sshl_f" | 20<br />
| class=" " |<br />
| class="sshl_f" | 6<br />
|<br />
|- class="odd"<br />
| class=" " | Row5<br />
| class=" sshl_f " |<br />
| class=" " |<br />
| class="sshl_f" | 10<br />
|<br />
|- class="even"<br />
| Row6<br />
| class=" " |<br />
| class=" " |<br />
| class="SelectTD" |<br />
|<br />
|}<br />
<br />
<div align="left"></div>''''''</div><br />
----<br />
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"><br />
<br />
MINA<br />
<br />
</div></div><br />
----<br />
<div id="8SpaceContent" class="zcontent" align="left"><br />
<br />
Lets see an example in (Column3,Row1)<br />
<br />
<nowiki>=MINA(B2:B5)</nowiki><br />
<br />
Smallest number from (3,5,0,20) is 0.<br />
<br />
Consider another example<br />
<br />
<nowiki>=MINA(5,2,TRUE,6,10)</nowiki><br />
<br />
MINA return the smallest number from(5,2,TRUE,6,10)<br />
<br />
is 1.<br />
<br />
</div><br />
----<br />
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div><br />
----<br />
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div><br />
----<br />
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div><br />
----<br />
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div><br />
----</div>
MassBot1