Apple numbers User Manual

 Dictionary of Functions

 

  

The MIN function finds the smallest number in the list of arguments.

MIN(number, [number, . . .])

 number:  A series of numbers, numeric expressions, or references to cells containing 

numbers or numeric expressions.

Notes
Cells that don’t contain numbers are ignored.

Text entered directly in the arguments results in an error.

  

The MINA function finds the smallest number in a set of values. In addition to numeric 
values, text values and logical FALSE are counted as 0 and logical TRUE is counted as 1.

MINA(value, [value, . . .])

 values:  A series of numbers or numeric expressions, or references to cells containing 

numbers, numeric expressions, text, or Boolean values. Text values are evaluated as 0.

Notes
Text entered directly in the arguments results in an error.
  

MID("lorem ipsum dolor sit amet",7, 5) returns "ipsum".

MID("1234567890",4,3) returns "456".

MID("shorten", 5, 20) returns "ten".

MIN(5, 5, 5, 5, 6) returns 5.

MIN(1, 2, 3, 4, 5) returns 1.

MINA(1, 2, 3, 4) returns 1.

MINA(A1:C1), where A1:C1 contains -1, -10, hello, returns -10.

MINA(A1:C1), where A1:C1 contains 1, 10, hello, returns 0.