Thread: Divided by zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hassan Hassan is offline
external usenet poster
  
Posts: 75
Default Divided by zero
Hi All,

I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1
equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0!

Plz help

Regards

Hassan
Reply With QuoteReply With Quote