Help

Re: Formula for multiplying a currency exchange rate?

4440 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rob_Krause
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey AT community!

Been working with Airtable for only a little while now and having trouble coming up with a formula that we will use in many of our tables.

I would simply like to input an amount in a USD$ field and have it automatically appear in the €EUR field by multiplying it against an exchange rate (ie. 0.93) Often, we receive both currencies in sales or donations.

In other words, if the Euro field is empty and the sale was in USD, we could enter the USD and exchange rate and have it calculate and populate the Euro column.

Here’s a screenshot of the columns and what I’m trying to figure out. How would you suggest I do this? Thanks in advance!

Screen Shot 2017-04-22 at 8.09.58 AM.png

17 Replies 17

Hi Filipa Didier

There is a MESSAGE option, maybe you could PM him. I just did a quick check and it seems this person has not posted anything since January, I could be wrong though, but I thought I would let you know.

MK

Has anyone figured this one out? I’m used to coming from Google Sheets where I can pull in an array formula which can get GoogleFinance to autocalculate currencies, and I’m hoping to move everything over to Airtable though.

Prettysim.pl

exactly same here, no good solution found.

Sean_io
5 - Automation Enthusiast
5 - Automation Enthusiast

Airtable… please add a CURRENCY(‘USDGBP’) type function

:pleading_face:

Yuval_Klein1
4 - Data Explorer
4 - Data Explorer

Does anyone know how to use this script?

Joseph_Tandle
4 - Data Explorer
4 - Data Explorer

I also need to convert currencies in another column. Anyone figure this out?

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer

@Joseph_Tandle Maybe our app will help with this? Its for bulk converting one currency to another. We also allow the use of a date column to ensure the exchange is historically accurate. Currency Converter - Apps - Airtable Marketplace
Any features missing that wll solve your problems - we’d love to know :slightly_smiling_face:

The Data Fetcher extension will let you convert currency in bulk easily in Airtable!