CONVERTCURRENCY Formula

This article explains how to convert currencies in your formulas

Sample Usage

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

Syntax

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 formula

  • 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