I am trying to create a formula which will leave a cell empty if it's
dividing by zero, or give me a result if there are numbers in the
referenced cells. It seems simple enough, but I can't get it to work.
My formula looks like this:
=IF(ERROR.TYPE(E13/E2)>0,"DUD",E13/E2)
If there are no numbers in E13 and/or E2 it returns DUD, but if I put a
number into either or both of E13 and E2, I get a #N/A error. I have
tried formatting the cells specifically as numbers and as general but
this hasn't made any difference.
HELP!!!:confused:
Trish

Signature
tuph
Biff - 24 May 2006 04:41 GMT
Hi!
Just test for 0:
=IF(E2=0,"",E13/E2)
Biff
> I am trying to create a formula which will leave a cell empty if it's
> dividing by zero, or give me a result if there are numbers in the
[quoted text clipped - 12 lines]
>
> Trish
tuph - 25 May 2006 00:37 GMT
Thanks, Biff! I knew it had to be simple :rolleyes:

Signature
tuph
Biff - 25 May 2006 02:06 GMT
You're welcome!
Biff
> Thanks, Biff! I knew it had to be simple :rolleyes: