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
    • the currency the number needs to convert to

Notes

The following currencies can be used in the function

CodeName
AEDUnited Arab Emirates Dirham
AFNAfghan Afghani
ALLAlbanian Lek
AMDArmenian Dram
ANGNetherlands Antillean Guilder
AOAAngolan Kwanza
ARSArgentine Peso
AUDAustralian Dollar
AWGAruban Florin
AZNAzerbaijani Manat
BAMBosnia-Herzegovina Convertible Mark
BBDBarbadian Dollar
BDTBangladeshi Taka
BGNBulgarian Lev
BHDBahraini Dinar
BIFBurundian Franc
BMDBermudan Dollar
BNDBrunei Dollar
BOBBolivian Boliviano
BRLBrazilian Real
BSDBahamian Dollar
BTCBitcoin
BTNBhutanese Ngultrum
BWPBotswanan Pula
BYRBelarusian Ruble
BZDBelize Dollar
CADCanadian Dollar
CDFCongolese Franc
CHFSwiss Franc
CLFChilean Unit of Account (UF)
CLPChilean Peso
CNYChinese Yuan
COPColombian Peso
CRCCosta Rican Colón
CUCCuban Convertible Peso
CUPCuban Peso
CVECape Verdean Escudo
CZKCzech Republic Koruna
DJFDjiboutian Franc
DKKDanish Krone
DOPDominican Peso
DZDAlgerian Dinar
EGPEgyptian Pound
ERNEritrean Nakfa
ETBEthiopian Birr
EUREuro
FJDFijian Dollar
FKPFalkland Islands Pound
GBPBritish Pound Sterling
GELGeorgian Lari
GGPGuernsey Pound
GHSGhanaian Cedi
GIPGibraltar Pound
GMDGambian Dalasi
GNFGuinean Franc
GTQGuatemalan Quetzal
GYDGuyanaese Dollar
HKDHong Kong Dollar
HNLHonduran Lempira
HRKCroatian Kuna
HTGHaitian Gourde
HUFHungarian Forint
IDRIndonesian Rupiah
ILSIsraeli New Sheqel
IMPManx pound
INRIndian Rupee
IQDIraqi Dinar
IRRIranian Rial
ISKIcelandic Króna
JEPJersey Pound
JMDJamaican Dollar
JODJordanian Dinar
JPYJapanese Yen
KESKenyan Shilling
KGSKyrgystani Som
KHRCambodian Riel
KMFComorian Franc
KPWNorth Korean Won
KRWSouth Korean Won
KWDKuwaiti Dinar
KYDCayman Islands Dollar
KZTKazakhstani Tenge
LAKLaotian Kip
LBPLebanese Pound
LKRSri Lankan Rupee
LRDLiberian Dollar
LSLLesotho Loti
LTLLithuanian Litas
LVLLatvian Lats
LYDLibyan Dinar
MADMoroccan Dirham
MDLMoldovan Leu
MGAMalagasy Ariary
MKDMacedonian Denar
MMKMyanma Kyat
MNTMongolian Tugrik
MOPMacanese Pataca
MROMauritanian Ouguiya
MURMauritian Rupee
MVRMaldivian Rufiyaa
MWKMalawian Kwacha
MXNMexican Peso
MYRMalaysian Ringgit
MZNMozambican Metical
NADNamibian Dollar
NGNNigerian Naira
NIONicaraguan Córdoba
NOKNorwegian Krone
NPRNepalese Rupee
NZDNew Zealand Dollar
OMROmani Rial
PABPanamanian Balboa
PENPeruvian Nuevo Sol
PGKPapua New Guinean Kina
PHPPhilippine Peso
PKRPakistani Rupee
PLNPolish Zloty
PYGParaguayan Guarani
QARQatari Rial
RONRomanian Leu
RSDSerbian Dinar
RUBRussian Ruble
RWFRwandan Franc
SARSaudi Riyal
SBDSolomon Islands Dollar
SCRSeychellois Rupee
SDGSudanese Pound
SEKSwedish Krona
SGDSingapore Dollar
SHPSaint Helena Pound
SLLSierra Leonean Leone
SOSSomali Shilling
SRDSurinamese Dollar
STDSão Tomé and Príncipe Dobra
SVCSalvadoran Colón
SYPSyrian Pound
SZLSwazi Lilangeni
THBThai Baht
TJSTajikistani Somoni
TMTTurkmenistani Manat
TNDTunisian Dinar
TOPTongan Paʻanga
TRYTurkish Lira
TTDTrinidad and Tobago Dollar
TWDNew Taiwan Dollar
TZSTanzanian Shilling
UAHUkrainian Hryvnia
UGXUgandan Shilling
USDUnited States Dollar
UYUUruguayan Peso
UZSUzbekistan Som
VEFVenezuelan Bolívar Fuerte
VNDVietnamese Dong
VUVVanuatu Vatu
WSTSamoan Tala
XAFCFA Franc BEAC
XAGSilver (troy ounce)
XAUGold (troy ounce)
XCDEast Caribbean Dollar
XDRSpecial Drawing Rights
XOFCFA Franc BCEAO
XPFCFP Franc
YERYemeni Rial
ZARSouth African Rand
ZMKZambian Kwacha (pre-2013)
ZMWZambian Kwacha
ZWLZimbabwean Dollar

Related articles

Learn more about convertcurrency in one of the following articles