getting rid of #DIV/0!

P

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.
 
S

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.
Click to expand...

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