View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
spezticle spezticle is offline
external usenet poster
 
Posts: 12
Default formula for spreadsheet, avoiding zeros?

i have a row of formulas.
b11 through h11
b8/b9, c8/c9,d8/d9, so on and so forth.
how to i prevent the formula from reporting #DIV/0! when in column B there
isn't a number, or the number is 0.

In these cases I just want it to be either blank, or a 0, not this error.
I know you can't divide by zero, i just don't know how to tell the prog that
it doesn't have to, and to just ignore