My base is begging for a PMT or Payment function, but there isn’t one I can find… I am hoping someone has found a workaround to calculate a mortgage payment. Kind of critical to our client and sales processes.
I realize this is not a spreadsheet, but other databases can do it. I see there are plenty of math functions… is anyone able to put them together in a way to “make” mortgage payment function?:
Would you be interested in being PAID to solve this for me?
My Airtable Base is very depressed.
a spreadsheet example looks like this:
…where MONTHLY PAYMENT (PI) in the middle is the result I’m talking about… because to get that payment I must use the fields before it and a PMT function … like this
So i ask, has anyone been able to put together the mathematical functions in a way to “make” a mortgage calculation?