Thread: Converting currency from US Dollar into Canadian dollars from column A to Column B
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Converting currency from US Dollar into Canadian dollars from column A to Column B
Assume US dollars in Column A

In B1 enter =A1/CDN rate

Which right now is about 90 cents but you can get the actual from DataImport
External DataImport DataMSN MoneyCentral exchangerate.iqy

=A1/.904 turns 1US$ into 1.106CDN$


Gord Dibben MS Excel MVP


On Wed, 6 Sep 2006 11:58:34 -0500, "Shahid wrote:

Hi,

I have inventory in US $ rate in one column. I have 1600 cells to convert.
Please someone help me to write a formula so that the value in next cloumn
will automatically convert into Canadian dollars.

Reply With QuoteReply With Quote