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,...)
Search JabSto ::




Custom Search