#div/0!

[Thumper84]

Hello,

I have tried searching through the threads but have not found this. I am getting the "DIV/0!" message for a worksheet that I am using. I have a table of formulas that point to other cells in other tabs.

For Example.

=Trey!A2

It works great but when I have no data in that cell, I get this error. I tried this...

=IF(C2=0,"",Trey!2) and it works, but when I apply it to the other cells in the table, they revert back to the "DIV/0!"

Any ideas?
Thanks!

 

[JD_GFI]

Do you want a default value instead of the error or just an empty cell?

Possibly look at the IFERROR function if so.

 

[Thumper84]

Thanks for the response.

The default value is an empty cell.

 

[JD_GFI]

Try:

=IFERROR(Trey!A2,"")

if I understand the problem correctly...

 

[Thumper84]

When I try that, I get the #NAME? error

 

[T. Valko]

When I try that, I get the #NAME? error

The IFERROR function requires that you have Excel 2007 or later.

Try this...

=IF(ISERROR(Trey!A2),"",Trey!A2)

I'm not sure this will solve your problem, though.

Try it and let's see.

 

[JD_GFI]

Sorry, should've checked version. I only have 2007 and 2010 here to test on at present.