Hide #DIV/0! where there are 2 equations dividing by 0

[ozbeachbum]

Hi,
I need to Hide #DIV/0! where there are 2 equations dividing by 0.
Any assistance will be greatly appreciated.
Cheers,
Dave.

div 0 x 2.xlsx
	H
8
Sheet1

 

[6StringJazzer]

Your example just shows a blank cell.

Can you be specific about what you mean? Generally if a divide by zero is possible, you need to decide what result you want in that case. For example:

=IF(B2=0,"",A1/B2)
=IF(B2=0,"B2 must be >0",A1/B2)
=IF(B2=0,0,A1/B2)

 

[ozbeachbum]

Hi,
The equation =IF(D8=0,D3/D4,D3/D6) works fine when there is either an entry in D4 or D6.
How ever the situation arises where there are no entries in either D4 or D6 and the result is #DIV/0! which I would like to hide.
If the equation was only dividing by one zero I would use IF(ISERROR to hide the result, but it does not work when there are TWO divisions by zero.
Trust this provides a better understanding of my situation.
Thanks in advance for any assistance you can provide.
Cheers,
Dave.

 

[offthelip]

the iferror function works if your version of excel has it:

=IFERROR(IF(D8=0,D3/D4,D3/D6),0))

 

[6StringJazzer]

Dave,

It doesn't matter that the same formula has two divisions by zero. The result of the formula will still be an error. What is the actual formula in question?

 

[ozbeachbum]

the iferror function works if your version of excel has it:

=IFERROR(IF(D8=0,D3/D4,D3/D6),0))

Thank you so much.
Cheers,
Dave.

 

[ozbeachbum]

Dave,

It doesn't matter that the same formula has two divisions by zero. The result of the formula will still be an error. What is the actual formula in question?

Thanks.
I have received an answer that works.
Cheers,
Dave.