Optimization

[jxbeeman]

Is there a way to optimize a specific cell by changing a few cells in excel?

What i'm trying to do is minimize my total cost by changing a few cells.
These few cells (5 of them with each cell having a possible range between
0-5) will change the total cost. so my question is how or can this be done
in excel and can it be automated instead of me plugging in(brute force and
ignorance method) the different options.

Thanks for the help, Josh

 

[Kevin B]

You can create and save Scenarios that can be applied to your data.

Create a default scenario using your original seed values, and then create
additional scenarios to show optimized values in place of the originals.

 

[David Biddulph]

Solver.