Formulas and Functions

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