Documentation/Calc Functions/MINA

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

MINA

Category:

Statistical Analysis

Summary:

Identifies the minimum value in the list of numbers passed as arguments. Cells containing text are given the value 0 and empty cells are ignored.

Syntax:

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

Returns:

Returns the smallest value from the list of numbers passed as arguments. Empty cells are ignored and cells containing text are given the value 0.

Arguments:

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

  • The function MINA() returns 0 if no value (numeric or text) and no error was encountered either directly in arguments or in the cell range(s) passed as cell reference(s).
  • Passing a literal string argument to MINA(), e.g. MINA("string"), counts it as 0.

Additional details:

None

Examples:

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

Related LibreOffice functions:

MAX

MAXA

MAXIFS

MIN

MINIFS

ODF standard:

Section 6.19.49, part 2

Equivalent Excel functions:

MINA