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"...") |
|||
| Line 1: | Line 1: | ||
| − | + | =MAX(n1,n2,...)= | |
| − | + | *Where n1,n2,... are numbers. | |
| − | + | MAX() calculates the largest value in a set of values. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | MAX(n1,n2,....) | |
| − | + | For Example, | |
| − | |||
| − | |||
| − | + | MAX(10,40,5,2,100) ''returns 100'' | |
| + | MAX(-3,0.02,TRUE,-7) ''returns 1'' | ||
| − | + | *Calci displays zero if the arguments do not have any numbers. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"><div> | <div id="2SpaceContent" class="zcontent" align="left"><div> | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | 15 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f " | 15 | ||
| class="sshl_f" | 32 | | class="sshl_f" | 32 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |
| − | + | |- class="odd" | |
| class="sshl_f" | 20 | | class="sshl_f" | 20 | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | | + | | class="sshl_f" | |
| − | | | + | |
| + | |- class="even" | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |
| − | + | |- class="odd" | |
| class="sshl_f" | 32 | | class="sshl_f" | 32 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | | class="sshl_f" | | |
| − | + | ||
| − | |||
| − | | class="sshl_f | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" | |
| + | | class="sshl_f" | 13 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" | | ||
| + | | class="sshl_f" | 13.5 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 21:15, 5 December 2013
MAX(n1,n2,...)
- Where n1,n2,... are numbers.
MAX() calculates the largest value in a set of values.
Description
MAX(n1,n2,....)
For Example,
MAX(10,40,5,2,100) returns 100 MAX(-3,0.02,TRUE,-7) returns 1
- Calci displays zero if the arguments do not have any numbers.
Examples
| 15 | 32 | |
| 20 | ||
| 3 | ||
| 32 | ||
| 13 | ||
| 13.5 |