Microsoft Office Tutorials and References

In Depth Information

**MIN**

MIN
MIN returns the smallest number in a set of values.=MIN(number1,number2,...)

Use the
MIN
function to display the smallest sales figure, loss due to shrink, employee

absentee rate, and so on, in a group of values. Figure 11.28 shows an example of the
MIN
function.

Is the cell reference(s), range name, or array that makes up the data set.

Up to 30 arguments (unique data sets) can be specified.

NUMBER N

Figure 11.28

While the
MIN
function

evaluates cells containing

numerical data, use

MINA
when you need to

evaluate data containing

text or logical values.

MIN
MINA
returns the smallest value in a list of arguments.

=MINA(value1,value2,...)

The
MINA
function differs from the
MIN
function in that it will also evaluate logical values such

as TRUE and FALSE. TRUE evaluates to one (1); FALSE evaluates to zero (0). Arguments

that contain text also evaluate to zero. Refer to Figure 11.28 for a comparison of
MIN
and
MINA
.

Is the cell reference(s), range name, text representations of numbers,

array, or logical values that makes up the data set. Up to 30 arguments

(unique data sets) can be specified. Text values in an array argument are

ignored.

VALUE N

MOD
MODE
returns the most frequently occurring, or repetitive, value in an array or range of data.

=MODE(number1,number2,...)