Sorry, maybe I did not explain it well. I have already my financial tables
with formulas in the original curency, and I want to display the tables in
US$, too. I have a cell with the exchange rate (where I put the exchange rate
that may be 2.15 today and 2.20 tomorrow). So, there might be a method to
divide the whole table by that cell with the exchange rate. Then I just need
to input the current exchange ae and I can always show the updted US$ table.




"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