Thread: #DIV/0! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bubbles1956 bubbles1956 is offline
external usenet poster
 
Posts: 3
Default #DIV/0! error

My formula in BN3 is this: =BL3/SUM(BL$3:BL$809)*100
In BL3 there is a 0
How do I get this error to a 0 so it doesn't mess up the rest of my formulas?