IF hypotheticals that are not TRUE/FALSE response
 

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro

IF hypotheticals that are not TRUE/FALSE response
 

The easiest way to get all the tables at the same time is to make nine copies
of the original worksheet.

In the original sheet set Agents=1
In the first copy set Agents=2
In the second copy set Agents=3


etc. etc.
--
Gary's Student


"Stan" wrote:

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro

IF hypotheticals that are not TRUE/FALSE response
 

That's a good patch, thanks, but is it possible in one sheet? Microsoft
direct support told me I'd need to write a macro.

"Gary''s Student" wrote:

The easiest way to get all the tables at the same time is to make nine copies
of the original worksheet.

In the original sheet set Agents=1
In the first copy set Agents=2
In the second copy set Agents=3


etc. etc.
--
Gary's Student


"Stan" wrote:

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro