Formulas and Functions Help
- Welcome
- Intro to formulas and functions
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
CURRENCYCODE
The CURRENCYCODE function returns the currency code of a given currency value, or the currency code for the language and region set for the computer or for the current document.
CURRENCYCODE(value)
value: An optional currency value for which the currency code is to be returned. If value is omitted, the default currency code for your language and region is returned.
Notes
Currency codes are defined by ISO 4217, a standard published by the International Organization for Standardization. You can find the ISO currency codes on the web.
The default currency code depends on your Language & Region settings (in System Preferences in macOS or in Settings in iOS and iPadOS), or on your Time Zone & Region in iCloud Settings. To change this setting for a document in macOS, choose File > Advanced > Language & Region in the open document, or, when you create the document, choose an option from the Language pop-up menu in the Template Chooser.
Examples |
|---|
=CURRENCYCODE(5) returns “USD” if your language and region setting is English (United States). =CURRENCYCODE(B2) returns “CNY,” the currency code for the Chinese Yuan, if cell B2 contains ¥12 and your language and region setting is Chinese (Simplified, China mainland). =CURRENCYCODE() returns “EUR,” the currency code for France, if your language and region setting is French (France). =CURRENCYCODE("£6”) returns “GBP,” the currency code for the British Pound, if your language and region setting is English (United Kingdom). |