Currency formulas in Excel

  • Thread starter Thread starter Rickster
  • Start date Start date
R

Rickster

I am trying to find out what Currency formulas do I need to use in
converting currency with excel. I will be working with Euro currencies
as well as the USD, JPY, CAD, NZD, GBP, etc. Is there a site or other
form of info to help me with writing formulas for this situation. I do
have DDE/realtime currency figures to work with.
Thanks for any help on this subject.
Rickster
 
Hi
to give you an example (using EURO and USD)
if you have the current exchange rate in cell A1 (e.g. A1 = 1.1950
/that is 1 EUR equals 1.1950 USD)
and you have a Euro value in B1
enter the formula
=B1*A1
to get the USD value

if you have a USD value in B1 enter the formula
=B1/A1
to get the Euro value
 
Thanks for the info Frank.....does this formula work for all differen
currencies as well?

Thank you! Rickste
 
Frank....I guess I should explain better.

What I am asking, is this formula process used in the same way on othe
currencies such as JPY/GBP..CAD/AUD...USA/CHF...etc...?

Or does the EURO countries get done differently as well?

When I format the cells I make sure that the currency symbol or name o
the country..ex JPY, USD, CAD....is setup also.

Sorry for the confusion!

Thanks
Rickste
 
Hi
you'll need the conversion rates for these countries (if USD/YEN or
USD/EUR the formulas are still the same)
The cell format does NOT do anything for your calculation (though
formating it is a good idea the calculation resukt does not change)
 
Back
Top