#1
|
|||
|
|||
Need help with a formula
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula help | rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
help with a look up or if formula | beb1227 | Excel | 3 | 12-31-2011 01:08 PM |
Help with formula please. | AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
If formula | sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |