This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Re: Spreadsheet RATE() Function

Solved
Jump to Solution
644 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 © 2024 Khoros, LLC