Keeping the formula blank until data is entered

[motsali]

Hi guys. I'm creating a bank statement format on excel; but need help in the balance column. I want the amount to be displayed only if the value is entered in debit credit columns (either 1 column).
A B C D E
[TABLE="class: grid, width: 822"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Particulars[/TD]
[TD] Debit[/TD]
[TD] Credit[/TD]
[TD] Running Balance[/TD]
[/TR]
[TR]
[TD]01-Jan-2019[/TD]
[TD]Opening Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD] 500.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Received from A[/TD]
[TD][/TD]
[TD] 200.00[/TD]
[TD] 700.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Received from B[/TD]
[TD][/TD]
[TD] 150.00[/TD]
[TD] 850.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paid to C[/TD]
[TD] 450.00[/TD]
[TD][/TD]
[TD] 400.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Received from D[/TD]
[TD][/TD]
[TD] 900.00[/TD]
[TD] 1,300.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 1,300.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 1,300.00[/TD]
[/TR]
</tbody>[/TABLE]

So as you can see in the above table that the formula balance is still appearing in E7 even though there are no values in C7 or D7.

Please help. TIA

 

[steve the fish]

This in E3 with the opening balance in E2:

=IF(COUNT(C3:D3),$E$2+SUM($D$3:D3)-SUM($C$3:C3),"")

 

[motsali]

Thank you so much Steve. This works

This in E3 with the opening balance in E2:

=IF(COUNT(C3:D3),$E$2+SUM($D$3:D3)-SUM($C$3:C3),"")