Spreadsheet RATE() Function

Utah_Mortgage · ‎Feb 04, 2020

Is it possible to recreate the RATE() function from Excel and Google Sheets inside Airtable?

openside · ‎Feb 04, 2020

Hi @Utah_Mortgage (from a fellow Utahn!). I’ve built this in the past that will help:

But unfortunately, the RATE() function is much more complex - not a simple mathematical calculation. Not sure it would be possible without some iterative processing.

See Solution in Thread

openside · ‎Feb 04, 2020

Hi @Utah_Mortgage (from a fellow Utahn!). I’ve built this in the past that will help:

But unfortunately, the RATE() function is much more complex - not a simple mathematical calculation. Not sure it would be possible without some iterative processing.