Please find attached file. I require some help in creating a running balance.
See File attached, For Example Cell I5 Displays Cash in Hand, an entry has been made in Money In cell E6, what i want is that E6 Entry to be added to the previous balance and a new total to be displayed in Cell I6, the same applied to I7, but in this case as money has gone out (Cell G7), I7 should calculate balance on I6 - G7 and new total to be displayed on I7.
I would be very grateful if somebody can provide me with a formula and incorporate and explain in the file attached. Many Thanks in advance!