Thread: #div/0 ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default #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.