Mina – Apple Numbers '08 User Manual

Page 249

Advertising
background image

Chapter 12

Dictionary of Functions

249

MIN

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.

MINA

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.

Examples

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

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

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

Examples

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

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

Examples

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.

Advertising