Thread: Blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
deannab deannab is offline
external usenet poster
 
Posts: 1
Default Blank cells

Using Excel 2007. I am using this basic formula in the H column
=SUM(H2,C3)-F3 in a spreadsheet with financial information. I copied and
pasted the formula into the entire H column. The last entry, for example,
might be in cell H6. From H7 on down the column, the calculation in H6 is
displayed. Is there something simple that can be added to keep the cell
calculation empty until data is entered into the other cells used in the
formula?