wrote the examples of goal seek and solver
Answers
Answered by
0
GOAL SEEK
For example, if the formula for revenue is equal to the number of units sold multiplied by the selling price, Goal Seek can determine how many units have to be sold to reach $1 million of revenue, if the selling price is known.
SOLVER
example, we have a couple of cells whose values can be changed: Projected clients per month (B4) that should be less than or equal to 50; and. Cost per service (B5) that we want Excel Solver to calculate.
Similar questions