#div/0 ?

[Geauxfish]

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.

 

[Jim Thomlinson]

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

 

[Shane Devenshire]

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)

 

[Jim Thomlinson]

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...

 

[Geauxfish]

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]

=if(sum(W9,X9,Y9) = 0, 0, T9/sum(W9,X9,Y9))
=if(large(w9:y9,1) = 0, 0, T9/large(w9:y9,1))

 

[Geauxfish]

Thanks Jim
fixed it perfectly~

=if(sum(W9,X9,Y9) = 0, 0, T9/sum(W9,X9,Y9))
=if(large(w9:y9,1) = 0, 0, T9/large(w9:y9,1))