US To Euros automatic conversion in excel

T

Tafari

Greetings

I have a financial statement in US dollars and would like to show a
column of a conversion in Euros.

Is it possible to have an excel function to do this automatically or
formula?

If so how?

Cheers
 
P

Peo Sjoblom

If you mean that by automatic excel somehow knows the exchange rate of
today?
No, you have to use an exchange rate, with the dollars in column A starting
in A2

Using today's exchange rate of one dollar = 0.854260 euro
in B2 put

=A2*0.854260

copy down as long as needed
 
Top