MAX
Syntax:
MAX ( argument-list )
Description: Computes the largest of a set of numbers.
Arguments:
Name |
Type |
Description |
---|---|---|
argument-list |
logical, number, name, arrays, reference to number. Any argument can be an array or a reference to an array. |
The arguments in argument-list designate the values for which the largest value is to be computed. Logical values and text representations of numbers occurring directly in the list of arguments are included. However, logical values and numbers in strings and are ignored inside references.
Note: : To include these, use
3.17.7.204). ] If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.MAXA (§ |
Return Type and Value: number – The largest of a set of numbers; however, if the arguments contain no numbers, zero is returned.
example:
Consider the case in which cell B3
contains 0
:MAX(-10,-12,-15,B3)
results in -10
MAXA(-10,-12,-15,B3)
results in 0
]