CHANGE "C" TO 100 TO FIGURE EXTENDED COST
 

I'm trying to create a purchase order that multiplies the qty by the
price-the price is per hundred, per thousand or each. I need to convert the
C, M, E to 100, 1000, 1. I've checked If, then; Convert; functions, etc.
This is in Excel 2003.

This formula will convert the Alpah code to your numeric value:

=VLOOKUP(A1,{"C",100;"M",1000;"E",1},2,0)

Can you fit that into your process?

--
Regards,
Ron

On Mon, 13 Jun 2005 07:54:02 -0700, "Karen Miiller" <Karen
wrote:

I'm trying to create a purchase order that multiplies the qty by the
price-the price is per hundred, per thousand or each. I need to convert the
C, M, E to 100, 1000, 1. I've checked If, then; Convert; functions, etc.
This is in Excel 2003.

With your C, M or E in A1,

=HLOOKUP(A1,{"C","M","E";100,1000,1},2,FALSE)

Adjust the reference to A1 to reflect your worksheet.


--ron