Thanks for the reply John, so I will need to type in a myFunc formula
"=myFunc(A1,A1S)" everytime I am doing a new work sheet? Which is OK I guess
isn't there a way I can use the code and it refers to the name in say A1 and
the formula is B1?

Thanks,
Keith

"John Bundy" wrote:

You could do it with a vlookup, put in the code and the cell next to it would
show the formula. The best way however would be through a user defined
function, you would type like =myFunc(A1,A1S) and it would perform the A1S
calculation on cell A1.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"TradeBind" wrote:

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