| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#div/0 ?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
=if(A1 = 0, 0, B1/A1)
-- HTH... Jim Thomlinson "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
=if(sum(W9,X9,Y9) = 0, 0, T9/sum(W9,X9,Y9))
=if(large(w9:y9,1) = 0, 0, T9/large(w9:y9,1)) -- HTH... Jim Thomlinson "Geauxfish" wrote: 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#div/0 ?
Thanks Jim
fixed it perfectly~ "Jim Thomlinson" wrote: =if(sum(W9,X9,Y9) = 0, 0, T9/sum(W9,X9,Y9)) =if(large(w9:y9,1) = 0, 0, T9/large(w9:y9,1)) -- HTH... Jim Thomlinson "Geauxfish" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
