Use the Solver tool when you have variables that you're unable to pinpoint accurately and need more loosely defined constraints. Decision variable cells, constraints, and your formula work together to find a solution to your problem with a result that you're searching for. These cells contain a formula for your main calculation and values set as maximum and minimum called constraints. Solver helps you find a projection or solution to your problem using a group of cells and a formula cell (called an objective cell). This is where the Solver tool comes in handy. It's a simple What-If analysis tool that can be used for basic projections, but you might have a more complex scenario where you are unsure of multiple variables including your goal. The outcome was a set value that Excel then used to calculate another value that would help you define your solution. With the Goal Seek tool, you found values that can be used to determine an outcome.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |