Difference between revisions of "Manuals/calci/MAX"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
MAX(10,40,5,2,100) ''returns 100'' | MAX(10,40,5,2,100) ''returns 100'' | ||
| + | |||
MAX(-3,0.02,TRUE,-7) ''returns 1'' | MAX(-3,0.02,TRUE,-7) ''returns 1'' | ||
| Line 22: | Line 23: | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 0.02 |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 0.5 |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | -6 |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | TRUE |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| + | | class="sshl_f" | 100 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| + | | class="sshl_f" | NAME | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | 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. | ||
Revision as of 16:31, 6 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
| 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.