CHANGE "C" TO 100 TO FIGURE EXTENDED COST

[Guest]

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.

 

[Guest]

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?

 

[Ron Rosenfeld]

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

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