Formulae for runnng balance where positive and negatives are in different columns?

[easysnr]

Good afternoon everybody,

I have a spreadsheet as follows:

Column A B C D E(net) F(VAT) G (Total) H, I, J K

1: DATE PAYEE DESCRIPTION INVOICE NUMBER(S) INCOMINGS OUTGOINGS Balance
2: 01/04/2013 Bob 12.50. 2.50. 15.00
3: 01/09/2013 B&Q Tools & Renewals 12.50. 2.50. 15.00 £5,876.56

Above is what the layout I have for accounts. I am wanting a forumula that will give me a running total. It will need to be the total of the 'K' cell above plus the amount in cell G for that row if a number is present and if not less the total of cell J. Does that make sense? I have been doing it manually for each entry but wondered if there is a conditional formulae that I could use?

I only want it to add up the totals and not the Net or VAT elements.

Thank you for your help in advance.

[easysnr]

an attachment might help...


Thanks

[duffry]

If I understand correctly this will follow the rules as laid out though it's not a running total.

Please Login or Register  to view this content.

[easysnr]

Thank you but when I input that it says that the formula is incorrect?

[duffry]

My mistake. Have edited the formula.

[easysnr]

Thanks again for the response, I think I may have explained what I am after incorrectly. The formula is working now but giving incorrect results and I don't understand why (my understanding of the formula is poor!)

Using the attachment as an example, K2 gives the current balance, the total of K3 needs to be K2 plus G2 where there is a value or minus J2 where there is a balance to give a new balance n K3 and so on.

Thanks again for your help!
Danielle

[Pepe Le Mokko]

Do you mean =K2+G3-J3 in K3 ? - Pull down as needed

[easysnr]

Yes, thank you!! Think I has over complicated that one in my head and explanation

Thanks again - that's just saved me hours of manual calculations

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.