Extracting info from one col. and combining it with a simple formu

[Eqa]

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.

 

[Roger Govier]

Hi

If you are just wanting the value in column D to "appear" as though it is
currency then you could use
=A1&" "&B1*C1

These would be Text values, and could not be used in further calculation.
I am assuming you are not proposing to sum column D anyway, as the
currencies are different.

If, on the other hand you were wanting to convert all values to one common
currency, then you could use a lookup to convert according to the currency
symbol in column A, to whatever currency value you require.
If the latter, then post back.

 

[Max]

Maybe you mean something like this in D2, copied down:
=IF(COUNTA(A2:C2)<3,"",A2&TEXT(B2*C2,"0.00"))

 

[Eqa]

Thanks. That works fantastically well.

Eqa

Hi

If you are just wanting the value in column D to "appear" as though it is
currency then you could use
=A1&" "&B1*C1

These would be Text values, and could not be used in further calculation.
I am assuming you are not proposing to sum column D anyway, as the
currencies are different.

If, on the other hand you were wanting to convert all values to one common
currency, then you could use a lookup to convert according to the currency
symbol in column A, to whatever currency value you require.
If the latter, then post back.