I have the following formula =IF(B5="","",E4-C5+D5) which works for a savings tracking worksheet.

I made a new worksheet because I changed banks and the formula I need is a bit different.

column "C" is withdrawal


column "D" is Deposit
Column "E" is Total

The first row I have data in is 3, I have an amount in D3 and the total which is the same in E3 as it is my first deposit.

I would like the correct formula for the following

E3 Which is "Total" as the starting cell which I have a dollar amount in now and then I want anything in column C to to subtract from Column "E" which is Total

Then anything in column D to add to column "E" which is Total
then I want to paste in E4 so that the total will calculate in all cells in column "E" all the way down that column.


I hope I explained what I need correctly but to sum it up I just need a formula that takes the total in E3 then Subtracts any amounts in column C and add any amount that is in column D and updates the total in the whole column of E

So as I add or subtract in C or D the Total will update in column E all the way down the column.



Thank you very much in advance

Hi
Here is a suggestion:
Start with an opening balance in E3.
In column C enter your withdrawals as minus figures and in column D as plus figures.
Then in E4, E5, E6 etc the formula should be E3+C4+D4.
That should give you a running balance down your column.
Good luck.
Tony

I wasn't asking how to do it I was asking someone who works with formulas in Excel to help me by giving me the formula to paste in the total column. I don't know how to work with formulas enough to write one. I know what I need the formula to do. just need the formula from someone

Thanks for the reply though

I have given you the formula in my response!

I'm sorry it may be because I don't understand how a formula works, I do know there has to be a subtraction for any withdrawals and a addition for any deposits.

The formula that worked on my other worksheet that someone in a excel forum gave me was =IF(B5="","",E4-C5+D5)

I couldn't get the same one to work in my new one. You formula is nothing like the one above so I am confused.

Hi
Sometimes there are a number of formulae that will do the same thing.
As I say if you enter your withdrawals as minus figures you will not need a complex formula.
Follow my instructions and try it. What have you got to lose?
Tony

Sorry Tony but you are not giving me a formula to enter, you are trying to tell me how to do it. No offense but maybe someone else might give me something like the formula I posted above.
I know you are trying to help me and I appreciate it but what you are doing isn't helping me.

Please post a small sample sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please post a sample sheet ( not an image - see FAQ) showing what goes wrong

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks everyone for trying to help me. the original formula works now . I wasn't entering anything in column B, once I enter a description in column B the amount entered in columns C & D are calculated and a running total in column E is working perfectly.

The formula that worked is =IF(B5="","",E4-C5+D5)


Thanks to all once again