getting rid of #DIV/0!

[Peter McCaul]

Hello,

I'm receiving the subject error in my cells when referencing a cell without
a number. I plan to put a number in those cells as they come to me but I
don't want to see that error. I would like the cell to be either blank or
zero.

The cell is G2 in which I'm receiving the error.

Its formula reads e10/f10 where f10 is blanked unless I input a number.

Is there a way to do this? Any help is appreciated.

 

[Peo Sjoblom]

=IF(F10="","",E10/F10)

 

[Stan Brown]

Mon, 9 Apr 2007 11:38:44 -0400 from Peter McCaul

I'm receiving the subject error in my cells when referencing a cell without
a number. I plan to put a number in those cells as they come to me but I
don't want to see that error. I would like the cell to be either blank or
zero.

The cell is G2 in which I'm receiving the error.

Its formula reads e10/f10 where f10 is blanked unless I input a number.

Is there a way to do this? Any help is appreciated.

=if(f10=0, "", e10/f10)