Hi

I have a workbook with hundreds of contract details, many in different currencies. I have the numerical value in one column and the currency in another. What I'd like to do is convert all of them to one standard currency as well for reporting. So I believe I need a logic formula that will multiply the value by a pre-determined conversion rate in another cell, depending on the currency designation (AUD, USD etc) in the currency column. I've played around with some things with no success thus far. Any help would be much appreciated!

RWL