Thursday, March 20, 2014

yogi_Given Prices Of Items In Different Currencies Convert The Prices Into Specified Currency

                                         Google Spreadsheet   Post  #1566
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-20-2014
post by ChadMYTZ (!category-topic/docs/spreadsheets/zdTbgTyrPG8)
Currency conversion based on cell currency format
I have a spreadsheet that has a price column with various currencies. Each cell is formatted to the appropriate currency and I want to convert to USD. 

A2=CA$ 100

I've tried various combinations using the GoogleFinance(Currency) function but I am unable to get it to work. 

It this possible to do based on the currency format of the cell or do I need a separate column that denotes the currency of the row?

In the following I have presented a solution to a bit more generalized problem -- I have however altered the layout from Chad's by delineating the currency in a separate column