View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
patt patt is offline
external usenet poster
 
Posts: 4
Default blank cell as zero

Hi. I have a cumulative budget worksheet where I add weekly numbers and will
show a profit/loss for each week as I go. It worked fine last year! but
whatever I did now, it picks up the blank cell (weeks I haven't come to yet)
as zero and so automatically shows all those weeks as losses all the way down
the page.

How can I get it to not pick up a cell as zero? To not subtract that cell
unless there is a number in it?

Thanks for your help.