Currency Conversion
+A1*.87
"CandiC" wrote:
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
|