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 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 MAX()}
.
- 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