Difference between revisions of "Manuals/calci/MAXA"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =MAXA( | + | <div style="font-size:30px">'''MAXA()'''</div><br/> |
| − | + | *Parameters are any set of numbers. | |
| − | + | **MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical values. | |
| − | |||
| − | MAXA() | ||
== Description == | == Description == | ||
| − | + | MAXA() | |
| − | MAXA( | + | *For Example,MAXA(140,5,-2,10) ''returns 140'' |
| − | + | *MAXA(-3,0.02,TRUE,-7) ''returns 1'' | |
| − | For Example, | + | *Arguments can be numbers, logical values, text, array or references that contain numbers. |
| − | |||
| − | MAXA(140,5,-2,10) ''returns 140'' | ||
| − | |||
| − | MAXA(-3,0.02,TRUE,-7) ''returns 1'' | ||
| − | |||
| − | *Arguments | ||
*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. | ||
*The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0. | *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 <math>MAXA()</math>. | ||
| + | **Parameters are any set of numbers. | ||
| + | *For e.g.,MAXA(-10..-1,false) | ||
== Examples == | == Examples == | ||
| Line 54: | Line 51: | ||
=MAXA(-2,FALSE) : Calculates the maximum value between -2 and FALSE. Displays ''0'' (for FALSE) 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. | =MAXA(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays ''2'' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|Wolmo-lcHZ4|280|center|MAXA}} | ||
== See Also == | == See Also == | ||
| Line 63: | Line 64: | ||
*[http://en.wikipedia.org/wiki/Large_numbers Large Number] | *[http://en.wikipedia.org/wiki/Large_numbers Large Number] | ||
*[http://en.wikipedia.org/wiki/Small_number Small Number] | *[http://en.wikipedia.org/wiki/Small_number Small Number] | ||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 14:22, 8 August 2018
MAXA()
- Parameters are any set of numbers.
- MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical 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 .
- 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