MAXA : General Usage
1
value
2
-3
3
0.1
4
-2
5
0.7
6
-1
7
8
9
Result
Formula
10
0.7
=MAXA(A2:A6)
11
5
=MAXA(A2:A6, -1, 5)
12
#VALUE!
=MINA(A2:A6, "Google")
13
1
=MAXA(A2:A6, TRUE)
14
0.7
=MAXA(A2:A6, FALSE)
15