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     www.energyefficientbuild.com.   Mar-20-2014
post by ChadMYTZ (https://productforums.google.com/forum/#!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. 

Example:
A2=CA$ 100

A3=£107.99
A4=€26.40
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