Is there a formula for goal seek in excel?



Is there a formula for goal seek in excel?..

Answer / Uttam Kumar Mishra

Yes, there is a Goal Seek feature in Excel. To use it, follow these steps:
1. Click on the cell that contains the value you want to change (the 'Set Cell').
2. Go to the 'Data' tab.
3. Click on 'What-If Analysis'.
4. Choose 'Goal Seek', and set your goals in the dialog box (the initial value, target value, and changing cell).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is ms word excel powerpoint?

1 Answers  


How do I make a cell diagonal in excel?

1 Answers  


How do I link data from one excel sheet to another?

1 Answers  


How do I change excel to pdf?

1 Answers  


How do you auto calculate in excel?

1 Answers  


What is a summary sheet?

1 Answers  


Where is the data validation source in excel?

1 Answers  


What is financial scenario analysis?

1 Answers  


How do you use the average function in excel 2016?

1 Answers  


What are function of ms excel?

1 Answers  


What is the splitting of cells called?

1 Answers  


Why do we use formulas in excel?

1 Answers  


Categories