Converting more than one currency

[Guest]

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!

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Guest]

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.

 

[Guest]

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

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

 

[Guest]

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...

 

[Bob Phillips]

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)