Formula for multiplying a currency exchange rate?

[Rob_Krause]

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!

[M_k]

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

[Rob_Weidner1]

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.

[Zhen_Cheng]

exactly same here, no good solution found.

[Sean_io]

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

:pleading_face:

[Yuval_Klein1]

Airtable

Airtable | Everyone's app platform

Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

Does anyone know how to use this script?

[Joseph_Tandle]

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

[GavinA]

@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:

[Andy_Cloke]

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

datafetcher.com

Data Fetcher for Airtable

Connect Airtable to any application with no-code using the Data Fetcher Airtable extension. Fetch data from any API into Airtable.