Forum Discussion
Kobus van Niekerk
Apr 11, 2018Copper Contributor
Help needed with excel formula
Good morning. I'm busy setting up a formula calculating a balance sheet. I want the current balance minus the debit or add credit: for example F6 - D7 + E7 =F7. Then F7 -D8 + E8=F8 and so on. Pret...
Logaraj Sekar
Apr 11, 2018Iron Contributor
Hi Kobus van Niekerk,
=IF(ISBLANK(C7),"",F6-D7+E7)
Copy the above formula and paste in F7 Cell and paste the same upto end.