CONVERTCURRENCY Function

This article explains how to convert currencies in your functions

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 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)

    ConvertCalculator is a powerful calculator form builder for your website