Microsoft Office Tutorials and References
In Depth Information
MAXA
MAX MAXA returns the largest value in a list of arguments.
=MAXA(value1,value2,...)
The MAXA function differs from the MAX 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.26 for a comparison on MAX and
MAXA .
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
MEDIAN
MEDIAN returns the median of the given numbers.
=MEDIAN(number1,number2,...)
The median is the number in the middle of the set of numbers, as opposed to the mean,
which is the average of the set of numbers. When the data set contains an odd number of
values, the value in the middle is returned (as shown in Figure 11.27). When the data set
contains an even number of values, the middle two values are averaged to determine the median.
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.27
The MEDIAN function
does not average the
entire set of numbers,
but simply returns
the middle number in
the set or the average
of the two middle
numbers (if the data
set contains an even
number of values).
Search JabSto ::




Custom Search