Documentation/Calc Functions/MAX

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

MAX

Category:

Statistical Analysis

Summary:

Identifies the maximum value in the list of numbers passed as arguments, ignoring empty cells and cells containing text.

Syntax:

MAX(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:

Returns the largest value from the list of numbers, ignoring empty cells and cells containing text passed as arguments.

Arguments:

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers. Empty cells and cells containing text are ignored. The logical value TRUE counts as 1, while FALSE counts as 0.

  • The function returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s).
  • Passing a literal string argument to MAX(), e.g. MAX("string"), results in an error.

Additional details:

Text cells are ignored by MAX(). The function MAXA() returns 0 if no value (numeric or text) and no error was encountered.

Examples:

Formula Description Returns
=MAX(A1:A5) where A1,A2,A3,A4,A5 are 1,2,3,4,5 returns the largest value from 1,2,3,4,5 5
=MAX(1.5;-2;0;-4.2) returns the largest value from 1.5,-2,0,-4.2 1.5

Related LibreOffice functions:

MAXA

MAXIFS

MIN

MINA

MINIFS

ODF standard:

Section 6.18.45, part 2

Equivalent Excel functions:

MAX