I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ‚¬ then * by 0.68. That way I could get all of our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is in.

Thanks in advance!

=B1*(LOOKUP(A1,{"$","?"},{1.92,0.68}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GCC" wrote in message
...
I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ? then * by 0.68. That way I could get all of
our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is
in.

Thanks in advance!

Ok I am putting this in and it doesn't seem to be working. What is the B1
for? Just trying to understand the formula to see where I am going wrong!

Thanks.

"Bob Phillips" wrote:

=B1*(LOOKUP(A1,{"$","?"},{1.92,0.68}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GCC" wrote in message
...
I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ? then * by 0.68. That way I could get all of
our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is
in.

Thanks in advance!

B1 is the amount to be converted
A1 is the currency type (symbol) ($,£,etc)

A1=$
B1=200
C1= the formula given by Bob

"GCC" wrote:

Ok I am putting this in and it doesn't seem to be working. What is the B1
for? Just trying to understand the formula to see where I am going wrong!

Thanks.

"Bob Phillips" wrote:

=B1*(LOOKUP(A1,{"$","?"},{1.92,0.68}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GCC" wrote in message
...
I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ? then * by 0.68. That way I could get all of
our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is
in.

Thanks in advance!

Ah, thanks. I didn't realise that the symbol had to be in a different cell.
This works now for all except the ‚¬ symbol. Do you know why this might be the
case? It actually does the calculation using the $ exchange rate...

"Toppers" wrote:

B1 is the amount to be converted
A1 is the currency type (symbol) ($,£,etc)

A1=$
B1=200
C1= the formula given by Bob

"GCC" wrote:

Ok I am putting this in and it doesn't seem to be working. What is the B1
for? Just trying to understand the formula to see where I am going wrong!

Thanks.

"Bob Phillips" wrote:

=B1*(LOOKUP(A1,{"$","?"},{1.92,0.68}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GCC" wrote in message
...
I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I was wondering if there was a way I could say if cell A1 is $
then * by 1.92 or if A1 is ? then * by 0.68. That way I could get all of
our
buy prices in the same currency without having to go through and put in
different formula's depending on what currency the original buy price is
in.

Thanks in advance!

Maybe my formula has a different symbol. Copy your version of the symbol and
paste it into the formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"GCC" wrote in message
...
Ah, thanks. I didn't realise that the symbol had to be in a different
cell.
This works now for all except the ? symbol. Do you know why this might be
the
case? It actually does the calculation using the $ exchange rate...

"Toppers" wrote:

B1 is the amount to be converted
A1 is the currency type (symbol) ($,£,etc)

A1=$
B1=200
C1= the formula given by Bob

"GCC" wrote:

Ok I am putting this in and it doesn't seem to be working. What is the
B1
for? Just trying to understand the formula to see where I am going
wrong!

Thanks.

"Bob Phillips" wrote:

=B1*(LOOKUP(A1,{"$","?"},{1.92,0.68}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"GCC" wrote in message
...
I have a spreadsheet with a list of buy prices on, however we buy
from
different countries so therefore all of the buy prices are in
different
currencies. I was wondering if there was a way I could say if cell
A1 is $
then * by 1.92 or if A1 is ? then * by 0.68. That way I could get
all of
our
buy prices in the same currency without having to go through and
put in
different formula's depending on what currency the original buy
price is
in.

Thanks in advance!