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

  • Thread starter Thread starter Eqa
  • Start date Start date
E

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.
 
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.
 
Maybe you mean something like this in D2, copied down:
=IF(COUNTA(A2:C2)<3,"",A2&TEXT(B2*C2,"0.00"))
 
Thanks. That works fantastically well.

Eqa

Roger Govier said:
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.
 
Back
Top