Turn my #div/0 into a 0 please.

[Steve]

In cell D50 I have a countif function. In cell d49 I
have a sum function. What i want to do is divide D49/D50.
If cell D49 is zero, I am getting that damn #div/0. How
can I keep the D49/D50 function and a 0 value also?

Thanks,
Steve

 

[Justin_Wolfe]

It should be as simple as putting,

=IF(D49>0, D49/D50,"")

in the cell you are dividing in. This way if D49 is greater than 0 i
will do the division, and if it isn't.. it will simply return a blan
cell.

Hope this helps,
- Justin

 

[Frank Kabel]

Hi
use
=IF(D50=0,0,D49/D50)

 

[Don Guillett]

try
=if(or(d49<1,d50<1),"",d49/d50)

 

[Dan Elgaard]

In cell D50 I have a countif function. In cell d49 I

have a sum function. What i want to do is divide D49/D50.
If cell D49 is zero, I am getting that damn #div/0. How
can I keep the D49/D50 function and a 0 value also?

This one traps ALL errors you may get with your formula:

=IF(ISERROR(D49/D50);0;D49/D50)