#div/0!

[ksebring]

Good morning,

I have a dashboard that refers to multiple workbooks and returns values into my dashboard. I have a cell that refers to a separate workbook sheet that has the value of #DIV/0! and returns on my dashboard as the same.

My cell refers to ='G:\PMO_Status_NEW\[Business_Solutions.xlsm]Client'!$B$44

How can i get my cell to not display #DIV/0! instead display "none"

I tried adding IF statment - didnt work

Any help would be appreciated.

thanks

 

[gaz_chops]

Try

=iferror('G:\PMO_Status_NEW\[Business_Solutions.xlsm]Client'!$B$44,"none")

 

[ksebring]

Great. Thanks. I was using the if statment at the end.

 

[Joe4]

I have a cell that refers to a separate workbook sheet that has the value of #DIV/0! and returns on my dashboard as the same.

Whenever possible, it is always best to try to address the error at the source itself (especially since IFERROR will ignore all errors, so you may not be alerted to other issues that you may have going on).

The #DIV/0! error is returned when you are trying to divide by zero. So, it is usually just a matter of adjusting the formula that originally returns this.
For example, if the formula is like:

=A1/B1

and the issue is that B1 is zero, you can adjust your formula to account for it by doing something like this:

=IF(B1<>0,A1/B1,"")

to return a blank
or

=IF(B1<>0,A1/B1,0)

to return zero.