Difference between revisions of "Manuals/calci/MAXA"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =MAXA( | + | =MAXA()= |
| − | * | + | *Parameters are any set of numbers. |
MAXA() calculates the largest value in a set of given values. | MAXA() calculates the largest value in a set of given values. | ||
| Line 7: | Line 7: | ||
== Description == | == Description == | ||
| − | MAXA( | + | MAXA() |
For Example, | For Example, | ||
| Line 15: | Line 15: | ||
MAXA(-3,0.02,TRUE,-7) ''returns 1'' | MAXA(-3,0.02,TRUE,-7) ''returns 1'' | ||
| − | *Arguments | + | *Arguments can be numbers, logical values, text, array or references that contain numbers. |
*Calci displays zero if the arguments do not have any numbers. | *Calci displays zero if the arguments do not have any numbers. | ||
*If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value. | *If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value. | ||
| Line 21: | Line 21: | ||
==ZOS== | ==ZOS== | ||
| − | *The syntax is to calculate maximum numbers in the set of numbers in ZOS is <math>MAXA( | + | *The syntax is to calculate maximum numbers in the set of numbers in ZOS is <math>MAXA()</math>. |
| − | ** | + | **Parameters are any set of numbers. |
*For e.g.,MAXA(-10..-1,false) | *For e.g.,MAXA(-10..-1,false) | ||
Revision as of 12:33, 8 June 2018
MAXA()
- Parameters are any set of numbers.
MAXA() calculates the largest value in a set of given values.
Description
MAXA()
For Example,
MAXA(140,5,-2,10) returns 140
MAXA(-3,0.02,TRUE,-7) returns 1
- Arguments can be numbers, logical values, text, array or references that contain numbers.
- Calci displays zero if the arguments do not have any numbers.
- If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value.
- The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0.
ZOS
- The syntax is to calculate maximum numbers in the 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 MAXA()}
.
- Parameters are any set of numbers.
- For e.g.,MAXA(-10..-1,false)
Examples
| 0.02 | |
| 0.5 | |
| -6 | |
| TRUE | |
| FALSE | |
| NAME |
=MAXA(A1:A6) : Calculates the maximum value in the range A1 to A6. Displays 1 (for TRUE ) as a result. =MAXA(-2,FALSE) : Calculates the maximum value between -2 and FALSE. Displays 0 (for FALSE) as a result. =MAXA(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays 2 as a result.
Related Videos
See Also
References