View Single Post
  #1   Report Post  
Karen Miiller
 
Posts: n/a
Default 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.