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.

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.

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.