Hello,
I have compiled an asset list and on that list I have items on which the company still owes money and the monthly payment. How do I automatically subtract that payment from the amount owed on say the 15th of each month, and have it update the new amount owed so on the following month it subtracts from the new amount rather than the old... I keep getting circular references... just can't wrap my head around it right now
Thanks
PS
Right now the format is:
A1: Amount Owed B1: Monthly Payment
A2: $$$ B2:$$$
Thanks,
Chris
Bookmarks