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

Date	Particulars	Debit	Credit	Running Balance
01-Jan-2019	Opening Balance			500.00
	Received from A		200.00	700.00
	Received from B		150.00	850.00
	Paid to C	450.00		400.00
	Received from D		900.00	1,300.00
				1,300.00
				1,300.00

<tbody>
</tbody>

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),"")