getting rid of #DIV/0!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter McCaul - 09 Apr 2007 16:38 GMT

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.

Reply to this Message

Peo Sjoblom - 09 Apr 2007 16:45 GMT

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

Signature

Regards,

Peo Sjoblom

> Hello,
>
[quoted text clipped - 8 lines]
>
> Is there a way to do this? Any help is appreciated.

Reply to this Message

Stan Brown - 10 Apr 2007 02:39 GMT

Mon, 9 Apr 2007 11:38:44 -0400 from Peter McCaul
<compcoff@hotmail.com>:

> 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
[quoted text clipped - 6 lines]
>
> Is there a way to do this? Any help is appreciated.

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

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message