New Balance

Question

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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Balance&nbsp;$ 140,000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date&nbsp;Ck #&nbsp;AMT&nbsp;Balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp; 140,106.95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106.95&nbsp;&nbsp;$&nbsp; 140,000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.00&nbsp;&nbsp;$&nbsp; 139,900.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.00&nbsp;&nbsp;$&nbsp; 139,800.00new balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How do you copy the new balance (Row I) into Cell J15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

rusty dane · Answer

A simple solution is a sum formula.&nbsp; Since your example had column/row headings, I recreated.In cell H1, enter the simple formula; =G5-SUM(E:E).&nbsp; This subtracts everything in column E from the beginning balance, cell G5.&nbsp; If check amounts are entered as negative, change formula to G5+SUM(E:E).&nbsp;

jmickey15 · Answer

Perfect, Thanks so much.

Forum Discussion

New Balance

Share

Resources

			Balance	$ 140,000.00


Date	Ck #	AMT	Balance
			$ 140,106.95
		$ 106.95	$ 140,000.00
		$ 100.00	$ 139,900.00
		$ 100.00	$ 139,800.00	new balance

	How do you copy the new balance (Row I) into Cell J15