Multiply a number of cells by a value

[mvivian]

I have a table of data that needs displaying in two currencies, £ and $ (not simulataneously). How do I write a macro that multiplies all values in the table by 1.4 (if currently in £) or 0.6 (if currently in $) to give the other currency

Thanks

 

[Ricky Morris]

This can be done relatively simply with a macro, but why not use a formula in an adjecent column instead?