Indexing products

[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

 

[Biff]

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