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

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.

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

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.

--

Regards
Roger Govier

"Eqa" wrote in message
...
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.

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

Maybe you mean something like this in D2, copied down:
=IF(COUNTA(A2:C2)<3,"",A2&TEXT(B2*C2,"0.00"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eqa" wrote:
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.

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

Thanks. That works fantastically well.

Eqa

"Roger Govier" wrote:

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.

--

Regards
Roger Govier

"Eqa" wrote in message
...
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.