Hi,

I have an echange rate problem, Hope someboy will help.

Column "B4:B200" where I write a cost in a certain currency, say Euro. In
column "A4:A2000" I return the USD value using a formual that refers to cells
A1 and B1. Column C4:C2000 is the date.

A1= 1 EUR
B1= 1.3 USD.

and the simple formula which is typed in cells "A4:A2000" is (=A1/B1).

This works as long as the value of USD is 1.3. Suppose that the value of
USD changed today from 1.3 to 1.1 against Euro. when I type the new exhange
rate in cell B1, the old valuses are changing as well. is there a way that
the value change only effect today onward and keep the previous cells with
the old value? I think it should be a relation between dates in culumn C and
the exchange rates in Cells A1 and B1, but I dont know how it do it.

Your help is appreciated
Hoshyar