Thread: #div/0 ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default #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.
Reply With QuoteReply With Quote