Forum Discussion
New Balance
I have a spread sheet the calculate the new balance when you enter a payment. I want to copy the new balance into cell J15 Balance Balance $ 140,000.00 ...
A simple solution is a sum formula. Since your example had column/row headings, I recreated.
In cell H1, enter the simple formula; =G5-SUM(E:E). This subtracts everything in column E from the beginning balance, cell G5. If check amounts are entered as negative, change formula to G5+SUM(E:E).
Perfect, Thanks so much.