Help needed with excel formula

Question

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&nbsp; F6 - D7 + E7 =F7. Then F7 -D8 + E8=F8 and so on. Pretty simple the only thing I need help with is I don't want the Balance repeated in the unused cells. See attached sample.Thanks&nbsp;

logaraj sekar · Answer

Hi&nbsp;Kobus van Niekerk,&nbsp;&nbsp;=IF(ISBLANK(C7),"",F6-D7+E7)&nbsp;&nbsp;Copy the above formula and paste in F7 Cell and paste the same upto end.

gourab dasgupta · Answer

HiResolved.please go through the attached file.&nbsp;

gourab dasgupta · Answer

hislightly changed the formula. please download the attachment. &nbsp;

Forum Discussion

Help needed with excel formula

Share

Resources