Turn my #div/0 into a 0 please.

  • Thread starter Thread starter Steve
  • Start date Start date
S

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

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

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