Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency conversions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
conversions | Excel Worksheet Functions | |||
Conversions | Excel Worksheet Functions | |||
Conversions | Excel Discussion (Misc queries) | |||
Conversions | Excel Discussion (Misc queries) |