max
1. Syntax:
Value
Number
max
(
Range
source)
Description:
Finds the numeric maximum in
source
.
2. Syntax:
Value
Number
max
(
List
Number
source)
Description:
Finds the numeric maximum in the list of integers.
Examples:
($d1:$d3) = max($a:$c)
Before:
A
B
C
D
1
1
6
7
2
12
one
8
3
3
-5
20
4
5
6
After:
A
B
C
D
1
1
6
7
7
2
12
one
8
12
3
3
4
20
20
4
5
6
($a1) = max($b1, $f3, 12, 14.5)