Add Condition to simple formula

Hi. Using Excel 2003. I have a very basic SUM formula I am using to show how many forms are still in-house. Pretty simple.

Column D is how many came in.
Column F is how many were completed.
Column E is what is left.

To get the daily count I take the previous day's Column E, add to today's Column D and subtract today's Column F.

=(E2+D3-F3)
Puts the results in E3.

This formula is copied on down the worksheet which results in:
=(E3+D4-F4), with the results in E4. And so on down Column E.

The problem is that if there is no data entered in Column D or F, the results from E are carried (copied?) as far down as the forumla. i.e., if today's column E results in 4, then that is displayed for as far down as I have copied the formula. What I'd like to do is set the formula so that if there is no data in columns E or F, then there is nothing displayed in Column E. Appreciate any direction given.

Thanks, Ken.

Try this in cell E4:

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Also, please post in the correct forum in the future