Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Spreadsheet RATE() Function

Solved
Jump to Solution
1053 0
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Utah_Mortgage
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Feb 04, 2020 09:45 AM

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

0 Kudos
Reply
1 Solution

Accepted Solutions
openside
10 - Mercury
10 - Mercury
Solved See Solution in Thread

‎Feb 04, 2020 04:42 PM

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

Reply
1 Reply 1
openside
10 - Mercury
10 - Mercury
Solved See Solution in Thread

‎Feb 04, 2020 04:42 PM

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.

Reply
Copyright © 2025 Khoros, LLC