Variable codes in Excel
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
|