View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default divide so no error Excel 2007

=IF(B2=0,0,A2/B2)

--


Regards,


Peo Sjoblom

"Striker" wrote in message
...
I have a simple issue. I have two cells with numbers and I want to divide
one by the other and set it up on many cells. Problem is if I enter the
folmula befor there are actually numbers in the two cells I get the Divide
by 0 error (#DIV/0!)

So How can I divide A2 / B2 only if it won't produce an error?