MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Having a zero/blank value instead of "DIV/0!"


Posted by Sailesh on September 19, 2001 12:57 AM

There is already a formula in the cell that displays DIV/0! so how do I get it to display nothing while I'm still waiting to input the figures for Sept?

Cheers!


Posted by Aladin Akyurek on September 19, 2001 1:08 AM

You didn't post the formula that returns the error value, so I have to be generic.

Modify your formula as follows:

=IF(denominator,your-formula,"")

Concretized:

Use

=IF(B1,A1/B1,"")

instead of

=A1/B1

where B1 is the denominator.

Cheers.

Aladin

Posted by Sailesh on September 19, 2001 1:19 AM

Cheers Aladin... the formula that returns the "DIV/0!" value is:

=IF(AND(100*I63/G63>97, G63>0),1,0)

Thanks for your help...

Posted by Aladin Akyurek on September 19, 2001 2:00 AM

> the formula that returns the "DIV/0!" value is:

Make that:

=IF(G63,IF(100*I63/G63>97,1,0),"")

Aladin