Difference between revisions of "Manuals/calci/MIN"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MIN'''('''n1''',n2,...) '''Where n1,n2,….are numbers for which the '''the minimum value to be find. </div>...") |
|||
| (15 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px"> '''MIN()''' </div><br/> |
| + | *Parameters are any set of numbers. | ||
| + | **MIN(), returns the minimum value in a list of arguments. | ||
| − | + | ==Description== | |
| + | *This function gives the smallest number in a given set of values. | ||
| + | *In <math> MIN()</math>,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 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 function will return the result as error when any one of the argument is non-numeric 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 [[Manuals/calci/MINA | MINA ]] function. | ||
| − | + | ==ZOS== | |
| + | *The syntax is to calculate minimum number in the given set of numbers in ZOS is <math>MIN()</math>. | ||
| + | **Parameters are any set of numbers. | ||
| + | *For e.g., MIN(2..10,-11..-4) | ||
| − | + | ==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 | ||
| − | + | ==Related videos== | |
| − | + | {{#ev:youtube|jjFj92LdJAQ|280|center|MIN}} | |
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/MINA | MINA ]] | ||
| + | *[[Manuals/calci/MAX | MAX ]] | ||
| + | *[[Manuals/calci/MAXA | MAXA ]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Minimum Minimum] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | | | ||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 07:08, 3 June 2020
MIN()
- Parameters are any set of numbers.
- MIN(), returns the minimum value in a list of arguments.
Description
- This function gives the smallest number in a given set of values.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MIN()} ,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 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 function will return the result as error when any one of the argument is non-numeric 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.
ZOS
- The syntax is to calculate minimum number in the given set of numbers in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MIN()}
.
- Parameters are any set of numbers.
- For e.g., MIN(2..10,-11..-4)
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
Related videos
See Also
References