what is the formula for tranlate dollars or ponds in euro`s? sorry for the tekst
R Rambo Apr 11, 2004 #1 what is the formula for tranlate dollars or ponds in euro`s? sorry for the tekst
F Frank Kabel Apr 11, 2004 #2 Hi you have to get the exchange rate into one field e.g. A1 stores 1.20 (that is 1EUR = 1.20$) if B1 stores your dollar value use the following formula in C1 =B1*(1/A1)
Hi you have to get the exchange rate into one field e.g. A1 stores 1.20 (that is 1EUR = 1.20$) if B1 stores your dollar value use the following formula in C1 =B1*(1/A1)