Excel formula with currency convertor

[collinsc]

Hi
Can anyone help... I have a list of values i.e. "100" in cell's which represent dollars. I want to create a formula after the 'total cell' which converts to pounds easily - so that the only thing i need to change is the currency.

i.e.$1= £0.62

Thanks

[Palmetto]

In an adjacent cell, use a drop down list (Data Validation) that contains the text "Dollars" and "Pounds".
Use the drop down to select the currency type.

Say this drop down cell is A11. In the formula cell, use

=IF(A11="Pounds",B10*.062,B10)

Where cell B10 is the totals cell.