CONVERT_CURRENCY

Returns the conversion rate between the two given currencies.

The conversion rates are updated a few times a day. They are for informational purposes only and should not be used for financial decisions.

Usage

CONVERT_CURRENCY(from_currency_code, to_currency_code, [from_amount])

from_currency_code	(Required) The initial currency. A 3-letter currency code.
to_currency_code	(Required) The final currency. A 3-letter currency code.
from_amount	Amount in from_currency_code to convert to to_currency_code. The default value is 1.

Example	With these variables	Result
CONVERT_CURRENCY(“CAD”, “USD”)	(None)	0.73087
CONVERT_CURRENCY(“USD”, “EUR”)	(None)	0.90691
CONVERT_CURRENCY(“CAD”, currency)	currency is "JPY"	107.86527
ROUND(CONVERT_CURRENCY(“CAD”, currency), 2)	currency is "JPY"	107.87

Note: The examples use old exchange rates.

About the conversion rates:

They are for informational purposes only and should not be used for trading or financial decisions
They are updated a few times a day

The list of available currency codes can be found on our provider’s site: https://exchangeratesapi.io/currencies/

It may be useful to use the ROUND function if you want fewer digits in the result.