Discover how to create a currency exchange rate calculator – a practical & versatile spreadsheet app. From a list of 61 currencies, this tool can generate a total of over 3,600 exchange rate combinations! Discover how to build it with basic functions: GoogleFinance, IF, data validation, and Vlookup.
How much is 100 Euros worth in USD? What is 1 Aussie Dollar equivalent to in British Pounds? Your currency exchange rate translator can figure that out! Check out how this calculator works in our 4 minute video tutorial:
Challenge: Create the Translator
Can you figure out how to create this currency exchange rate translator? For guidance, view specific video tutorials on the key functions of the exchange rate translator app by selecting below. Feel free to ask us questions in the Comment/Question box below or send us an email at spreadsheetsolving@gmail.com. Only after you’ve given your best shot at creating this app, go to our Resources selection below and view our spreadsheet template.
Caveats
Whereas the majority of my spreadsheet frameworks and apps can be used interchangeably among spreadsheet programs (Microsoft Excel, Google Spreadsheet), this currency exchange rate calculator as currently set up can be done on Google Spreadsheet. The key function, GoogleFinance, retrieves information from GoogleFinance and is unique to Google Spreadsheets.
A second caveat is that this spreadsheet app will only work if you have Internet connection. In addition, data quotes from GoogleFinance can be delayed up to 20 minutes.
Resources & Related Topics
To view the spreadsheet, select here: Currency Exchange Rate Calculator Spreadsheet. Remember to edit the spreadsheet, first create a copy of it on your Google drive.
You may be using this calculator as you are travelling across various countries. Traveling with a group of friends? Need a way to figure out how to split aggregate trip costs? View our related post here: