next up previous contents index
Next: MDURATION Up: A. Function Reference Previous: MATCH   Contents   Index


MAX

Syntax: MAX(argumentlist)

argumentlist = any combination or numbers, cells, or ranges

MAX returns the maximum of its arguments. Blank cells and cells containing strings are not counted.

Examples:

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

Excel function: MAX


next up previous contents index
Next: MDURATION Up: A. Function Reference Previous: MATCH   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003