Converting currency from US Dollar into Canadian dollars from column A to Column B

[Shahid Ali]

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.

 

[Guest]

You would have to know the conversion factor.

Example: if there is two CD to one USD, then you would have to multiply your
column of USD by 2 to get Canadian Dollars, etc.

Dave

 

[Gord Dibben]

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 Data>Import
External Data>Import Data>MSN MoneyCentral exchangerate.iqy

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


Gord Dibben MS Excel MVP

 

[Gord Dibben]

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 Data>Import
External Data>Import Data>MSN MoneyCentral exchangerate.iqy

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


Gord Dibben MS Excel MVP