Basically, I have a few variables that I wish to be varied by solver, and a
certain function cell that I wish to be minimised, but the function in the
minimized cell depends on three cells (call set-cells) which are not varied
by the solver in addition to those that are. I requre to set the value of
these cells before running the solver.

The problem is that there are eight cases; eight different sets of values
for the three set-cells, for which I need to know the value of the minimised
cells, and the final values of the varied cells which provide the minimum
case.

Is there a way to do this that will give an output for all cases, whilst
only having to input the initial eight cases? In other words, is there no
other way than to vary the set-cells each time, after solving for the
previous set, and recording the values for each case?

Thank you

Michael