In Col A I have drop down boxes which lets me enter the currency a product
is purchased in EG. US$, JapY, Aus$, EUe, etc. In Col B I have the unit price
for each product, In Col C the units purchased. I would like Col D to add up
BxC and tell me what currency I owe the money in as shown in Col A.

I hope this is clear.

Thanking you in anticipation,

Eqa.