MAX

Description

Returns the largest value in the specified list of numbers.

Syntax

MAX ( number_list )

Parameter	Description
number_list	A list of up to 30 comma-separated numbers or source fields: The list can contain numbers, logical values, or text representations of numbers. Source fields can contain only a single value. Error values or text that cannot be translated into numbers return errors. If there are no numbers in the list, 0 is returned.

Examples

This function returns 500:

MAX(50, 100, 150, 500, 200)

For the following example, assuming that S7 contains 34, S8 contains 227, and S9 contains 74, this function returns 227:

MAX(S7,S8,S9)