Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Excel will not allow me to change a numerical figure in a specifi. | Excel Discussion (Misc queries) | |||
change figure to text | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |