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 |
What is ms word excel powerpoint?
How do I make a cell diagonal in excel?
How do I link data from one excel sheet to another?
How do I change excel to pdf?
How do you auto calculate in excel?
What is a summary sheet?
Where is the data validation source in excel?
What is financial scenario analysis?
How do you use the average function in excel 2016?
What are function of ms excel?
What is the splitting of cells called?
Why do we use formulas in excel?