excel consultants - What if analysis

Hi Tamara,

For What-If Analysis, there are quite a few options:
1) Goal Seek
2) Scenarios
3) Solver

Depending on your requirements.
1) Goal Seek (Set a new target, let Excel work out the value to reach your target base on the formula)
a) Select your formula cell
b) Tools > Goal Seek
c) Confirm the result cell
d) Type in the new value
e) Key in the parameter cell.

2) Scenarios (Excel works out a new result with your input of a list of variables)
a) Tools > Scenarios
b) Add
c) Name Scenarios
d) define cells to be changed
e) Type in new Values
f) Either Show / Summarise on a new worksheet to see result

3) Solver (It finds an optimal value for a formula, your variables can be refined in a range)
*Must first switch on function in Tools>Add-Ins
a) Tools > Solver
b) Set Formula cell as target cell
c) Set it equal to your new value
d) Click Guess
e) add to insert new constrains
f) Click Solve to view changes
g) Either Keep new values or restore to original values


Hope this helps.

Katie






Hope this helps

Katie