98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Carlos
Carlos
Resolved · Medium Priority · Version 2007
Goal Seek
Hi Claudio
Goal Seek is a What-If Analysis tool in Excel.
With Goal Seek you can set a formula to a new value (Goal) and then specify which one of the cells that the formula referenced as the cell to be adjusted.
If the selected cell is formatted as a percentage them you can enter the new Goal in the Set Value box as a percentage. The computer will take it into account in the calculation.
Hope this helps
Carlos
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Date and timeCTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON |