Difference between revisions of "Manuals/calci/MINA"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
*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. | *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 [[Manuals/calci/MIN | MIN ]] function. | *If we want make logical values and text representations of numbers as dummy then we can use the [[Manuals/calci/MIN | MIN ]] function. | ||
| + | |||
| + | ==ZOS Section== | ||
| + | *The syntax is to calculate minimum number in the given set of numbers in ZOS is <math>MINA(n1,n2,...)</math>. | ||
| + | **<math>n1,n2,n3…, </math> are the numbers. | ||
| + | *For e.g.,MINA(1..5,false) | ||
==Examples== | ==Examples== | ||
Revision as of 23:09, 2 July 2014
MINA(n1,n2,n3,..)
- 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 n1,n2,n3…, } are the numbers.
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 MINA(n1,n2,n3,…), n1} is required and 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 n2,n3… } ,are optional.
- Here 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 n1,n2,n3,...} , 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.
ZOS Section
- 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 MINA(n1,n2,...)}
.
- 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 n1,n2,n3…, } are the numbers.
- For e.g.,MINA(1..5,false)
Examples
- =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