Dividing by zero

[careyc]

I made a template where one column is to display the result of a formul
of numbers entered into other columns. The formula contains a division
which prompts the result cell to display #DIV/0! until a number i
entered into the cell that corresponds with the denominator in th
formula. Although it doesn't affect the functionality of the template
I don't want the result column to show #DIV/0! if the denominator cel
is blank. Is there a way to do this?

Thanks in advance!
Excel 200

 

[Cutter]

You can wrap your formula in an IF() function

Try this:

=IF(ISERR(your formula),"",your formula)

This will show a blank cell if your formula returns any error and show
a value if your formula returns anything other than an erro

 

[careyc]

I put it in and it worked perfectly.

Much appreciation for your help! :

 

[Cutter]

You're quite welcome. Glad to help.

I should have added an extra note: The formula I gave you will resul
in a blank for all errors except the #N/A error. If you have troubl
with that one as well then change the formula to be ISERROR instead o
ISERR

 

[careyc]

I'll keep that one in mind if the problem ever occurs.

Thanks again

 

[Guest]

In the formula cell direct no entry at all until there is a number in the
denominator cell by entering this assume the denominator cell is A1.
=if(A1="","",B1/A1).