Indexing products

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I wander if anybody could help me with this one...

....I am wanting to create a data sheet with a whole lot of
different formulas on it. When using these formulas I
don't want to have to type out each formul every time I
want to use it. There are about 7 different raw materials
in eah formula. All I want to have to do is type in the
formula name and then I want my spread sheet to
automatically insert the raw material data.

Is this possible and if so how?

Thanks for the help

Mark
 
Hi Mark,

It sounds like all you want to do is assign names to your
formulas. Goto Insert>Name>Define. Choose a name then
enter the formula in the Refers To box. For example, name
is Total. Refers To =10*10.

To execute that formula in a cell enter =Total. You can
also use that name in other formulas: =Total/B100

Biff
 
Back
Top