View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KatB KatB is offline
external usenet poster
 
Posts: 1
Default how do I skip blank cells when writing formulas

I'm using Excel 2003. I need to add a value to a large range of cells. Most
cells contain numbers greater than zero, some contain "0", and others are
blank. When I write formulas, it seems like blank cells are assumed to
contain "0". I need to be able to add something to the cells with a "0",
while leaving the blank cells blank. Is there a way to do this?