Skip to main content
Solved

Spreadsheet RATE() Function

  • February 4, 2020
  • 1 reply
  • 0 views
U

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
Did this topic help you find an answer to your question?

1 reply

O
Forum|alt.badge.img+19
  • openside
  • Inspiring
  • 351 replies
  • Answer
  • February 5, 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.

U
1 person likes this
  • U
    Utah_Mortgage

Reply


Most helpful members this week

Terms & Conditions