User Profile
Sheets5
Copper Contributor
Joined Feb 07, 2023
User Widgets
Recent Discussions
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....
