Not sure I am following what you are doing. Where are the formulas stored?
where is the value you are performing the formula on? and how do you know
which formula to use (where is it)?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"TradeBind" wrote:

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