how to calculate exchange rate?

N

Nick Hodge

Question is a bit vague... If you just want a formula to say convert $10
(In A1) to £GBP (In B1) at a rate of 1.8 £/$ then in Cell B1 enter

=A1/1.8

You can put the exchange rate in say C1 and always refer to that, so it's
easy to change

=A1/$C$1

or is you have a series of currencies with say currency codes in a table
with their exchange rates then you should consider looking at VLOOKUP in
help

If you need more help. post back with more info

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
M

Mr. Me

On Mon, 1 Aug 2005 13:13:02 -0700 in article <12CE93FD-52A9-4B84-9D48-
[email protected]>, [email protected] spoke
thusly...
Please I need a formulea to calculate Country exchange rate?
Many thanks
Click to expand...
Exchange rates cannot be calculated by Excel. The banks doing business with
another country calculates the exchange rate and they change daily. So if
country A is doing business with country B, country A's banks calculate the
exchange rate for the day with country B.
 
Top