Thread: Converting currency from US Dollar into Canadian dollars from column A to Column B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
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.

Reply With QuoteReply With Quote