What is the easiest way to calculate exchange rates in Excel? Is there a formula wherein the currency code can be entered and it returns the exchange rate into currency #2 for a given day? Seems like there should be a formula for that, but haven't found one. thanks!
This may be something that Power Query can do for you, but in order to even start, we will need to know which currencies you want to have rates for. Additionally, this will entail do a web Query and refreshing the query on a regular (daily, hourly, etc.?) basis. It is not something that is native to Excel.
Provided you have a table of currencies/rates/dates, a formula could return the rate for any currency and date in the table.
One way to build a table is to choose a web site that allows personalisation and download of a currency portfolio, then download to update the table as required.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
