Re: Converting dollars into euros

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just multiply the amount by the exchange rate.

SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use

=A1*Sheet2!C3

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Niko" <niko@xxxxxx> wrote in message
news:p8gri.199537$F25.77796@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is it possible to convert dollars automatically into euros in Excel 2002?
I have downloaded automatically updating currency rates using MSN Money.
Now I would want to make a cell in which I could enter the amount in
dollars and see the amount in euros in the same cell. Is this possible?

Regards,
Niko


.

Relevant Pages

  • Re: Message Box should Popup on condition
    ... Private Sub Worksheet_Change ... In above data in cell "C1" I ... Box only if cell "C1" have total amount 100 and if there is any figure ... Please go to Sheet2 ...
    (microsoft.public.excel.programming)
  • Re: How can wizards be so TOTALLY stupid about muggle stuff?
    ... An exchange rate is an exchange rate, it doesn't matter which direction it ... has to be a fairly large amount of cross-pollination in that regard. ... in order to get the large amount of food they would need. ... The matter of food creation isn't as clearcut as you put it... ...
    (alt.fan.harry-potter)
  • Re: Using a sinlge "Variable" across spread sheet - Maybe simple
    ... you may define a name for this cell which holds the exchange rate (goto ... > the list of US prices at the current periods exchange rate. ... > having to manually set up each cell that holds a dollar amount to ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Salary codes
    ... you have your list in sheet2 with code in column A and amount in B, ... sheet1 you enter the code in cell A5 in B5 enter ...
    (microsoft.public.excel.misc)
  • Re: Using a sinlge "Variable" across spread sheet - Maybe simple
    ... In an empty cell, type in the exchange rate and click in the Name box (to ... > the list of US prices at the current periods exchange rate. ... > apply) it always looks for the exchange rate in a cell, an amount of cells ...
    (microsoft.public.excel.worksheet.functions)