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?

Blank cells
 

=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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"deannab" wrote:

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?