Thread
:
Currency Conversion
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Currency Conversion
Sorry about that, I initially had the exchange rates the other way round and
then at the last moment I decided that it would be better to have the larger
numbers which to my mind are more understandable then the reciprocals.
Glad that you got it sorted out despite me.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Rudy" wrote in message
...
I stand corrected, it does produce the result though I have to change from
"*" to "/". Sorry about that. Thanks...
"Sandy Mann" wrote:
Because the exchange rates will vary all the time I would create a
VLOOKUP()
table.
Say in F2:F4 you enter:
Japanese Yen
Euro
Singapore Dollar
Then in G2:G4
JPY
EUR
SGD
And finaly in H2:H4 the excahnge rates:
108.18
1.47816
1.43338
With your - say - Singapore dollar amount in L3 and SGD in K3 enter the
following formula in M3:
=L3*VLOOKUP(K3,G2:H4,2,0)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Rudy" wrote in message
...
Here's one again:
I've got various amount in different currencies (i.e. yen, euro,
singapore
$) in column L. What I want now is to convert these currencies into US$
in
column M as I enter the value in column L. How do I do that?
Thanks & rgds,
rudy
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann