Paul,
This is an array variation of the formula
=MAX(IF(NOT(ISNA(A1:A20)),A1:A20))
commit it with Ctrl-Shift-Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Paul" wrote in message
...
=Max(A1:A20) returns #N/A when one or more of the cells in
the series contains #N/A.
Is there a way to cause the formula to overlook the #N/A
and return the maximum value? Or, is there another
function that would accomplish this?
|