Difference between revisions of "Manuals/calci/MAXA"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=MAXA(n1,n2,...)= | =MAXA(n1,n2,...)= | ||
| − | * | + | *where <math>n1,n2,...</math> are numbers. |
MAXA() calculates the largest value in a set of given values. | MAXA() calculates the largest value in a set of given values. | ||
| Line 15: | Line 15: | ||
MAXA(-3,0.02,TRUE,-7) ''returns 1'' | MAXA(-3,0.02,TRUE,-7) ''returns 1'' | ||
| − | *Arguments can be numbers, logical values, text, array or references that contain numbers. | + | *Arguments <math>n1,n2,...</math> can be numbers, logical values, text, array or references that contain numbers. |
*Calci displays zero if the arguments do not have any 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. | *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. | ||
Revision as of 17:22, 13 December 2013
MAXA(n1,n2,...)
- where are numbers.
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.