Subtraction Formula
Hi folks,
I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 7000. I want to visibly see the reduction on the 7000 debt cell when each new month of payment is added. Is there a formula for this?
Thanks
Answers

@nicole.turner Do you want to (continue to) see the original $7,000 somewhere? Or will it be gone once payments start? Is the $160 the monthly payment, meaning it will appear on subsequent rows? Something like this?
Is that the presentation you want?
dm

Yes, that's exactly it! How?! :D

Create your sheet using above?
In the "Outstanding" column, use this formula and you should be good to go.
=Original1  SUM(Original4:Original8)  put this in the column/row where you want the results to appear.
Original1 = the the column/row showing original amount owned ( I assume) $7000
Original4 = the column/row where the first payment is recorded
Original8 = the column/row where the last recorded payment is made
Hopefully that helps you to understand and also gets you going along.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!