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