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
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
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
|
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
No comments:
Post a Comment