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

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

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

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