Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Spreadsheet RATE() Function

Topic Labels: Formulas
Solved
Jump to Solution
1617 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Utah_Mortgage
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
openside
10 - Mercury
10 - Mercury

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

1 Reply 1
openside
10 - Mercury
10 - Mercury

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.