IF formula for currency or Macro help.


EOP

Joined
Jul 1, 2015
Messages
1
Reaction score
0
I have column A with amounts in various currencies (USD, Euro and British Pounds) and I am looking to create some type of formula that recognizes the currency in column A and provides me with the conversion in USD in column B.

i.e. =IF (a1, formatted in ___, A1*the conversion rate...)

I don't know if this can be done with an IF formula but any ideas are welcome.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top