Blank cells

  • Thread starter Thread starter deannab
  • Start date Start date
D

deannab

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?
 
=IF(COUNT(H2,C3,F3)=3,H2+C3-F3,"")

This will check to make sure numbers are entered in all relevant cells
before performing calculation.
 
Back
Top