Difference between revisions of "Manuals/calci/MAX"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =MAX( | + | =MAX()= |
| − | * | + | *Parameters are any set of numbers. |
MAX() calculates the largest value in a set of given values. | MAX() calculates the largest value in a set of given values. | ||
| Line 7: | Line 7: | ||
== Description == | == Description == | ||
| − | MAX( | + | MAX() |
For Example, | For Example, | ||
| Line 15: | Line 15: | ||
MAX(-3,0.02,TRUE,-7) ''returns 1'' | MAX(-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, they are considered in finding the MAX value. | *If the logical values and text values are entered directly in the argument, they are considered in finding the MAX value. | ||
| Line 21: | Line 21: | ||
==ZOS== | ==ZOS== | ||
| − | *The syntax is to calculate the maximum value in the set of numbers in ZOS is <math>MAX( | + | *The syntax is to calculate the maximum value in the set of numbers in ZOS is <math>MAX()</math>. |
| − | ** | + | **Parameters are any set of numbers. |
*For e.g.,MAX(2..8,10..15) | *For e.g.,MAX(2..8,10..15) | ||
Revision as of 13:29, 8 June 2018
MAX()
- Parameters are any set of numbers.
MAX() calculates the largest value in a set of given values.
Description
MAX()
For Example,
MAX(10,40,5,2,100) returns 100
MAX(-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, they are considered in finding the MAX value.
- If the logical values and text values are entered as a part of array or reference, they are not counted.
ZOS
- The syntax is to calculate the maximum value in the set of numbers in ZOS is .
- Parameters are any set of numbers.
- For e.g.,MAX(2..8,10..15)
.
Examples
| 0.02 | |
| 0.5 | |
| -6 | |
| TRUE | |
| 100 | |
| NAME |
=MAX(A1:A6) : Calculates the maximum value in the range A1 to A6. TRUE and NAME are not counted. Displays 100 as a result. =MAX(200,A3) : Calculates the maximum value between 200 and -6. Displays 200 as a result. =MAX(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