formulas with "NA"?

[MetLife]

Hi,

I asked a similar question with the "SUM" function. Now I want to use Max and Min but the range will occasionally have "#N/A" in the data.

I want the max/min to skip those cells. How do I construct this formula?

Thanks

 

[JoeMo]

Enter with ctrl+shift+enter, change range to suit:

=MAX(IF(NOT(ISNA(B2:B13)),B2:B13))

 

[MetLife]

OK thanks it works, I just needed to make it an array.

 

[Rick Rothstein]

Here is another formula that should also work... it also needs to be entered using CTRL+SHIFT+ENTER.

=MAX(IFERROR(B2:B13,))