US To Euros automatic conversion in excel

  • Thread starter Thread starter Tafari
  • Start date Start date
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
 
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
 
Back
Top