Skip to main content
Solved

Spreadsheet RATE() Function

  • Feb 4, 2020 5:45 PM UTC
  • 1 reply
  • 57 views

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

Best answer by openside

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.

View original
This topic has been closed for replies.

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • Answer
  • Feb 5, 2020 12:42 AM UTC

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.