![]() If it is not provided, the latest available date is used. date - The date to search in rates history. Currency alphabetic codes should follow the ISO 4217 standard. Gets alphabetic codes of supported currencies for a given date. Note, in some countries, arguments in formulas should be separated by a semi-colon ( ) instead of comma (,). Returns a converted value OR a single-column range of converted values. date - The date to search in rates history OR single-column range of dates. currencyTo - The currency alphabetic code to convert to OR single-column range of codes. currencyFrom - The currency alphabetic code to convert from OR single-column range of codes. amount - The value to convert from OR single-column range of values. =Currenc圜onverter(A2:A41, B2:B41, C2:C41, D2:D41) returns an array of converted values.Ĭurrenc圜onverter(amount, currencyFrom, currencyTo, ) =Currenc圜onverter(A2:A41, B2:B41, C2:C41, "") returns an array of converted values for date. =Currenc圜onverter(A2:A41, "usd", C2:C41) returns an array of converted values from US dollar to a range of currencies for the latest available date. For better performance, it is recommended to pass a range of values as input instead of using the function multiple times on a large range of data. ![]() To get started, open your document and select any item in the menu "Add-ons" | "Currency Converter".Ĭonverts a given amount from one currency to another for a given date. Functions support 40 types of traditional currencies since 2000 and 12 types of cryptocurrencies. This add-on adds functions to your Google Sheets document for currency conversion that use historical reference exchange rates gathered from European Central bank and other sources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |