![]() |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]() Quote:
=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" |
#3
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
![]() |
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |