Difference between revisions of "Manuals/calci/MAX"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MAX'''('''n1''',n2,...) Where n1,n2……are numbers. </div> ---- <div id="1SpaceContent" class="zcontent"...") |
|||
| (13 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''MAX()'''</div><br/> |
| + | *Parameters are any set of numbers. | ||
| + | **MAX(), returns the maximum value in a list of arguments. | ||
| − | + | == 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 <math>MAX()</math>. | |
| − | + | **Parameters are any set of numbers. | |
| + | *For e.g.,MAX(2..8,10..15) | ||
| − | + | == Examples == | |
| − | + | <div id="2SpaceContent" class="zcontent" align="left"><div> | |
| − | |||
| − | <div id=" | ||
| − | + | {| id="TABLE1" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class="sshl_f" | 0.02 | ||
| + | | class="sshl_f" | | ||
| − | + | |- class="odd" | |
| − | + | | class="sshl_f" | 0.5 | |
| − | + | | class="sshl_f" | | |
| − | |||
| − | |||
| − | + | |- class="even" | |
| − | | | + | | class="sshl_f" | -6 |
| − | |- | + | | class="sshl_f" | |
| − | | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" | TRUE | ||
| + | | class="sshl_f" | | ||
| − | + | |- class="even" | |
| − | |- | + | | class="sshl_f" | 100 |
| − | | | + | | class="sshl_f" | |
| − | + | |- class="odd" | |
| + | | class="sshl_f" | NAME | ||
| + | | class="sshl_f" | | ||
| − | + | |} | |
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | =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== | |
| − | + | {{#ev:youtube|Ixj2CXw-Xcc|280|center|MAX}} | |
| − | |} | ||
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/MAXA| MAXA]] | |
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Large_numbers Large 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 16:27, 7 August 2018
MAX()
- Parameters are any set of numbers.
- MAX(), returns the maximum value in a list of arguments.
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