Goal seek allows you to try the different values in the formula to arrive at a solution for the ______ value.
Answers
Answered by
3
Answer:
The Goal Seek Excel function (often referred to as What-if-Analysis) is a method of solving for a desired output by changing an assumption that drives it. The function essentially uses a trial and error approach to back-solving the problem by plugging in guesses until it arrives at the answer. 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. The function is extremely useful for performing sensitivity analysis in financial modeling.
Answered by
1
Answer:
your answer please mark me as Brainlist answer
Attachments:
Similar questions
Biology,
18 days ago
Math,
18 days ago
Math,
1 month ago
Chemistry,
9 months ago
Computer Science,
9 months ago