Remember Me?

#### Menu

#1
September 6th 06, 05:58 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 1
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.

#2
September 6th 06, 06:11 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 2,574
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.

#3
September 6th 06, 10:47 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,907
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Neil Goldwasser Excel Worksheet Functions 4 May 30th 06 08:55 AM Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM hotrodenford Excel Worksheet Functions 2 January 7th 05 06:29 AM

All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017