View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JohnnyJomp JohnnyJomp is offline
external usenet poster
 
Posts: 6
Default divide by 0 error jmp

Hi!
I have a spreadsheet where if certain cells are empty, I get a divide by 0
errors. I understand I can nopt divide by 0; that is not the issue. My issue
is I can not seem to add a column of numbers if one or more have divide by 0
errors.
Can someone suggest how I can either get rid of the divide/0 error, or be
able to add a selection of cells where 1 or more have /0 errors?