Calculating Exchange Rate
There is an Excel file that teaches how to perform the Calculating Exchange Rate operation.
Excel Powered Calculating Exchange Rate
This workbook calculates currency conversions using VBA with a compact 6-row layout and three formula cells for exchange rate computation.
Hope it is useful.