Dividing by zero

C

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
 
C

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
 
C

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
 
M

manxman

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).
 
Top