#REF!
 

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?

#REF!
 

One way

Try, array-entered (press CTRL+SHIFT+ENTER) in say B1:
=MAX(IF(ISNUMBER(A1:A10),A1:A10))

Adapt the range to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?

#REF!
 

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?

#REF!
 

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?

#REF!
 

Thanks!

"Max" wrote:

One way

Try, array-entered (press CTRL+SHIFT+ENTER) in say B1:
=MAX(IF(ISNUMBER(A1:A10),A1:A10))

Adapt the range to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?

#REF!
 

You're welcome, Chris.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote in message
...
Thanks!