Forum Discussion
Balance Help
I'm trying to keep the balance from reverting back to the total cost when I delete a payment and add a new payment amount. I need this is all on the same row, Ex:
B3= starting amount or total cost
E3= payment amount
F3= the balance after payment.
I would like F3 to keep a running balance as I delete the previous amount in E3
B3 = $100 - E3 (payment) = $50 - F3= Balance $50.
Now when I delete E3 ($50) and replace it with $25,
F3 should read $25
The way I have it now the balance reverts back to B3 $100. In cell F3 =SUM(B3-E3)
Thanks in advance for your help....
7 Replies
But the formula in F3 says (i.e., it defines itself as) =B3-E3 (the SUM in your formula is redundant). You're asking that the formula return an untruth. It doesn't work that way.
It also is a mistake in that, even if it could work that way, you'd be destroying history; which isn't a good idea when it comes to financial records.
So come up with a way to both keep your history AND show a current balance accurately.
And how we might do that depends in great measure on what you're tracking here. Is it one account? One debt that you're paying back? If so something like the attached will work. If it's something else, let us know.
I can see it just fine. And the image makes it look to be a homework assignment of some kind, perhaps for a class you're taking on Excel. Is that the case?
If so, those of us who frequent this forum in order to help people out with Excel questions have also agreed we're not here to help people with their homework. For that you can talk with fellow students, your professors.... or, at the very least, come here having made some efforts yourself at solving the problem, telling us what you've done, where you've encountered a roadblock, not just that so far you've not succeeded.
