Help

Re: Spreadsheet RATE() Function

Solved
Jump to Solution
744 0
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.