View Single Post
  #2   Report Post  
samerry
 
Posts: n/a
Default How do you get rid of 0 when data not in formula row yet?

I have copied a formula down several rows for future data to be entered and
calculated. In the formula column it shows "0". I would like for the "0" not
to show. Does anyone know how to make the "0" go away without deleting the
formula. Data will later be entered in the appropriate rows and need to be
calculated at the appropriate time.