For example:
Now:
A1*B1
A2*B2
A3*A4
etc

Desired:
(A1*B1)/E4
(A2*B2)/E4
(A3*B3)/E4
etc.
And in E4 there is the place to input the exchange rate.
"Ragdyer" wrote:

Don't understand your problem.

Construct your formulas to reference A1, where you manually enter and/or
revise the exchange rate in A1 whenever you wish.

You can simply enter the date you last revised A1 in an adjoining cell, say
B1.

Do you have a problem with this?
Maybe post some of your formulas if you think you might need some help.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Oliver" wrote in message
...
How can I multiply a range of cells by the (changing) contents of another
cell? For example: I have a range of cells with formulas and I want to
divide
each o these cells by another specific cell -say A1 (where I input each
days
exchange rate). So, the whole range gets multiplied by the content of A1.

I can`t use Copy, Paste Special, Multiply because this will multiply the
range by the current exchange rate only. Each day I only want to change
the
exchange rate and then the whole table gets updated by each day's exchange
rate.

Thank you