Currency Conversion

[CandiC]

I have a spread sheet that has costs in Euros, Canadian and US $. I have over
10000 items to convert to US$, what formula should I use in COLUMN C to
convert all to US$. *For example

ROW A ROW B ROW C
Unit Cost currency code(EU, CAN,US) CONVERTED TO US$
*1.00 EU .87

Thank you in advance for your help.

Candi

 

[dlw]

+A1*.87

 

[Eduardo]

Hi,
Assuming that you have the FX rates for each currency in Sheet2 ( cell A1
says US$ and cell B1 has the 0.87
In column C enter
=sumproduct(--(b1=sheet2!a1:a50),--a1*sheet2!B1:B50)

Using the above formula you will be able to convert all the different
currencies

 

[CandiC]

Cell A1 contains the cost loaded into my mrp system which can be either EU,
CAN or US $ in numerical form. Column B1 contains the currency code in text
format EU, CAN or US. I would like to convert all costs from column A to USD
in numerical form in column C.

 

[CandiC]

The following formula worked for me.

=IF(J2="EU",(H2/1.35),IF(J2="CA",(H2/1.15),IF(J2="US",(H2/1))))

 

[Eduardo]

Hi Candi,
So in sheet 2 you need a table with the FX from each currency to US like this

Column A Column B

CAD 0.87
EU 1.2
US 1

The above is just an example replace with the real FX, execpt for US that
will always be 1 since it's the currency you want to convert to

now use the formula in column C

=sumproduct(--(b1=sheet2!a1:a50),--a1*sheet2!B1:B50)