Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column picked randomly with probability relative to number of entr Neil Goldwasser Excel Worksheet Functions 4 May 30th 06 08:55 AM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
converting #dollars into word dollars? 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