Returns the minimum value of 1 to 30 numbers (cell C1).
MAX(number1, numnber2, ..)
Returns the maximum value of 1 to 30 numbers (cell C2).
Entered as array functions gives you more control over what is included or
excluded. In the example, the user wants to find the minimum value excluding
ZERO. Here the formula in cell C2 is: {=MIN(IF(A1:A11<>C1,A1:A11))}
It uses IF to include or exclude the value in cell C1 from the array which is
passed to MIN. MIN then finds the minimum value passed to it.
These functions can be combined with
conditional formatting to
highlight maximum and minimum values
Published: 14-May-2003
Last edited:
01-Apr-2007 19:11
