James_Bolduc - profile

James_Bolduc · Apr 03, 2022

How do I write the equivalent of Excel’s PMT formula in AirTable field that produces the equivalent result in Excel? In Excel it’s =PMT(rate,nper,pv). In Excel I adapted it as =PMT(rate/12,nper12,pv)-1** which also produced the monthly payment as a p...

James_Bolduc · Apr 05, 2022

Thanks augmented that did the trick.

James_Bolduc · Apr 05, 2022

Here’s why. My loan amount was $720K. My interest rate is 4%. My Loan Term is 10 years. When I used the formula unaltered it returned a value for monthly payment of $88,768.48. When I adapted it I got a payment value of $7,3332.66 , which is much clo...

User Statistics

User Activity

How to write the equivalent of Excel's PMT formula in AirTable field that produces the equivalent result in Excel?

Re: How to write the equivalent of Excel's PMT formula in AirTable field that produces the equivalent result in Excel?

Re: How to write the equivalent of Excel's PMT formula in AirTable field that produces the equivalent result in Excel?