Difference between revisions of "Manuals/calci/MAXA"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MAXA'''('''v1''',v2,...) where v1,v2.. are the values. <font color="#484848"><font face="Arial, sans-serif"><fo...") |
|||
| Line 1: | Line 1: | ||
| − | + | =MAXA(n1,n2,...)= | |
| − | + | *Where n1,n2,... are numbers. | |
| − | + | MAXA() calculates the largest value in a set of given values. | |
| − | |||
| − | |||
| − | + | == Description == | |
| − | + | MAXA(n1,n2,....) | |
| − | --- | + | |
| − | + | For Example, | |
| − | + | ||
| − | + | MAXA(140,5,-2,10) ''returns 140'' | |
| − | + | ||
| − | + | MAXA(-3,0.02,TRUE,-7) ''returns 1'' | |
| − | + | ||
| − | <div id=" | + | *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, or as a part of array or reference, are counted in finding the MAX value. | ||
| + | *The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0. | ||
| + | |||
| + | == Examples == | ||
| + | |||
| + | <div id="2SpaceContent" class="zcontent" align="left"><div> | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" | 0.02 |
| − | | class=" " | | + | | class="sshl_f" | |
| − | | class=" | + | | class="sshl_f" | |
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 0.5 | |
| − | |||
| − | | class="sshl_f" | | ||
| 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="sshl_f" | FALSE | |
| − | + | | class="sshl_f" | | |
| + | | class="sshl_f" | | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" | NAME | ||
| + | | class="sshl_f" | | ||
| + | | class="sshl_f" | | ||
| − | + | |} | |
| − | + | =MAXA(A1:A6) : Calculates the maximum value in the range A1 to A6. Displays ''1'' (for TRUE ) as a result. | |
| + | =MAXA(-2,FALSE) : Calculates the maximum value between -2 and FALSE. Displays ''0'' (for FALSE) as a result. | ||
| + | =MAXA(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays ''2'' as a result. | ||
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/MAX| MAX]] | |
| − | |||
| − | |||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Large_numbers Large Number] | |
| − | + | *[http://en.wikipedia.org/wiki/Small_number Small Number] | |
Revision as of 17:57, 6 December 2013
MAXA(n1,n2,...)
- Where n1,n2,... are numbers.
MAXA() calculates the largest value in a set of given values.
Description
MAXA(n1,n2,....)
For Example,
MAXA(140,5,-2,10) returns 140
MAXA(-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, or as a part of array or reference, are counted in finding the MAX value.
- The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0.
Examples
| 0.02 | ||
| 0.5 | ||
| -6 | ||
| TRUE | ||
| FALSE | ||
| NAME |
=MAXA(A1:A6) : Calculates the maximum value in the range A1 to A6. Displays 1 (for TRUE ) as a result. =MAXA(-2,FALSE) : Calculates the maximum value between -2 and FALSE. Displays 0 (for FALSE) as a result. =MAXA(A1:A3, 2) : Calculates the maximum value in the range A1 to A3 and value 2. Displays 2 as a result.