Difference between revisions of "Manuals/calci/MIN"

Revision as of 08:13, 25 December 2013

MIN(n1,n2,n3,..)

Failed to parse (syntax error): {\displaystyle n1,n2,n3…, } are the numbers.

This function gives the smallest number in a given set of values.
In Failed to parse (syntax error): {\displaystyle MIN(n1,n2,n3,…)} $n1$ is required and Failed to parse (syntax error): {\displaystyle n2,n3….} ,are optional.
Here $n1,n2,n3,...$ , 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.

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

@@ Line 10: / Line 10: @@
 *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.
+*suppose we want to consider the logical values in a referred array , we can include in the [[MINA]] function.
 ==Examples==