currency conversion

Hi i have an order book which lists the value of each order against the currency it was ordered in. So in column A i have a list of currencies (THB, GBP, AUD, USD, the user clicks the appropriate one) and in column B i have the figure (23.50). I want a formula that can convert all these in GBP so that i can report the order totals in one currency in column C.

=(IF A1="THB", B1/50, "") can i adapt this to include all variables? I will add a table with the currency conversion rates.

Thanks

warrima, if you x-post you must per forum rules provide links:

http://www.mrexcel.com/forum/showthread.php?t=383417

I've already posted on the above thread...