View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Henry[_4_] Henry[_4_] is offline
external usenet poster
 
Posts: 72
Default Currency conversions

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


"vaughn.treco.news" wrote in message
...
Hi All:

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

Can anyone give me a few pointers?

----
Best regards:
Vaughn