I have a spreadsheet that has a column (column B) of numbers. Some of the
numbers are formatted in Euro currency and some are formatted in USD currency.
I would like to put a formula in column C to automatically calculate the
currency conversion of the Euro to USD.

If cell B1 currency = Euro, then cell C1*1.45, else cell B1
Is there any way to do this?