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
|