Hi,

Instead of trying to work around the error, why not fix it?

if you post your formula that is returning the #REF! error I'm sure someone
will suggest a fix for you.

Regards!
Jean-Guy



"RichardSchollar" wrote:

Hi Chris

=MAX(IF(ISNUMBER(A1:A100),A1:A100))

Confirmed with Ctrl+Shift+Enter will exclude any #REFs (this is an
array formula).

Hope this helps!

Richard

On 26 Jan, 13:46, Chris wrote:
If I try to use the max function on a column with a cell with #REF!, I get
#REF! as my result. I tried doing an if statement saying if a cell = #REF!
make it a 0 but it's not working. Anything else I can do?