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

__________________
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

Hi
Why is E3+C4+D4 not a formula?
E3 is your opening balance.
C4 is your first withdrawal - if any.
D4 is your first deposit - if any.
You seem to be hung up on your original formula. It does not work for you - forget it.
I have provided you with a solution AND A FORMULA - why do you not want to use it?
Tony

I'm sorry you don't think I am not taking your advice. a formula looks like this
=IF(B5="","",E4-C5+D5)

What formula that I can paste into a cell and drag it down will give me a running total?
I do not see your formula doesn't a formula start with a "=" sign??

Don't be insulted you are not giving me what I need. sorry

This is also a formula

=IF(DATEDIF(A9,B9,"y")=0,"",DATEDIF(A9,B9,"y ")&" years ")&IF(DATEDIF(A9,B9,"ym")=0,"",DATEDIF(A9,B9,"ym") &" months ")&DATEDIF(A9,B9,"md")&" days"

Hi
Then just add an = sign before my formula!
And then drag it down the column to repeat it.
Just for information the = sign is not part of the formula it simply indicates to Excel that everything after the = sign is a formula.
Good luck.
Tony

I added how I do my deposits and withdrawals in the image above and it shows how the balance in the "Total" column "E" updates. This is what I am trying to do.


What I can't understand is I have the identical worksheet set up the exact same way as the one above with one exception, the formula is entered in E5, the formula is =IF(B5="","",E4-C5+D5)

That worksheet has one more row in the top of the sheet that is why the formula in in E5 in the one above I need the formula to be in E4 but the rest should work.
The worksheet that has this formula =IF(B5="","",E4-C5+D5) works perfectly. I enter a withdrawal in column C row 4 then the total changes to reflect the withdrawal. I enter a deposit in column D and it adds to the total

I do not enter a withdrawal and a deposit on the same row , the deposits are entered in column D then withdrawals are in column C but in the next row down there is never a deposit and withdrawal in the same row.

why doesn't it work???

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

__________________
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