Microsoft Office Tutorials and References

In Depth Information

**Syntax**

Syntax

=MAX(number1,number2,...)

The MAX function returns the largest value in a set of values. The argu-

ments number1, number2, ... are one to 255 numbers for which you want to find

the maximum value. The remaining rules are similar to those for MIN, de-

scribed in the preceding section.

Finding a Minimum Text Value

Finding a Minimum Text Value

If you read the descriptions for MINA and MAXA, you might think that

the functions can be used to find the smallest text value in a range.

However, here is the Excel Help description for MAXA:

MAXA(value1,value2) returns the largest value in a list of arguments.

Text and logical values such as TRUE and FALSE are compared as well

as numbers.

The problem, however, is that text values are treated as the number 0 in

the compare operation. It is a struggle to imagine a scenario where this

would be mildly useful. If you have a series of positive numbers and

want to know if any of them are text, you can use =MINA(A1:A99). If the

result is 0, then you know that there is a text value in the range.

Similarly, if you have a range of negative numbers in A1:A99, you could

use =MAXA(A1:A99). If any of the values are text, the result returns 0

instead of a negative number.

MINA and MAXA could be used to evaluate a series of TRUE/FALSE val-

ues. FALSE values are treated as 0. TRUE values are treated as 1.

Using

Using
LARGE

Values in a List of Values

The MAX function discussed in the preceding section finds the single largest

value in a list. Sometimes it is interesting to find the top 10 values in a list.

Say that with a list of customer receivables, someone in accounts receiv-

able might want to call the top 10 receivables in an attempt to collect the

accounts. The LARGE function can find the first, second, third, and so on

largest values in a list.

LARGE
to Find the Top

to Find the Top
N
Values in a List of Values