If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can i multipy values in a column by 1 number
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? |
#2
|
|||
|
|||
can i multipy values in a column by 1 number
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? |
#3
|
|||
|
|||
can i multipy values in a column by 1 number
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? |
#4
|
|||
|
|||
can i multipy values in a column by 1 number
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? |
Thread Tools | |
Display Modes | |
|
|