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

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.

Converting currency from US Dollar into Canadian dollars from colu
 

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
--
Brevity is the soul of wit.


"Shahid Ali" 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.

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.