Currency conversions

  • Thread starter Thread starter vaughn.treco.news
  • Start date Start date
V

vaughn.treco.news

Hi All:

I'm attempting to build a formula for converting various European currencies into US$.

Can anyone give me a few pointers?
 
Vaughn,

Column A Currency name
Column B Today's exchange rate
Column C Amount of foreign currency to be converted
In D1 =C1 * B1
Copy this down for the number of rows that you need.

Name Rate Amount $
£Sterling 1.50 100 150

Note that some exchange rates are expressed as number of $s to the £
and some as number of £s to the $.
If the formula gives the wrong result then use =C1/B1 in cell D1

HTH
Henry


Hi All:

I'm attempting to build a formula for converting various European currencies
into US$.

Can anyone give me a few pointers?
 
Back
Top