Forum Discussion
Depleting Balance - Help
I wonder if anyone with skills above mine can help me, I can't figure out how to implement this so what I'm trying to do is show a depleting balance as project spend is added. So as data is added to ...
Use two cells for this: one for the initial amount, and a second one for the remaining balance.
For example, enter the initial amount of £45,000 in R2, and the formula =E2-SUM(E4:E100) in K2.