I am trying to enter a new formula and just can't seem to get it. What I need is column C2 to subtract Column D1 and to equal the new balance on D2 except for when column E has the word Advance in it. When it has the word Advance in it, it then Adds column C2 to D1 equaling on D2.
And if column D has a balance of 0 and the word Advance is not in column E then D2 stays at 0.
Also column C need to have a running total balance.
See attached Spreadsheet
Thanks so much.
Bookmarks