I want to set up an excel file that calculates the payment per month on a Fair Market Value lease. Can somebody please direct me to a function in excel. Thanks !
You Can Solve this using SUM IF formula.
=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)
In Excel two built-in functions, Future Value FV() and Present Value PV() https://support.office.com/en-us/article/pv-function-23879d31-0e02-4321-be01-da16e8168cbd. Perhaps the latest one is more close to FMV lease.
In order to calculate monthly lease payments in excel, you can use PMT(rate, nper, pv, [fv], [type])
For more specific solution you need to share sample data with complete parameters.