currency converter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there
I am creating and expense report and I have included a drop list with
currencies but I would like to convert automatically a currency different
than EURO into EURO.
Could you please help me on this?
I am not very familiar with this so a help step by step will be very helpful

Thanks a lot
 
Just divide or multiply using the rates (depending on where you come from)
Example, you want to convert euros to dollars, today's rate is
1 euro = 1.29159 dollars

put 1.29159 in a cell (assume B2), assume A2 holds the amount of euros you
want to convert then use something like

=ROUND(A2*B2,2)

round will round it to the nearest cent

the other way around you have dollars in A2 and want to convert to euros

=ROUND(A2/B2,2)

or change the rate in B2 to

0.77435

and use the first formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting amount($) of my expenditure into the base currency i wa 1
Currency Conversion 5
Identifying currencies 7
IF formula for currency or Macro help. 0
Currency Formula 1
Euro currency conversion in Excel 2000 2
currency conversion macro 3
Return value from column 2

Back
Top