Difference between revisions of "Manuals/calci/MINA"

Latest revision as of 14:42, 8 August 2018

MINA()

Parameters are any set of numbers.
- MINA(), returns the smallest value in a list of arguments, including numbers, text, and logical values.

This function gives the smallest number in a given set of values.
In $MINA()$ , First parameter is required and from the second parameter are optional.
Here Parameters can be numbers, names, arrays or references that contain numbers.
Also logical values and text representations can be valid.
Suppose the argument contain the logical value TRUE , it is considered as 1 and if it is FALSE ,it is considered as 0.
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.
If we want make logical values and text representations of numbers as dummy then we can use the MIN function.

The syntax is to calculate minimum number in the given set of numbers in ZOS is .
- Parameters are any set of numbers.
For e.g.,MINA(1..5,false)

=MINA(5,15,25)=5
=MINA(-1,-6,-9,-15)=-15
=MINA(0.252,0.234,0.214,0.2)=0.2
=MINA(2,5,7,TRUE)=1
=MINA(4,7,9,FALSE)=0

@@ Line 1: / Line 1: @@
-<div style="font-size:30px"> '''MINA(n1,n2,n3,..)''' </div><br/>
+<div style="font-size:30px"> '''MINA()''' </div><br/>
-*<math>n1,n2,n3..., </math> are the  numbers.
+*Parameters are any set of numbers.
+**MINA(), returns the smallest value in a list of arguments, including numbers, text, and logical values.
 ==Description==
 *This function gives the smallest number in a given set of values.
-*In <math>MINA(n1,n2,n3,...), n1</math> is required and <math>n2,n3... </math>,are optional.
+*In <math>MINA()</math>, First parameter is required and from the second parameter are optional.
-*Here <math>n1,n2,n3,...</math>, can be numbers, names, arrays or references that contain numbers.
+*Here Parameters can be numbers, names, arrays or references that contain numbers.
 *Also logical values and text  representations can be valid.
 *Suppose the argument contain the logical value TRUE , it is considered as 1 and if it is FALSE ,it is considered as 0.
@@ Line 15: / Line 16: @@
 ==ZOS==
-*The syntax is to calculate minimum number in the given set of numbers in ZOS is <math>MINA(n1,n2,...)</math>.
+*The syntax is to calculate minimum number in the given set of numbers in ZOS is <math>MINA()</math>.
-**<math>n1,n2,n3,... </math> are the  numbers.
+**Parameters are any set of  numbers.
 *For e.g.,MINA(1..5,false)