Manuals/calci/MAXA1
Jump to navigation
Jump to search
MAXA(n1,n2,n3.........)
MAXA(R1,R2,external R1............)
There is no limit to how many parameters pass to MAXA.
This function calculates the largest value from set of numbers.
Parameters can be numbers,array,logical values
TRUE counted as 1 and FALSE counted as 0
Parameters have no numbers, MAXA shows 0.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 17 | 0.1 | 1 |
| Row2 | 7 | 0.5 | ||
| Row3 | FALSE | TRUE | ||
| Row4 | 17 | 0.8 | ||
| Row5 | 0.9 | |||
| Row6 |
MAXA
Lets see an example in (Column3,Row1)
=MAXA(B2:B5)
Largest number from (2,7,FALSE,17) is 17.
Consider another example
=MAXA(0.1,0.5,TRUE,0.8,0.9)
MAXA return the smallest number from(0.1,0.5,TRUE,0.8,0.9)
is 1.
Syntax
Remarks
Examples
Description