http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2FMIN1
Manuals/calci/MIN1 - Revision history
2026-06-25T14:50:10Z
Revision history for this page on the wiki
MediaWiki 1.35.2
http://wiki.zcubes.com/index.php?title=Manuals/calci/MIN1&diff=500&oldid=prev
MassBot1: Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MIN(n1,n2,n3.........) MIN(R1,R2,external R1............) There is no limit to how many parameters pass to MIN...."
2013-10-25T02:40:09Z
<p>Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MIN(n1,n2,n3.........) MIN(R1,R2,external R1............) There is no limit to how many parameters pass to MIN...."</p>
<p><b>New page</b></p><div><div id="6SpaceContent" class="zcontent" align="left"><br />
<br />
MIN(n1,n2,n3.........)<br />
<br />
MIN(R1,R2,external R1............)<br />
<br />
There is no limit to how many parameters pass to MIN.<br />
<br />
</div><br />
----<br />
<div id="1SpaceContent" class="zcontent" align="left"><br />
<br />
This function returns the smallest number from set of numbers.<br />
<br />
</div><br />
----<br />
<div id="7SpaceContent" class="zcontent" align="left"><br />
<br />
Parameters can be numbers,array or references that contain numbers.<br />
<br />
Parameters have no numbers, MIN returns 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 />
| Column2<br />
| Column3<br />
| Column4<br />
|- class="odd"<br />
| class=" " | Row1<br />
| class=" " | 2<br />
| class="sshl_f" | 2<br />
| class=" " | 2<br />
| class="sshl_f" | 0<br />
|- class="even"<br />
| class=" " | Row2<br />
| class=" " | 7<br />
| class=" sshl_f " |<br />
| class=" " | 5<br />
| class=" sshl_f sshl_t ChangeBGColor" |<br />
|- class="odd"<br />
| Row3<br />
| class=" " | 12<br />
|<br />
| class=" " | 8<br />
| class="sshl_t" |<br />
|- class="even"<br />
| Row4<br />
| class=" " | 17<br />
|<br />
| class=" " | 9<br />
| class="sshl_t" |<br />
|- class="odd"<br />
| class=" " | Row5<br />
| class=" " |<br />
|<br />
| class="sshl_f " | 0<br />
| class="sshl_t" |<br />
|- class="even"<br />
| Row6<br />
|<br />
|<br />
| class=" " |<br />
| class="sshl_t" |<br />
|}<br />
<br />
<div align="left"></div>''''''</div><br />
----<br />
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">MIN </div></div><br />
----<br />
<div id="8SpaceContent" class="zcontent" align="left"><br />
<br />
Lets see an example<br />
<br />
<nowiki>=MIN(B2:B5)</nowiki><br />
<br />
Smallest number from (2,7,12,17) is 2.<br />
<br />
Consider another example<br />
<br />
<nowiki>=MIN(2,5,8,9,0)</nowiki><br />
<br />
MIN return the smallest number from(2,5,8,9,0) is 0.<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