Concatenate currency

I currently have one column with just the currency, and another column with the currency value.

I would like to combine the two so that the result would be a calculable value, eg.

A B C

1 USD 100 USD 100

2 EUR 200 EUR 200

3 USD 200 USD 200

 

and C1+C3 would = USD 300

By: Justin

Leave a Reply

Your email address will not be published. Required fields are marked *