so, value-list contains: no pencil, red pencil, blue pencil, green pencil, black w/sharpener, red w/sharpener. Pencils are $1 and sharpeners are $.50 I have the prices set in two fields on my price sheet form.
you can try this calculation:
PatternCount ( ValueListField ; "sharpener" ) ; 1.5 ;
PatternCount ( ValueListField ; "pencil" ) ; 1 ;
PatternCount ( ValueListField ; "no " ) ; 0
Prices should be looked up, not calculated. Either attach a price to each one of your product variations, or add a table of product categories and enter the prices there.