 Formula Engine Reference Guide |
|
Back to Class Index
MAX(argumentlist)
This function returns the maximum of its arguments. Blank cells and cells containing strings are not counted.
Parameters
argumentlist
Any combination or numbers, cells, or ranges
Example
MAX(4, 56, 33, 100, 0, -1) = 100
MAX(S3..S7) = -1
where S3..S7 = -1, -4, -99, -20, -1.5
MAX(A1..B2) = 93
where A1 = 0, A2 = -93, B1 = 93, and B2 = 7