Forum Discussion
Balance Help
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.