I'm messing around with Google Sheets today, and I'm trying to put together a balance sheet similar to the one my bank uses. Its got both a credit and debit field in each row and a running balance to the far right. I'm kinda new to this, so I'm learning as I go.
I've got it set up like so - cell E2 has the following formula:
While cells E3 and beyond have:
It works for the most part, but if you'll notice cells E6 onwards each have the same value as a result of the formula being applied to every cell in that column. Is there any way to hide the balance value or change it to 0 if the debit/credit field is empty, just for layout purposes?
edit: It's supposed to be a running balance of an account. So the end result is like this
DEBIT CREDIT BALANCE DATE
5 5 05 Feb 2015
1 4 06 Feb 2015
10 14 07 Feb 2015
8 6 09 Feb 2015
But just to re-iterate, my issue isn't so much with the formula but rather with the way it displays the total.
I'm looking for something like this (I zeroed out E5-E11 by hand):
The balance should display "P0.00", or be blank, when the line is empty.