Thread: what is the formula that help when cell=0/cell=0 to be display a .
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mangawy Mangawy is offline
external usenet poster
  
Posts: 1
Default what is the formula that help when cell=0/cell=0 to be display a .
at the excel if b1 = 0 , b2 = 0 , and b3 formula is =(b1)/sum(b1:b2) it
display at b3 " #div/0!" i need a formula replace " #div/0!" at b3 with
number "100"
please help
Reply With QuoteReply With Quote