Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

MAX function

MAX(First, Other...) MAX(First; Other...)

First

Number or { Number }

The first parameter.

Other

Number or { Number } (accepts many)

Additional parameters.

Returns

Number

The largest number of the given numbers.

Returns the largest number of the given numbers. MAX(4, 22, -4, 32)MAX(4; 22; -4; 32) returns 32.

MAX only accepts numbers, or number arrays. Use MAXA instead of you also need to evaluate logical values and text strings representing numbers. Use MAXIFS to only consider values satisfying one or several conditions.

Examples

MAX(4, 22, -4, 32)MAX(4; 22; -4; 32)

Returns 32.

MAX(4, 22, -4, BLANK(), 32)MAX(4; 22; -4; BLANK(); 32)

Returns 32. Blank values are ignored.

MAX({ 4, 22, -4, 32 })MAX({ 4; 22; -4; 32 })

Returns 32. Arrays are supported.

MAX(4, 22, { -4, 32 })MAX(4; 22; { -4; 32 })

Returns 32. Arrays mixed with regular numbers are supported.

MAX(4, 22, { BLANK(), -4, 32 })MAX(4; 22; { BLANK(); -4; 32 })

Returns 32. Arrays mixed with regular numbers are supported. Blank values are ignored.

INDEX(Employees!Name, XMATCH(MAX(Employees!Salary), Employees!Salary))INDEX(Employees!Name; XMATCH(MAX(Employees!Salary); Employees!Salary))

Returns the name of the employee with the highest salary. Name and Salary are both named values, belonging to the Employees screen, whose formulas are arrays specifying the contents of these table columns. These named values and their formulas can be created and maintained using a spreadsheet-like editor in Calcapp Creator.