Exchange rates

Hi Rebecca

Thank you for your question

Calculating exchange rates usually involves multiplying an amount by a fixed decimal to calculate the conversion.

In Excel the most efficient technique would be to place your conversion rate in a cell within your workbook, and then multiply the cells containing the unconverted currency by the conversion rate to get the new figure

I sense from your question however that you have a range of different currencies and you wish to choose which one to convert to. This would involve having a column in your table which specifies the currency to be used, and then to create a lookup table listing the currencies and there conversion rates. You would then use a Vlookup function to calculate the conversion.

Vlookups are covered on the advanced Excel course

Regards

Stephen