writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − '''MIN'''('''n1''',n2,...)+ + + + + + + + + − '''Where n1,n2,….are numbers for which the '''the minimum value to be find.+ + + + + + + + + + − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − It calculates the smallest number in a set of values.+ + + + − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − MIN+ − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − {| width="38" cellpadding="1" − | <font size="3" face="Tahoma"> − − <font size="3">21</font> − − </font> − |- − | <font size="3" face="Tahoma"> − − <font size="3">17</font> − − </font> − |- − | <font size="3" face="Tahoma"> − − <font size="3">9</font> − − </font> − |- − | <font size="3" face="Tahoma"> − − <font size="3">37</font> − − </font> − |- − | <font size="3" face="Tahoma"> − − <font size="3">12</font> − − </font> − |} − − <font size="3" face="Times New Roman"> − − <font size="3">Let’s see an example in (Column1 Row 1:Column1Row5)</font> − − <font size="3">MIN (n1, n2…)</font> − − <font size="3">i.e.MIN (C1R1:C1R5) is 9</font> − − </font></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div> − − {| id="TABLE1" class="SpreadSheet blue" − |- class="even" − | class=" " | − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − |- class="odd" − | class=" " | Row1 − | class=" " | 21 − | class="sshl_f" | 9 − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 17 − | class="sshl_f SelectTD SelectTD" | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row3 − | class="sshl_f" | 9 − | class=" " | − | class="sshl_f" | − |- class="even" − | class="sshl_f" | Row4 − | class="sshl_f" | 37 − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row5 − | class=" " | 12 − | class="sshl_f" | − | − |} − − <div align="left"></div>''''''</div></div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px"> '''MIN(n1,n2,n3,..)''' </div><br/>
*<math>n1,n2,n3…, </math> are the numbers.
==Description==
*This function gives the smallest number in a given set of values.
*In <math> MIN(n1,n2,n3,…)</math> <math>n1</math> is required and <math> n2,n3….</math> ,are optional.
*Here <math> n1,n2,n3,...</math>, can be numbers, names, arrays or references that contain numbers.
*Also logical values and text representation can be valid when we are entering directly.
*In a referred array only numbers are considered.Empty cells,logical values or text in the referred array are not considered.
*suppose the arguments contain no numbers then this gives the value as 0.
*This functon will return the result as error when any one of the argument is nonnumeric or the referred array cannot translated in to numbers.
*suppose we want to consider the logical values in a referred array , we can include in the MINA function.
==Examples==
#MIN(10,15,28,87)=10
#MIN(-5,-8,-15,0)=-15
#MIN(0.45,0.265,0.314,0.121)=0.121
#MIN(4,7,9,TRUE)=1
#MIN(4,7,9,FALSE)=0
5
8
TRUE
MIN(B1:B3)=5
==See Also==
*[[Manuals/calci/MINA | MINA ]]
*[[Manuals/calci/MAX | MAX ]]
*[[Manuals/calci/MAXA | MAXA ]]
==References==