MAX Function

Returns the largest number from a list. Largest means closest to positive infinity.

Syntax

MAX(number1,number2,...,numberN)

Parameters

Name

Required/Optional

Data Type

Description

number1

Required

Varies

The first number in the list.

number2

Optional

Varies

The second number in the list.

numberN

Optional

Varies

The nth number in the list.

Return Value

Varies

Example

MAX(13 in,1 ft, 20 cm)

Returns 13 inches.