If you're dealing with various currencies in your data or you simply want to change values from one currency to another, both Google Sheets and Excel offer tools that can help you easily perform these currency conversion calculations.
Convert currencies in Google Sheets
To retrieve currency exchange rates and perform conversions, you can utilize the GOOGLEFINANCE() function. Simply input the function with the syntax GOOGLEFINANCE("currency:<source_currency><target_currency>") to get the desired exchange rate for your calculation.
The calculation cell might display a long decimal. You can format the cell to display the result in the desired currency format.
Convert currencies in Excel
For detailed instructions and step-by-step guidance, you can refer to the Microsoft documentation available here.
Create your metrics using Metric Builder
Navigate to Metric Builder and select your Spreadsheet as the data source.
Create your Google Sheets metric and add it onto a Databoard.