Currency formulas in Excel

[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

 

[Frank Kabel]

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

 

[Rickster]

Thanks for the info Frank.....does this formula work for all differen
currencies as well?

Thank you! Rickste

 

[Frank Kabel]

Hi
just make sure which conversion rate you have and yes this is a general
formula

 

[Rickster]

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

 

[Frank Kabel]

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)