Hi!
I am trying to setup an excel spreadsheet to calculate paydown of a loan based on sale.
There is an initial outstanding balance. The balance needs to be adjusted when we have a sale. We will not know the sale price until the date of the sale, which means that input is adjustable.
What is the best way to setup a cell to calculate the following: (outstanding loan balance) - (sale price). Again - sale price is unknown so I need to know if there is a way to trigger the subtraction function using an IF formula, or something of that sort.
If you think you might know but need further clarification please contact me!
Thank you!
Bookmarks