Thread
:
#N/A
View Single Post
#
1
Paul
Posts: n/a
#N/A
=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?
Reply With Quote