View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TradeBind TradeBind is offline
external usenet poster
 
Posts: 4
Default Variable codes in Excel

Hello, I am VERY new to Excel. I have created a pricing worksheet for a
printing company. With printing we will have a lot of extra services
depending on the job, what I would like to do is be able to enter a code
number that will provide a certain formula from a list of formulas need for
the extra services. For Example:

On one job I would enter "A1S" and the "B5E"

Extra Code A1S
Extra Code B5E

There will be a list:

A1S - 1 position score - with a formula =20+.02* quantity
B5E - Blank A2 Envelopes - with a formula =.15* quantity

The list can be coded anyway

Any ideas? Thanks for your help.

Keith