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?

Enter the current exchange rate in an empty cell. Select it and copy it.

Now select the column of numbers to which you want to apply the exchange
rate. Go to edit--paste special--multiply.

Dave
--
Brevity is the soul of wit.


"davnjessy" wrote:

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?

You can do the first cell current value*exchange rate and then copy it down.
Or are you multiplying them all by the same rate?

"davnjessy" wrote:

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?

Without any formulas.........

Copy the currency column to the new sheet.

Enter the exchange rate in an unused cell.

Copy that cell.

Select the range of currency and EditPaste SpecialMultiplyOKEsc.

If this will be an ongoing operation I suggest use formulas and enter the
exchange rate in a cell then reference that cell in your formulas.

i.e. In Sheet2 A1 enter =Sheet1!A1*B1 where you have the exchange rate in B1
of Sheet2

Drag/copy that down as far as you wish.


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 12:39:00 -0800, davnjessy
wrote:

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?