CONVERTCURRENCY Function

This article explains how to convert currencies in your functions

Sample Usage

FS
CONVERTCURRENCY(100, 'EUR', 'USD')
FS
CONVERTCURRENCY(QA + QB, 'EUR', 'USD')
FS
CONVERTCURRENCY(VA, 'USD', 'GBP')
FS
CONVERTCURRENCY(100, QA, QB)

Syntax

FS
CONVERTCURRENCY(value, from_currency, to_currency)
  • value
    • the value that needs to be converted to another currency
  • from_currency
    • the base currency on which the value is based
  • to_currency
    • th currency the number needs to convert to

Notes

The following currencies can be using in the function

(CAD, HKD, ISK, PHP, DKK, HUF, CZK, GBP, RON, SEK, IDR, INR, BRL, RUB, HRK, JPY, THB, CHF, EUR, MYR, BGN, TRY, CNY, NOK, NZD, ZAR, USD, MXN, SGD, AUD, ILS, KRW, PLN)

Related articles

Learn more about convertcurrency in one of the following articles