beautypg.com

Mina, 273 mina – Apple iWork '09 User Manual

Page 273

background image

Chapter 10

Statistical Functions

273

“MINA” on page 273

“SMALL” on page 288

“Listing of Statistical Functions” on page 225

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

MINA

The MINA function returns the smallest number in a collection of values that may
include text and Boolean values.

MINA(value, value…)

Â

value: A value. value can contain any value type.

Â

value…:  Optionally include one or more additional values. All numeric values must
be of the same type. You cannot mix numbers, dates, and duration values.

Usage Notes

Text values and logical FALSE are given a value of 0 and logical TRUE is given a value

Â

of 1.
To determine the smallest value of a collection that contains only numbers or dates,

Â

use the MIN function.

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.

Related Topics
For related functions and additional information, see:

“MAXA” on page 270

“MIN” on page 272

“Listing of Statistical Functions” on page 225

Value Types” on page 36

The Elements of Formulas” on page 15