I have a column containing currency values. I want to multiply the values by
the current exchange rate which i will input on another sheet to give me the
new currency value in a different column.
Is there a formula to do this using the column rather than individual cells?