Sorry I didn't post a formula, here are two formula's giving me the #div/0 in
seperate columns, same row.

T9/sum(W9,X9,Y9) is cell Q9
(total cost per cycle)=sum(T9)/large(w9:y9,1) is cell R9, it is taking the
largest number of cycles between 0-12 in cell w9, x9, y9, but when 0 is there
it gives me #div/0.

I will try your formula and see

"Jim Thomlinson" wrote:

I personally would avoid the iferror function as it is just to general. It
will catch any error not just #Div/0. If you get a #ref or #value it will
return nothing when quite possibly those error point to a corrption in your
file. As ageneral rule I keep my error handling as specific as possible.

That is just my 2 cents...
--
HTH...

Jim Thomlinson


"Shane Devenshire" wrote:

Since you did not show us the formula generating the problem, here are two
options which might be applicable:

=IF(A1=0,A1,B1/A1)

in 2007:

=IFERROR(B1/A1,A1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Geauxfish" wrote:

How can I get around the equations giving me this #div/0? I know it refers to
$0.00, but I need the formula to read that amount.