CURRENCYCONVERT

The CURRENCYCONVERT function returns the price of a given currency value in a different currency, using exchange rate data from the previous market day’s close, retrieved remotely via the internet.

CURRENCYCONVERT(value, currency-code)

value: The value to be converted to a new currency. If value is not a currency value, the default currency (for your language and region) is used.

currency-code: The currency code of the target currency for the conversion.

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 depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS). To change this setting for a specific 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

=CURRENCYCONVERT(1) returns $1.00, if your language and region setting is English (United States).

=CURRENCYCONVERT("£6", "EUR") returns the price of 6 pounds sterling in euros at the close of the previous market day.

=CURRENCYCONVERT(C3, "USD") returns the price of ¥5 in U.S. dollars at the close of the previous market day, if cell C3 contains ¥5 and your language and region setting is Chinese (Simplified, China mainland).

The CURRENCYCONVERT function is powered by Yahoo

See alsoCURRENCYCURRENCYCODE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.