Currency Conversion

[Rudy]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Rudy]

I stand corrected, it does produce the result though I have to change from
"*" to "/". Sorry about that. Thanks...

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk