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
|